Today i will Share a Horror Story about Mariadb(MySQL) ,

We are Checking Our Server Load in that time we face a Huge Load Issue in our Server that was 12 Core CPU so it almost consumes 80% of the CPU we look into deep but in this case, the Server get Restart. When I Back it Online All Of the services are Working good But MYSQL Not Working Most Of the Sites are Facing MYSQL Issue, Database not Establish, I think to look at MYSQL or MariaDB I get

[root@us ~]# systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.

This means We have Some issue in MariaDB Service so look into it
No Solution !! No Solution
I think my Database Cruppretted 🙁 & yes I am finding a Solution for it No Solution.
last I figure out it if I make rename to ib_logfile0 & ib_logfile1
what will be ?
I did to Rename

mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak 

mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak

systemctl start mysql

WOW 😮 My MariaDB Service Active & Working 🙂


Nothing is Impossible If you try  🙂 have a Nice Day