bug的原因是在linux系统下,mysql的配置文件my.cnf的basedir不能使用软连接.
表象如下:
#cat /usr/local/mysql/my.cnf | grep basedir basedir=/usr/local/mysql #ln -sf Percona-Server-5.6.34-rel79.1-Linux.x86_64.ssl101 mysql #/usr/local/mysql/support-files/mysql.server start Starting MySQL (Percona Server). mysqld_safe ld_preload libraries can only be loaded from system directories (/usr/lib64, /usr/lib, /usr/local/mysql/lib) ERROR! The server quit without updating PID file (/usr/local/mysql/data/pidfile.pid).
然后,把basedir的地址换成绝对路径
#cat /etc/my.cnf | grep basedir basedir=/mysql/Percona-Server-5.6.34-rel79.1-Linux.x86_64.ssl101 #/usr/local/mysql/support-files/mysql.server start Starting MySQL (Percona Server). SUCCESS!
就是这么回事.......
此bug存在于5.6.34(我用出问题的版本),还有5.7.15(bug提供者的版本),其实我个人感觉严格来说也不能算是bug吧,毕竟也没影响正常使用,如果是官方版本,也不会出现此类问题,因为不用创软连接.
bug提供者提交的网页地址
https://bugs.launchpad.net/percona-server/+bug/1639735