MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.

Percona Monitoring and Management (PMM) is an open-source platform for managing and monitoring MySQL and MongoDB performance. It is developed by Percona in collaboration with experts in the field of managed database services, support and consulting.

MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.

Via https://damien.pobel.fr/post/mycli-client-mysql-en-ligne-de-commande/

Via https://mastodon.evolix.org/@evolix/99614683605158418

Via https://stackoverflow.com/questions/24270733/automate-mysql-secure-installation-with-echo-command-via-a-shell-script

mysql -u root -p

Taille des bases :

SELECT table_schema AS "Database Name",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size in (MB)"
FROM information_schema.TABLES GROUP BY table_schema; 

Taille des tables d'une base :

SELECT table_name AS "Table Name",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size in (MB)"
FROM information_schema.TABLES WHERE table_schema = "ma-base" ORDER BY (data_length + index_length) DESC;

Taille physique :

du -h /var/lib/mysql