show processlist;
kill id;
◆旧
/usr/bin/mysqldump -hdb_host -udb_user -pdb_pass db_name table_name > /tmp/table_name.stdout.sql 2> /tmp/table_name.stderr.txt
→ エラーが出力される場合もある
Warning: Using a password on the command line interface can be insecure.
◆新
MYSQL_PWD=db_pass /usr/bin/mysqldump -hdb_host -udb_user db_name table_name > /tmp/table_name.stdout.sql 2> /tmp/table_name.stderr.txt
SELECT ROUND(SUM(data_length)/1024/1024) AS mb FROM information_schema.tables WHERE table_schema = 'aaa' ;
cmd="" cmd=$cmd"cat 1.txt | " cmd=$cmd"sort | " cmd=$cmd"uniq > 2.txt" eval $cmd
cat aaa.txt | while read line do echo $line done