There is some part of this which is not fixed, because the "mysql" user can't start with
[root@percona1 ~]# cat /etc/my.cnf |egrep "flush|numa" flush_caches=1 numa_interleave=1
[root@percona1 ~]# id uid=0(root) gid=0(root) groups=0(root)
[root@percona1 ~]# /etc/init.d/mysql start Starting MySQL (Percona Server)..... SUCCESS!
[root@percona1 ~]# /etc/init.d/mysql stop Shutting down MySQL (Percona Server)... SUCCESS!
[root@percona1 ~]# su - mysql
# as "mysql" user:
-bash-4.1$ cat /etc/my.cnf |egrep "flush|numa" flush_caches=1 numa_interleave=1
-bash-4.1$ id uid=497(mysql) gid=498(mysql) groups=498(mysql)
-bash-4.1$ /etc/init.d/mysql stop ERROR! MySQL (Percona Server) PID file could not be found!
-bash-4.1$ /etc/init.d/mysql start Starting MySQL (Percona Server). ERROR! The server quit without updating PID file (/var/lib/mysql/percona1.pid).
-bash-4.1$ logout [root@percona1 ~]# vi /etc/my.cnf [root@percona1 ~]# cat /etc/my.cnf |egrep "flush|numa" flush_caches numa_interleave
[root@percona1 ~]# /etc/init.d/mysql stop Shutting down MySQL (Percona Server).. SUCCESS!
# as mysql user; now succeeds: [root@percona1 ~]# su - mysql
-bash-4.1$ /etc/init.d/mysql start Starting MySQL (Percona Server).. SUCCESS! -bash-4.1$
There is some part of this which is not fixed, because the "mysql" user can't start with
[root@percona1 ~]# cat /etc/my.cnf |egrep "flush|numa"
flush_caches=1
numa_interleave=1
[root@percona1 ~]# id
uid=0(root) gid=0(root) groups=0(root)
[root@percona1 ~]# /etc/init.d/mysql start
Starting MySQL (Percona Server)..... SUCCESS!
[root@percona1 ~]# /etc/init.d/mysql stop
Shutting down MySQL (Percona Server)... SUCCESS!
[root@percona1 ~]# su - mysql
# as "mysql" user:
-bash-4.1$ cat /etc/my.cnf |egrep "flush|numa"
flush_caches=1
numa_interleave=1
-bash-4.1$ id
uid=497(mysql) gid=498(mysql) groups=498(mysql)
-bash-4.1$ /etc/init.d/mysql stop
ERROR! MySQL (Percona Server) PID file could not be found!
-bash-4.1$ /etc/init.d/mysql start mysql/percona1. pid).
Starting MySQL (Percona Server). ERROR! The server quit without updating PID file (/var/lib/
-bash-4.1$ logout
[root@percona1 ~]# vi /etc/my.cnf
[root@percona1 ~]# cat /etc/my.cnf |egrep "flush|numa"
flush_caches
numa_interleave
[root@percona1 ~]# id
uid=0(root) gid=0(root) groups=0(root)
[root@percona1 ~]# /etc/init.d/mysql start
Starting MySQL (Percona Server)..... SUCCESS!
[root@percona1 ~]# /etc/init.d/mysql stop
Shutting down MySQL (Percona Server).. SUCCESS!
# as mysql user; now succeeds:
[root@percona1 ~]# su - mysql
-bash-4.1$ /etc/init.d/mysql start
Starting MySQL (Percona Server).. SUCCESS!
-bash-4.1$