Skip to content

Calculate MySQL DB size

Vitalii Mikhnevych edited this page Sep 7, 2024 · 4 revisions

Запрос для подсчета размера баз в MySQL

SELECT table_schema AS "Database", 
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;

пример работы запроса

image

Clone this wiki locally