Scaling website (mysql) tips?
I have a website that runs on 2 boxes, 1 for mysql and 1 for html. My problem is during peak hours, my mysql load is too high and the site takes forever to load. We are no experts with NIX/Server Management and its a small operation we are running here (revenue wise) so we can't afford to buy expensive hardware nor are we really technical when it comes to scaling, we are student-hackers who are...