Database Connections Increase when Post or Product is Updated – Site slows down

  • My wordpress site is fast on wp-admin and on the frontend UNTIL I edit/publish a post. As soon as I click Publish, the Database Connections start increasing exponentially and the site slows down so much that we have to restart the server.

    Any thoughts on the cause?

    Current Stats:
    Using Amazon EC2 Server
    100-350 Active visitors on the site when this happens
    Only increases DB connections when editing/publishing a post

    Plugins:
    Contact Form 7
    Duplicate Post
    SearchWP
    SearchWP Term Archive Priority
    Simply Share Buttons Adder
    WooCommerce
    Woo Amazon S3 Storage
    Woo MadMimi Integration
    Woo Name Your Price
    Woo Order Status Control
    Woo Paypal Payments Advanced Gateway
    Woo Points and Rewards
    Woo Smart Coupons
    Woo Table Rate Shipping
    Woothemes Helper
    Wordpress Download Monitor
    Wordpress SEO
    WP Super Cache

Viewing 1 replies (of 1 total)
  • Thread Starter markluchauer

    (@markluchauer)

    Here is another way to describe this issue:

    When editing a post or product, it creates multiple php processes that keep the connection to the database open which eventually kills memory on the server as it keeps trying to create new processes to serve the requests.

Viewing 1 replies (of 1 total)
  • The topic ‘Database Connections Increase when Post or Product is Updated – Site slows down’ is closed to new replies.