We have tried restarting MySQL several times, right after restarting it, it will respond to queries in good time, but after 15-20 minutes it continues to slowdown and degrade in performance. Eventually it becomes really slow taking up to several minutes for a query that should take no more than a second or two. We restarted the server itself once also, and experienced the same result.
We tried upgrading to MySQL 4.0.18, hoping this would improve things. It did not. We have spent the last 2 days of constant troubleshooting and we are running out of ideas.
We have a test server setup that is running the same php and apache as the web environment, it is also running the same version of MySQL, yet it doesn't experience any of these problems. It even has a lot less CPU and RAM, yet its can make the same queries in a second.
We have tried doing the same queries our web environment is doing on the local MySQL command line and get the same slowness to return results. Does anyone have any ideas??
Thanks,
Preston Podaril - [EMAIL PROTECTED] Network Administrator, ispi of Lincoln
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
