[Info] Top 10 SQL Performance Tips

Top 10 SQL Performance Tips, please refer to the link:
http://forge.mysql.com/wiki/Top10SQLPerformanceTips

Wish this helps.

regards,
Stanley Huang

Comments

Post a Comment

Popular posts from this blog

[Level 3] Install Memcached Storage Engine for MySQL on CentOS 5.4

Prepare the package first for build the memcached storage engine. Download libmemacached 0.34 and install: # wget http://download.tangent.org/libmemcached-0.34.tar.gz # tar zxvf ./libmemcached-0.34.tar.gz # cd ./libmemcached-0.34 # export PKG_CONFIG_PATH=/usr/local/lib/pkgconfig # ./configure && make && make install Download libxml2 and install: # wget ftp://xmlsoft.org/libxml2/libxml2-2.7.7.tar.gz # tar zxvf libxml2-2.7.7.tar.gz # cd ./libxml2-2.7.7 # ./configure && make && make install Download  libxmlrow and install: # wget http://download.tangent.org/libxmlrow-0.2.tar.gz # tar zxvf ./libxmlrow-0.2.tar.gz # cd ./libxmlrow-0.2 #  export PKG_CONFIG_PATH=/usr/local/lib/pkgconfig # ./configure && make && make install  Download  memcached storage and install: # export PKG_CONFIG_PATH=/usr/local/lib/pkgconfig # sed -i "s#uint16_t#uint32_t#g" ./src/ha_memcache.cc # ./configure --...
Read more

[Level 1] How to install Jython on Ubuntu.

You have two way to install jython on Ubuntu: 1. Use apt-get: # sudo apt-get -y install jython # jython --version 2. Download source: # cd /tmp # wget http://sourceforge.net/projects/jython/files/jython/2.5.2/jython_installer-2.5.2.jar/download # mv ./download ./jython.jar # java -jar ./jython.jar ... following the wizard. # export PATH=$PATH:/opt/jython/bin # (if you installed Jython in /opt/jython) # jython --version Wish this helps. regards, Stanley Huang
Read more

[Level 2] Shell Interactive With Zenity Episode 4 -- file-selection

Image
Does zenity provide the file/directory GUI? Yes, you can use the option "--file-selection". The command synopsis as following: SYNOPSIS      zenity --file-selection [--title=title] [--window-icon=path]  --width=width]  [--height=height] [--timeout=seconds]  [--filename=path]  [--multiple]  [--directory] [--save] [--separator=character] [--confirm-overwrite] When you use the option "--file-selection", you will see a pop out screen at the directory that you run this command, like below. # cd /etc # zenity --file-selection Just like " --calendar ", if you press "ESC" key or click button "Cancel", the return code will be "1". If you select one file and click "OK", zenity will response the filename and return the code will be "0". And also the same effect about the options "--title", "--timeout"...etc, for saving your time, please refer to the previous post " [Level 2] Shell I...
Read more