I've executed a query which deleted about 18 million records. After executing this query, mysql stopped responding to queries. I've restarted the server and now I can't start mysql service using the following command:
service mysql start
Maybe it just prints error but I can't find the error-log file. I am running CentOS 6 and have installed mariaDB from it's official repository using yum.
What should I do in order to start mysql? I don't care if the query just gets canceled. I can see that some mysqld process are eating CPU and I/O. I think maybe it's still trying to execute this query.