SHOW TABLE STATUS LIKE "product_manufacturer" ; +----------------------+--------+---------+-------------+------+----------------+-------------+---------------------+--------------+----------------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +----------------------+--------+---------+-------------+------+----------------+-------------+---------------------+--------------+----------------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | product_manufacturer | TokuDB | 10 | tokudb_zlib | 3081 | 82 | 255440 | 9223372036854775807 | 447232 | 18446744073709452583 | 11925 | 2018-02-20 06:32:04 | 2018-02-20 06:32:04 | NULL | utf8_unicode_ci | NULL | | | +----------------------+--------+---------+-------------+------+----------------+-------------+---------------------+--------------+----------------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ 1 row in set (0.00 sec) SHOW INDEXES IN product_manufacturer; +----------------------+------------+------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------------------+------------+------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | product_manufacturer | 0 | PRIMARY | 1 | id | A | 3081 | NULL | NULL | | BTREE | | | | product_manufacturer | 0 | slug | 1 | slug | A | 3081 | NULL | NULL | YES | BTREE | | | | product_manufacturer | 1 | manufacturer_manufacturer_52094d6e | 1 | name | A | 3081 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | manufacturer_manufacturer_65da3d2c | 1 | code | A | 3081 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | manufacturer_7b4398b1 | 1 | is_brand | A | 2 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | manufacturer_3514e692 | 1 | make_car | A | 2 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | manufacturer_71a5415f | 1 | make_truck | A | 2 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | manufacturer_6a707003 | 1 | make_engine | A | 2 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | product_manufacturer_17256f31 | 1 | oe | A | 2 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | product_manufacturer_1fe41c97 | 1 | is_active | A | 1 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | product_manufacturer_516bb1bd | 1 | count | A | 3081 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | product_manufacturer_ec9ad377 | 1 | modified | A | 106 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | name | 1 | name | A | 3081 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | products_count | 1 | products_count | A | 1027 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | cross_count | 1 | cross_count | A | 1541 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | id__is_active | 1 | id | A | 3081 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | id__is_active | 2 | is_active | A | 3081 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | is_brand_is_active | 1 | is_active | A | 1 | NULL | NULL | | BTREE | | | | product_manufacturer | 1 | is_brand_is_active | 2 | is_brand | A | 2 | NULL | NULL | | BTREE | | | +----------------------+------------+------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 19 rows in set (0.00 sec) SHOW TABLE STATUS LIKE "product" ; +---------+--------+---------+-------------+---------+----------------+-------------+---------------------+--------------+----------------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------+--------+---------+-------------+---------+----------------+-------------+---------------------+--------------+----------------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | product | TokuDB | 10 | tokudb_zlib | 7577280 | 148 | 1128046163 | 9223372036854775807 | 1261710694 | 18446744072168129927 | 7577491 | 2018-02-20 03:46:03 | 2018-03-29 04:18:45 | NULL | utf8_unicode_ci | NULL | | | +---------+--------+---------+-------------+---------+----------------+-------------+---------------------+--------------+----------------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ 1 row in set (0.01 sec) SHOW INDEXES IN product; +---------+------------+--------------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------+------------+--------------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | product | 0 | PRIMARY | 1 | id | A | 7577280 | NULL | NULL | | BTREE | | | | product | 1 | product_product_3aac1984 | 1 | num | A | 7577280 | NULL | NULL | | BTREE | | | | product | 1 | product_product_4ac7f441 | 1 | manufacturer_id | A | 1527 | NULL | NULL | | BTREE | | | | product | 1 | product_product_425ae3c4 | 1 | group_id | A | 13 | NULL | NULL | YES | BTREE | | | | product | 1 | product_7607617b | 1 | source_id | A | 14 | NULL | NULL | | BTREE | | | | product | 1 | product_65da3d2c | 1 | code | A | 7577280 | NULL | NULL | | BTREE | | | | product | 1 | product_index_1 | 1 | num | A | 7577280 | NULL | NULL | | BTREE | | | | product | 1 | product_index_1 | 2 | manufacturer_id | A | 7577280 | NULL | NULL | | BTREE | | | | product | 1 | product_f429bc7 | 1 | type | A | 20 | NULL | NULL | | BTREE | | | | product | 1 | product_6c1a5129 | 1 | union_id | A | 16437 | NULL | NULL | YES | BTREE | | | | product | 1 | only_number | 1 | number | A | 7577280 | NULL | NULL | | BTREE | | | | product | 1 | weight | 1 | weight | A | 8 | NULL | NULL | | BTREE | | | | product | 1 | price_min | 1 | price_min | A | 7 | NULL | NULL | | BTREE | | | | product | 1 | manufacturer_price_min | 1 | manufacturer_id | A | 1650 | NULL | NULL | | BTREE | | | | product | 1 | manufacturer_price_min | 2 | price_min | A | 1650 | NULL | NULL | | BTREE | | | | product | 1 | price_max | 1 | price_max | A | 8 | NULL | NULL | | BTREE | | | | product | 1 | manufacturer_price_max | 1 | manufacturer_id | A | 1928 | NULL | NULL | | BTREE | | | | product | 1 | manufacturer_price_max | 2 | price_max | A | 1928 | NULL | NULL | | BTREE | | | +---------+------------+--------------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 18 rows in set (0.00 sec) SHOW TABLE STATUS LIKE "product_source" ; +----------------+--------+---------+-------------+------+----------------+-------------+---------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +----------------+--------+---------+-------------+------+----------------+-------------+---------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | product_source | TokuDB | 10 | tokudb_zlib | 5 | 25 | 126 | 9223372036854775807 | 30 | 33631 | 11 | 2018-02-20 06:32:05 | 2018-02-20 06:32:05 | NULL | utf8_unicode_ci | NULL | | | +----------------+--------+---------+-------------+------+----------------+-------------+---------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ 1 row in set (0.00 sec) SHOW INDEXES IN product_source; +----------------+------------+-------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------------+------------+-------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | product_source | 0 | PRIMARY | 1 | id | A | 5 | NULL | NULL | | BTREE | | | | product_source | 1 | product_source_55f56498 | 1 | is_active | A | 1 | NULL | NULL | | BTREE | | | +----------------+------------+-------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 2 rows in set (0.00 sec)