MySQL上线，检查数据库设计的“十条合规”

复制SELECT TABLE_SCHEMA,十条合规         TABLE_NAME TABLE_NAME, TABLE_ROWS,                    CONCAT(ROUND(data_length / (1024 * 1024), 2),M) data_length,                    CONCAT(ROUND(index_length / (1024 * 1024), 2),M) index_length,                    CONCAT(ROUND(ROUND(data_length + index_length) / (1024 * 1024),2),M) total_size,                    engine  FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA NOTIN (INFORMATION_SCHEMA ,                             performance_schema,                             sys,                             mysql)  ORDERBY (data_length + index_length) DESC LIMIT 10;  +--------------+-----------------------+------------+-------------+--------------+------------+--------+ | TABLE_SCHEMA | TABLE_NAME            | TABLE_ROWS | data_length | index_length | total_size | ENGINE |  +--------------+-----------------------+------------+-------------+--------------+------------+--------+ | employees    | salaries              |    1910497 | 64.59M      | 0.00M        | 64.59M     | InnoDB |  | employees    | employees             |     299556 | 14.52M      | 10.03M       | 24.55M     | InnoDB |  | employees    | employees01           |     101881 | 5.52M       | 8.55M        | 14.06M     | InnoDB |  | employees    | t_temp                |      95374 | 5.52M       | 5.52M        | 11.03M     | InnoDB |  | db3          | t_temp                |       1000 | 0.08M       | 0.13M        | 0.20M      | InnoDB |  | db3          | transportorder        |          3 | 0.02M       | 0.06M        | 0.08M      | InnoDB |  | db3          | transportorderwaybill |          3 | 0.02M       | 0.05M        | 0.06M      | InnoDB |  | db1          | pt1                   |         10 | 0.06M       | 0.00M        | 0.06M      | InnoDB |  | db1          | city                  |          2 | 0.02M       | 0.03M        | 0.05M      | InnoDB |  | db2          | tabname               |         30 | 0.02M       | 0.03M        | 0.05M      | InnoDB |  +--------------+-----------------------+------------+-------------+--------------+------------+--------+ 10 rowsinset (0.20 sec)  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.