Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- mysql [2024-11-18 13:01:20] – [Variablen ausgeben] manfred
+++ mysql [2025-09-12 12:37:11] (aktuell) – [auf Platte] manfred
@@ Zeile 228: / Zeile 228: @@
   SELECT CONCAT(@@server_id, UUID());
   SHOW VARIABLES LIKE 'server_id';
-  SHOW VARIABLES WHERE Variable_name IN ('server_id');
+  SHOW VARIABLES WHERE Variable_name IN ('hostname');
   SHOW STATUS WHERE Variable_name IN ('Connections','Created_tmp_files','Innodb_buffer_pool_write_requests','Innodb_data_fsyncs','Innodb_data_writes','Innodb_data_written','Innodb_log_write_requests','Innodb_log_writes','Innodb_pages_written','Queries','Ssl_cipher','Uptime','Uptime_since_flush_status','Innodb_buffer_pool_load_status');
@@ Zeile 266: / Zeile 266: @@
   ASC
   LIMIT 10;
+==== VIEWs zeigen ====
+  > echo "SHOW STATUS WHERE variable_name LIKE 'Max_used_connections%' OR variable_name LIKE 'Uptime';" | mysql -t
+  +---------------------------+---------------------+
+  | Variable_name             | Value               |
+  +---------------------------+---------------------+
+  | Max_used_connections      | 386                 |
+  | Max_used_connections_time | 2025-06-24 10:19:25 |
+  | Uptime                    | 5931173             |
+  +---------------------------+---------------------+
@@ Zeile 1327: / Zeile 1339: @@
 ### Summen
 echo "
+SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
 SELECT
         table_schema AS 'Datenbankname',
@@ Zeile 2110: / Zeile 2123: @@
         data_length / 1024 / 1024 'Daten in MB',
         index_length / 1024 / 1024 'Index in MB'
-        FROM infor/root/bin/Tabellengröße_einer_Datenbank_anzeigen.sh simsysnetwork -Nmation_schema.tables WHERE table_schema='${1}' AND"
+        FROM information_schema.tables WHERE table_schema='${1}' AND"
 fi
@@ Zeile 2117: / Zeile 2130: @@
         echo "${SQL} table_name='${TAB}';" | mysql ${OPT}
 done
+</code>
+<code bash /root/bin/Datenbankgröße.sh>
+#!/bin/bash
+#------------------------------------------------------------------------------#
+echo "
+SELECT
+        table_schema 'Datenbankname',
+        sum( data_length + index_length ) / 1024 / 1024 'Datenbank in MB',
+        data_length / 1024 / 1024 'Daten in MB',
+        index_length / 1024 / 1024 'Index in MB'
+FROM
+        information_schema.tables
+GROUP BY table_schema
+;" | mysql -t
+#------------------------------------------------------------------------------#
+</code>
+<code bash /root/bin/Tabellengröße.sh>
+#!/bin/bash
+#------------------------------------------------------------------------------#
+echo "
+SELECT
+        table_schema AS 'Datenbankname',
+        table_name,
+        ROUND( DATA_LENGTH / 1024 / 1024, 3 ) AS 'Daten (MB)',
+        ROUND( INDEX_LENGTH / 1024 / 1024, 3 ) AS 'Index (MB)',
+        ROUND( DATA_FREE / 1024 / 1024, 3 ) AS 'Freier Speicher (MB)'
+FROM
+        information_schema.tables
+WHERE
+        TABLE_TYPE='BASE TABLE'
+        AND
+        ENGINE='InnoDB'
+        AND
+        TABLE_SCHEMA<>'mysql'
+        AND
+        TABLE_SCHEMA<>'sys'
+ORDER BY 3
+;" | mysql -t
+#------------------------------------------------------------------------------#
 </code>