what is Bytes_received and Bytes_sent in mysql server

i refer to this one
http://dev.mysql.com/doc/refman/5.1/en/show-status.html

#

Bytes_received

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

Bytes_sent

The number of bytes sent to all clients. This variable was added in MySQL 3.23.7.

but i am few confusion ..



(a) Bytes Received : i guess its anything insert into database or any query recieved from php or any other application

(b) bytes Sent : i guess its sending the data to the client back ..


Now if i look at bellow result :

mysql>  SHOW STATUS LIKE 'Bytes_sent';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Bytes_sent    | 181   |
+---------------+-------+
1 row in set (0.17 sec)

mysql>  SHOW STATUS LIKE 'Bytes_sent';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Bytes_sent    | 323   |
+---------------+-------+
1 row in set (0.17 sec)

mysql>  SHOW STATUS LIKE 'Bytes_sent';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Bytes_sent    | 465   |
+---------------+-------+
1 row in set (0.18 sec)

mysql>  SHOW STATUS LIKE 'Bytes_sent';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Bytes_sent    | 607   |
+---------------+-------+
1 row in set (0.17 sec)

this is one of our master server

every time i type the command its starts with 181 then every time I typed, its go high and high ..

>>>why its starts from 181 always ??

now if look at cacti graph
it sayg

Byte Sent : Avg 741.8 K
Byte Received : avt 40 K

Byte Sent : Current 868K
Byte Sent : Current 40 K



->> From where this values are comming ???


I have another Mysql SErver

where Byte sent : 2.5M
and Byte Receive : 103K

but Mysql Status for Bytes Received and Bytes_sent does not refject that value ..

hence i am confused.

LVL 29
fosiul01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
Note that following each of your requests for show status, the increment is 128.
Everytime you establish a new connection these counter seem to start from the same point/value.

The bytes_received/bytes_sent you query seem to be session based data.
i.e. you connect and the response to your connection request is 181bytes that mysql sent.
Is cacti reflecting the amount of data sent/received based on network polling or do you poll mysql itself using mysql app pluggin for cacti.

I get the same behavior on 5.0.
phpmyadmin reports cumulative data for bytes received/sent.
0
fosiul01Author Commented:
Is cacti reflecting the amount of data sent/received based on network polling    :

its cacti doing .

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

and cacti sh owing

bytes Sent : 2Mb
received : 98.9K

but dont understand, how cacti is getting this valu e
0
arnoldCommented:
I have not been able to thus far extract the data from which cacti pulls this data.
show status reflects the per session data.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

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.