[nycphp-talk] MySQL & 2.5 million rows!

Brent Baisley brent at
Fri Apr 11 15:01:38 EDT 2003

That is correct, but only for the duration of the rename which take 
only a split second.

On Friday, April 11, 2003, at 12:21 PM, jsiegel1 at wrote:

> Did a quick search and noticed the following concerning table renaming:
> "The rename is done atomically, which means that no other thread can 
> access any of the tables while the rename is running." (from MySQL 
> online docs.)
> Correct me if I'm wrong but this would mean that website visitors 
> would not be able to query the database during this operation. Is that 
> correct?
> Jeff
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577

More information about the talk mailing list