sSQLSTATS
|host_description| - aSQLSTATS
1
120
500
on
2
on
on
100
0
1000
hash_080011e7277a83ee3a5885a6eb3491c830e47d
FF897C
5
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
User Connections
1
hash_080011e7277a83ee3a5885a6eb3491c830e47d
0
9
4
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Current:
2
hash_080011e7277a83ee3a5885a6eb3491c830e47d
0
9
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Average:
3
hash_080011e7277a83ee3a5885a6eb3491c830e47d
0
9
3
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Max:
on
4
hash_0800110c3320095bdd8b0600c0a7f0ed24e644
FFAB00
4
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Users Blocked
5
hash_0800110c3320095bdd8b0600c0a7f0ed24e644
0
9
4
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Current:
6
hash_0800110c3320095bdd8b0600c0a7f0ed24e644
0
9
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Average:
7
hash_0800110c3320095bdd8b0600c0a7f0ed24e644
0
9
3
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Max:
on
8
hash_0800119fd629546225950fd5ddb0f8bda72013
7EE600
6
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Total Blocking Locks
9
hash_0800119fd629546225950fd5ddb0f8bda72013
0
9
4
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Current:
10
hash_0800119fd629546225950fd5ddb0f8bda72013
0
9
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Average:
11
hash_0800119fd629546225950fd5ddb0f8bda72013
0
9
3
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Max:
on
12
hash_0800114d602370bc46c57b7f066b7a1a08a7ba
FF00FF
4
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Total Locks
13
hash_0800114d602370bc46c57b7f066b7a1a08a7ba
0
9
4
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Current:
14
hash_0800114d602370bc46c57b7f066b7a1a08a7ba
0
9
1
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Average:
15
hash_0800114d602370bc46c57b7f066b7a1a08a7ba
0
9
3
0
hash_060011e9c43831e54eca8069317a2ce8c6f751
Max:
on
16
User Connections
task_item_id
hash_000011025617614a3df603e17e1a489f46381f|hash_000011b108dbfacd5f4a014ebe8df19c98ba40|hash_000011448dd44de6af827a1d54818dac610865|hash_0000114ed363e69c5c27dffde266573cdf5047
Users Blocked
task_item_id
hash_0000117d2f603928ee975d47910a7722768388|hash_00001142df394000060d40775e8bd9e521d421|hash_000011da0b5bf3e92ae935e3d135f7bd92dec6|hash_0000115a5b5d794c1664e3db0f3499803fe5c4
Total Blocking Locks
task_item_id
hash_0000110d06946b309456b733208a42a44e0084|hash_000011a8541ac3fae1cf909a0425eb3f53f024|hash_000011f5ec52770c0dd40b8aabdbf27168aef5|hash_000011bc2f9200e8d26b7125df4b16314271c0
Total Locks
task_item_id
hash_000011b01c5c3ab61d85d93c86c1d4f2ec1204|hash_000011025f055d3e527c85c6de0cc6e3ef013a|hash_00001166bece2bed3d9af8c4f405c594052f0b|hash_0000118bf7e21d852915a882c6e3972ac2e5a5
aSQLSTATS
|host_description| - aSQLSTATS
hash_030011e19fc274aea79d03a786f5621c3ffc1c
300
on
hash_150011c21df5178e5c955013591239eb0afd46|hash_1500110d9c0af8b8acdc7807943937b3208e29|hash_1500116fc2d038fb42950138b0ce3e9874cc60|hash_150011e36f3adb9f152adfa5dc50fd2b23337e|hash_1500117c2e7d2c249a45b5bef63d03b3c1962f
UserConnections
0
1000
1
600
hash_070011449b6eba096a9f4746d367c826d64cae
TotalBlockingLocks
0
1000
1
600
hash_07001155864919f6760c46f0260c8bee6b2fb7
TotalLocks
0
1000
1
600
hash_0700119ed3d512efd0437d56c4a7bd1a4c1f3e
UsersBlocked
0
1000
1
600
hash_070011b054ffaf0a025671dca5e401caad3aea
hash_0700119ec16be93d1bcc9af4dff4990061ca9a
hash_07001161051c9263a83ebf58ce6895c9e44f5f
GETSQLSTATS
1
perl <path_cacti>/scripts/SQL_STATS.pl <management_ip> <snmp_community> <snmp_username> <snmp_password> <snmp_version>
SNMP IP Address
hostname
in
management_ip
SNMP Community
snmp_community
in
snmp_community
Total Locks
on
out
TotalLocks
User Connections
on
out
UserConnections
Total Blocking Locks
on
out
TotalBlockingLocks
Users Blocked
on
out
UsersBlocked
Daily (5 Minute Average)
0.5
1
25920
7776000
1|2|3|4
Weekly (30 Minute Average)
0.5
6
9000
7776000
1|2|3|4
Monthly (2 Hour Average)
0.5
24
2250
7776000
1|2|3|4
Yearly (1 Day Average)
0.5
288
797
33053184
1|2|3|4
Yearly (2 Hour Average)
0.5
24
9300
33053184
1|3|4
Normal
%8.2lf %s