Red Hat 6 MySQL 5.5.28 installation MySQL start script issue

[sanjeewa fonseka]

Red Hat 6 MySQL 5.5.28 installation MySQL start script issue .

I download commercial version of MySQL rpm from oracle and installed following rpm’s
MySQL-shared-advanced-5.5.28-1.el6.x86_64
MySQL-server-advanced-5.5.28-1.el6.x86_64
MySQL-devel-advanced-5.5.28-1.el6.x86_64
MySQL-shared-compat-advanced-5.5.28-1.el6.x86_64
MySQL-client-advanced-5.5.28-1.el6.x86_64


and installed them correctly and MySQL server running without any issue. However I found following strange bit stupid issue. Can you please help?

if I run ‘/etc/init.d/mysql start’ multiple times , it creates different instance of MySQL each time .
I can do this for 1 or 2 times and after few MySQL crash and I can’t access any of MySQL server .
if I do ps –ef | grep mysql
I can see multiple instance of mysql running .


ps -ef | grep mysqld_safe
root 6864 1 0 17:14 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/SERVER-NAME.pid
root 7215 1 0 17:16 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/SERVER-NAME.pid


and in the 3rth attempt of start script exit with this(still multiple instance running)
Starting MySQL.............................................[FAILED]................................................The server quit without updating PID file (/var/lib/mysql/SERVER-NAME.pid)

Im using default my.cnf file from setup for the moment : /usr/share/mysql/my-large.cnf



Edited 1 time(s). Last edit at 11/15/2013 11:43AM by sanjeewa fonseka.