On Jan 27, 2007, at 4:12 AM, Travis Derouin wrote:
We have reached the maximum table size limit of 4GB for our text table
- what's the best way around or to fix this?
mysql> alter table text AVG_ROW_LENGTH=10240 MAX_ROWS=1000000000;
now this will safely hold 10T on MyISAM too ;-) I'll poke mediawiki table definitions for MyISAM-people.
BTW, MySQL in 5.0 increased default pointer size, so the 4GB datafile size is no longer default maximum.