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 operating systems have a “ulimit” shell command (sh and bash) which can allow more open … Read more