MySQL Keeps Down (Cpanel Server)

May 30, 2007

I have a Cpanel server with a problem: SQL keeps failing

Everytime I try to restart MySQL via WHM, it gives me:

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock'
exists! mysql has failed, please contact the sysadmin (result was "mysql
has failed").

I can only restart it successfully after 2nd attempt. Server load is always low. Memory usage is also low.

It happens in very short interval (in less than every 1-10 minutes)

It never happens until recently when my server management company tweak something I didn't know. They said fixed it and then it happens again every minutes.

I have 9 servers and it never happens to the rest 8 servers. Just this server always happening.

View 14 Replies


ADVERTISEMENT

How To Use External CPanel Mysql In Another CPanel Server

Mar 14, 2007

I have 2 servers both have cpanel. I want to use 2nd server's mysql in my site which is on 1st server. I think thats not that hard. I don't wanna do clustering as this is temproary.

View 2 Replies View Related

How To Upgrade Mysql 4.0 To 4.1 On Cpanel Server

Mar 22, 2007

how to upgrade mysql 4.0 to 4.1 on cpanel server? Is there any script there?

View 2 Replies View Related

MySQL Error : MySQL Server Has Gone Away

Dec 18, 2007

I keep getting this error :
MySQL Error : MySQL server has gone away

How do I fix it?

my.cnf contents

Quote:

[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

View 5 Replies View Related

Your PHP MySQL Library Version 5.0.75 Differs From Your MySQL Server Version

Jun 27, 2009

I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :

Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.

View 2 Replies View Related

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

May 8, 2009

Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved