Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SHOW INDEX FROM logging;
- +---------+------------+--------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
- | TABLE | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | NULL | Index_type | Comment |
- +---------+------------+--------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
- | logging | 0 | PRIMARY | 1 | log_id | A | 26479390 | NULL | NULL | | BTREE | |
- | logging | 1 | type_time | 1 | log_type | A | 20 | NULL | NULL | | BTREE | |
- | logging | 1 | type_time | 2 | log_timestamp | A | 26479390 | NULL | NULL | | BTREE | |
- | logging | 1 | user_time | 1 | log_user | A | 5295878 | NULL | NULL | | BTREE | |
- | logging | 1 | user_time | 2 | log_timestamp | A | 26479390 | NULL | NULL | | BTREE | |
- | logging | 1 | page_time | 1 | log_namespace | A | 20 | NULL | NULL | | BTREE | |
- | logging | 1 | page_time | 2 | log_title | A | 26479390 | NULL | NULL | | BTREE | |
- | logging | 1 | page_time | 3 | log_timestamp | A | 26479390 | NULL | NULL | | BTREE | |
- | logging | 1 | times | 1 | log_timestamp | A | 26479390 | NULL | NULL | | BTREE | |
- | logging | 1 | log_user_type_time | 1 | log_user | A | 4413231 | NULL | NULL | | BTREE | |
- | logging | 1 | log_user_type_time | 2 | log_type | A | 5295878 | NULL | NULL | | BTREE | |
- | logging | 1 | log_user_type_time | 3 | log_timestamp | A | 26479390 | NULL | NULL | | BTREE | |
- | logging | 1 | log_page_id_time | 1 | log_page | A | 13239695 | NULL | NULL | YES | BTREE | |
- | logging | 1 | log_page_id_time | 2 | log_timestamp | A | 26479390 | NULL | NULL | | BTREE | |
- +---------+------------+--------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
- 14 ROWS IN SET (0.43 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement