I got the table text full message on one of my wikis and tried this.
mysql is hanging. Should it come back right away or should I wait.
The first time I did control-c and then thought that might have been
a mistake. Any thoughts?
Jim
On Feb 5, 2007, at 4:09 AM, Domas Mituzas wrote:
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.
--
Domas Mituzas --
http://dammit.lt/ -- [[user:midom]]
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/wikitech-l
=====================================
Jim Hu
Associate Professor
Dept. of Biochemistry and Biophysics
2128 TAMU
Texas A&M Univ.
College Station, TX 77843-2128
979-862-4054