Hi, I'm using MySQL 4.0.18-max (same problem with 4.0.18-standard) on one server, and I encounter a strange problem :
When I make some change on a table (adding index for exemple), at the end of the ALTER process all the queries that must write on this table switch in the "Waiting for table" state forever. A flush table doesn't solve the problem and I have to kill mysql and restart the server... Last time this problem occurs, I was converting a table to InnoDB, and the "Waiting for table" problems occured when the ALTER TABLE switched to "renaming table" state, at this end of the ALTER process... When I restarted mysql, the InnoDB table was OK. Any idea of what could happen on this server, since it's the first time I see this kind of problem with MySQL ? Thanks, Jocelyn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]