> In the last episode (Dec 13), Tim Wood said: > > Does anyone out there know of any > > - future plans by the mysql development crew to increase table size > > limits by eg using their own custom filesystem type? > > You mean the MyISAM RAID table extension, or the Innodb tablespace > format? Done. Check the manual for details. > > > - any kernel fs patches I might apply to get around the 4G limit imposed > > by the linux kernel > > - any alternative filesystems (JFS?) that might permit greater table > > sizes under mysql > > 2.4.2 should support 64-bit files just fine. It turns out I should have RTFM a bit more closely. For those wondering how to use 2.4.x & mysql to get > 4G tables, here's the deal: the 4G limit is a default (not a FS /kernel imposed limitation as I'd previously surmised).
To get > 4G using vanilla isam table type, you need to specify the max_rows and/or avg_row_length parameters at table creation time. The other options (raid , innobase) Dan mentioned look easy enough to implement as well - but for now I'll just go with a very long running "alter table". Thanks Dan Tim --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
