MySQL to view the space occupied by the table)

//  Go to the MySQL built-in Management Library: information_schema  //  Your own database: dbwww58com_kuchecarlib  //  Your own table: t_carmodelparamvalue MySQL  >   Use  Information_schema;  Database  Changed MySQL  >   Select  Data_length, index_length  ->  From Tables Where        -> Table_schema =  '  Dbwww58com_kuchecarlib  '        ->   And Table_name =   '  T_carmodelparamvalue  '  ;  +  -- ----------- + -------------- +  | Data_length | Index_length |    +  --  ----------- + -------------- +  |     166379520   |      235782144   |    +  --  ----------- + -------------- + 1 Row In   Set ( 0.02  Sec) MySQL  >   Select Concat ( Round ( Sum (Data_length /  1024  /  1024 ), 2 ),'  MB  ' ) As  Data_length_mb,  -> Concat ( Round ( Sum (Index_length /  1024  /  1024 ), 2 ), '  MB ' ) As  Index_length_mb  ->   From Tables Where        -> Table_schema =  '  Dbwww58com_kuchecarlib  '        ->   And Table_name =   ' T_carmodelparamvalue  '  ;  +  --  -------------- + ----------------- +  | Data_length_mb | Index_length_mb |    +  --  -------------- + ----------------- +  |   158 . 67 MB |  224 . 86 MB |    +  --  -------------- + ----------------- +  1 Row In   Set ( 0.03 Sec)