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

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

Via http://www.geek-directeur-technique.com/2017/08/10/arkiv-sauvegarde-de-fichiers-et-bases-mysql-archivage-sur-amazon-s3-et-amazon-glacier

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

MariaDB qui demande pas de password à l'install, et du coup, impossibilité d'utiliser PHPMyAdmin par exemple :

sudo mysql -u root
[mysql] use mysql;
[mysql] update user set plugin='' where User='root';
[mysql] flush privileges;
[mysql] \q

Le tout pour supprimer la connexion par plugin pour root.

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

wget http://mysqltuner.pl/ -O mysqltuner.pl
perl mysqltuner.pl

Script read-only : il ne fera que vous donnez des conseils pour l'optimisation, il ne touche à rien.

/Coude.