手動控制風扇轉速 (IBM X220)

# vi /etc/modprobe.d/thinkpad_acpi.conf

thinkpad_acpi fan_control=1

# reboot

$ cat /proc/acpi/ibm/fan

level:        auto

$ echo level 0 | sudo tee /proc/acpi/ibm/fan  # fan off

$ echo level 2 | sudo tee /proc/acpi/ibm/fan  # low speed

$ echo level 4 | sudo tee /proc/acpi/ibm/fan  # medium speed

$ echo level 7 | sudo tee /proc/acpi/ibm/fan  # maximum speed 

$ echo level auto | sudo tee /proc/acpi/ibm/fan  # automatic - default

# echo level disengaged | sudo tee /proc/acpi/ibm/fan  # disengaged

References :
How to control fan speed - ThinkWiki

download subdirectory from GitHub

            https://github.com/Username/Repository/tree/master/subdirectory
                                                    |
                                                    v
svn checkout https://github.com/Username/Repository/trunk/subdirectory

References :
Cloning only a subdirectory with git - Stack Overflow

CodeIgniter composite primary key

$this->dbforge->add_key('blog_id', TRUE);
$this->dbforge->add_key('site_id', TRUE);
// gives PRIMARY KEY `blog_id_site_id` (`blog_id`, `site_id`)

References :
model - Codeigniter MY_Model composite primary key - Stack Overflow

CodeIgniter Insert on duplicate

$orig_db_debug = $this->db->db_debug;

$this->db->db_debug = FALSE;

RUN QUERY HERE

$this->db->db_debug = $orig_db_debug;

References :
Dealing with duplicate keys in codeigniter mysql insert - Stack Overflow

西班牙文鍵盤輸入

! => Shift + 1
¡ => =
? => Shift + _
¿ => Shift + =
b => ;
á, é, í, ó, ú => ' + a, e, i, o, u




References :
西班牙文鍵盤 @ 熱情西班牙-我是Flora :: 痞客邦 PIXNET ::

開啓 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