Never mind, it was a query optimization issue. Upon the third
interogation of the other admin, he remembered one small setting that he
changed, which just so happened to increase the number of queries
exponentially.
Thanks,
Jonathan Duncan
On Mon, 6 Dec 2004, Jonathan Duncan wrote:
Background: I have a web site that is running MySQL 3.23.58 (although
phpinfo shows "Client API version: 4.0.20") and PHP 4.3.9 on a FreeBSD 4.7
system. The only live site on the server is http://www.routerbitworld.com/
which is using osCommerce.
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]