PDA

View Full Version : SOS-Wrong with MySQL


tears
Wed 7th Feb '01, 11:40pm
Sometimes when more than 100 members in my forum powered by VBulletin 1.1x,the MySQL database will be someting wrong. but it does NOT affect other programs running in same sever.

the forum page said
----------------
Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in admin/db_mysql.php on line 31

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
----------------
So I can only reset the Sever(dual PII 400+256M+10G).
Can U help me?

JimF
Wed 7th Feb '01, 11:44pm
Next time you get that error, view the source of the message and paste it here. It will have the specific error message in it.

Going out on a limb, I'd say you have to increase your MAX_CONNECTIONS to MySQL; just a hunch, though.

-jim

tears
Thu 8th Feb '01, 5:05am
But it only said like this:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in config.inc.php on line 2

Warning: Supplied argument is not a valid MySQL-Link resource in config.inc.php on line 3

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/abbs/htdocs/index.php on line 9

-------------
I don't know anymore about MySQL,can U tell me how to increase the MAX_CONNECTIONS to MySQL?

Dark_Wizard
Thu 8th Feb '01, 7:44am
I agree with JimF....talk to your hosting provider and ask him to bump up "MAX_CONNECTIONS" in MySQL.

tears
Thu 8th Feb '01, 8:22am
thanks,but I have to change "MAX_CONNECTIONS" in MySQL myself.

Can u tell me how to do it?
I've create a my.cnf file in /etc,but it seems NO effect.

werehere
Thu 8th Feb '01, 1:36pm
That does not appear to be the too many connections error, so next time you get the error then view the source of the page and post it's contents here.

As a side note: After you make changes to your my.cnf file you will have to restart mysql to activate the changes! :)