Sunday, 15 September 2013

php - Increasing mysql connections -



php - Increasing mysql connections -

we got big problem our mysql server setup. utilize zend framework 2 doctrine 2 , pdo mysql connection. our problem is, connections shown mysql > show status increasing , increasing. seems behavior slowing our whole application. @ moment connection count 150000. 5 hours before 2000.

we activated persistant connections in php.ini , on pdo connection. => no change

can behavior slow downwards our whole scheme or normal?

what problem?

thanks help

the 'connections' figure shown on show status total number of connection attempts made since server started (see: http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_connections). it's normal number maintain increasing, , it's highly unlikely slowing downwards application.

if application running should benchmark seek see bottleneck is.

php mysql doctrine2 zend-framework2

No comments:

Post a Comment