I need someone to optimize MySQL on my Apple Xserve.
Here are the specs:
1. Mac OS X Server 10.2.8
2. MySQL 4.0.18 - 2 Databases (24MB & 197MB)
3. Apache 2.0.49 - 55 Virtual Hosts
Occasionally, the larger database become inaccessible - pages in the forums cannot be accessed. During this time, there are usually quite a few "locked" MySQL processes relating to this database. As soon as MySQL is restarted, the forums function properly for several more hours.
I have optimized a couple of the largest tables in this database several times, but that doesn't seem to have an effect.
I can provide 24 hour system-wide access via SSH in order to optimize MySQL.