Store wide Sale Issue

[disciple]

Hi,

We have had 3 store wide sales in the last couple years and after each one ended our site went down for a day or so. We are about to have another one in a couple of weeks and I am wondering if anyone else has experienced this issue.

Thanks

Rick

[Kim]

Rick-

Describe "down"? Did your server go down? Was the Database a problem? More details please.

[disciple]

It was just the store that went down. We believe it was a database issue. All other areas of the site and server experienced no problems.

[Kim]

And the database crashed after you did something or when the sale ended automatically? What did you do to restore things?

[disciple]

It sounds really odd but once the sale ended automatically the store went down and after a day or so it came back up.

[Kim]

What version of Zen Cart? PHP? MYSQL?

[disciple]

Zen Cart: Is current. Don't remember specific versions when crashes happened
MySQL 4.1.22-standard
PHP Version: 4.4.7 (Zend: 1.3.0)

[DrByte]

I'm still not following what you mean by "the store went down".
Did you get "database not connected" messages?
Did you get "down for maintenance" notices?
Did you get blank screens?
Did you get specific error messages?
Was your admin area still accessible?

If you're gutsy, what happens if you turn on a tiny 1% store-wide sale effective yesterday and make it expire today? Or starts today and expires tomorrow?

[disciple]

Did you get "database not connected" messages? No

Did you get "down for maintenance" notices? No

Did you get blank screens? No

Did you get specific error messages? No

Was your admin area still accessible? No

The main problem (as I looked back at messages I saved) was that at the end of the sale my server load went through the roof. It was due to mysql processes on the store database.

 ++++++++++
root@trinity1 [~]# mysqladmin proc
+------+----------+-----------+-------------------+---------+------+-----------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+----------+-----------+-------------------+---------+------+-----------+------------------------------------------------------------------------------------------------------+
| 1274 | digitals | localhost | digitals_database | Query | 0 | | select products_price, products_priced_by_attribute from products where products_id = '4600' |
| 1276 | digitals | localhost | digitals_database | Query | 0 | query end | select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product |
| 1283 | digitals | localhost | digitals_database | Query | 0 | query end | select master_categories_id from products where products_id = '3277' |
| 1284 | digitals | localhost | digitals_database | Query   | 0    | Locked    | update products set
                  products_price_sorter='6.5000'
                  where produ |
| 1285 | digitals | localhost | digitals_database | Query | 0 | Locked | select master_categories_id from products where products_id = '1168' |
| 1287 | digitals | localhost | digitals_database | Query | 0 | query end | select master_categories_id from products where products_id = '4707' |
| 1292 | digitals | localhost | digitals_database | Query   | 0    | Locked    | update products set
                  products_price_sorter='3.7500'
                  where produ |
++++++++++++

There seemed to be nothing we could do to stop it. However if it runs it course in about 24-30 hours suddenly everything is fine.

[DrByte]

Did you get "database not connected" messages? No

Did you get "down for maintenance" notices? No

Did you get blank screens? No

Did you get specific error messages? No

So, what did you see in your browser?