Re: Queries slow down daily, optimizing helps -> why?
Posted by:
Kaspar Con
Date: February 20, 2009 08:34AM
OK, I think I understand the problems with QC. I could thest the issue you mentioned and I could verify it.
But it is "only" a difference from 250ms to 28ms for building the whole page. If we face the problem initially described serving the page lasts 6 seconds!
The cache hitrate is 98% but the cache is quite fragmented. I could not provide reliable show status data at the moment, because we just restarted mysqld. I calculated the values 2 days ago.
We have to generally think about QC but perhaps it is not our main problem. I issued it, I know, but thinking of it and considering what you told me I think it is the lesser problem.
I increased key_buffer_size to 3 GB, let's see what this can do. We have only MyIsam tables.
We will update our mysql 5.0.37 to the most recent version next week, perhaps this kills the issue (hopefully!).
Thanks for your help so far, if you have any more ideas, please post them, I really would like to understand what's going on.
Sami
Subject
Views
Written By
Posted
4474
February 18, 2009 04:54AM
2292
February 18, 2009 09:04AM
2383
February 18, 2009 11:57AM
2375
February 19, 2009 01:00AM
2331
February 19, 2009 01:52AM
2345
February 19, 2009 03:32AM
1774
February 19, 2009 05:08AM
2217
February 19, 2009 12:24PM
2307
February 19, 2009 10:53PM
Re: Queries slow down daily, optimizing helps -> why?
2421
February 20, 2009 08:34AM
2200
March 18, 2009 03:58AM
2318
February 21, 2009 06:15AM
2268
February 24, 2009 10:02AM
2474
February 26, 2009 02:30AM
2101
February 26, 2009 09:56AM
2293
February 26, 2009 08:14PM
2313
February 27, 2009 01:38AM
2193
February 27, 2009 07:56PM
2188
February 28, 2009 06:20AM
2526
February 28, 2009 03:43PM
2319
February 27, 2009 04:21AM