select count(*) query is too slow. I'm guess it is not work by indexing – CentOS
I would like to ask for comment because I did a better search. My server environment is below. CentOS release 5.1 Linux 2.6,18 CPU: Intel (R) Xeon (R) CPU E3-1230 v3 @ 3.30GHz 8core M / M: 8 GB MySQL…