afullcup
12-16-2007, 09:02 PM
I have had a lot of problems with my site getting very slow. It is a pretty busy board, but I also have a lot of resources. I just had my server folks look into it today and here is what they told me:
We have tweaked some Mysql variables and restarted the service. But still some queries are getting in sleep state, that is because of the bad coding style. You need to take care of mysql connection open, close and other query managements in the code for avoiding this.
So... how do I figure out where this is happening? I do have way more hacks/mods than I probably should, but removing them all isn't really a good option for me. Is there an easy way to figure out which hacks are making database calls? (like something to "grep" for in the files I've downloaded?)
Any insight into this would be greatly appreciated!!!
--------------- Added 1197919160 at 1197919160 ---------------
anyone?
We have tweaked some Mysql variables and restarted the service. But still some queries are getting in sleep state, that is because of the bad coding style. You need to take care of mysql connection open, close and other query managements in the code for avoiding this.
So... how do I figure out where this is happening? I do have way more hacks/mods than I probably should, but removing them all isn't really a good option for me. Is there an easy way to figure out which hacks are making database calls? (like something to "grep" for in the files I've downloaded?)
Any insight into this would be greatly appreciated!!!
--------------- Added 1197919160 at 1197919160 ---------------
anyone?