Timeline for query_cache tuning for a database server to keep db from slowing
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 13, 2012 at 22:29 | vote | accept | Quantum | ||
| Jul 13, 2012 at 22:29 | comment | added | Quantum | Oh.. so drogart, your right, some time the db start readying right and the app server is the one hanging. I has a memory leak and what was going on is that it was just holding up the db server an dmade it look like the root when it was not. thanks for pointing out that idea. | |
| Jul 4, 2012 at 0:04 | comment | added | Quantum | So truning off the cache seems to speed it up.. with a cache like that who need speed :D .. so i made a few changes noted above.. I don't see high i/o or cup atm but I'll try to pin that info you asked about when it really slows down again. | |
| Jul 3, 2012 at 20:27 | comment | added | drogart | Does turning off the query cache cause the same problem right away? Is there a correlation between the query cache becoming full and slowness? When things are slow do you see high cpu or i/o activity? Is there swapping happening? Anyting in your error log for that time? What does the processlist look like when things are slow? It may very well be the query cache, but a lot of things can cause slowness. I would recommend gathering as much info as you can during a normal ops and compare it to behavior when it is slow. Perhaps that will point you towards the problem. | |
| Jul 3, 2012 at 19:59 | comment | added | Quantum | I was thinking that the slowing down was due to the cache cause after a fresh restart of mysqld everthing is speedy for the next couple of days. As we move close to, lets say the thrid day, things slow down to a crawl and simple restarting that service brings back the speed. I have to put my fingure somewhere to start, and with the fact that this server slice is just a basic CentOs install with the added install of the mysql only that putting my fingure on the cache would be the first. It's a gut thing, not saying it's the right cause to the issue. | |
| Jul 3, 2012 at 17:13 | history | answered | drogart | CC BY-SA 3.0 |