We've got a Media Temple dv install (running dv 3.5) that keeps hitting its hard limit. Currently, it's using 68,124 of 68950 hard limit.
They've been less than helpful in helping us diagnosing this, other than copying and pasting some answers and links to things in their KnowledgeBase.
Any ideas on how to diagnose this further?
I've already run
mysqltuner.pl and have been able to Google and fix a few things in there, but it's not really having much effect. I also ran
mysqlcheck -or -A -u and that got rid of some fragmented tables, but obviously isn't the culprit either.
Any ideas or other things I can try to diagnose and/or optimize?