thank you for the links, I can't change system variables at runtime, so the only choice I have is, probably, to stop mysql server set variables and then run another ALTER TABLE. ;-(
I'm going to siwtch to mysql4 as soon as possible. Selon "Kevin A. Burton" <[EMAIL PROTECTED]>: > Mohamed Badri wrote: > > >Hi, > > > >just had a problem with a myisam table who reached 4GB of data, > >I increased the number of rows by doing : > > > >ALTER TABLE foo MAX_ROWS=1000000000 > > > > > > This is EXACTLY what you want: > > http://www.peerfear.org/rss/permalink/2004/10/16/MySQLAndALTERTABLEGuiltyAsCharged > http://www.peerfear.org/rss/permalink/2004/10/15/MaxTableSizeInMySQL > > REPAIR TABLE considered harmful would be a better blog post title for > these guys! > > Kevin > > -- > > Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an > invite! Also see irc.freenode.net #rojo if you want to chat. > > Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html > > If you're interested in RSS, Weblogs, Social Networking, etc... then you > should work for Rojo! If you recommend someone and we hire them you'll > get a free iPod! > > Kevin A. Burton, Location - San Francisco, CA > AIM/YIM - sfburtonator, Web - http://peerfear.org/ > GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > --------------------------- http://webmail.netbadri.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]