SELECT
    TABLE_SCHEMA,
    TABLE_NAME,
    round(((data_length + index_length) / 1024 / 1024), 2) as size
FROM
    information_schema.TABLES
WHERE
    table_name LIKE 'table_0%'
ORDER BY (data_length + index_length) DESC;

SELECT
    count(*) as counts
FROM
    information_schema.TABLES
WHERE
    table_schema = 'test_db1';

SELECT count(*) as counts
FROM information_schema.columns
WHERE table_schema = 'test_db1' AND table_name = 'table_001';

SELECT TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH 
FROM information_schema.tables 
WHERE table_schema = 'test_db1' AND table_name = 'table_001';

SELECT
    CONSTRAINT_NAME,
    COLUMN_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_COLUMN_NAME
FROM information_schema.key_column_usage
WHERE table_schema = 'test_db1' AND table_name = 'table_001';

SELECT INDEX_NAME, COLUMN_NAME
FROM information_schema.statistics
WHERE table_schema = 'test_db1' AND table_name = 'table_001';

SELECT count(*) as counts
FROM information_schema.routines
WHERE routine_schema = 'test_db1' AND routine_type = 'PROCEDURE';

SELECT User, Host
FROM mysql.user
WHERE delete_priv = true;