we have a dedicated SQL Server, CentOS_x64 Mysql 5.5 x64 running 80% innoDB tables
running in 12GB memory and a raid 5 ..
however the data stored is REALLY BAD organized ...
mysql config is changed a little bit but not serverly.
in peak times the web server has about 250requests per second ... and the database server 150 threads open.
i need someone can optimize the database settings [url removed, login to view] and analyze the table indexes in order to speed things up to a normal standard.