ANALYZE TABLE kms_new.kms_form;
ANALYZE TABLE kms_new.kms_form_adj_tbl;
ANALYZE TABLE kms_new.kms_form_note_tbl;
ANALYZE TABLE kms_new.kms_form_portrait;
ANALYZE TABLE kms_new.kms_form_chine;
ANALYZE TABLE kms_new.kms_interview;
ANALYZE TABLE kms_new.kms_interview_other_attr;
ANALYZE TABLE kms_new.kms_dico_adj;
ANALYZE TABLE kms_new.kms_study;
ANALYZE TABLE kms_new.kms_product;
ANALYZE TABLE kms_new.wrr_users;

SELECT TABLE_NAME, TABLE_ROWS,
  ROUND(DATA_LENGTH/1024/1024,1) as data_mb,
  ROUND(INDEX_LENGTH/1024/1024,1) as idx_mb,
  ROUND((DATA_LENGTH+INDEX_LENGTH)/1024/1024,1) as total_mb
FROM information_schema.TABLES
WHERE TABLE_SCHEMA='kms_new'
ORDER BY (DATA_LENGTH+INDEX_LENGTH) DESC;
