Multisite errored due to "Error establishing a database connection"

  • Sai Siddula

    (@uorwst)


    11 years, 3 months ago

    Hi,

    Before creating this new post I did search on internet for the generic error- “Error establishing a database connection” I tried / checked the options given in those blogs. However I still get the error and I think my situation is bit different.

    I have a multisite and there are around 200 blogs. We started getting this error since yesterday. I checked the wp-config settings all the details seems to working. I checked phpmyadmin page and was able to access the db as well. However, it was very slow. So we immediately thought it could be spammers inserting comments in one of the blog so we immediately cut off access to our blogs to external world and made it only to our organisation. Things started to improve and we were able to access website. and also we disabled all the comments for all the blogs. But now we hit a dead end not sure what to do or check to rectify this problem. It could be a blog which is causing this problem but not sure how to pin point that blog. Could someone please guide and provide some information on what steps I need to do to fix this problem.

    Thanks
    Sai

Viewing 3 replies - 1 through 3 (of 3 total)
  • Dimitris – WPMU DEV Support

    (@wpmudev-support6)

    11 years, 3 months ago

    Hello Sai,

    Hope you are well today!

    I am assuming that you have correct details in the wp-config.php,
    and this happens on different occasions, whne the MySQL server is not responding to the queries.

    This might be problem with the MySQL server and a high I/O on the server.

    Do you host your files and MySQL on the same server or they are separated?
    What is your configuration – shared hosting, VSP, dedicated server?

    What is the load average on the MySQL server?

    This questions might help narrow the problem, but it will be hard to find the exact problem and a solution for it on a public forum. Even if it happen it will take a lot of time.
    Best approach is to hire a system admin to find the bottleneck and offer you a solution.

    Thanks,
    Ivan

    Thread Starter Sai Siddula

    (@uorwst)

    11 years, 3 months ago

    Hi Ivan, Thanks for your reply.

    Our Application server is different from MySQL server. I will do check on the IO on MySQL server. I had chat with networks team as well today and looks like there is some DNS/ network issues currently. I’m assuming those network issues might have caused the problem. I will wait until they fix the issue and see if WordPress issue still persists.

    Thanks for your reply.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    11 years, 3 months ago

    Our Application server is different from MySQL server.

    That’s fine.

    I checked phpmyadmin page and was able to access the db as well. However, it was very slow.

    THAT may be the issue. Try pinging the SQL sever from the WWW host. See if that’s crazy slow. You may need to set up some reverse DNS lookups.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Multisite errored due to "Error establishing a database connection"’ is closed to new replies.

Tags