Howdy Folks, Got a bit of a hassle. After some broken tries (got impatient) to change the type of large table's column I found that, when I finally got the patience, my disk went full and cancelled the operation again. Since MySQL copies the table before such operation, my ibdata1 file (using InnoDB) has grown about three times the size it has to be. When I tried a repair operation, the only thing I saw was the size increasing even more.
Huge, in this context, is currently 28GB, on a 32GB hd, 465M free and no more files to move out of the way. Any advice on how I can reduce the filesize back to the necessery size? Thanks, Wouter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
