Connecting to the MySQL Server

bluenoser · 08-22-2005, 12:06 PM

I am having some problems with my websites, they are maxxing out their connections. They are not very high traffic sites and the hosting company is claiming that I am using too many connections.

There are 4 scripts on the account. 3 Wrodpress blogs and one PHPNUKE site. The PHPNUKE site is the pre-modded PNP verison

Does anyone know if there is anything that I can do to lessen my load on the server? Or do you think that the hosting company is talking out their behinds?

BTW when I say low traffic I mean a total of 500 hits a day combined.

iNod · 08-22-2005, 12:10 PM

That is defently the hosting company.. I suggest you change. MySQL server can handel many many sql select commands at once. Theya re probley not on a fast server or they don't know what there talking about.

PM me if you want any reccommanded hosting companies.

Regards,

RJ · 08-22-2005, 12:34 PM

If any of the scripts you're using have an option for using "persistant connections", turn that feature off.

By the way, the number of connections is set for the entire server and not likely to just your account. If you're only getting that small amount of traffic, its more likely that there is another account on the same hosting server that is hogging all the MySQL connections, such as a vBulletin forum with persistant connections enabled.

500 visits a day is a very light load for MySQL. Change hosts, imho.

aween · 08-22-2005, 12:44 PM

Originally Posted by -RJ-

If any of the scripts you're using have an option for using "persistant connections", turn that feature off.
????: NamePros.com http://www.namepros.com/programming/117638-connecting-to-the-mysql-server.html

By the way, the number of connections is set for the entire server and not likely to just your account. If you're only getting that small amount of traffic, its more likely that there is another account on the same hosting server that is hogging all the MySQL connections, such as a vBulletin forum with persistant connections enabled.

500 visits a day is a very light load for MySQL. Change hosts, imho.

couldnt agree more

bluenoser · 08-22-2005, 12:57 PM

Thanks, I will check to see for the persistent connections option. The problem just started again,

And about the hosts, I JUST changed host and would rather not go through it again. I hope I can get it fixed.

I will let you know how it goes

bluenoser · 08-24-2005, 08:24 AM

Originally Posted by bluenoser

Thanks, I will check to see for the persistent connections option. The problem just started again,
????: NamePros.com http://www.namepros.com/showthread.php?t=117638

And about the hosts, I JUST changed host and would rather not go through it again. I hope I can get it fixed.

I will let you know how it goes

There were NO persistent connections options that I could see. And it seemed like it would dissconnect from the database after each query, or at least the majority of them

Is there any better ways to connect? I hear pconnect was supposed to be better?

08-22-2005, 12:06 PM	THREAD STARTER #1 (permalink)
bluenoser NamePros Regular Join Date: Aug 2005 Location: Canada Posts: 455	Connecting to the MySQL Server I am having some problems with my websites, they are maxxing out their connections. They are not very high traffic sites and the hosting company is claiming that I am using too many connections. There are 4 scripts on the account. 3 Wrodpress blogs and one PHPNUKE site. The PHPNUKE site is the pre-modded PNP verison Does anyone know if there is anything that I can do to lessen my load on the server? Or do you think that the hosting company is talking out their behinds? BTW when I say low traffic I mean a total of 500 hits a day combined. __________________ Webmaster Blog Hoser News Why I like RecieveLinks

08-22-2005, 12:10 PM	#2 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,272	That is defently the hosting company.. I suggest you change. MySQL server can handel many many sql select commands at once. Theya re probley not on a fast server or they don't know what there talking about. PM me if you want any reccommanded hosting companies. Regards, __________________ I feel old.

08-22-2005, 12:34 PM	#3 (permalink)
RJ NamePros Webmaster Join Date: Feb 2003 Posts: 12,930 Follow @DomainBuyer	If any of the scripts you're using have an option for using "persistant connections", turn that feature off. By the way, the number of connections is set for the entire server and not likely to just your account. If you're only getting that small amount of traffic, its more likely that there is another account on the same hosting server that is hogging all the MySQL connections, such as a vBulletin forum with persistant connections enabled. 500 visits a day is a very light load for MySQL. Change hosts, imho. __________________ @DomainBuyer facebook

08-22-2005, 12:57 PM	THREAD STARTER #5 (permalink)
bluenoser NamePros Regular Join Date: Aug 2005 Location: Canada Posts: 455	Thanks, I will check to see for the persistent connections option. The problem just started again, And about the hosts, I JUST changed host and would rather not go through it again. I hope I can get it fixed. I will let you know how it goes __________________ Webmaster Blog Hoser News Why I like RecieveLinks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 02:24 PM
soooo many yahoo's	redhippo	Domain Name Discussion	5	07-13-2005 12:26 AM
Dedicated Servers from just £45 $90 + [UK] 1 TB Data Transfer P4 3.0GHZ Only £119	blackicehosting	Web Hosting Offers	0	07-12-2005 07:24 PM
Unmetered Summer Savings + 10% Discount	blackicehosting	Web Hosting Offers	0	07-02-2005 12:20 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)