Are you logging slow queries? Have you run an explain plan for the queries in question?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/24/04, 10:29:33 AM, Bill Marrs <[EMAIL PROTECTED]> wrote regarding disabling optimizations to identify slow queries: > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
