Mysql server restart failed

Question

My question is exactly the same as this one here, Why is “mysqld.pid” and “mysqld.sock” missing from my system even though the values are set in “my.cnf?”.

I followed all the steps provided in the answer, on the last step, I get an error, Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

How can I solve this? Thanks in advance

ps: I could've asked in the comments section, but I need 50 reputation.

Answer 1

After checking the mysql error log file, there was an error InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts., the solution was to add innodb_use_native_aio = 0 in /etc/mysql/my.cnf file. I then restarted the server. It's working!