Оцінка БД MySQL / Maria DB

Автор

Загальний обсяг всіх БД

SELECT 
  table_schema AS db_name,
  ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS size_mb
FROM information_schema.tables
GROUP BY table_schema
ORDER BY size_mb DESC;

Обсяг по таблицям

SELECT
    table_name AS `table`,
    ROUND((data_length + index_length) / 1024 / 1024, 2) AS `size_mb`,
    ROUND(data_length / 1024 / 1024, 2) AS `data_mb`,
    ROUND(index_length / 1024 / 1024, 2) AS `index_mb`
FROM information_schema.tables
WHERE table_schema = DATABASE()
ORDER BY size_mb DESC;

Зовнішні ключі таблиці

SELECT
    CONSTRAINT_NAME,
    COLUMN_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'table_name'
  AND REFERENCED_TABLE_NAME IS NOT NULL;

Залишити коментар