How to automatically restart MySQL after server rebooted?
location: linuxquestions.com - date: May 1, 2012
I have a web site that uses MySQL database. My problem is whenever the web server got rebooted, I have to manually restart the MySQL server (/etc/init.d/mysqld restart) otherwise the web site does not work.
Is there a way to do automatic restart to the MySQL after the web server has rebooted?
Have to constantly restart mysql service
location: ubuntuforums.com - date: May 12, 2012
I'm running Ubuntu 12.04 on an EC2 Micro instance. I have a very small Joomla 1.5 site there. The server also has webmin, vsftp and awstats installed. Typically ram usage on the instance is around 40% in use, with about 20% average CPU use, and bursts to about 60% cpu usage so this is a very small system. It takes less than 1,000 hits per month.
I recently set this server up. It was running fantastic for a week straight without any crashes, and now it has suddenly started to crash. Simply restarting the mysql service solves the problem. When reviewing the syslog, there is 1 anomaly:
May 12 10:43:01 ip-10-202-18-193 kernel: [46106.736962] Out of memory: Kill process 707 (mysqld) score 131 or sacrifice child
May 12 10:43:01 ip-10-202-18-193 kernel: [46106.736980] Killed process 707 (mysqld) total-vm:889284kB, anon-rss:79356kB, file-rss:40kB
May 12 10:43:01 ip-10-202-18-193 kernel: [46106.950933] init: mysql main process (707) killed by KILL sign
How to restart mysql server? [closed]
- date: November 20, 2012
Every time I restart MySQL server
:/$ sudo opt/bitnami/ctlscript.sh start server
WWarning: World-writable config file '/opt/bitnami/mysql/my.cnf' is ignored
Warning: World-writable config file '/opt/bitnami/mysql/my.cnf' is ignored
121120 12:30:18 mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
121120 12:30:18 mysqld_safe Starting mysqld daemon with databases from /opt/bitnami/mysql/data
121120 12:30:20 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-136-14-170.pid ended
/opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started
The server responds with the following error:
(2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)")
Please tell me what I have to do fix this issue.
Better script to restart mysql on Ubuntu 8.04
location: linuxexchange.com - date: March 20, 2009
When I say sudo /etc/init.d/mysql restart on Ubuntu 8.04.2 sometimes there remains a "mysql_safe" process eating 99% of cpu. Making the machine practically inusable.
Is there a better way to restart mysql? I thought about writing a script:
sudo /etc/init.d/mysql stop
sudo killall mysql_safe
sudo /etc/init.d/mysql start
But this would be a evil workaround. (And the script is just a quick shot)
I googled and found that mysql_safe is a wrapper script which starts mysqld, and makes sure it gets restarted if it should die. So there should be a better way to restart the thing.
I googled that this is a common problem in this ubuntu version. Is debian / ubuntu doing it wrong at this point? The init.d script looks quite sophisticated and it deals with mysql_safe also, but my skills are not good enough to understand it fully. But this would be the best place to improve. This is a paste of the version on my machine (which is untouched): http://pastie.org/421938
I found many hints
How do I restart mysql and where is my.cnf file
location: linuxexchange.com - date: April 30, 2015
I am using a Mac OS X Snow Leopard Apple computer.
I installed MySQL on my machine using instructions mentioned here. Everything works great. However I have two questions.
Where is my.cnf file? I searched the whole file system and result is empty. Is it possible that there is no my.cnf and MySQL works with default values. If yes then probably I should create my.cnf at /etc/mysql. Is that right?
How do I restart the MySQL server ? I know it gets started when I restart my machine. Here is what plist looks like. mysqld_safe does not let me restart server.
centos: Another MySQL daemon already running with the same unix socket
location: linuxexchange.com - date: April 22, 2014
I have a strange error when starting mysqld service:
Another MySQL daemon already running with the same unix socket.
I've tried to list running services and stopping them but the same error happens when starting mysqld service.
I can try to remove the mysqld and reinstall it but will this remove the database too?
MySQL won't restart on CentOS
location: linuxexchange.com - date: September 4, 2014
When I try to restart mysql, I got the following error:
ERROR! MySQL server PID file could not be found!
Starting MySQL SUCCESS!
I can log in and use mysql from here, but any changes done to the my.cnf are not updated since mysql did not actually stop when I tried to restart it.
When I try to stop it using service mysql stop, it gives me the following error:
ERROR! MySQL server PID file could not be found!
I am running CentOS 6.5, and my MySQL server is MariaDB 10.0. Everything was running just fine and not sure just now I have this issue.
SLOW Ubuntu Server vs CentOS MySQL Disk Access
location: ubuntuforums.com - date: January 14, 2009
I don't belive Ubuntu should compile the standard kernel with these options:
They SHOULD BE for any new server or servers no older than say 3 years old:
At the very least, Ubuntu should have a standard kernel package we can apt-get that has the clock set at 1000.
So, we have recently spent a very long time trying to track down problems with our MySQL server.
Our requirements are high concurrency, high load, and ACID transaction compliance.
We use InnoDB in MySQL for our database. To increase the safety of the data integrity, we turn "sync-binlog=1" in the MySQL my.cnf. We notice this basically killed all performance on our server... essentialy 98% performance hit on our ubuntu64 10GB Ram with Raid-1 sas with battery backed up cache.
We tried configuring MySQL 4.1, 5.0, 5.1, 6.0 and the config logs hundreds of times. Nothing we did would improve our performance.
MySQL error 2002 : Mysql does not restart
location: ubuntuforums.com - date: December 7, 2011
I am getting an error with MySQL and it is down. The error is:
#2002 Cannot log in to the MySQL server.... Connection for controluser as defined in your configuration failed.
I cannot log into the mysql system. I tried to restart MySQL using the following command.
sudo service mysql restart
It took a while but the command eventually finished... then I checked to see if it is running using the following command.
sudo netstat -tap | grep mysql
Nothing happened..... I expected to see a table describing the mysql but it did not come up. So I think it is not running.
I attempted to reinstall Mysql but this did not fix the problem.
Any idea what is going on? What could have broken? What do I do to fix this issue?
[SOLVED] Error while configuration of mysql replication in centos
location: linuxquestions.com - date: April 6, 2012
I try to replicte mysql database when database update on master server to get update on slave.I followed the following link for configuration ,but whenever mysql database getting on matser server does int getting replicate on slave .Can anyone help me whether its possible to replicate mysql database from master to slave
Page: 1 2 3 4 5 6 7 8 9 10