My server keeps shutting down due to there not being enough space. I keep receiving this error: /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! failed!
I need more space for the tmp directory so this never happens again.
MySQL also has a few bugs in it, if any databases are corrupted they need to be repaired and optimized. I need it working flawlessly.