WordPress.org

Ready to get started?Download WordPress

Forums

mySQL crashed and host is blaming WordPress (5 posts)

  1. zapata
    Member
    Posted 6 years ago #

    I'm on a dedicated server at livingdot and this morning mySQL crashed... upon asking the host I got this reply:

    Your query_cache_size is set to 64M

    queries were:

    | 198519 | wrdp2 | localhost | wrdp2 | Sleep | 132 | | |
    | 198520 | wrdp2 | localhost | wrdp2 | Sleep | 133 | | |
    | 198521 | wrdp2 | localhost | wrdp2 | Sleep | 133 | | |
    | 198522 | wrdp2 | localhost | wrdp2 | Sleep | 132 | | |
    | 198523 | wrdp2 | localhost | wrdp2 | Sleep | 132 | | |
    | 198524 | wrdp2 | localhost | wrdp2 | Sleep | 133 | | |
    | 198525 | wrdp2 | localhost | wrdp2 | Sleep | 132 | | |
    | 198526 | wrdp2 | localhost | wrdp2 | Sleep | 132 | | |
    | 198527 | wrdp2 | localhost | wrdp2 | Sleep | 132 | | |
    | 198528 | wrdp2 | localhost | wrdp2 | Sleep | 132 | | |

    your scripts don't terminate unused connections. your queries should close connections after use.

    I've tried many times to find the root cause of the problems... what queries cause the servers to go slow and at time crash (I was on a shared server but since the problems occured on regular basis had moved to dedicated server upon my hosts advise)...

    Since this is happening once/twice a month and I'm not able to get a clear source of the problem from my host... how can in simple terms can I ask my host to "look here and see " to find the root cause of the problem.

    Recently (two weeks ago) I turned on APC and qcache the server speed had increased but this happening today leads me to believe I have to take care of some issues that neither me nor my host are aware of.

  2. zapata
    Member
    Posted 6 years ago #

    Here is also a list of plugins that I'm using... could anyone of them be a problem that you may have experienced?

    Akismet 1.15

    Awstats 1.0a

    Bad Behavior 2.0.10

    Dagon Design Form Mailer 5.33

    Democracy 2.0.1

    Feedburner Feed Replacement 2.1

    Flexible upload 1.5

    Get Recent Comments 1.3.1

    Google Sitemaps 2.7.1

    Google Translate 3.24.07

    IImage Gallery 1.9

    Lightbox JS v2.03.3 Plugin 1.7

    Most Commented 1.02

    My Video 1.3

    Optimal Title 1.0

    Organize Series Plugin 1.0

    Plugin AntiTroll 1.0

    podPress 8.2

    Role Manager 2.0.8

    Sidebar Widgets 1.0.20060711

    SimplePie for WordPress 1.2

    WordPress Database Backup 1.7

    WP-PostRatings 1.11

    WP-PostViews 1.00

    WP Movie Ratings 1.4

    Yahoo/MSN Style Smileys 4.4

    === Not all the above plugins are used on all pages... some plugins are used only on specific pages. Does anyone notice any plugin which may be causing a problem?

    According to my host's latest email:

    Your WordPress database is crashing the server, when we run the report to see all active queries we see the information we provided you with. In other words a bunch of open connections to the database, that are not being used. That's the reason our server administrators are asking if they're being closed.

  3. Samuel Wood (Otto)
    Tech Ninja
    Posted 6 years ago #

    WordPress does not use persistent connections. So when the script ends execution, the connection is closed.

  4. zapata
    Member
    Posted 6 years ago #

    Thanks Otto... I did inform my host about this.

    Since the server only has WP and bbPress... could there be any reason for mySQL to crash?

  5. zapata
    Member
    Posted 6 years ago #

    Just received host email:

    we have set value of max_user_connections to be the same as max_connections because there is only one account on the server. It should fix the problem

    I'll keep this thread informed about the results, in case any other users are facing similar issues.

Topic Closed

This topic has been closed to new replies.

About this Topic