I have enough disk space for indexes, the problem doesn't happen during adding an index. it happens after the index is added.
On Sun, 2003-12-28 at 21:33, mos wrote: > At 06:28 PM 12/28/2003, you wrote: > >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]