Greetings All,

Having an interesting problem that started a day ago. When I go to Tools -> Send Mail, our server load goes through the roof (100%) and shuts down services. The page never finishes loading and our site looses db connection and defaults to the nddbc.html page...

I checked the customers table via phpMyAdmin and it shows 61K rows. I am on a dedicated server, but not sure why in the past day it would be come a problem???

The support folks (hostgator) said I needed to optimize my queries because something was "Stacking" queries to MySQL???

I have another install (same Zen Cart code base, different template), but with only 2K customers and the Send Email takes about 45 sec to load. However, it does complete.

Using Zen Cart 1.3.8x (can't upgrade at this time), MySQL 5.0.96-community, PHP 5.2.14, Apache 2.2.16

Any suggestions as where to look? Do you think this is a MySQL config issues that may have changed?

Thank you