Skip to content

Instantly share code, notes, and snippets.

@robcole

robcole/gist:1079454

Created July 12, 2011 23:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save robcole/1079454 to your computer and use it in GitHub Desktop.
Save robcole/1079454 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
+--------+------------+-----------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------+------------+-----------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+
| topics | 0 | PRIMARY | 1 | id | A | 71941 | NULL | NULL | | BTREE | |
| topics | 1 | user_id | 1 | user_id | A | 14388 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_topics_on_forum_id | 1 | forum_id | A | 21 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_topics_on_sticky_and_replied_at | 1 | forum_id | A | 273 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_topics_on_sticky_and_replied_at | 2 | sticky | A | 436 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_topics_on_sticky_and_replied_at | 3 | replied_at | A | 71941 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_topics_on_forum_id_and_replied_at | 1 | forum_id | A | 94 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_topics_on_forum_id_and_replied_at | 2 | replied_at | A | 71941 | NULL | NULL | YES | BTREE | |
| topics | 1 | video_forum_id_index | 1 | video_id | A | 23980 | NULL | NULL | YES | BTREE | |
| topics | 1 | video_forum_id_index | 2 | forum_id | A | 23980 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_topics_on_video_forum_id | 1 | video_forum_id | A | 103 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_forum_id_on_video_forum_id | 1 | forum_id | A | 25 | NULL | NULL | YES | BTREE | |
| topics | 1 | index_forum_id_on_video_forum_id | 2 | video_forum_id | A | 25 | NULL | NULL | YES | BTREE | |
+--------+------------+-----------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+
13 rows in set (0.01 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment