Well,
Try to start checking the IOPs vs Disc. Check your iowait and the cache
size.
Could you send a create table and the query for us?
Atenciosamente,
*Eduardo Fontinelle*
*Chief Technology Officer | G**erencianet*
Phone: +55 (31) 3603-0812
2014-08-20 12:04 GMT-03:00 Jim
Jim/Jaime
What engine are you implementing?/
Qual mecanismo de MySQL que você está implementando?
Saludos desde Sud America
Martín
Date: Wed, 20 Aug 2014 13:54:46 -0300
Subject: Re: inconsistent optimization
From: edua...@gerencianet.com.br
To: j...@lowcarbfriends.com
CC: mysql
innodb
On 8/20/2014 1:22 PM, Martin Gainty wrote:
Jim/Jaime
What engine are you implementing?/
Qual mecanismo de MySQL que você está implementando?
Saludos desde Sud America
Martín
Date: Wed, 20 Aug 2014 13:54:46 -0300
Subject: Re: inconsistent optimization
From: edua...@gerencianet.com.br
Hi Jim,
On 8/20/2014 11:04 AM, Jim wrote:
Without going into specific details on queries...
Using mysql 5.1 as provided with CentOS6, I've noticed some queries
providing what I can best explain as inconsistent optimization. The
database can be quieted to just controlled queries and at times