I have MySQL 5.14 installed on Dell R710 32GB RAM 600GB SAS HDD with Ubuntu 10.04 64 Bit.
I deploy InnoDB as my default engine. The server is a high load server. On a fresh
install and empty table it can insert around 5 millions new records per day average. But
when the table getting fat the performance starting to drop around 5% per day. It forces
me to re create an empty table each month. So how to keep my server has a stable
performance? Many thanks for the tips.