mysqld process usage high and long

2004-12-06 Thread Jonathan Duncan
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.

Re: mysqld process usage high and long

2004-12-06 Thread Jonathan Duncan
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: