List:General Discussion« Previous MessageNext Message »
From:Matt W Date:September 1 2003 2:19am
Subject:Re: spaces in index name
View as plain text  
Hi,

----- Original Message -----
From: "Benjamin KRIEF"
Sent: Sunday, August 31, 2003 8:17 PM
Subject: Re: spaces in index name


> thanks for all your answers ! i'd never imagine that mailing-list to
be
> so active and efficient!

It's usually not that active on weekends, volume-wise. And I see Roger
and Dan had already replied before me. :-)


> matt : does mysql locks the table during the whole alter table
execution?

Yes, with a read lock on non-Windows systems. So the table can still be
read from but UPDATE/INSERT/DELETE queries will wait (and they will
block subsequent reads if they're not LOW_PRIORITY). On Windows, the
table is completely locked while ALTER TABLE is running. From
http://www.mysql.com/doc/en/Windows_vs_Unix.html

"While you are executing an ALTER TABLE statement, the table is locked
from usage by other threads. This has to do with the fact that on
Windows, you can't delete a file that is in use by another threads. (In
the future, we may find some way to work around this problem.)"

Hope that helps.

Matt

Thread
spaces in index nameBenjamin KRIEF1 Sep
  • Re: spaces in index nameRoger Baklund1 Sep
  • Re: spaces in index nameDan Nelson1 Sep
  • Re: spaces in index nameMatt W1 Sep
    • Re: spaces in index nameBenjamin KRIEF1 Sep
  • Re: spaces in index nameMatt W1 Sep