Limit concurrent mySQL connections

  • Hi,

    I am using latest version of WordPress on my website: https://www.mirasbrides.com
    I’ve build the website just a couple of weeks ago. It was providing good response and I was getting 1000+ visitors a day. On 4th October I got 3000+ unique visitors on my website. And than I have installed “Google XML Sitemaps” plugin. I was using a free theme from SMThemes.

    Than suddenly I was unable to access my website. I found “Error in establishing database connection”.

    I contacted with my hosting support and they replied:

    We have a limit of 10 concurrent MySQL connections and for database, it appears like at that time you have exceeded the above limit and hence received the error message.

    In order to prevent the such issues in future, you need to modify the scripts in such a way that it does not use 10 concurrent MySQL connections at a time. You can contact your system Administrator or vender of the application to get the details.

    I’ve hired a developer, but he was not able to sort it. I can’t access to admin panel. When I tried to access phpMyAdmin, it don’t allow to browse tables because of some restrictions.

    One developer told me that this issue is because of theme, which is using more databases resources.

    Than suddenly I’ve noticed that my website is live again and I was able to access admin panel. I have changed my theme from “EURODOM” to “Tydskrif”. After 30 minutes I got the same issue, Error in esatblishing database connection.

    One developer told me that there should be only one open connection no matter how much traffic you have on your website. But he is not able to put this limit.

    Kindly help me what should I do to overcome this problem. I am loosing thousands of visitors daily ??

    Thanks

Viewing 15 replies - 1 through 15 (of 17 total)

  • Have you tried:

    – deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the default theme to rule out any theme-specific problems.

    – resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems.

    Thread Starter fiz.kamran

    (@fizkamran)

    Thank you for the suggestions.

    I have deactivated all the plugins from FTP. And my site starts running again fine.

    Than I have activated Google Adsense plugin and NextGen Gallery Plugin. After getting 30 to 40 visits my site was down again.

    Again I deactivated all the plugins and then activated only Adsense plugin. My site was again running fine. Than I’ve activated ALL in one SEO plugin. Got no problem. Again I activated NextGen Gallery and site goes down again. Which means there is a problem in Next Gen.

    Than I have activated all the plugins except NextGen. And site goes down again. It means there is some other plugin as well which is problematic. Now, I am confirm about NextGen. Will find the other plugin as well.

    but I want to know how to resolve this issue with NextGen? Just keep it deactivated is not the solution I think as I need to use this plugin. It is very useful and I am using it on other site as well where it is working fine. How can I fix the problem in NextGen Gallery plugin?

    Thanks.

    Increase max_connection variable : 200 i am using (100 by default) Open table cache: 512 (400 by default.

    that will fix the problem:

    NOTE:some hosting company dont alow to change this…

    You can try to solve this, and you will succeed temporarily, but the problems will rise again together with the amount of visitors.

    Simply install a cache plugin like W3 Total Cache and configure it to use the advanced page cache.

    For normal page views, it doesn’t even need to make a database connection anymore (it will just server a static file). Nice side effect: it will make you site fly ??

    Jeroen

    this will not resolve the iss with W3 Total Cache ,because will crash when is update to mod rewrite..

    But he can try….

    he..also he can edit the htaccess and see what is the ip cousing this,,and block that ip…remember one IP use a lot of conection like robots..

    I think it will resolve the issue, but I don’t understand your argument. ‘because will crash when is update to mod rewrite’ doesn’t make any sense to me, I’m sorry.

    Of course, W3TC will need to build the cache, but after that, no more database access is needed.

    I do think TS’s site is getting a questionable amount of traffic for a new site with PageRank 0. This traffic could be due to some attack. Please check log files to find the IP (range) this traffic is coming from and block it in .htaccess.

    Jeroen

    Thread Starter fiz.kamran

    (@fizkamran)

    Well, thanks for your responses, I will try these for sure.

    But about traffic, I have real traffic on my website, almost 2000+ unique visitors daily. I have very strong social profiles. Like, on my Google + profile I have 30,000+ followers. When I share my website’s link I got traffic. On my facebook fan page, I have 800K plus fans. And all are interested in the topic of my website. So when I share my link on facebook, I got a lot of traffic from there as well. My google analytics shows 95% traffic coming from Facebook and Google plus.

    About W3 Total cache, after installing and configuring this tool, can I use NextGen Gallery again?

    Thanks to all of you for your help ??

    Yes you can.

    Jeroen

    Thread Starter fiz.kamran

    (@fizkamran)

    Fatal error: Call to undefined function w3tc_button_link() in /hermes/waloraweb035/****/**********/wp-content/plugins/w3-total-cache/lib/W3/GenericAdminEnvironment.php on line 99

    https://bit.ly/GKM8EC

    Jeroen

    Thread Starter fiz.kamran

    (@fizkamran)

    Thanks ??

    It worked. Now, I have just enable the options:

    Page Cache

    Enable page caching to decrease the response time of the site.

    Page cache: Enable (I’ve enabled it)
    Caching pages will reduce the response time of your site and increase the scale of your web server.

    I’ve touch any other option in the settings. Is this all I’ve to do?

    Page cache (and be sure to select the enhanced one) is the most important to you.

    Furthermore, you could enable Browser Cache and Minify. The other options are generally useless.

    Jeroen

    Thread Starter fiz.kamran

    (@fizkamran)

    Ok, done.

    Now I am going to enable all my plugins. And hoping, everything will be fine.

    Thanks.

    Please remind to empty your cache when you activate a plugin, W3TC will ask you to do so by default.

    Jeroen

    Thread Starter fiz.kamran

    (@fizkamran)

    My CSS is disturbed now. Watch here: https://www.mirasbrides.com/

    Left side bar is not visible. Slider is not visible. Menus are gone. ?? ??

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Limit concurrent mySQL connections’ is closed to new replies.