4 ms·
1) Delayed inserts do not work with InnoDB tables. 2) This is a great idea for time based data. You age out the tables and create a merge table which is a log
by denimboy 19y ago
1) Delayed inserts do not work with InnoDB tables.
2) This is a great idea for time based data. You age out the tables and create a merge table which is a logical view of all the tables together. You can get tricky and use compressed myisam tables for the older, static data since it will never change.