Hello Every Body , I have been facing a strange problem, that i assume its a mysql bug of some sort.
In my datadabase there are 2 tables, if i tried to add any index to them ,any INSERT INTO request status will be - in show processlist- update and will freeze like this forever , and consequently all inserts ot this table stays in the que, untill mysql stops responding.
This can happen if you're run out of disk space for adding the indexes. When an index is added, it has to create a copy of the table. If it runs out of space it can just sit there locking out the other processes that are waiting for the table.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]