Recently with the increase of traffic I have noticed that my server load has gone up (especially mySQL).

The reason I'm making this topic is because I want to discuss about some ways to minimize server load, and in my opinion this can be done easily.

Having too much data in your databases isn't good so therefor I have this idea. Having a huge download database isn't good, a good 40k downloads would be enough. As for recent searches it also seems fair enough to limit it at 50k.

Since you only need the newest downloads and the latest searches it is possible to just have the recent 40k downloads and the last 50k searches

Easiest way would be to create a PHP file with some queries:

1*Get the highest ID in the downloads tabel
2*Do a query to remove all the downloads with a lower id than Highest_ID - 40 000
3*Get the highest ID in the search tabel
4*repeat step 2 but then just with the searches tabel

Anyone any comments?
Whoo Reviewed by Whoo on . Keeping the server load cool? Recently with the increase of traffic I have noticed that my server load has gone up (especially mySQL). The reason I'm making this topic is because I want to discuss about some ways to minimize server load, and in my opinion this can be done easily. Having too much data in your databases isn't good so therefor I have this idea. Having a huge download database isn't good, a good 40k downloads would be enough. As for recent searches it also seems fair enough to limit it at 50k. Since Rating: 5