Intéressant : select * from file_summary_by_instance order by count_read desc,count_write desc limit 5

Réservé Mysql 5.6 / MariaDB 10.0

1) USE performance_schema;
2) select * from performance_schema.events_waits_summary_global_by_event_name where count_star>0 order by count_star desc limit 25;

save :
sudo -u mysql mysqldump --protocol=socket -S /var/run/mysqld/mysqld.sock --all-databases -p | bzip2 -c > databasebackup.sql.bz2

restore :
bzip2 -d databasebackup.sql.bz2
sudo -u mysql --protocol=socket -S /var/run/mysqld/mysqld.sock < databasebackup.sql

si droits root (création de base, etc...)

sudo -u mysql -u root -p --protocol=socket -S /var/run/mysqld/mysqld.sock < databasebackup.sql