Posts

[ Level 2 ] Color for man page.

I forget where to get this information, just try it. export PAGER="`which less` -s" export BROWSER="$PAGER" export LESS_TERMCAP_mb=$'\E[38;5;167m' export LESS_TERMCAP_md=$'\E[38;5;39m' export LESS_TERMCAP_me=$'\E[38;5;231m' export LESS_TERMCAP_se=$'\E[38;5;231m' export LESS_TERMCAP_so=$'\E[38;5;167m' export LESS_TERMCAP_ue=$'\E[38;5;231m' export LESS_TERMCAP_us=$'\E[38;5;167m' Wish this helps. regards, Stanley Huang

[ Level 3 ] Bash auto completion

Bash auto complete Wish this helps. regards, Stanley Huang

[ Level 1] The most popular benchmark tools for MySQL

The most popular benchmark tools are: In MySQL official release: sql-bench mysqlslap Developed by community: DBT-2 SysBench Wish this helps. regards, Stanley Huang

[ Level 1 ] Utilities for MySQL.

Some body asked me any good utilities for MySQL, therefore, I listed several good utilities here and you could try to google it for detail information. Included: dim_STAT Maatkit mysqlreport mysqlresources mytop Wish this helps. regards, Stanley Huang

[ Level 2 ] Install Redmine on Ubuntu.

If you want to install Redmine on Ubuntu, please follow the following steps. Ref: Redmine Wiki The steps are as the following: 1. Download Redmine by subversion. 1-a. Install subversion by apt-get: # apt-get -y install subversion 1-b. Download Redmine by subversion: # svn co http://redmine.rubyforge.org/svn/branches/2.0-stable redmine-2.0 2. Install gem by apt-get. # apt-get -y install rubygems 3. Install Redmine by bundler. 3-a. Pre-install MySQL5.5, bundler and rmagick # apt-get -y install mysql-server-5.5 # gem install bundler # gem install rmagick 3-b. Setup Redmine by bundler # cd ./redmine-2.0 # bundle install --without development test mysql postgresql sqlite rmagick 4. Create database on MySQL. # mysql mysql> create database redmine character set utf8; mysql> create user 'redmine'@'localhost' identified by 'my_password'; mysql> grant all privileges on redmine.* to 'redmine'@'localhost...

[Level 2] How to get root permission to write file.

If you want to get root permission when you launch vim with normal user. You could try the following command in vim. 1. to write to file. 2. reload the file. :w !sudo tee [file_name] :e! Wish this helps. regards, Stanley Huang

[Level 2] How to know python module come from.

python> print sys.modules {'copy_reg': <module 'copy_reg' from '/usr/lib/python2.6/copy_reg.pyc'>, 'encodings': <module 'encodings' from '/usr/lib/python2.6/encodings/__init__.pyc'>, 'site': <module 'site' from '/usr/lib/python2.6/site.pyc'>, '__builtin__': <module '__builtin__' (built-in)>, '__main__': <module '__main__' (built-in)>, 'encodings.encodings': None, 'abc': <module 'abc' from '/usr/lib/python2.6/abc.pyc'>, 'posixpath': <module 'posixpath' from '/usr/lib/python2.6/posixpath.pyc'>, 'errno': <module 'errno' (built-in)>, 'encodings.codecs': None, '_abcoll': <module '_abcoll' from '/usr/lib/python2.6/_abcoll.pyc'>, 'types': <module 'types' from '/usr/lib/python2.6/types.pyc'>, '_code...