Store regularly crashes until I optimize database

[Cheepnis]

Fairly regularly, when I log on in the morning, I find that the customer side of the store has crashed (500 Server Error). When I optimize the database from the admin side (or via phpMyAdmin) it is fixed. Any idea why this would happen? I can't sit around waiting for the store to crash all the time and I don't know how to set a cron job to optimize nightly (nor should it even be necessary, to be honest).

[Kim]

We need more information -

What version of Zen Cart?
What Addons do you have installed?
What errors are you seeing?
Who is the host?
What version of php?
What version of MySQL?

[Cheepnis]

We need more information -

What version of Zen Cart?
1.3.9.h

What Addons do you have installed?
Edit Orders (latest version, as of a month ago)
Backup Zen Cart Version 1.0.7 (never used since it won't work w/ admin-wide SSL)
Database Backup Manager MySQL
Enhanced Who's Online
Easy Populate
Query Cache 1.7

What errors are you seeing?
500 Server Error (store side)
none (admin side)

Who is the host?
domaindiscover.com

What version of php?
5.2.4-2ubuntu5.17 (Zend: 2.2.0)

What version of MySQL?
MySQL 5.0.51a-3ubuntu5.8-log
(I switched all tables except products_description to InnoDB from MyISAM in order to prevent max user connection lockups, but that hasn't been a problem before)

[Cheepnis]

Any help?

[kuroi]

Has your apache error log recorded the reason for the server errors?

[Vger]

I switched all tables except products_description to InnoDB from MyISAM in order to prevent max user connection lockups, but that hasn't been a problem before

Exceeding max user connections for MySQL should not be a problem unless:

1. You have a very poor host. Check with them what the max user connections allowance is.
2. You have an exceptionally busy website. This seems unlikely if it is happening overnight.
3. You have reset the default setting in the configuration.php files to allow persistent MySQL connections.

correct setting:

define('USE_PCONNECT', 'false');

Vger

[Cheepnis]

Exceeding max user connections for MySQL should not be a problem unless:

1. You have a very poor host. Check with them what the max user connections allowance is.
2. You have an exceptionally busy website. This seems unlikely if it is happening overnight.
3. You have reset the default setting in the configuration.php files to allow persistent MySQL connections.

correct setting:

define('USE_PCONNECT', 'false');

Vger

1. My host has the max user connection set to 10 and they won't budge unless I buy dedicated server, claiming 10 is more than enough. They are actually pretty good, but aren't interested in debugging my store scripts, naturally.
2. Nothing too bad, (10-15 at a time, including spiders).
3. the configure setting you described hasn't changed and is at the default you posted.

The logs don't indicate anything unusual.

[DrByte]

I find that the customer side of the store has crashed (500 Server Error).

Has your apache error log recorded the reason for the server errors?

As kuroi indicated, your server holds the key to the actual cause of the "500" error.
https://www.zen-cart.com/tutorials/index.php?article=63