Database limits

[broda7710]

Hi Guys,

I have a problem with my database server and its limitations. I'm using Web hosting in one of biggest Polish web hosting company. My shop worked fine for over a year but since roundabout 3-4 months I'm experiencing problems with database. First problem when my database reaches max busy time (see error below), and than my shop is down for an hour:

1226 - User '************' has exceeded the 'busy_time' resource (current value: 600000000)

select value from sessions where sesskey = '31733edff5c8ecba4fd3a71d9daaa143' and expiry > '1230644382'

and second during product import into excel:

1226 - User '************' has exceeded the 'max_questions' resource (current value: 200000)

select configuration_key as cfgKey, configuration_value as cfgValue from configuration.

 

I know what these errors means but I'm looking a tip how to avoid my server limits, maybe due to database configuration or shop adjustment.

Thank for any help.

[Jan Zonjee]

I'm looking a tip how to avoid my server limits

Thread on the topic: A Store Speed Optimization in Progress, Step by step from a vanilla install!

 

Output Queries Debug Contribution to see how many queries a page generates and how long it takes to execute them (find excessive amount of queries or slow ones).

 

Optimize tep_get_tax_rate() method

 

Optimize categories box

 

tep_get_category_tree optimization (only helpful on the admin side)