MySQL/metrics

Métriques sur les tables : nombre de lignes, taille de données et des indexes.

SELECT concat(table_schema,'.',table_name),
       table_rows Rows,
       round(data_length/(1024*1024),2) "Data (MB)",
       round(index_length/(1024*1024),2) "Index (MB)",
       round((data_length+index_length)/(1024*1024),2) "Total size (MB)"
FROM information_schema.TABLES
ORDER BY data_length+index_length DESC;

Cumul

SELECT table_schema,
       round(sum(data_length)/(1024*1024),0) "Data (MB)",
       round(sum(index_length)/(1024*1024),0) "Index (MB)",
       round(sum(data_length+index_length)/(1024*1024),0) "Total size (MB)"
FROM information_schema.tables
GROUP BY table_schema;

Pour avoir le nombre de requêtes total ou par seconde :

mysql> status

Renvoie

Threads: 14  Questions: 65212688  Slow queries: 26  Opens: 10849  Flush tables: 159  Open tables: 60  Queries per second avg: 15.048

Autre solution, avec une requête :

SELECT uptime.variable_value,
       queries.variable_value,
       round(queries.variable_value/uptime.variable_value,2)
FROM information_schema.SESSION_STATUS as queries,
     information_schema.SESSION_STATUS as uptime
WHERE uptime.variable_name='UPTIME'
  AND queries.variable_name='QUERIES';