[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.


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).


More information about the development mailing list