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 mysql server created some temporary files on disk ( 3 hours ) > #sql-7ad2_d6cb95.MYD > #sql-7ad2_d6cb95.MYI > #sql-7ad2_d6cb95.frm and now the process is in state : > Repair with keycache It seems to be really slow, how can I improve speed ? or how can I get more infos about what mysql is doing ? I try to set global variables like myisam_sort_buffer_size but it didn't work. I use mysql v 3.23.57 any help wil be appreciated. thanks. --------------------------- http://webmail.netbadri.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
