5

debian mysql server always down

view full story
linux-howto

http://serverfault.com – I am hosting a mysql server in a debian 6.0.4 server hosted in linode, the new data is frequently written into the mysql server using R, about 30-40 "write" per minute, about 7 hours a day, 5 days a week. Recently I found that the mysql server seem to down frequently, always give me error that mysql server cannot be connected through socket. I wonder if this is caused by my high demand to my mysql server, and if this can be solved. I am definitely a newbie in manage server. Please let me know if I need to provide additional information for this question in order to get it solved. Thanks. up (HowTos)

dayu's picture
Submitted by dayu on 04/09/2012 – Made popular on 04/09/2012

Stories similar to debian mysql server always down

The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down:

mysql> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection.

My server hangs everyday

So i checked system health - process manager in whm

there was a command given below

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306

see this image

here this mysql command process is taking

I have 2 servers, both running Ubuntu server 11.10. The first server runs Apache and PHP and it connects to a Mysql database on the second server.

The problem is slow mysql response on the second server.mysql logs does not show any errros other than: 120526 12:56:27 [Note] Plugin 'FEDERATED' is disabled.

I can start mysql fine,

/usr/local/mysql/support-files/mysql.server start Starting MySQL SUCCESS!

But any mysql action after that I get the error: MySQL server PID file could not be found

/usr/local/mysql/support-files/mysql.server stop ERROR! MySQL server PID file could not be found!

Where do I find the server PID file on Mac with OSX 10.8? I am wondering if it is a permission problem.

MySQL Data Center Replication 18 weeks 1 hour ago

I have a (possibly not so quick question) about the best way to set up a 'global' MySQL Database.

I basically need to set up multiple MySQL servers in separate geographical locations that will all server the same data set (i.e. If I add data to one server, it will appear on another server relatively quickly).

I think yum is having problems installing MySQL 5.1 because there is already a pre-existing MySQL 5.5 installation.

I wanted to cleanly remove MySQL 5.5 (I had problems with 5.5 with PHP and Python).

My MySQL server has broken down, and I can't figure out why. Trying to do a yum reinstall I get this: Error: mysql-server conflicts with mysql-server

I figure that's because the server already had the mysql server, and when I ran the upgrade, everything got messed up.

I'm unable to access MySQL, so I can't even do a mysqldump. How can I reinstall without compromising my existing databases?

I'm trying to install MySQL 5.5 on Ubuntu 12.04, but I'm stuck with this error:

Setting up mysql-server-5.5 (5.5.24-0ubuntu0.12.04.1) ... start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent co

Hi

I have mysql server 5.0 installed via binary package on RHEL 5 where I have big databases running on it.

I want to upgrade mysql server to 5.1 without backup/restore of DBs. what is the best way to do this?