Read Perfromance


I have 10 nodes, with cache=.35, and max-sql-memory=.30 , with a single table total around 2millions data, with a single avg() select group by statement, there is secondary index use, about less than 100 records affected, it will take about 6~9s, it is really slow, any suggestions?