timmy hat die Gist bearbeitet 9 months ago. Zu Änderung gehen
1 file changed, 28 insertions
mysql_database_queries.sql(Datei erstellt)
| @@ -0,0 +1,28 @@ | |||
| 1 | + | SHOW DATABASES; | |
| 2 | + | ||
| 3 | + | USE myapp; | |
| 4 | + | SHOW TABLES; | |
| 5 | + | ||
| 6 | + | SELECT TABLE_NAME, TABLE_ROWS | |
| 7 | + | FROM INFORMATION_SCHEMA.TABLES | |
| 8 | + | WHERE TABLE_SCHEMA = 'myapp'; | |
| 9 | + | ||
| 10 | + | SELECT TABLE_NAME, | |
| 11 | + | ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS SIZE_MB | |
| 12 | + | FROM INFORMATION_SCHEMA.TABLES | |
| 13 | + | WHERE TABLE_SCHEMA = 'myapp' | |
| 14 | + | ORDER BY SIZE_MB DESC; | |
| 15 | + | ||
| 16 | + | SELECT TABLE_NAME, | |
| 17 | + | TABLE_ROWS AS RECORDS, | |
| 18 | + | ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS SIZE_MB | |
| 19 | + | FROM INFORMATION_SCHEMA.TABLES | |
| 20 | + | WHERE TABLE_SCHEMA = 'myapp' | |
| 21 | + | ORDER BY SIZE_MB DESC; | |
| 22 | + | ||
| 23 | + | SELECT TABLE_SCHEMA AS DATABASE_NAME, | |
| 24 | + | TABLE_NAME, | |
| 25 | + | TABLE_ROWS AS RECORDS, | |
| 26 | + | ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS SIZE_MB | |
| 27 | + | FROM INFORMATION_SCHEMA.TABLES | |
| 28 | + | ORDER BY DATABASE_NAME, SIZE_MB DESC; | |
Neuer
Älter