Zen Cart Logo
Forums / General Questions / mysql hangs up

mysql hangs up

Locked

Views: 1,883

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
17 Feb 2008, 1:29 AM
#1
billt avatar

billt

Zen Follower

Join Date:
Aug 2004
Posts:
93
Plugin Contributions:
0

mysql hangs up

Twice in the last 12 hours I have had to restart mysql. To give a little history my site was on a vps. Search were running very slow. So I upgrade from1.3.01 to 1.3.8a and moved to a dedicated server. It's running PHP5.2.5 and mysql 5.0.45. Searches have been much faster but the mysql froze twice in the last 12 hr. We are averaging 3500 unique visitors a day with about 37,000 hits. We have 28,000 registered customers. I have been running the database optimizer from admin/my store every couple days. My host tech people have looked at the problem and had the following to say.

"While its normal for MySQL to hang and require a restart on occasion, twice in the last 12 hours is a little odd. I don't see any errors reported in the MySQL error log, but I do see some large innodb table files in the Mysql directory. Do you use innodb for a storage engine in any of your tables? With the size of this file growing and the crashing of MySQL, this indicates that one of your database tables may be corrupted and executing longer queries than normal. I've enabled the slow query log as well as the crash logs on your server, so if this happens again we may be able to determine which table caused the problem."

Does anyone have any suggestions to help. The url is https://www.jonasbrothersmerch.com

Thank,
billt

17 Feb 2008, 1:32 AM
#2
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: mysql hangs up

Funny, since you dont have that many categories or products or even attributes. This should not be a problem. Yep, we have to look at the sql log from the host to determine what went wrong.

17 Feb 2008, 1:37 AM
#3
billt avatar

billt

Zen Follower

Join Date:
Aug 2004
Posts:
93
Plugin Contributions:
0

Re: mysql hangs up

Thanks for the very fast reply. I will post them as soon as I can.