ifstat and hobbitclient-sunos.sh
Hi,
The command "/usr/bin/kstat -p -s '[or]bytes64' | sort" for ifstat in hobbitclient-sunos.sh collects statistics for wrsmd (WCI Remote Shared Memory (WRSM) DLPI driver), which is wrong.
Example on a Solaris 9 client:
[bb at eliot bin]$ /usr/bin/kstat -p -s '[or]bytes64' | sort eri:0:eri0:obytes64 363076089018 eri:0:eri0:rbytes64 15860668051 ge:0:ge0:obytes64 0 ge:0:ge0:rbytes64 0 wrsmd:0:wrsmd0:obytes64 0 wrsmd:0:wrsmd0:rbytes64 0 wrsmd:10:wrsmd10:obytes64 0 wrsmd:10:wrsmd10:rbytes64 0 wrsmd:11:wrsmd11:obytes64 0 wrsmd:11:wrsmd11:rbytes64 0 wrsmd:12:wrsmd12:obytes64 0 wrsmd:12:wrsmd12:rbytes64 0 wrsmd:13:wrsmd13:obytes64 0 wrsmd:13:wrsmd13:rbytes64 0 wrsmd:14:wrsmd14:obytes64 0 wrsmd:14:wrsmd14:rbytes64 0 wrsmd:15:wrsmd15:obytes64 0 wrsmd:15:wrsmd15:rbytes64 0 wrsmd:1:wrsmd1:obytes64 0 wrsmd:1:wrsmd1:rbytes64 0 wrsmd:2:wrsmd2:obytes64 0 wrsmd:2:wrsmd2:rbytes64 0 wrsmd:3:wrsmd3:obytes64 0 wrsmd:3:wrsmd3:rbytes64 0 wrsmd:4:wrsmd4:obytes64 0 wrsmd:4:wrsmd4:rbytes64 0 wrsmd:5:wrsmd5:obytes64 0 wrsmd:5:wrsmd5:rbytes64 0 wrsmd:6:wrsmd6:obytes64 0 wrsmd:6:wrsmd6:rbytes64 0 wrsmd:7:wrsmd7:obytes64 0 wrsmd:7:wrsmd7:rbytes64 0 wrsmd:8:wrsmd8:obytes64 0 wrsmd:8:wrsmd8:rbytes64 0 wrsmd:9:wrsmd9:obytes64 0 wrsmd:9:wrsmd9:rbytes64 0
A quick fix is to replace it with "/usr/bin/kstat -p -s '[or]bytes64' | grep -v wrsmd | sort"
Dominique UNIL - University of Lausanne
Hi,
I'm just asking you how do you monitor your MySQL databases ? I've setted up the bb-mysqlstatus.sh and modify it to support NCV format. Now I got graphs for queries/sec and slowqueries. That's cool but it's not very accurate... I'm using MySQL Administrator from http://dev.mysql.com/downloads/gui-tools/5.0.html and results are not the same. Did you write something to track insert, select, etc. from 'mysqladmin extended-status' ? Thanks for your help ! Sincerly,
Thomas
Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite au titre de ce message, s'il a ete altere, deforme ou falsifie.
This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.
On 10/10/06, thomas.seglard.enata at cnp.fr <thomas.seglard.enata at cnp.fr> wrote:
I'm just asking you how do you monitor your MySQL databases ? I've setted
Attached is a script I wrote up one night based off MySQL Activity Report (http://gert.sos.be/en/projects/mysqlar/). Can't guarantee it'll work, but it works for me with 4.1.21.
It does the following:
- max connections vs threads connected
- (Questions / Selects / Inserts / Updates / Deletes) per minute
- Table Cache vs Open Tables
- Created Tmp Tables vs Tmp Disk Tables <-- logic is wrong here I know I need to fix this
It was my 2nd hobbit script, so please let me know where I can improve.
-- Matthew Davis http://familycampground.org/matthew/
Thanks for your script and the link, they are very useful... All are working perfectly. I will check the mysqlar site soon. Best regards,
Thomas
mormonmatthew at gmail.com a écrit sur 10/10/2006 18:43:29 :
On 10/10/06, thomas.seglard.enata at cnp.fr <thomas.seglard.enata at cnp.fr> wrote:
I'm just asking you how do you monitor your MySQL databases ? I've setted
Attached is a script I wrote up one night based off MySQL Activity Report (http://gert.sos.be/en/projects/mysqlar/). Can't guarantee it'll work, but it works for me with 4.1.21.
It does the following:
- max connections vs threads connected
- (Questions / Selects / Inserts / Updates / Deletes) per minute
- Table Cache vs Open Tables
- Created Tmp Tables vs Tmp Disk Tables <-- logic is wrong here I know I need to fix this
It was my 2nd hobbit script, so please let me know where I can improve.
-- Matthew Davis http://familycampground.org/matthew/ [rattachement "mysql-activity.tar.gz" supprimé par Thomas SEGLARD/FI6/ANFI/CNP Assurances] To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite au titre de ce message, s'il a ete altere, deforme ou falsifie.
This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.
I saw this too with some of our clients, so this is what I did for that:
echo "[ifstat]"
LINE=/sbin/ifconfig -a | /bin/egrep RUNNING | /bin/awk -F':' '{printf $1"\n"}' | /bin/sort -u | /bin/awk '{printf $1"|"}'
/usr/bin/kstat -p -s '[or]bytes64' | sort | egrep "${LINE}"
This way it only grabs the interfaces that are running.
---Eric
-----Original Message----- From: Dominique Frise [mailto:Dominique.Frise at unil.ch] Sent: Tuesday, October 10, 2006 09:18 To: hobbit at hswn.dk Subject: [hobbit] ifstat and hobbitclient-sunos.sh
Hi,
The command "/usr/bin/kstat -p -s '[or]bytes64' | sort" for ifstat in hobbitclient-sunos.sh collects statistics for wrsmd (WCI Remote Shared Memory (WRSM) DLPI driver), which is wrong.
Example on a Solaris 9 client:
[bb at eliot bin]$ /usr/bin/kstat -p -s '[or]bytes64' | sort eri:0:eri0:obytes64 363076089018 eri:0:eri0:rbytes64 15860668051 ge:0:ge0:obytes64 0 ge:0:ge0:rbytes64 0 wrsmd:0:wrsmd0:obytes64 0 wrsmd:0:wrsmd0:rbytes64 0 wrsmd:10:wrsmd10:obytes64 0 wrsmd:10:wrsmd10:rbytes64 0 wrsmd:11:wrsmd11:obytes64 0 wrsmd:11:wrsmd11:rbytes64 0 wrsmd:12:wrsmd12:obytes64 0 wrsmd:12:wrsmd12:rbytes64 0 wrsmd:13:wrsmd13:obytes64 0 wrsmd:13:wrsmd13:rbytes64 0 wrsmd:14:wrsmd14:obytes64 0 wrsmd:14:wrsmd14:rbytes64 0 wrsmd:15:wrsmd15:obytes64 0 wrsmd:15:wrsmd15:rbytes64 0 wrsmd:1:wrsmd1:obytes64 0 wrsmd:1:wrsmd1:rbytes64 0 wrsmd:2:wrsmd2:obytes64 0 wrsmd:2:wrsmd2:rbytes64 0 wrsmd:3:wrsmd3:obytes64 0 wrsmd:3:wrsmd3:rbytes64 0 wrsmd:4:wrsmd4:obytes64 0 wrsmd:4:wrsmd4:rbytes64 0 wrsmd:5:wrsmd5:obytes64 0 wrsmd:5:wrsmd5:rbytes64 0 wrsmd:6:wrsmd6:obytes64 0 wrsmd:6:wrsmd6:rbytes64 0 wrsmd:7:wrsmd7:obytes64 0 wrsmd:7:wrsmd7:rbytes64 0 wrsmd:8:wrsmd8:obytes64 0 wrsmd:8:wrsmd8:rbytes64 0 wrsmd:9:wrsmd9:obytes64 0 wrsmd:9:wrsmd9:rbytes64 0
A quick fix is to replace it with "/usr/bin/kstat -p -s '[or]bytes64' | grep -v wrsmd | sort"
Dominique UNIL - University of Lausanne
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
participants (4)
-
Dominique.Frise＠unil.ch
-
etmsys＠rit.edu
-
matthew＠familycampground.org
-
thomas.seglard.enata＠cnp.fr