MYSQL常用SQL

快速查询FK与统计库大小

最新推荐文章于 2025-01-06 21:24:30 发布

转载最新推荐文章于 2025-01-06 21:24:30 发布 · 133 阅读

A quick way to list your FKs (Foreign Key references) using the KEY_COLUMN_USAGE view:

SELECT CONCAT( table_name, '.',
column_name, ' -> ',
referenced_table_name, '.',
referenced_column_name ) AS list_of_fks
FROM information_schema.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_SCHEMA = (your schema name here)
AND REFERENCED_TABLE_NAME is not null
ORDER BY TABLE_NAME, COLUMN_NAME;

统计库大小
SELECT concat( table_schema, '.', table_name ) table_name,
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
FROM information_schema.TABLES
ORDER BY data_length DESC;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26526320/viewspace-2123432/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26526320/viewspace-2123432/