<![CDATA[向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除]]> http://jackxiang.com/index.php zh-cn http://jackxiang.com/post// <![CDATA[如何查询mysql里某张表所有记录所占内存？我想比较一下innodb表和myisam表所占用内存大小]]> jack <xdy108@126.com> Wed, 06 Oct 2010 15:38:39 +0000 http://jackxiang.com/post//
mysql> show table status \G;
*************************** 1. row ***************************
           Name: innodb
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 0
Avg_row_length: 0
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 0
Auto_increment: 1
    Create_time: 2010-10-07 23:21:25
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
Create_options:
        Comment: InnoDB free: 4096 kB
1 row in set (0.00 sec)

ERROR:
No query specified


来源:http://www.soidc.net/discuss/14/090621/15/719934_1.html ]]> http://jackxiang.com/post//#blogcomment <![CDATA[[评论] 如何查询mysql里某张表所有记录所占内存？我想比较一下innodb表和myisam表所占用内存大小]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://jackxiang.com/post//#blogcomment