Tell me more ×
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. It's 100% free, no registration required.
up vote 2 down vote favorite

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 serverfault.com Nov 13 '12 at 23:08

2 Answers

up vote -1 down vote

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
up vote -2 down vote

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
2  
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

 
discard

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.