the other
AND clauses, if doing so would allow a lot of records to be skipped
over during the index scan, rather than read in their entirety.
> From: "Wendell Dingus" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Subject: RE: MySQ
Thanks to everyone who has helped and/or made suggestions so far. I'll
try to provide some answers to your further queries and report back on
some testing I've done.
Jeremy asked for explains of some of the problem queries:
Here is a particularly troublesome one that gets ran quite a lot:
mysql> S
On Sat, Jun 28, 2003 at 01:47:28PM -0400, Wendell Dingus wrote:
> Hello, I've got a situation I'm hoping someone here can help me out with.
We
> have a web server serving up data via some PHP programs pulling from MySQL
> (3.23.56 currently) in INNODB tables. There are 40+ (active) databases
> t
On Sat, Jun 28, 2003 at 01:47:28PM -0400, Wendell Dingus wrote:
> Hello, I've got a situation I'm hoping someone here can help me out with. We
> have a web server serving up data via some PHP programs pulling from MySQL
> (3.23.56 currently) in INNODB tables. There are 40+ (active) databases
> tota
Sent: Saturday, June 28, 2003 2:45 PM
To: Wendell Dingus
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL/INNODB speed on large databases
Maybe my question is too obvious but, since you have several databases
instead of only one, have you considered moving some of them to a
separate server ?
Also, have you che
riginal Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 2:45 PM
To: Wendell Dingus
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL/INNODB speed on large databases
Maybe my question is too obvious but, since you have several databases
instead of only one, have you
Maybe my question is too obvious but, since you have several databases
instead of only one, have you considered moving some of them to a
separate server ?
Also, have you checked MySQL replication capabilities ?
It is a very efficient way to distribute the load across several
servers unless you do a
