[nycphp-talk] MySQL & 2.5 million rows!
Brent Baisley
brent at landover.com
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 optonline.net 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