Store wide Sale Issue

[DrByte]

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.

The only thing that happens in the database when a sale expires is a reset of prices without the sale applied.
How many products are in your database?
Do you use a lot of attributes?
Do you have attribute-dependent pricing ?

What happens if you (do a database backup first and then) go to Admin->Tools->Store Manager and click on Update all Products Price Sorter ?
If this step is the problem, well, you might wait a long time.

24 hours seems absurd. Especially since PHP is likely to time out after 5 minutes, or even 30 seconds depending on the server configuration.

[disciple]

Depended upon how high the load was. Most of the time it would just time out and you could not see anything. There were a few times the load was low enough that the page would load but you could not do anything or go anywhere else.

[disciple]

The only thing that happens in the database when a sale expires is a reset of prices without the sale applied.

How many products are in your database? over 3000

Do you use a lot of attributes? No

Do you have attribute-dependent pricing ? No

What happens if you (do a database backup first and then) go to Admin->Tools->Store Manager and click on Update all Products Price Sorter ? Don't know. Would have to try it.

24 hours seems absurd. Especially since PHP is likely to time out after 5 minutes, or even 30 seconds depending on the server configuration.
Regardless of how absurd it seems this is what happened each time we had a store wide sale.

[DrByte]

Clarification: When I said "absurd" earlier, it wasn't meant as derogatory. I probably should have said "insanely long". I meant to convey that I agree that it's unacceptable.


If you can do that price sorter reset, we'll know better what's happening.

[disciple]

I will be out most of the day. I will do it tonight or tomorrow.

Thanks

Rick

[disciple]

What happens if you (do a database backup first and then) go to Admin->Tools->Store Manager and click on Update all Products Price Sorter ?
If this step is the problem, well, you might wait a long time.

Went fast and as far as I can tell no problems

[disciple]

DrByte,

Do you have any other suggestions or ideas? We only have a few days left before we place everything on sale again.

Thanks

Rick

[DrByte]

Sorry - I have no idea, since I've never seen it happen and don't see why it would have any reason to do what you described.

I'd suggest just planning to keep a close eye on things, and if it does spike, watch exactly which SQL process are chewing up all the resources.

If it were me, I'd be doing a simulation before the sale to try to isolate the problem. Perhaps take a full backup of files+database and install on another server , and set up a sale, let it expire, and see what happens. Of course, you'll need to be clicking around in the test store at expiry time in order to trigger and observe things.