Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Looking into using Amazon's RDS offering announced this week. In doing cost analysis, I'd like to see what our current data transfer in/out in. We have a dedicated server running Apache & MySQL 4.1.22. SHOW STATUShas a Bytes_recieved and Bytes_sent variable. Just divide that by the server's uptime and work from there, or is there a better way?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Bytes_received or Bytes_sent divided by Uptime is the only way to pull the information from MySQL itself. You need to bear in mind that it will (obviously) be averaged over the total uptime period.

So if the server hasn't been up for very long then it may not have experienced it's true peak/trough usage. Likewise if it has been up for a long time then it might include some unusual activity that you wouldnt normally see, like a mysqldump that happened to be a one off.

A much better approach, if you have the time, would be to monitor the current machine with something like Cacti. You can record throughput on the system's network interfaces and various metrics from MySQL using Baron Schwartz's excellent templates. Graphs will be created and you observe the trends from both a daily and weekly/monthly/yearly basis.

share|improve this answer
add comment

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.