Problems using MySQL instead of MySQLi

Question

I have a blog, which is on Drupal v6.14. Recently I changed my web hosting provider. My new hosting provider does'nt support MySQLi. So I have to use MySQL instead of MySQLi. All things worked fine for some days. But on a very fine morning, I found my blog is down and the error message was Mysql: Too Many Connections to the server. And this problem occurs several times a day now.
I contacted my web hosting provider, they said, its a problem in your database. I don't trust this. My blog was working fine at old web server. Can it be a problem because I moved to MySQL from MYSQLi.

Answer 1

Check this entry from the MySQL documentation on the 'Too many connections' error. The number of allowed connections is a setting of the mysqld server. Depending on your hosting plan, you might be able to adjust this setting yourself, but for smaller plans this needs to be done by the provider. Also, if you are on a shared hosting plan, the mysqld server might well serve multiple databases besides your own.

There is no direct connection to the usage of the MySQLi vs. the MySQL driver.

So in summary, if your hosting plan comes with a dedicated MySQL instance, and gives you control over the mysqld settings, it is your problem. Otherwise, you need to resolve this with your provider.