About a week ago I started to see more and more problems snowballing on my MU install. They began going down every couple hours and only restarting the box would fix the problem.
I started deactivating plugins, trying to optimize the mysql database, and checking the error logs obsessively. After trying just about everything to no avail, I noticed an odd folder on my MU server. Don't know how long it's been there, but it was labeled tmp, and inside were two files:
resource.pag
resource.dir
The weird part: the resource.pag file was over 2.5 gigs. It was so large that it had exceeded the maximum file size that my server would write to and, thus, was the cause for why my server was locking up (at least, I'm pretty sure that was the problem).
What I still don't understand, and haven't been able to figure out despite hours of Googling, is what exactly the resource.pag files are. Are they error files, created by my mysql database? Are they something else?
Anyone else out there seen this problem or have a better understanding of what those files do?