database site keep falling over...

[dsilvera]

Hi all - i hope someone can help.


all of my sites that use Mysql and php keep stopping with the following error: server is currently unavailable, Web Team

I emailed my server tech support - their reply is below.

I need real help asap - all my db sites have been up and down like yoyos today.

------------------------------------------------------
From Verio Enterprise suport

I've tracked this down to this piece of code:

----
if ($xxServOpen($linkdbas,$hostname,$username,$password) == false){
die('<h3>Sorry, The server is currently unavailable.<br><br>Web
----

Which is part of the directadmin. Basically directadmin cannot access the mysql database that it stores all this in and then throws up the error. It's all internal to the box, it's not going off for anything so it appears to be a misconfiguration in directadmin.

I notice that it's started 111 mysql processes which is probably a problem, you certainly shouldn't need anywhere near that many, and this may be related to database connectivity issues.

-----------------------------------------------------------------------------

Nb server is IBM 306 with 512mb ram - am adding another gig asap


Thanks in advance
Dave Silvera

 

[nobaloney]

I've never seen this before; may I suggest sending an email to DirectAdmin support?

They may be able to help you figure it out.

In the meantime try removing mysql from the list of programs DA monitors to see if this helps keep it running. You can search these forums for the location.

Jeff

 

[dsilvera]

Update

Hi - think weve solved it - my tech guys got back with:
---------------------------------------------
I've (potentially) resolved this by modifying the MySQL configuration. Previously there was no 'my.cnf' file under /etc/, which meant that mysqld loaded with the default values. Under /home/admin/accom_main_code/sitelogg/ I found some logfiles indicating that the maximum number of connections was being made and that was causing the failures on the sites.

I created a my.cnf from the template 'medium load' configuration file and doubled the connections from 100 to 200, which should hopefully help this. We'll have to monitor it over the near future to see if the problems carry on.
----------------------------------------------------

Fingers crossed

Dave

 

[nobaloney]

There's a good my.cnf file posted somewhere on these forums which includes a lot of optimizations. You may want to check it out.

Jeff