MySQL Administration and Routine Database Operations
Configuring the CLI Prompt
To temporarily modify the MySQL prompt during a session, execute the prompt command:
mysql> prompt \u@mycluster \r:\m:\s->
For a persistent configuration, append the prompt directive under the [mysql] section in the my.cnf configuration file:
[mysql]
prompt=\u@mycluster \r:\m:\s->
Establishing Database Connec ...
Posted on Fri, 08 May 2026 18:45:15 +0000 by reeferd
Monitoring Disk Usage and Storage Optimization in MySQL
Assessing Global Database Storage
To analyze the disk footprint across all databases, querying the information_schema tables is necessary. The following script aggregates the total size, distinguishing between data and index usage, and sorts the results by the heaviest consumers first.
SELECT
table_schema AS 'Database Name',
ROUND(SUM( ...
Posted on Fri, 08 May 2026 03:59:40 +0000 by AudiS2