Re:MySQL InnoDB Clustered Indexes and Rails (or How RescueTi...
by denimboy on Monday March 10, 2008 @09:06PM
(#133675)
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.
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.