Problem: Until today, the site was speedy. Pages pulled up in seconds. Nearly every page accesses the db. Now it can take upto a couple of minutes to pull up even the main page.
Troubleshooting: I have a copy of the site and database on the same server under a different name for staging purposes. I accessed that and it was speedy as usual. So it must not be the MySQL DBMS, it must be the actual database. The plain HTML pages on the site work fine, so it must not be the Apache server. I ran a "myisamchk -e" to see if there were errors and fix any of them. I rebooted the MySQL server as well as the physical machine. I restored a backup copy of the database from a day ago. None of these steps helped.
Further info: Using "top" to monitor the mysqld processes I see something similar to this when I access the site:
PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 92903 mysql 80 14 30976K 8156K RUN 1 1:18 17.19% 17.19% mysqld 93018 mysql 80 14 30976K 8156K CPU1 1 0:44 17.19% 17.19% mysqld 92989 mysql 18 14 30976K 8156K pause 1 0:50 17.14% 17.14% mysqld 92893 mysql 80 14 30976K 8156K RUN 1 1:25 17.04% 17.04% mysqld 93016 mysql 18 14 30976K 8156K pause 1 0:44 17.04% 17.04% mysqld 92966 mysql 18 14 30976K 8156K pause 1 0:56 16.75% 16.75% mysqld 92988 mysql 18 14 30976K 8156K pause 1 0:51 16.60% 16.60% mysqld 93304 mysql 79 14 30976K 8156K RUN 1 0:14 16.76% 16.46% mysqld 92932 mysql 77 14 30976K 8156K RUN 1 1:08 16.06% 16.06% mysqld 93436 mysql 18 14 30976K 8156K pause 1 0:01 18.96% 4.20% mysqld
Any ideas what could be causing the slowness? There are only two admins on the system, including myself. I did nothing over the weekend and the other admin said he only edited an e-mail address on someone's account.
Help?
Thank you very much for your time, Jonathan Duncan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]