mysql查询数据库各表大小_查找数据库大小和表大小

mysql> SELECT table_name AS "Tables",round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"

-> FROM information_schema.TABLES

-> WHERE table_schema = "www_ttlsa_com"

-> ORDER BY (data_length + index_length) DESC;

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

| Tables | Size in MB |

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

| ttlsa_postmeta | 29.74 |

| ttlsa_posts | 25.04 |

| ttlsa_redirection_404 | 15.30 |

| ttlsa_sph_stats | 2.53 |

| ttlsa_options | 2.53 |

| ttlsa_comments | 1.44 |

| ttlsa_commentmeta | 1.17 |

| ttlsa_redirection_logs | 1.11 |

| ttlsa_usermeta | 0.75 |

| ttlsa_cst_files | 0.70 |

| ttlsa_term_relationships | 0.38 |

| ttlsa_redirection_items | 0.30 |

| ttlsa_terms | 0.28 |

| ttlsa_term_taxonomy | 0.19 |

| ttlsa_post_views_realtime | 0.07 |

| ttlsa_wp_rp_tags | 0.06 |

| ttlsa_users | 0.04 |

| ttlsa_ez_adsense_options | 0.04 |

| ttlsa_post_views_history | 0.03 |

| ttlsa_links | 0.01 |

| ttlsa_pollsip | 0.00 |

| ttlsa_redirection_groups | 0.00 |

| ttlsa_redirection_modules | 0.00 |

| ttlsa_termmeta | 0.00 |

| ttlsa_woocommerce_order_itemmeta | 0.00 |

| ttlsa_post_views_summary | 0.00 |

| ttlsa_mobilepress | 0.00 |

| ttlsa_pollsa | 0.00 |

| ttlsa_ahm_download_stats | 0.00 |

| ttlsa_pollsq | 0.00 |

| ahm_files | 0.00 |

| ttlsa_sph_counter | 0.00 |

| ttlsa_wpo_campaign_category | 0.00 |

| ttlsa_gravatars | 0.00 |

| ttlsa_woocommerce_order_items | 0.00 |

| ttlsa_nggv_votes | 0.00 |

| ttlsa_wpo_campaign_word | 0.00 |

| ttlsa_seo_title_tag_tag | 0.00 |

| ttlsa_nggv_settings | 0.00 |

| ttlsa_wpo_campaign_post | 0.00 |

| ttlsa_wpo_campaign_feed | 0.00 |

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

41 rows in set (0.00 sec)