開啓 libvirtd log 功能

# vi /etc/libvirt/libvirtd.conf

log_level = 1
log_filters="3:remote 4:event 3:json 3:rpc"
log_outputs="1:file:/var/log/libvirt/libvirtd.log"

# /etc/init.d/libvirt-bin restart 

References :
libvirt: Wiki: DebugLogs

libguestfs inspection support: False

# apt-get install python-guestfs

從 bash history 查看指令的使用頻率

$ awk '{print $1}' ~/.bash_history | sort | uniq -c | sort -n

References :
Idle Curiosity: Which shell commands loom large?
How do I see what my most used linux command are? - Super User

bash history 忽略特定指令

$ vi ~/.bashrc

export HISTIGNORE="pwd:ls:ls -ltr:unzip *"

References :
15 Examples To Master Linux Command Line History

mplayer 指定字幕檔

$ mplayer -sub subtitiles.srt mymovie.avi

References :
[MPlayer-users] using srt files

MySQL SHOW PROCESSLIST too long

$ echo "show full processlist;" | mysql -uroot -ppassword | less

MySQL SELECT WHERE REGEXP

mysql> SELECT * FROM `users` WHERE address REGEXP '台北市|新北市';

References :
sql - MySQL LIKE IN()? - Stack Overflow