ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Performance testing server with jMeter - maxing 1500 mysql connections, code not closing mysql connections?

May 14, 2010 5:25pm

Subscribe [2]
  • #1 / May 14, 2010 5:25pm

    Brad Morse

    428 posts

    I am running a performance test on my development server of simulating 350 users hitting the site with an httpd request, at 2 second intervals.

    I set the max mysql connections to 1500 and within 40-50 seconds, it gives me the message of:

    Database Error: Unable to connect to your database. Your database appears to be turned off or the database connection settings in your config file are not correct. Please contact your hosting provider if the problem persists.

    The question I have, is it possible that EE does not close the connection after the user was done w/ it’s httpd request?

    EE 1.6.9
    MySQL 5.0.77
    PHP 5.1.6

  • #2 / May 14, 2010 5:40pm

    Ingmar

    29245 posts

    You are using non-persistent connections, correct? Even so, it does take some time to close the handle and your site seems to be running out of open connections.

  • #3 / May 17, 2010 9:58am

    Brad Morse

    428 posts

    Correct. http://cl.ly/82b97b60ea914dc59e29

    I think I am being unrealistic with the user load I am sending to the traffic and should work my way up to my maximum user/data load and then investigate.

  • #4 / May 17, 2010 3:42pm

    Ingmar

    29245 posts

    Sounds like a plan 😊 Let us know what you find out.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases