Autoblogged MySQL question

amsterdamned · Feb 2, 2010

Hey,

I was wondering if someone knows what the heck my host is talking about.

Today my (rather large package) but shared hosting account got disabled due to autoblogged. (Yes I know I should be on a VPS) but the host said something interesting:

The script could run very well (even on shared hosting) if it would only add "mysql_close" and change "mysql_pconnect" naar "mysql_connect".

Anyone run into this or know where to change this?

Thanks!

happyhatter · Feb 2, 2010

Sounds like they are complaining that you have too many open database connections.

Do a search in your script for mysql_pconnect and change it to mysql_connect so you can use mysql_close to close your database connection.

MrBlue · Feb 2, 2010

What shared hosting are you using?

funktrust · Feb 2, 2010

Don't waste your time and money on a VPS, do what I did, setup 25blogs per reseller account, there reseller servers have around 16cores, compared to the 2 core VPS. I was getting nothing but problems with my VPS, so I migrated all my sites across resellers.

theleanhorse · Feb 2, 2010

What software are you using to run your blogs? If you're using Wordpress I can't imagine that Wordpress is using the persistent connection and not closing them appropriately.

cozmic_ · Dec 4, 2011

amsterdamned said:
Hey,

I was wondering if someone knows what the heck my host is talking about.

Today my (rather large package) but shared hosting account got disabled due to autoblogged. (Yes I know I should be on a VPS) but the host said something interesting:

The script could run very well (even on shared hosting) if it would only add "mysql_close" and change "mysql_pconnect" naar "mysql_connect".

Anyone run into this or know where to change this?

Thanks!

I am in trouble with same problem. Autobogged kill my 3gb 2 core server (runnig only 2 websites) . I don't know why it sometimes consume all of the ram and swap of the server. It opens lots of mysql socks instantly and kills the server in 5 minutes. Did you fiugure out this problem ? Any suggestion?

Scripteen · Dec 4, 2011

Just change change "mysql_pconnect" to "mysql_connect" in all the script files and forget about mysql_close() as this might be tricky to add to all script files.

Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.

From http://www.php.net/manual/en/function.mysql-close.php

SpiderWebMaster · Dec 4, 2011

cozmic_ said:
I am in trouble with same problem. Autobogged kill my 3gb 2 core server (runnig only 2 websites) . I don't know why it sometimes consume all of the ram and swap of the server. It opens lots of mysql socks instantly and kills the server in 5 minutes. Did you fiugure out this problem ? Any suggestion?

You need a sysadmin to optimize your server. I run dozens of sites using autoblogged in servers with the same specs as yours and never got a problem. VPS's on the other hand would get killed, the same with reseller accounts.

Autoblogged MySQL question

amsterdamned

Regular Member

happyhatter

Registered Member

MrBlue

Senior Member

funktrust

Regular Member

theleanhorse

Junior Member

cozmic_

Newbie

Scripteen

Elite Member

SpiderWebMaster

Power Member

Main Menu

Marketplace

Making Money

BlackHat World