个人对于常用的
mysql sql问题分析和确定的方法的小结
set profiling=1
execute the sql sentence for test
show profiles
show profile cpu,block io,memory....for query n;
go aheard,no reason
time mysql -A tuan_opencm -e "select * from t_groupon_item" > t
good resource:http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html