A site running modx 2.0.7pl trad. is maxing out my mysql connections with requests to the mod session table
example (from SHOW FULL PROCESSLIST):
| 1123784 | xxxx | localhost | xnamex | Query | 25 | Locked | SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = '54a9a0de712dc3326c1fac6638bc31234'
I have max_connections = 151
almost all in the list looked much like the example.
Can some one give me an idea how to prevent this??
enviro. info.
mysql 5.1.50 (client 5.0.9.0)
php 5.2.17 with pdo
Apache/2.2.3 (CentOS)
no opcode cache
error log has lots of this stuff:
[2011-04-07 16:00:48] (ERROR in xPDO::connect @ /var/www/vhosts/domain.org/httpdocs/core/xpdo/xpdo.class.php : 331) SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'sending authentication information', system error: 32
[2011-04-07 16:00:48] (ERROR @ /index.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ? - Array
(
[0] => 00000
)
[2011-04-07 16:00:55] (ERROR @ /index.php) No class specified for loadClass
