After installed all i need on my server and enable hugepages with 512, my memory available is 2800MO.

My tables grow more and more, about 600 insert by day (one by one).
There are only 50-100 table in SQL.

In one table, there are 120 000 rows (80MO), and it's slow when i ask him for display 600 rows in the web browser, it take 15 seconds to finish. When i am on my old server, where there are lot of domain (the server aren't only for me), it takes 7 seconds for the same SELECT.
(by display, i would say that i make an echo with php)

I have read lot of decumentation, i don't understand what i have forgot or bad do...

Comment

Thanks debug,
I have try the sames querys in the terminal and the result is good, about 2 seconds to finish.
In the webpage too, if i launch the SELECT querys without display the result (by default i display with an "echo", and it's just one "echo" of all, at the end of the traitements)

I have reoptimize my php script for delete all i can delete, rename less long, rebuild... to gain ko (the file to load weight now 1mo)

I have compile apache2 with the mpm prefork support, what settings do you recommend about them and my server ?

When i echo, many results where loaded directly, and in the middle, it's begin to display block by block of about 30 results.