+----------+

| count(*) |

+----------+

|     8000 |

+----------+

+---------+---------+----------+----------+

| Table   | Op      | Msg_type | Msg_text |

+---------+---------+----------+----------+

| test.t1 | analyze | status   | OK       |

+---------+---------+----------+----------+

+---------+------------+-------------+

| db_name | table_name | cardinality |

+---------+------------+-------------+

| test    | t1         |        8000 |

+---------+------------+-------------+

+---------+------------+------------+--------------+---------------+

| db_name | table_name | index_name | prefix_arity | avg_frequency |

+---------+------------+------------+--------------+---------------+

| test    | t1         | PRIMARY    |            1 |        1.0000 |

| test    | t1         | c1         |            1 |        1.0000 |

| test    | t1         | c2         |            1 |       81.6327 |

+---------+------------+------------+--------------+---------------+

+----------------+

| c2 cardinality |

+----------------+

|        97.9999 |

+----------------+

+-------+----------+--------------+-------------+-------------+

| Table | Key_name | Seq_in_index | Column_name | Cardinality |

+-------+----------+--------------+-------------+-------------+

| t1    | PRIMARY  |            1 | c1          |        8050 |

| t1    | c1       |            1 | c1          |        8050 |

| t1    | c2       |            1 | c2          |         187 |

+-------+----------+--------------+-------------+-------------+

+------+--------+---------+------------+------+

| Name | Engine | Version | Row_format | Rows |

+------+--------+---------+------------+------+

| t1   | InnoDB |      10 | Compact    | 8050 |

+------+--------+---------+------------+------+