Optimize MySQL and Schedule Maintenance with MySQL Tuner
After all, most of the data may be stored in it...
Some Tasks I would Recommend You to Do
Please notice that this work may not be done manually, but can be automated. If you do so, you may be contribute it back to the community at your favorite open source project:
(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)