<![CDATA[向东博客专注WEB应用构架之美 --- 构架之美，在于尽态极妍

<![CDATA[向东博客专注WEB应用构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除]]> http://www.jackxiang.com/index.php zh-cn http://www.jackxiang.com/post// <![CDATA[如何查看某个Innodb库的大小？ ]]> jack <xdy108@126.com> Wed, 11 Aug 2010 10:36:09 +0000 http://www.jackxiang.com/post//
摘自CU论坛里面的一个问题：
[root@mail mysql]# /usr/local/mysql/bin/mysql -uroot -p123 -e "show table status from stat" | awk 'NR>=2{index_size =$9;data_size =$7}END{print "index_size\t"(index_size/1024/1024)"M";print "data_size\t"(data_size/1024/1024)"M"}'
index_size 2717.81M
data_size 3858.27M

mysql -uroot -e "show table status from stat" | awk 'NR>=2{index_size =$9;data_size =$7}END{print "index_size\t"(index_size/1024/1024)"M";print "data_size\t"(data_size/1024/1024)"M"}'

]]> http://www.jackxiang.com/post//#blogcomment <![CDATA[[评论] 如何查看某个Innodb库的大小？ ]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://www.jackxiang.com/post//#blogcomment