mysql server issue in linux server
Dear Experts
We have sugarcrm running on redhat linux it was successfully working but suddenly we started getting data base failure we got to know this is due to space utilisation was 100% used, later we provisioned additional space but this required us to reboot the server, server is vm on esxi server.
1.We are not able to start and stop mysql service by service mysql start/stop and also not able to perform /etc/init.d/mysld start/stop, mysqld scripts found to be missing in /etc/init.d/. Hence at present mysql is running by executing /usr/libexec/mysqld -u root,
2. I suspect few tables are using engine as Myisam and few tables are using the engine as innoDB and I am not sure if this is okay and this is how it will work OR if this is not okay do not know why this happened please suggest how to troubleshoot and fix, if you suggest all the tables to be using one type of engine for example innoDB since we have combination now that is Myisam and InnoDB how to correct this and resolve , please suggest.
additional information
please find the below yum list mysql-* output taken just now.
mysql.x86_64
mysql-libs.x86_64
mysql-server.x86_64
Please help us in trouble shooting this and permanent fix
Thanks in advance
We have sugarcrm running on redhat linux it was successfully working but suddenly we started getting data base failure we got to know this is due to space utilisation was 100% used, later we provisioned additional space but this required us to reboot the server, server is vm on esxi server.
1.We are not able to start and stop mysql service by service mysql start/stop and also not able to perform /etc/init.d/mysld start/stop, mysqld scripts found to be missing in /etc/init.d/. Hence at present mysql is running by executing /usr/libexec/mysqld -u root,
2. I suspect few tables are using engine as Myisam and few tables are using the engine as innoDB and I am not sure if this is okay and this is how it will work OR if this is not okay do not know why this happened please suggest how to troubleshoot and fix, if you suggest all the tables to be using one type of engine for example innoDB since we have combination now that is Myisam and InnoDB how to correct this and resolve , please suggest.
additional information
please find the below yum list mysql-* output taken just now.
mysql.x86_64
mysql-libs.x86_64
mysql-server.x86_64
Please help us in trouble shooting this and permanent fix
Thanks in advance
ASKER
Thanks for the reply, until 2 days back all these was working perfectly. able to start and stop mysql services in both the ways that is from 1.service mysqld start /stop
2./etc/init.d/mysqld start/stop
now not not able to do so , actually now mysqld script file is missing in /etc/init.d.
please suggest on how to troubleshoot this and fix. is it suggested to install mysql packages if yes please let me know which packages to be installed and should will have to overwrite the existing packages , which package and what command to install/upgrade the package ,
thanks in advance
2./etc/init.d/mysqld start/stop
now not not able to do so , actually now mysqld script file is missing in /etc/init.d.
please suggest on how to troubleshoot this and fix. is it suggested to install mysql packages if yes please let me know which packages to be installed and should will have to overwrite the existing packages , which package and what command to install/upgrade the package ,
thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Dan Craciun
reinstalled mysql server but then try to start , service does not start below error message, please suggest to troubleshoot and fix it
service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
reinstalled mysql server but then try to start , service does not start below error message, please suggest to troubleshoot and fix it
service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
Check /var/log/messages, /var/log/mysql.log for the full error message.
service mysqld start
Also, recent Redhat distros don't use sysvinit any more, but systemd.
HTH,
Dan