useful mysql command

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

adject file descriptors

On Unix, each TCP/IP connection uses a file descriptor, so you must increase the total number of descriptors available to the operating system, and also increase the maximum number of descriptors each process is allowed to use. All Unix style…

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.