Hi everyone. Just a general question here. MySQL allows a maximum table space size of something like 64TB (Terrabytes).

Assuming I can attach sufficient Disks will the SUSE file system (Reiserfs) allow MySQL to have table spaces of several TB each or am I limited by the file system.

Using INNODB types rather than MyISAM allows your MySQL data spaces to span multiple volumes.

I'm sure ideally the best way would be to split the data up across several servers but it's not really feasable in this case without a complete re-design of the application.

Any info from DB designers out their on limitations of Reiserfs file size limits and MySQL would be greatly appreciated.

Thanks.

-K

I do not recomend MySql for large data volumes and if you want to be able to alter any of the big tables.

Our installation contains around 300 GB and if we need to add/remove/rename columns or create/drop any index mysql needs to lock the table, copy it, alter copy, remove old table, move copy back and finally unlock the table. This operation takes around 19 h for a table that contains 15 million records (~40 GB). 19 h when nobody can access the table, NOT that nice for a live production system with a SLA of 99.999%...

Another con is the lack of partitioning of tables.