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?