How calculate Mysql Trafiq

Hi
I have setup Cacti graph which is showing mysql trafiq

http://code.google.com/p/mysql-cacti-templates/


but what i want to know is

is there any variables in mysql which shows the incoming traifq and out going trafiq ???

example : "Connection" will show how many connection is my the server

so i am woundering how the script actually calculating the Incomming trafiq and outgoing trafiq from mysql server .

Thanks for advise
LVL 29
fosiul01Asked:
Who is Participating?
 
johanntagleCommented:
http://dev.mysql.com/doc/refman/5.1/en/show-status.html

e.g.
SHOW STATUS LIKE 'THREADS_CONNECTED';
SHOW STATUS LIKE 'THREADS_RUNNING';
0
 
fosiul01Author Commented:
hi thank

but how will you know.. how much data is comming into mysql server
and going out from mysql server ??

is this by

Bytes_received           | 155372598  |
| Bytes_sent               | 1176560426 |
 

that value what that value ?? K or B??
0
 
fosiul01Author Commented:
i think its sayin Bytes its saying Bytes Received

but that value ..

whats that value ??

Bytes receives : it could be insert into database

but what bytes_set ??
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
fosiul01Author Commented:
also that value

per second ??

according to mysql documentaiton is saying

Bytes_received

The number of bytes received from all clients. This variable was added in MySQL 3.23.7.

but this number is per second ?? or per minutes?? whats the interval ??
0
 
johanntagleCommented:
Guess those are totals since the counters were reset.  Suggest you take a peek at the code of cacti to check what commands it actually sends to MySQL.
0
 
Kevin CrossChief Technology OfficerCommented:
I agree. My understanding was always that this number was reset every time your restarted MySQL server. The received is 0.15gb and the sent 1.1gb, which would make sense on a system doing more SELECT queries than INSERT or UPDATE. Remember this is for all clients. You get for SESSION if you want to just see current client.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.