PDA

View Full Version : mySQL Sleeping?


lucky760
7-3-05, 12:37 AM
Anyone have any idea what would cause mySQL to slow down for seemingly no reason? All of my pages load with no problem except for one (a page that displays a single full-sized photo). Every time I browse to such a page it takes 60 seconds at the very least before the page loads. During this loading time the processlist in phpmyadmin shows no query, but command "Sleep" until it actually loads. Here's the actual processlist data:
ID | Command | Time | Status | SQL-query
816667 | Sleep | 44 | --- | ---
I haven't made any changes to the php code or the mySQL database and I can't figure out how to make the page load like normal... Any ideas?