I have a VPS with 8 sites on it. None of them are high traffic. I have 6 sites on there using WordPress. MySQL is crashing every 48 hrs or so, and my host has confirmed that WordPress is the issue. (MySQL is version 3.2.3.)
I have WP-Cache installed on each site. Queries average from 20-35 per page load, depending on what plugins are installed.
Does anyone have any advice that will help me improve the performance of WordPress and hopefully stop crashing MySQL all the time?