Hi, added the Lamp stack (from stackscript) and everything working fine except Now I uploaded all my entries into my site which is a directory site with more than 100k listings and its running like a dog.

free -m
total used free shared buffers cached
Mem: 348 343 4 0 7 241
-/+ buffers/cache: 93 254
Swap: 255 0 255

Looks ok to me although 'top' shows mysql using anything between 10-30% of memory and similar amount of cpu at any one time.

Played around with the my.cnf settings but nothing affects this performance.

Mysqltuner reports that more ram is required but I don't understand this if their is a fair amount free?

Oh and it averages about 20k i/o on the disk with around 60k peak.

I use Binarycanary as a site monitor which is mailing me telling me the sites down about every hour.

Theres nobody on it really except for Googles robots et al.

Are there indexes on the tables?

Yes, the script provides caching which is turned on though.

FYI caching ≠ table index in SQL.

Sorry, did not mean to indicate the same, yes there are indexes on the tables.

thanks