Merge tables are mainly based for having two identical tables then
'merging' them together with a third. I am guessing that he wants RAID
chucks in the 'create table' statement. Also, InnoDB has built in
functionality to create new files and roll over...
http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html
This does not fix the 'optimize table dbmail_messageblks;'. Hrmmm...
Eugene Prokopiev wrote:
If anybody now how to do optimize MySQL tables in such hard terms
- please answer.
I'm open to suggestions and ideas here. I've been having this very same
problem.
http://dev.mysql.com/doc/refman/4.1/en/merge-storage-engine.html
Big RDBMS (Sybase, Oracle) have advanced table partitioning features,
which help me to store more than 100Gb in one Oracle table.
