# mysqlindexcheck --server=instance_3306 --show-drops --show-indexes --stats --report-indexes -vvv ttlsa_com
# Source on localhost: ... connected.
# Checking indexes...
# Getting indexes for ttlsa_com.bbs_categories
# Showing indexes from ttlsa_com.bbs_categories:
#
+------------+-----------------+----------+--------+---------+----------------+-----------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+-----------------+----------+--------+---------+----------------+-----------+
| ttlsa_com | bbs_categories | PRIMARY | BTREE | True | False | cid, pid |
+------------+-----------------+----------+--------+---------+----------------+-----------+
#
# Table ttlsa_com.bbs_categories has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_comments
# Showing indexes from ttlsa_com.bbs_comments:
#
+------------+---------------+----------+--------+---------+----------------+---------------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+---------------+----------+--------+---------+----------------+---------------+
| ttlsa_com | bbs_comments | PRIMARY | BTREE | True | False | id, fid, uid |
+------------+---------------+----------+--------+---------+----------------+---------------+
#
# Table ttlsa_com.bbs_comments has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_favorites
# Showing indexes from ttlsa_com.bbs_favorites:
#
+------------+----------------+----------+--------+---------+----------------+----------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+----------------+----------+--------+---------+----------------+----------+
| ttlsa_com | bbs_favorites | PRIMARY | BTREE | True | False | id, uid |
| ttlsa_com | bbs_favorites | uid | BTREE | False | False | uid |
+------------+----------------+----------+--------+---------+----------------+----------+
#
# Table ttlsa_com.bbs_favorites has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_forums
# Showing indexes from ttlsa_com.bbs_forums:
#
+------------+-------------+-------------+--------+---------+----------------+----------------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+-------------+-------------+--------+---------+----------------+----------------+
| ttlsa_com | bbs_forums | PRIMARY | BTREE | True | False | fid, cid, uid |
| ttlsa_com | bbs_forums | updatetime | BTREE | False | True | updatetime |
| ttlsa_com | bbs_forums | ord | BTREE | False | False | ord |
+------------+-------------+-------------+--------+---------+----------------+----------------+
#
# Table ttlsa_com.bbs_forums has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_links
# Showing indexes from ttlsa_com.bbs_links:
#
+------------+------------+----------+--------+---------+----------------+----------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+------------+----------+--------+---------+----------------+----------+
| ttlsa_com | bbs_links | PRIMARY | BTREE | True | False | id |
+------------+------------+----------+--------+---------+----------------+----------+
#
# Table ttlsa_com.bbs_links has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_notifications
# Showing indexes from ttlsa_com.bbs_notifications:
#
+------------+--------------------+----------+--------+---------+----------------+------------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+--------------------+----------+--------+---------+----------------+------------+
| ttlsa_com | bbs_notifications | PRIMARY | BTREE | True | False | nid, nuid |
+------------+--------------------+----------+--------+---------+----------------+------------+
#
# Table ttlsa_com.bbs_notifications has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_page
# Showing indexes from ttlsa_com.bbs_page:
#
+------------+-----------+----------+--------+---------+----------------+----------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+-----------+----------+--------+---------+----------------+----------+
| ttlsa_com | bbs_page | PRIMARY | BTREE | True | False | pid |
+------------+-----------+----------+--------+---------+----------------+----------+
#
# Table ttlsa_com.bbs_page has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_settings
# Showing indexes from ttlsa_com.bbs_settings:
#
+------------+---------------+----------+--------+---------+----------------+------------------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+---------------+----------+--------+---------+----------------+------------------+
| ttlsa_com | bbs_settings | PRIMARY | BTREE | True | False | id, title, type |
+------------+---------------+----------+--------+---------+----------------+------------------+
#
# Table ttlsa_com.bbs_settings has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_tags
# Showing indexes from ttlsa_com.bbs_tags:
#
+------------+-----------+------------+--------+---------+----------------+------------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+-----------+------------+--------+---------+----------------+------------+
| ttlsa_com | bbs_tags | PRIMARY | BTREE | True | False | tag_id |
| ttlsa_com | bbs_tags | tag_title | BTREE | True | False | tag_title |
+------------+-----------+------------+--------+---------+----------------+------------+
#
# Table ttlsa_com.bbs_tags has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_tags_relation
# Showing indexes from ttlsa_com.bbs_tags_relation:
#
+------------+--------------------+---------+--------+---------+----------------+----------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+--------------------+---------+--------+---------+----------------+----------+
| ttlsa_com | bbs_tags_relation | tag_id | BTREE | False | False | tag_id |
| ttlsa_com | bbs_tags_relation | fid | BTREE | False | True | fid |
+------------+--------------------+---------+--------+---------+----------------+----------+
#
# Table `ttlsa_com`.`bbs_tags_relation` does not contain neither a PRIMARY nor UNIQUE key.
# The following indexes for table ttlsa_com.bbs_tags_relation contain the clustered index and might be redundant:
#
CREATE INDEX `tag_id` ON `ttlsa_com`.`bbs_tags_relation` (`tag_id`) USING BTREE
#
CREATE INDEX `fid` ON `ttlsa_com`.`bbs_tags_relation` (`fid`) USING BTREE
#
# DROP/ADD statements:
#
ALTER TABLE `ttlsa_com`.`bbs_tags_relation` DROP INDEX `tag_id`, ADD INDEX `tag_id` (tag_id);
ALTER TABLE `ttlsa_com`.`bbs_tags_relation` DROP INDEX `fid`, ADD INDEX `fid` (fid);
#
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_users
# Showing indexes from ttlsa_com.bbs_users:
#
+------------+------------+----------+--------+---------+----------------+------------------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+------------+----------+--------+---------+----------------+------------------+
| ttlsa_com | bbs_users | PRIMARY | BTREE | True | False | uid, group_type |
+------------+------------+----------+--------+---------+----------------+------------------+
#
# Table ttlsa_com.bbs_users has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_user_follow
# Showing indexes from ttlsa_com.bbs_user_follow:
#
+------------+------------------+----------+--------+---------+----------------+-----------------------------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+------------------+----------+--------+---------+----------------+-----------------------------+
| ttlsa_com | bbs_user_follow | PRIMARY | BTREE | True | False | follow_id, uid, follow_uid |
+------------+------------------+----------+--------+---------+----------------+-----------------------------+
#
# Table ttlsa_com.bbs_user_follow has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.bbs_user_groups
# Showing indexes from ttlsa_com.bbs_user_groups:
#
+------------+------------------+----------+--------+---------+----------------+------------------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+------------------+----------+--------+---------+----------------+------------------+
| ttlsa_com | bbs_user_groups | PRIMARY | BTREE | True | False | gid, group_type |
+------------+------------------+----------+--------+---------+----------------+------------------+
#
# Table ttlsa_com.bbs_user_groups has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.data
# Showing indexes from ttlsa_com.data:
#
+------------+--------+----------+--------+---------+----------------+----------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+--------+----------+--------+---------+----------------+----------+
| ttlsa_com | data | PRIMARY | BTREE | True | False | value |
| ttlsa_com | data | id | BTREE | False | False | id |
+------------+--------+----------+--------+---------+----------------+----------+
#
# Table ttlsa_com.data has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# Getting indexes for ttlsa_com.t_data
# Showing indexes from ttlsa_com.t_data:
#
+------------+---------+----------+--------+---------+----------------+----------+
| database | table | name | type | unique | accepts nulls | columns |
+------------+---------+----------+--------+---------+----------------+----------+
| ttlsa_com | t_data | PRIMARY | BTREE | True | False | value |
| ttlsa_com | t_data | id | BTREE | False | False | id |
+------------+---------+----------+--------+---------+----------------+----------+
#
# Table ttlsa_com.t_data has no duplicate nor redundant indexes.
# WARNING: Not enough data to calculate best/worst indexes.
#
# ...done.