mysql运行久了会放很多日志文件在/var/lib/mysql下，每天几百M，很快会填满硬盘，可以用下面方法清空日志：

shell> mysql -u username -p
mysql> PURGE BINARY LOGS BEFORE '2009-05-01 00:00:00';

Reference: http://systems.takizo.com/2009/08/23/how-to-remove-mysql-binary-log/

A friend of me asked me long time ago: "How can I have a ranking on a result with MySQL?". Now I found some time to write it down:

Lets do first some preparation for the example:

CREATE TABLE sales (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, fruit VARCHAR(32)
, amount DECIMAL
);

INSERT INTO sales
VALUES (NULL, 'apple', 12.75), (NULL, 'orange', 1.89), (NULL, 'pear', 19.23)
, (NULL, 'banana', 4.25), (NULL, 'cherry', 123.75), (NULL, 'plum', 23.15)
;

Now lets query:

今天尝试在Ubuntu 12.04下使用Oprofile，但由于软件依赖问题失败了。查了一下，说Oprofile不再被Ubuntu支持，原因之一是有替代品perf，用了一下，不错！

http://www.pixelbeat.org/programming/profiling/

http://community.nvda-project.org/wiki/FutureGoals
http://community.nvda-project.org/changeset/5b4fe295004d33d6e286b83c609f...

搜索以上链接的方法如下：
1. 获取NVDA源码
2. grep "input method" * -inr
3. 在Changelog中找到“support Asian character input”的关键词
4. 在NVDA官网的搜索框中输入以上关键词可找到

直接在4中搜索各种关键词应该也能找到。