MySql issues?

[disciple]

Hi,

We recently upgraded via new install and upgrade database to the most current version of zen-cart.

Everything seemed to be fine until we had a big sale in our store. The mysql totally hogged up the cpu usage and caused us to kill and restart mysql several times in a 48 hour period and we even had to reboot the server twice.

The weird thing is that we can't seem to nail down why. I don't think we ever had over 150 people on at one time and sometimes it ran fine and then other times I had to restart.

Any ideas what might be causing this?

Here are my specs.
PHP Version: 5.2.5 (Zend: 2.2.0) PHP Memory Limit: 256M
PHP File Uploads: On Max Size: 2M
Database Data Size: 491,414 kB
Database: MySQL 4.1.22-standard
HTTP Server: Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.5
PHP Safe Mode: Off
Database Index Size: 92,881 kB

Thanks

Rick

[disciple]

I am especially having trouble when trying to mail a gift certificate. I can't even get to the page to do so and my the mysql cpu usage steadily climbs through the roof.

[yellow1912]

Your Zen version is?

[disciple]

As I said above I am using the most current version.

1.3.8a

[yellow1912]

Number of categories, products, attributes per product?
ZC currently has some problem with products having to many attribute, or deep nested categories.

[disciple]

39 categories, with only a few going one level down and 1 other category going 2 levels down.

We have over 4000 products with very few of them having attributes

Rick

[disciple]

I have figured out that when I click on "mail gift certificates" in the admin it locks up many queries in mysql and then I cannot log in or do anything until I restart mysql. It also does not allow customers to log into the front end either.

This did not happen until I upgraded to current version.

Rick

[disciple]

To be more specific the queries are locking up on the customer table when I try accessing the mail gift certificates in the admin.

Rick

[disciple]

I have attached a copy of the mysql process

[disciple]

Anybody have any ideas. I am missing functionality of the cart because of this.

Thanks

Rick