root@db1075[sys]> select table_schema, sum(total_latency) as latency FROM x$schema_table_statistics GROUP BY table_schema ORDER BY latency DESC LIMIT 20;
+---------------+-------------------+
| table_schema | latency |
+---------------+-------------------+
| loginwiki | 27408946574524658 |
| heartbeat | 6598870761431520 |
| ruwiktionary | 5763622545480800 |
| ruwikisource | 5387585333028756 |
| enwikisource | 4369249543450792 |
| ruwikinews | 4348592997866546 |
| cywiki | 4345551731211834 |
| dawiki | 4010741717824270 |
| specieswiki | 3772207160558122 |
| elwiki | 3411122321623874 |
| urwiki | 3097049706021414 |
| mediawikiwiki | 2947554293969428 |
| hiwiki | 2758917533134906 |
| hywiki | 2708470437012054 |
| azwiki | 2464451878996822 |
| etwiki | 2353731533405538 |
| cewiki | 2123102752972630 |
| simplewiki | 2120499753908536 |
| incubatorwiki | 2078290888311924 |
| mswiki | 2075837350189746 |
+---------------+-------------------+
20 rows in set (0.14 sec)
root@db1075[sys]> select table_schema, sum(rows_fetched) as row_reads FROM x$schema_table_statistics GROUP BY table_schema ORDER BY row_reads DESC LIMIT 20;
+--------------+------------+
| table_schema | row_reads |
+--------------+------------+
| heartbeat | 1987401108 |
| ruwikinews | 1178327443 |
| eswikinews | 903064930 |
| ruwiktionary | 573260200 |
| enwikisource | 404222322 |
| dawiki | 345920511 |
| elwiki | 335306424 |
| ptwikinews | 328507775 |
| urwiki | 299433460 |
| specieswiki | 295739411 |
| cywiki | 292026525 |
| plwikisource | 261066955 |
| ruwikisource | 243940983 |
| simplewiki | 225388431 |
| hiwiki | 216349589 |
| etwiki | 216315626 |
| azwiki | 190692054 |
| mswiki | 181966577 |
| hywiki | 179103722 |
| zhwikisource | 175792365 |
+--------------+------------+
20 rows in set (0.14 sec)
root@db1075[sys]> select table_schema, sum(rows_inserted + rows_updated + rows_deleted) as row_writes FROM x$schema_table_statistics GROUP BY table_schema ORDER BY row_writes DESC LIMIT 20;