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