MYSQL

Ask questions about dedicated servers here and we and other users will do our best to answer them. Please also refer to the self-help section for tutorials and answers to the most commonly asked questions.
Post Reply
Dooty
A semi-regular
A semi-regular
Posts: 24
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Tue Mar 26, 2013 11:10 am

MYSQL

Post by Dooty »

how can i fix this?
http://imgur.com/r5Nco3j
User avatar
Edge100x
Founder
Founder
Posts: 13156
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: MYSQL

Post by Edge100x »

This means that you have a MySQL-using application that has connected to the MySQL server too many times. If you shut down the offender, the error should clear up.
Dooty
A semi-regular
A semi-regular
Posts: 24
Joined: Tue Mar 26, 2013 11:10 am

Re: MYSQL

Post by Dooty »

how do i fix this? im only using wampserver and hosting a game. On other vps that ive bought, i never had this issue.
User avatar
Edge100x
Founder
Founder
Posts: 13156
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: MYSQL

Post by Edge100x »

Do you have a plugin on your game server that is trying to access your MySQL server? If so, I am saying that if you shut down that server, the error should disappear. You should then troubleshoot your plugin to determine why it's opening so many connections.
Dooty
A semi-regular
A semi-regular
Posts: 24
Joined: Tue Mar 26, 2013 11:10 am

Re: MYSQL

Post by Dooty »

well then i know the reason why is this happening. When someone enters my site, my batch shows the vps ip. how do i fix this? i installed everything the same on all the vps i buy. only this and one other had this. where when someone enters site, it shows vps ip on batch
User avatar
Edge100x
Founder
Founder
Posts: 13156
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: MYSQL

Post by Edge100x »

I don't know what you mean when you say it shows the IP by batch.

Most applications that use MySQL databases use a single connection at a time and close it when they are done. For you to be seeing this error, you have some application or applications that is/are opening many connections and holding them open.
Dooty
A semi-regular
A semi-regular
Posts: 24
Joined: Tue Mar 26, 2013 11:10 am

Re: MYSQL

Post by Dooty »

my game server is only using one connection per user. When i hold refresh on my website, my batch gets spammed with vps ip since the site is hosted on it. Im not sure why its doing that. Im using wampserver 64 bits & php 5.3 2.2E
Post Reply