Differences

This shows you the differences between two versions of the page.

--- datenbanken:mysql [2024/07/03 14:47] – [Befehle] gsys
+++ datenbanken:mysql [2025/03/03 15:04] (current) – [Befehle] gsys
@@ Line 21: / Line 21: @@
 SHOW FIELDS FROM tabelle;                       # Struktur einer Tabelle anzeigen
 DESCRIBE user;                                  #    "       "      "       "
+show grants;                                    # Berechtigungen für angemeldeten user anzeigen
+show grants for 'user'@'10.1.2.3';              # Berechtigungen für user mit ip anzeigen
 </code>
@@ Line 46: / Line 48: @@
 </code>
-<code>
+** Get Tables Sizes from all DBs **
-show grants;
+<code mysql>
-show grants for 'user'@'10.1.2.3';
+SELECT
+  TABLE_NAME AS `Table`,
+  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
+FROM
+  information_schema.TABLES
+WHERE
+  TABLE_SCHEMA = "$DB_NAME"
+ORDER BY
+  (DATA_LENGTH + INDEX_LENGTH)
+DESC;
 </code>