/var/lib/mysqld/ibdata1 is flooded
-
naga.aripaka
- Posts: 24
- Joined: Fri Jun 16, 2017 12:31 pm
/var/lib/mysqld/ibdata1 is flooded
ibadata is occupying more than 30 gb of data and we cannot flush it since it is innodb and nagios recommended not to do anything on it. Can you suggest us the possible solution for it ?
-
dwhitfield
- Former Nagios Staff
- Posts: 4583
- Joined: Wed Sep 21, 2016 10:29 am
- Location: NoLo, Minneapolis, MN
- Contact:
Re: /var/lib/mysqld/ibdata1 is flooded
Please attach your /etc/my.cnf.
You could, theoretically, get rid of that file and the two innodb log files, and then reimport your database. It's not something I would generally suggest, but if you are in a pinch as far as your disk filling up, I did it just today and it worked. That said, that was on XI, not fusion.
This may be the type of thing we need to do a remote for. We wouldn't be able to schedule one today because our work day is about today, but if you send an email to [email protected] we should be able to get you in tomorrow.
What's the output of df -h? That will help determine how urgent this is.
Lastly, where were you told to do nothing with the db? It sounds like there is some backstory I'd like to read through.
You could, theoretically, get rid of that file and the two innodb log files, and then reimport your database. It's not something I would generally suggest, but if you are in a pinch as far as your disk filling up, I did it just today and it worked. That said, that was on XI, not fusion.
This may be the type of thing we need to do a remote for. We wouldn't be able to schedule one today because our work day is about today, but if you send an email to [email protected] we should be able to get you in tomorrow.
What's the output of df -h? That will help determine how urgent this is.
Lastly, where were you told to do nothing with the db? It sounds like there is some backstory I'd like to read through.