2015-09-22

I have an InnoDB database table with more than 2 million rows. I am running efficienty indexed queries to reduce server load, but site becomes slower day by day.

I ran Mysqltuner.pl to identify any problems with server configuration. I don't have any prior experience with MySQL tweaking.
Please suggest me the correct configuration on the basis of below info.

Mysqltuner.pl result

my.cnf

MySQL running on a server with 64GB RAM, 2TB HDD.

Update

Global Variables

Global Status

Show more