Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In order to split mysql database into two different databases on different hosts. I would like to know few things:

  1. what is the size of the tables.
  2. what is the traffic throughput to those tables.

Size of the tables can be determined easily, but how to find traffic throughput to tables.

How to identify how many data was retrieved from specific table?

share|improve this question

migrated from Nov 13 '12 at 23:08

This question came from our site for system and network administrators.

Try MONyog which has Disk Info tab which shows tables size also you will come to know most accessed tables using Real-Time feature of MONyog. enter image description here

share|improve this answer

mytop mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server

share|improve this answer
In the same space (and somewhat more updated) are mtop and innotop. None of them do what the OP is asking for, however. – Ladadadada Nov 13 '12 at 9:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.