[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

[Level 2] Solaris 10 Technical Conference ( 2009/10/25,11/13,12/4 ) -- Basic SMF hands-on lab

The following is my lab file, please refer to it. Wish this helps. regards, Stanley Huang **************************************************************************************************** The purpose of this lab is to let you have basic SMF administration skill. And then you will have the following capabilities. Lab 1: * list service. * check service dependenty. * manage service. Lab 1: 1. list services # svcs -a; ## list all service included 'disabled services' ---------------------------- STATE          STIME    FMRI ... ---------------------------- # svcs */milestone/*; ---------------------------------------------------------------------------- STATE          STIME    FMRI online          8:40:05 svc:/milestone/network:default online          8:40:...
Read more