Hi all,
after upgrading to Drupal 7.19 I'm having serious problems which cause my site
http://www.marketingaziende.it
to become practically unusable. In particulare I frequently have two kinds of PDOExeception:
PDOException: SQLSTATE[08004] [1040] Too many connections in lock_may_be_available()
PDOException: user XXXXXX has more than max user connections'.
The above problems never happened before upgrading to 7.19.
I'm wondering if the new version 7.19 relies on threads more than previous versions. However, since caching is enabled, each script closes the connection to the DB as long as is no more required, I really don't know should be done to improve the situation.
Here are some SQL configuration variables:
max allowed packet 1.048.576
max connect errors 60.000
max connections 200
max user connections 4
max delayed threads 20
max error count 64
max heap table size 16.777.216
max insert delayed threads 20
max join size 18.446.744.073.709.552.000
max length for sort data 1.024
max prepared stmt count 16.382
max relay log size 0
max seeks for key 18.446.744.073.709.552.000
max sort length 1.024
max sp recursion depth 0
max tmp tables 32
Thanks in advance for your support
Luciano Mallamaci
