So as of the past hour the X-Media Online websites have ground to a halt and can’t be accessed, after being alerted of the issue I quickly went to investigate. My first port of call is usually to /var/log because I’m ashamed to admit I’ve let some log files get out of hand before. But this time (thankfully) that wasn’t the problem (I’d fixed those issues, hopefully).
This time the issue seems to be in /var/lib/mysql where the ibdata1 file has grown to about 20GB in size which is just shy of the max size of the partition that it’s on.
I’m currently in the process of fixing it and will give updates as I go through the process of fixing it. I’m using both this Stackoverflow post and this MySQL documentation. I’m at step one, currently creating a dump of the entire database. I’ll keep you updated as I go.
Update: No update on the fixing yet, but I’ve determined the root of the problem to be the old X-Media Online wiki which must be open to editing. There are over 17 million records in the wiki text table making up 19.7GB of the 20GB InnoDB file. A lot of mistakes to learn from at this early hour of the morning (it’s 2:40am here right now).
Update 3: Bug mentioning the issue for future reference.