Skip to content

Instantly share code, notes, and snippets.

@ticklemynausea

ticklemynausea/test.txt

Created July 18, 2014 01:38
Show Gist options
  • Save ticklemynausea/ad1aac9d446197ab41de to your computer and use it in GitHub Desktop.
Save ticklemynausea/ad1aac9d446197ab41de to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test.txt
mysql> select distinct table_schema, engine, table_name, table_rows from information_schema.tables where table_schema not in ('performance_schema', 'mysql', 'hlstats', 'information_schema') order by table_schema, table_rows desc;
+---------------------------+--------+-------------------------------------------------+------------+
| table_schema | engine | table_name | table_rows |
+---------------------------+--------+-------------------------------------------------+------------+
| esotalk | InnoDB | et_activity | 608 |
| esotalk | InnoDB | et_member_conversation | 539 |
| esotalk | MyISAM | et_post | 456 |
| esotalk | InnoDB | et_like | 234 |
| esotalk | InnoDB | et_member | 64 |
| esotalk | InnoDB | et_cookie | 59 |
| esotalk | InnoDB | et_attachment | 58 |
| esotalk | InnoDB | et_conversation | 43 |
| esotalk | InnoDB | et_channel_group | 35 |
| esotalk | InnoDB | et_channel | 13 |
| esotalk | InnoDB | et_member_member | 7 |
| esotalk | InnoDB | et_member_group | 6 |
| esotalk | InnoDB | et_member_channel | 5 |
| esotalk | InnoDB | et_group | 2 |
| esotalk | InnoDB | et_profile_field | 2 |
| esotalk | InnoDB | et_search | 1 |
| esotalk | InnoDB | et_oc_member_social | 0 |
| esotalk | InnoDB | et_oc_settings | 0 |
| esotalk | InnoDB | et_page | 0 |
| esotalk | InnoDB | et_profile_data | 0 |
| fe | InnoDB | fe_accounts | 3381 |
| fe_testing | InnoDB | fe_accounts | 3386 |
| globalmarket | InnoDB | history | 7340 |
| globalmarket | InnoDB | items | 1104 |
| globalmarket | InnoDB | mail | 249 |
| globalmarket | InnoDB | users | 149 |
| globalmarket | InnoDB | listings | 126 |
| globalmarket | InnoDB | queue | 0 |
| globalmarket_testing | InnoDB | history | 7419 |
| globalmarket_testing | InnoDB | items | 1157 |
| globalmarket_testing | InnoDB | mail | 249 |
| globalmarket_testing | InnoDB | users | 146 |
| globalmarket_testing | InnoDB | listings | 45 |
| globalmarket_testing | InnoDB | queue | 0 |
| inquisitor | MyISAM | players | 6035 |
| inquisitor_testing | MyISAM | players | 5978 |
| minecraft_auth | InnoDB | sessions_history | 69306 |
| minecraft_auth | InnoDB | itemdrops | 46691 |
| minecraft_auth | MyISAM | accounts | 5878 |
| minecraft_auth | InnoDB | players | 5358 |
| minecraft_auth | MyISAM | sessions | 3608 |
| minecraft_auth | MyISAM | playerdata | 1079 |
| minecraft_auth | InnoDB | stats_materials | 377 |
| minecraft_auth | InnoDB | lockouts | 313 |
| minecraft_auth | InnoDB | fail_log | 223 |
| minecraft_auth | InnoDB | stats_entities | 59 |
| minecraft_auth | InnoDB | stats_settings | 45 |
| minecraft_auth | InnoDB | stats_server_statistics | 28 |
| minecraft_auth | MyISAM | news | 6 |
| minecraft_auth | MyISAM | locations | 1 |
| minecraft_auth | InnoDB | stats_detailed_death_players | 0 |
| minecraft_auth | InnoDB | stats_detailed_destroyed_blocks | 0 |
| minecraft_auth | InnoDB | stats_detailed_dropped_items | 0 |
| minecraft_auth | InnoDB | stats_detailed_log_players | 0 |
| minecraft_auth | InnoDB | stats_detailed_pickedup_items | 0 |
| minecraft_auth | InnoDB | stats_detailed_placed_blocks | 0 |
| minecraft_auth | InnoDB | stats_detailed_pve_kills | 0 |
| minecraft_auth | InnoDB | stats_detailed_pvp_kills | 0 |
| minecraft_auth | InnoDB | stats_detailed_used_items | 0 |
| minecraft_auth | InnoDB | stats_distances | 0 |
| minecraft_auth | InnoDB | stats_misc_info_players | 0 |
| minecraft_auth | InnoDB | stats_players | 0 |
| minecraft_auth | InnoDB | stats_player_inventories | 0 |
| minecraft_auth | InnoDB | stats_player_locations | 0 |
| minecraft_auth | InnoDB | stats_total_blocks | 0 |
| minecraft_auth | InnoDB | stats_total_deaths | 0 |
| minecraft_auth | InnoDB | stats_total_items | 0 |
| minecraft_auth | InnoDB | stats_total_pve_kills | 0 |
| minecraft_auth | InnoDB | stats_total_pvp_kills | 0 |
| minecraft_auth_testing | InnoDB | sessions_history | 68536 |
| minecraft_auth_testing | InnoDB | itemdrops | 45279 |
| minecraft_auth_testing | InnoDB | players | 7118 |
| minecraft_auth_testing | MyISAM | accounts | 5837 |
| minecraft_auth_testing | MyISAM | sessions | 3591 |
| minecraft_auth_testing | MyISAM | playerdata | 1074 |
| minecraft_auth_testing | InnoDB | stats_materials | 707 |
| minecraft_auth_testing | InnoDB | lockouts | 279 |
| minecraft_auth_testing | InnoDB | fail_log | 163 |
| minecraft_auth_testing | InnoDB | stats_entities | 59 |
| minecraft_auth_testing | InnoDB | stats_settings | 45 |
| minecraft_auth_testing | InnoDB | stats_server_statistics | 28 |
| minecraft_auth_testing | MyISAM | news | 6 |
| minecraft_auth_testing | MyISAM | locations | 1 |
| minecraft_auth_testing | InnoDB | stats_detailed_death_players | 0 |
| minecraft_auth_testing | InnoDB | stats_detailed_destroyed_blocks | 0 |
| minecraft_auth_testing | InnoDB | stats_detailed_dropped_items | 0 |
| minecraft_auth_testing | InnoDB | stats_detailed_log_players | 0 |
| minecraft_auth_testing | InnoDB | stats_detailed_pickedup_items | 0 |
| minecraft_auth_testing | InnoDB | stats_detailed_placed_blocks | 0 |
| minecraft_auth_testing | InnoDB | stats_detailed_pve_kills | 0 |
| minecraft_auth_testing | InnoDB | stats_detailed_pvp_kills | 0 |
| minecraft_auth_testing | InnoDB | stats_detailed_used_items | 0 |
| minecraft_auth_testing | InnoDB | stats_distances | 0 |
| minecraft_auth_testing | InnoDB | stats_misc_info_players | 0 |
| minecraft_auth_testing | InnoDB | stats_players | 0 |
| minecraft_auth_testing | InnoDB | stats_player_inventories | 0 |
| minecraft_auth_testing | InnoDB | stats_player_locations | 0 |
| minecraft_auth_testing | InnoDB | stats_total_blocks | 0 |
| minecraft_auth_testing | InnoDB | stats_total_deaths | 0 |
| minecraft_auth_testing | InnoDB | stats_total_items | 0 |
| minecraft_auth_testing | InnoDB | stats_total_pve_kills | 0 |
| minecraft_auth_testing | InnoDB | stats_total_pvp_kills | 0 |
| minecraft_cp | InnoDB | co_block | 19425077 |
| minecraft_cp | InnoDB | co_entity | 1031909 |
| minecraft_cp | InnoDB | co_container | 689816 |
| minecraft_cp | InnoDB | co_chat | 283934 |
| minecraft_cp | InnoDB | co_command | 109550 |
| minecraft_cp | InnoDB | co_session | 42930 |
| minecraft_cp | InnoDB | co_sign | 24799 |
| minecraft_cp | InnoDB | co_user | 4277 |
| minecraft_cp | InnoDB | co_skull | 80 |
| minecraft_cp | InnoDB | co_world | 29 |
| minecraft_cp | InnoDB | co_version | 2 |
| minecraft_cp_testing | InnoDB | co_block | 17291 |
| minecraft_cp_testing | InnoDB | co_session | 117 |
| minecraft_cp_testing | InnoDB | co_chat | 58 |
| minecraft_cp_testing | InnoDB | co_user | 30 |
| minecraft_cp_testing | InnoDB | co_command | 29 |
| minecraft_cp_testing | InnoDB | co_entity | 18 |
| minecraft_cp_testing | InnoDB | co_world | 12 |
| minecraft_cp_testing | InnoDB | co_version | 1 |
| minecraft_cp_testing | InnoDB | co_container | 0 |
| minecraft_cp_testing | InnoDB | co_sign | 0 |
| minecraft_cp_testing | InnoDB | co_skull | 0 |
| minecraft_tickets | InnoDB | SHT_Tickets | 60 |
| minecraft_tickets_testing | InnoDB | SHT_Tickets | 59 |
| wp_minecraftia | MyISAM | wp_postmeta | 2678 |
| wp_minecraftia | MyISAM | wp_posts | 1098 |
| wp_minecraftia | MyISAM | wp_options | 971 |
| wp_minecraftia | MyISAM | wp_term_relationships | 347 |
| wp_minecraftia | MyISAM | wp_usermeta | 268 |
| wp_minecraftia | MyISAM | wp_term_taxonomy | 142 |
| wp_minecraftia | MyISAM | wp_terms | 138 |
| wp_minecraftia | InnoDB | wp_woocommerce_termmeta | 80 |
| wp_minecraftia | MyISAM | wp_commentmeta | 30 |
| wp_minecraftia | MyISAM | wp_ngg_pictures | 21 |
| wp_minecraftia | MyISAM | wp_users | 13 |
| wp_minecraftia | MyISAM | wp_comments | 11 |
| wp_minecraftia | InnoDB | wp_pollsa | 5 |
| wp_minecraftia | InnoDB | wp_plugin_minecraft_server_info | 4 |
| wp_minecraftia | MyISAM | wp_ngg_gallery | 3 |
| wp_minecraftia | InnoDB | wp_woocommerce_attribute_taxonomies | 2 |
| wp_minecraftia | InnoDB | wp_pollsq | 1 |
| wp_minecraftia | MyISAM | wp_ngg_album | 1 |
| wp_minecraftia | InnoDB | wp_itsec_lockouts | 0 |
| wp_minecraftia | InnoDB | wp_itsec_log | 0 |
| wp_minecraftia | InnoDB | wp_itsec_temp | 0 |
| wp_minecraftia | InnoDB | wp_pollsip | 0 |
| wp_minecraftia | InnoDB | wp_woocommerce_downloadable_product_permissions | 0 |
| wp_minecraftia | InnoDB | wp_woocommerce_order_itemmeta | 0 |
| wp_minecraftia | InnoDB | wp_woocommerce_order_items | 0 |
| wp_minecraftia | InnoDB | wp_woocommerce_tax_rates | 0 |
| wp_minecraftia | InnoDB | wp_woocommerce_tax_rate_locations | 0 |
| wp_minecraftia | MyISAM | wp_links | 0 |
| wp_minecraftia | MyISAM | yts_log | 0 |
| wp_minecraftia_test | MyISAM | wp_postmeta | 2653 |
| wp_minecraftia_test | MyISAM | wp_posts | 1170 |
| wp_minecraftia_test | MyISAM | wp_options | 721 |
| wp_minecraftia_test | MyISAM | wp_term_relationships | 321 |
| wp_minecraftia_test | MyISAM | wp_usermeta | 272 |
| wp_minecraftia_test | MyISAM | wp_term_taxonomy | 140 |
| wp_minecraftia_test | MyISAM | wp_terms | 136 |
| wp_minecraftia_test | InnoDB | wp_woocommerce_termmeta | 80 |
| wp_minecraftia_test | MyISAM | wp_commentmeta | 23 |
| wp_minecraftia_test | MyISAM | wp_ngg_pictures | 21 |
| wp_minecraftia_test | MyISAM | wp_users | 13 |
| wp_minecraftia_test | MyISAM | wp_comments | 9 |
| wp_minecraftia_test | InnoDB | wp_pollsa | 5 |
| wp_minecraftia_test | InnoDB | wp_plugin_minecraft_server_info | 4 |
| wp_minecraftia_test | MyISAM | wp_ngg_gallery | 3 |
| wp_minecraftia_test | InnoDB | wp_woocommerce_attribute_taxonomies | 2 |
| wp_minecraftia_test | InnoDB | wp_pollsq | 1 |
| wp_minecraftia_test | MyISAM | wp_ngg_album | 1 |
| wp_minecraftia_test | InnoDB | wp_itsec_lockouts | 0 |
| wp_minecraftia_test | InnoDB | wp_itsec_log | 0 |
| wp_minecraftia_test | InnoDB | wp_itsec_temp | 0 |
| wp_minecraftia_test | InnoDB | wp_pollsip | 0 |
| wp_minecraftia_test | InnoDB | wp_woocommerce_downloadable_product_permissions | 0 |
| wp_minecraftia_test | InnoDB | wp_woocommerce_order_itemmeta | 0 |
| wp_minecraftia_test | InnoDB | wp_woocommerce_order_items | 0 |
| wp_minecraftia_test | InnoDB | wp_woocommerce_tax_rates | 0 |
| wp_minecraftia_test | InnoDB | wp_woocommerce_tax_rate_locations | 0 |
| wp_minecraftia_test | MyISAM | wp_links | 0 |
| wp_minecraftia_test | MyISAM | yts_log | 0 |
+---------------------------+--------+-------------------------------------------------+------------+
184 rows in set (0.84 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment