Update. It came back after I took a walk:
Query OK, 1688168 rows affected (56 min 17.41 sec) Records: 1688168 Duplicates: 0 Warnings: 0
On Apr 21, 2007, at 6:13 PM, Jim Hu wrote:
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@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
Wikitech-l mailing list Wikitech-l@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