I’m new to this cool forum
I have a DELL PowerEdge 1950, 2x 146GB SAS 15k RPM in hardware Raid1 and 4GB ram.
This server is a mysql server only. Not other services on it.
I have a database with an innodb table of more than 1.800.000 records growing up quickly and I have a website that has more than 1.500.000 page views per day.
Each page view does a select on the innodb table.
When simultaneus connection are low, performance are ok but in the afternoon, when connections grow up, queries took more then 15-20 seconds to be down and site is very very slow.
How could I optimize this server? Should I do a cluster or a replication? I have 4-5 writes every 10-15 select.