MySQL crashes

Anybody have any idea why MySQL would start to have this error message
every 4 or so days at midnight:

Connection error: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

This just started happening a little more than 2 weeks ago. The server
has been running fine for almost two years.

MySQL is on a Linux system. There are about 750 dbs and accessed by
approximately half that number websites (375). Half of the websites are
on a different server than the MySQL server.

Charlene

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL crashes

Charlene,

You should check the mysql error log and if there isn't a message about
the cause there you may want to check /var/log/syslog for mysql being
killed by oomkiller.

Tyler

On 6/21/10 11:11 AM, Charlene wrote:
> Anybody have any idea why MySQL would start to have this error message
> every 4 or so days at midnight:
>
> Connection error: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
> This just started happening a little more than 2 weeks ago. The
> server has been running fine for almost two years.
>
> MySQL is on a Linux system. There are about 750 dbs and accessed by
> approximately half that number websites (375). Half of the websites
> are on a different server than the MySQL server.
>
> Charlene
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL crashes

Charlene wrote:
> Anybody have any idea why MySQL would start to have this error message
> every 4 or so days at midnight:
>

Do look at the logs, but if the error always occurs at midnight, you
might look for a disk backup or compression program that's scheduled
to run than and accesses the database files incompatibly.

Cheers,

Ann

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL crashes

--0016e6d588b9ef523104898bf29a
Content-Type: text/plain; charset=ISO-8859-1

you can stop your Mysql server (the program) and delete the file mysql.sock
and the try to start.




2010/6/21 Tyler Poland

> Charlene,
>
> You should check the mysql error log and if there isn't a message about the
> cause there you may want to check /var/log/syslog for mysql being killed by
> oomkiller.
>
> Tyler
>
>
> On 6/21/10 11:11 AM, Charlene wrote:
>
>> Anybody have any idea why MySQL would start to have this error message
>> every 4 or so days at midnight:
>>
>> Connection error: Can't connect to local MySQL server through socket
>> '/var/lib/mysql/mysql.sock' (2)
>>
>> This just started happening a little more than 2 weeks ago. The server
>> has been running fine for almost two years.
>>
>> MySQL is on a Linux system. There are about 750 dbs and accessed by
>> approximately half that number websites (375). Half of the websites are on
>> a different server than the MySQL server.
>>
>> Charlene
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=guifre.bosch@gmail.com
>
>


--
Guifre Bosch Fabregas
Tlf.: 687911075

--0016e6d588b9ef523104898bf29a--