Learn F5 Technologies, Get Answers & Share Community Solutions Join DevCentral

Filter by:
  • Solution
  • Technology
Answers

/var/lib/mysql @ 100%

Attached is the screenshot of my df -h Image Text

I noticed that my /var/lib/mysql is @ 100% could somebody please help me fix this issue.

I issued this command "find /var/lib/mysql -xdev -type f -exec du {} \; | sort -rn | head -20" and here is the output: Image Text

Your immediate response would be greatly appreciated.

0
Rate this Question

Answers to this Question

placeholder+image
USER ACCEPTED ANSWER & F5 ACCEPTED ANSWER

I believe this solved my problem. https://support.f5.com/csp/article/K23345645

After I compressed the VAR, i rebooted the unit with bigstart restart afterwards /var/lib/mysql is @ 9%

Not quite sure which solved which. Now it has been 2 days and this is the result of my df -h Image Text

0
placeholder+image
USER ACCEPTED ANSWER & F5 ACCEPTED ANSWER
Comments on this Answer
Comment made 4 months ago by Philippe Page 191

Thank you for the quick response. Unfortunately, I had tried this and can't seem to make it work.

Image Text

Any ideas what I might have been doing wrong?

0
placeholder+image
USER ACCEPTED ANSWER & F5 ACCEPTED ANSWER
Comments on this Answer
Comment made 4 months ago by Philippe Page 191

After doing so, monpd is at Down state. Is this because of the 100% /var/lib/mysql? Image Text

0
Comment made 4 months ago by Jie 2658

Check "/var/log/avr/monpd.log" to see what happened.

0
Comment made 4 months ago by Philippe Page 191

Thanks Jie for answering my questions.

Here is the logs. Image Text

0
Comment made 4 months ago by Jie 2658

Has it reclaimed the disk space at all? And you can try to restart the service while monitoring the log.

0
Comment made 4 months ago by Jie 2658
0
Comment made 4 months ago by Philippe Page 191

the /var/lib/mysql is still @ 100% Image Text

And I also tried restarting the service while another terminal is opened with tail -f on /var/log/avr/monpd.log the results are still the same

Image Text

Also tried deleting temporary files in the /var/avr/loader directory, but it is still @ 100% Image Text

0
Comment made 4 months ago by Philippe Page 191

Im currently trying this solution: https://support.f5.com/csp/article/K23345645

I'll update after I've done this.

0