useful mysql command

show status like ‘Qcache%’; explain select ….. 分析 schema  echo “select * from tbl_item procedure analyse()\G” | mysql db_name > ana.txt

Top 84 MySQL Performance Tips

You can check the same tips from here.Here is very useful tips for all mysql DBA’s, Developers these tips are noted from MySQL Camp 2006 suggested by mysql community experts.