MySQL bottlneck - getting mysql errors

[ksoup]

about 7400... mainly downloadables (which means at least one attribute on each one)

has anyone seen a zen cart database larger than this? how far can it be pushed!

Not better optimization of Zen Cart - more to optimizing your server LAMP settings and these are not something many will share as hours upon hours are spent in finetuning these settings.

Question: DB is 500MB?? How many products do you have?

[DrByte]

Have you enabled Email Archiving? If so, why? You should probably trim it down if you plan to keep it enabled.
Do you clear your Admin Activity Log regularly?
Naturally, make backups before you go deleting any information.


I've seen several databases larger than 500 MB, and they operate just fine.

Your performance issues are more likely related to your server's general configuration than to the size of the database. Having such high sustained load-averages is going to slow everything down.

Tuning your MySQL settings may help, but your load averages should be dealt with first.

[ksoup]

The email archive table is empty .. and we clean admin when the site flags us at the top in the admin area... so both good things.

Have you enabled Email Archiving? If so, why? You should probably trim it down if you plan to keep it enabled.
Do you clear your Admin Activity Log regularly?
Naturally, make backups before you go deleting any information.


I've seen several databases larger than 500 MB, and they operate just fine.

Your performance issues are more likely related to your server's general configuration than to the size of the database. Having such high sustained load-averages is going to slow everything down.

Tuning your MySQL settings may help, but your load averages should be dealt with first.