I have a web site, with more than : 500 MySQL queries per second - 2M+ queries per hour. Online users simultany 150+.
The server is always high loaded.
web site built in PHP/MySQL
I already optimized apache, mysql configurations.
My dedicated server config :
Processors 8 : Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz Ram : 12 GB SCSI Harddisk
I want to ask if Memcached is the best solution for this problem, or I have to separate MySQL server from the web server.