NYCPHP Meetup

[nycphp-talk] MySQL & 2.5 million rows!

jsiegel1 at optonline.net jsiegel1 at optonline.net
Fri Apr 11 16:26:20 EDT 2003


Hmmm...sounds like a solution.

Jeff

----- Original Message -----
From: Brent Baisley <brent at landover.com>
Date: Friday, April 11, 2003 3:01 pm
Subject: Re: [nycphp-talk] MySQL & 2.5 million rows!

> 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
> 
> 
> 
> --- Unsubscribe at http://nyphp.org/list/ ---
> 
> 
> 




More information about the talk mailing list