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