disabling optimizations to identify slow queries

[Bill Marrs]

I've found a performance issue with a series of mysql queries that I make 
to generate a web page.  But, when I go to investigate it, reloading the 
page a few times, I find the performance of the pages within a couple tries 
becomes very fast.

So, it's hard to track down and work on the queries that are slow, since 
they do not remain slow.

Unfortunately, the page is still slow fairly often, so this doesn't help my 
real problem.

On my test server, I've tried disabling some optimizations in the server 
parameters, to see if I could get a more reproducible case (figuring that 
query caching and/or the key buffer could be resulting in repeated queries 
being optimized):

set-variable = query_cache_type=0
set-variable = key_buffer_size=0
...but, I haven't managed to reproduce the slow queries reliably.

Does anything know what might be going on and if there's some setting I can 
use to make my performance issue more reproducible?

Am I missing something?

-=bill

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]