[development] mysql merge tables and partitioning

Rowan Kerr rowan at stasis.org
Thu Feb 1 15:30:01 UTC 2007


What about using ARCHIVE table instead of MERGE. It's basically 
optimized for watchdog style data.

http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html

To me, it doesn't make sense to spend time making the db schema more 
complicated and relying on a table type that is already deprecated (and 
implemented only by one database). (Didn't people want a cleaner db 
design for the next release?). If you really want this type of 
behaviour for large log tables, think about working on it from a 
partitioning point of view which is supported by more db's (and will be 
more future-proof).

-Rowan



More information about the development mailing list