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


what is the size of the tables.
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?
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.