Webhosting Blog

Starting MySQL.Manager of pid-file quit without updating


While restarting mysql on the server  you might get the following error:

Starting MySQL.Manager of pid-file quit without updating

This error generally  indicates that MySQL is not starting as it is unable to load a variable set in /etc/my.cnf.

If you find the /etc/my.cnf to have a large amount of entries under it please try to rename it as say /etc/my.cnf-old.

Once done try to restart the mysql service. If it loads then start customizing the /etc/my.cnf again.

You can refer following optimal settings for the /etc/my.cnf.

[mysqld]
socket = /var/lib/mysql/mysql.sock
safe-show-database
max_connections=200
connect_timeout=30
key_buffer=2048M
join_buffer=32M
innodb_file_per_table
max_allowed_packet=16M
table_cache=24576
innodb_buffer_pool_size=256M
sort_buffer=32M
record_buffer=8M
thread_cache_size=64
max_user_connections=50
concurrent_insert=2
thread_concurrency=8
myisam_sort_buffer_size=64M
query_cache_limit=2M
query_cache_size=128M
query_cache_type=1
long_query_time=2
tmp_table_size=256M
join_buffer_size=4M
read_buffer_size=4M
sort_buffer_size=4M
query_prealloc_size = 65536
query_alloc_block_size = 131072
max_heap_table_size = 256M
tmpdir=/dev/shm
collation_server=utf8_unicode_ci
character_set_server=utf8

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=32M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_bufer=16M

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

[mysqlhotcopy]
interactive-timeout

Still if the problem persist then you can check for errors in the error log file  in /var/lib/mysql/<hostname>.err. You can encounter this error if any of your mysql database table is corrupted. In that case you would use myisamck to repair the table.

Advertisements

4 responses

  1. Pingback: 2010 in review « Linux Blog

  2. Corbokhan

    Thanks. Was worried I wouldn’t be able to get my site back up.

    April 11, 2012 at 3:28 pm

  3. KL

    Something I ran into was that the ownership of the /var/lib/mysql directory was not set to mysql. Once I issued the ‘chown -R mysql:mysql mysql’ inside the /var/lib directory, I was able to start mysql without issue. The /var/lib/mysql/.err pointed me in the right direction

    October 31, 2012 at 2:08 pm

    • Thanks for the solution :).

      November 4, 2012 at 8:54 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s