[Level 2] How to get tables are in use or locked in MySQL?

How to get tables are in use or locked in MySQL?
mysql> show open tables where in_use <> 0 or name_locked <> 0;

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