stopping mysql with init script doesn't work if pid-file is provided as pid_file in my.cnf

[justinb]

This bug is exactly the same as reported in https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1208865 for XtraDB Cluster.

It says pid_file but doesn't use that pid file when it starts..

mysqld --print-defaults
mysqld would have been started with the following arguments:
--basedir=/usr --bind_address=127.0.0.1 --datadir=/var/lib/mysql --expire_logs_days=10 --key_buffer=16M --log_error=/var/log/mysqld.log --max_allowed_packet=16M --max_binlog_size=100M --max_connections=1024 --myisam_recover=BACKUP --pid_file=/var/lib/mysql/mysql.pid --port=3306 --query_cache_limit=1M --query_cache_size=16M --skip-external-locking=true --socket=/var/lib/mysql/mysql.sock --ssl=false --ssl-ca=/etc/mysql/cacert.pem --ssl-cert=/etc/mysql/server-cert.pem --ssl-key=/etc/mysql/server-key.pem --thread_cache_size=8 --thread_stack=256K --tmpdir=/tmp --user=mysql

sudo service mysql start
Starting MySQL (Percona Server)... [ OK ]

ps auxwwf | grep mysql
root 15538 1.1 0.2 11336 1372 pts/0 S 09:00 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/centosmysql.pid
mysql 15961 2.0 8.0 495424 40396 pts/0 Sl 09:00 0:00 \_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centosmysql.pid --socket=/var/lib/mysql/mysql.sock --port=3306

[Muhammad Irfan (muhammad-irfan)]

I am able to reproduced it. When i use underscore "_" instead dash :-" for pid file in my.cnf it doesn't honor underscore for pid file.

[Laurynas Biveinis (laurynas-biveinis)]

A duplicate of 1208865, let's target that bug to Percona Server instead.