I came across a scenario where we were concerned about the size of a table, a 134G table, its a pretty huge table and growing fast. The nature of the table – its a table which contains logs , sort of a audit table. Some fundamental questions around this table’s use: 1) would it have a lot of reads ? — Answer – No 2) is it always insert only? — Answer – Yes 3) current strategy to restrict size ? — Answer – delete data from table. 4) does one need backup of the table, i.e. is it very important ? — Answer – No Well based on the above, it would seem that logging is the theme. Schema of the table: CREATE TABLE `SystemLogs` ( `column1` varchar(255) DEFAULT NULL, `column2` varchar(255) DEFAULT NULL, `column3` varchar(255) DEFAULT NULL, `column4` varchar(255) DEFAULT NULL, `column5` text, `column6` text, `timestamp` datetime DEFAULT NULL, `id` int(11) …
[Read more]
Showing entries 1 to 1
Feb
03
2014
Showing entries 1 to 1