(31) 3272 - 0226 / 9114 - 7695
- Mensagem original
De: Rob Wultsch <[EMAIL PROTECTED]>
Para: JW <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Enviadas: Domingo, 11 de Maio de 2008 0:04:17
Assunto: Re: Table Locking (Was: Best CPU config for a busy DB server)
On Sat, May
On Sat, May 10, 2008 at 4:24 PM, JW <[EMAIL PROTECTED]> wrote:
>> Table locking will occur with MyISAM tables when any row(s) of the table is
>> being updated (Update,Delete,Insert,Load Data etc).
>> If you are only executing Select statements, then they can be executed in
>> parallel and won't be
> Table locking will occur with MyISAM tables when any row(s) of the table is
> being updated (Update,Delete,Insert,Load Data etc).
> If you are only executing Select statements, then they can be executed in
> parallel and won't be blocked.
Just curious: you say "with MyISAM tables" - do any of t
At 05:05 PM 5/9/2008, you wrote:
On Friday 09 May 2008 04:32:10 pm Saravanan wrote:
> --- On Sat, 5/10/08, JW <[EMAIL PROTECTED]> wrote:
> > From: JW <[EMAIL PROTECTED]>
> > Is it correct that mysql 5.0 is threaded in such a way that
> > a DB server taking lots of queries from many clients will b
On Friday 09 May 2008 04:32:10 pm Saravanan wrote:
> --- On Sat, 5/10/08, JW <[EMAIL PROTECTED]> wrote:
> > From: JW <[EMAIL PROTECTED]>
> > Is it correct that mysql 5.0 is threaded in such a way that
> > a DB server taking lots of queries from many clients will be able\
> > to utilize lots of CPUs
