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.
please find the below yum list mysql-* output taken just now.
Please help us in trouble shooting this and permanent fix
Thanks in advance