pythontr.com
SELECT table_schema as "Veritabanı Adı", sum(data_length + index_length) /1024 /1024/1024 as "GB Olarak Büyüklük" FROM information_schema.TABLES GROUP BY table_schema ;
SELECT table_schema as "Veritabanı Adı", sum(data_length + index_length) /1024/1024/1024 as "GB Olarak Büyüklük" FROM information_schema.TABLES where table_schema='Sorgulanacak veritabanı adı' GROUP BY table_schema ;
SELECT table_name as "Tablo Adi", (data_length + index_length) /1024/1024/1024 as "GB Olarak Büyüklük" FROM information_schema.TABLES where table_schema='Sorgulanacak veritabanı adı';
Yorumlar