Greetings- I have the binary dist of 4.0.20 running on a fairly adequate box (dualxeon,6gbRAM).
I try to alter a table which has 733k rows and get the following: mysql> ALTER TABLE `CPULoad` CHANGE `TIME` `TIME` VARCHAR( 24 ) NOT NULL; ERROR 1034: sort_buffer_size is to small 'Huh?' I say........ mysql> select @@sort_buffer_size; +--------------------+ | @@sort_buffer_size | +--------------------+ | 1073741816 | +--------------------+ 1 row in set (0.00 sec) Any clue why this happens? It only shows up on tables where there is data. Empty tables can be modified without problem. Thanks- P ----------------------------------------------------- Peter J. Milanese The New York Public Library System Administrator mailto:[EMAIL PROTECTED] Tel.: +1 (212) 621-0203 Fax: +1 (212) 247-5848 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]