- malloc-lib路径问题
# /etc/init.d/mysqld start Starting MySQL (Percona Server). mysqld_safe --malloc-lib must be located in one of the directories: /usr/lib /usr/lib64 /usr/lib/i386-linux-gnu /usr/lib/x86_64-linux-gnu ERROR! The server quit without updating PID file (/data/mysql/mysql3306/data/mysql.pid).
解决办法: cp -a /usr/local/mysql/lib/mysql/libjemalloc.so.1 /usr/lib64/libjemalloc.so
2.mysqld路径问题
Percona解压到/opt/mysql目录下，软链接到/usr/local/mysql会遇到以下问题
# ll /usr/local/ total 0 drwxr-xr-x. 2 root root 6 Nov 5 23:38 bin drwxr-xr-x. 2 root root 6 Nov 5 23:38 etc drwxr-xr-x. 2 root root 6 Nov 5 23:38 games drwxr-xr-x. 2 root root 6 Nov 5 23:38 include drwxr-xr-x. 2 root root 6 Nov 5 23:38 lib drwxr-xr-x. 2 root root 6 Nov 5 23:38 lib64 drwxr-xr-x. 2 root root 6 Nov 5 23:38 libexec lrwxrwxrwx 1 mysql mysql 56 Apr 6 05:54 mysql -> /opt/mysql/Percona-Server-5.7.17-12-Linux.x86_64.ssl101/ drwxr-xr-x. 2 root root 6 Nov 5 23:38 sbin drwxr-xr-x. 5 root root 49 Mar 1 21:43 share drwxr-xr-x. 2 root root 6 Nov 5 23:38 src # /etc/init.d/mysqld start Starting MySQL (Percona Server).2017-04-05T21:55:38.934035Z mysqld_safe The file /usr/local/Percona-Server-5.7.17-12-Linux.x86_64.ssl101/bin/mysqld does not exist or is not executable. Please cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe& See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information ERROR! The server quit without updating PID file (/data/mysql/mysql3306/data/mysql.pid).
解决办法一: 用相同版本的Oracle MySQL的mysqld_safe替换
解决办法二: 把Percona Server解压到/usr/local/目录下，并创建软链接/usr/local/mysql
- 有个朋友重启服务器后发现TokuDB的插件没有了，相关参数都已经写到配置方法当中，禁用transparent_hugepage也已经写到rc.local了，操作系统是CentOS6, 最后了解到mysqld设置了自启动，因为服务自启动的优先级别比rc.local的要高，也就是mysqld启动完成以后再禁用transparent_hugepage，所以就不起作用了。解决办法是把重启mysqld，禁用mysqld自启动，如果一定要mysqld开机自动启动的话, 把/etc/init.d/mysqld start加到rc.local，注意放置到禁用transparent_hugepage的后面。