MySQL Local Statistics - Commands 1 120 500 on on 2 0 on on 100 0 1000 cmds/second hash_080015dc5f1174af007c2b54ae6c8e01526578 002A97 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 INSERT 1 hash_080015dc5f1174af007c2b54ae6c8e01526578 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_080015dc5f1174af007c2b54ae6c8e01526578 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_080015dc5f1174af007c2b54ae6c8e01526578 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_08001555f9e543f6b6b60eeb94a4832aa437a5 F51D30 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 DELETE 5 hash_08001555f9e543f6b6b60eeb94a4832aa437a5 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_08001555f9e543f6b6b60eeb94a4832aa437a5 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_08001555f9e543f6b6b60eeb94a4832aa437a5 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 hash_0800153beae3c60a74d164bf9aa97b091feacf 00CF00 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 SELECT 9 hash_0800153beae3c60a74d164bf9aa97b091feacf 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 10 hash_0800153beae3c60a74d164bf9aa97b091feacf 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 11 hash_0800153beae3c60a74d164bf9aa97b091feacf 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 12 hash_080015a30a1285101a5c6a0c278306509d93da 7CB3F1 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 UPDATE 13 hash_080015a30a1285101a5c6a0c278306509d93da 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 14 hash_080015a30a1285101a5c6a0c278306509d93da 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 15 hash_080015a30a1285101a5c6a0c278306509d93da 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 16 hash_08001528d14364afda52c9eba55043c10fb6f4 750F7D FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 REPLACE 17 hash_08001528d14364afda52c9eba55043c10fb6f4 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 18 hash_08001528d14364afda52c9eba55043c10fb6f4 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 19 hash_08001528d14364afda52c9eba55043c10fb6f4 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 20 Data Source [com_select] task_item_id hash_00001519a6849efe699e0e4f3024b1a665b3e6|hash_0000155d23a85ad938a2db29eb4bba437bee9f|hash_000015e73ac013e54766a838a3aa0febd22c3f|hash_0000154f45d1a3f8410e17c7fe04eb7c4ecc3f Data Source [com_inserts] task_item_id hash_000015e3ace2ed4ef754ab927ca1462342ab94|hash_000015c9cfb3734b475873726e81c90148fd78|hash_000015292f031368d9381f5d2fc52fff7e9e45|hash_00001556e63a3d76213c2da6a6283a4dadf607 Data Source [com_delete] task_item_id hash_000015b1b431bb54f341292e50d38403daffce|hash_000015f041b0b6bd62ba70f959c60d9d31f0bf|hash_00001533d390608e6ea49022c277435f4a00b2|hash_0000159884a50df1b2090dc70af558c2f17183 Data Source [com_update] task_item_id hash_000015bc8d72af914b5e04ea2656cc213e4b86|hash_0000155e01027c4ac3466517b287aa87646529|hash_00001534c53ab72bd2b05124fa5fcd53627716|hash_000015949fecbee949738a9cbd51d332d5f49f Data Source [com_replace] task_item_id hash_0000155d84a75237e067f2809d1a28a5b100ed|hash_000015123d57172bbf66609efb33a626c5d2cc|hash_000015b10e08271b27ef8bc5f510e01b4ffe5f|hash_00001534426e99e6b63ba9d9ab1fdc4756ed81 MySQL Local Statistics - Commands MySQL Local Statistics - Commands hash_030015d507fde160b5d32f7878d684cefeab1b 300 on hash_150015c21df5178e5c955013591239eb0afd46|hash_1500150d9c0af8b8acdc7807943937b3208e29|hash_1500156fc2d038fb42950138b0ce3e9874cc60|hash_150015e36f3adb9f152adfa5dc50fd2b23337e|hash_150015283ea2bf1634d92ce081ec82a634f513 com_delete 0 0 2 600 hash_070015ff5001909d127615b6723e0790981474 com_inserts 0 0 2 600 hash_070015d7314568f417ad41b7c667c7d41c88a5 com_lock_table 0 0 2 600 hash_0700152a15313143bde2771c4ef85ab632fc4f com_replace 0 0 2 600 hash_07001504771cb501a57f4064c9944afb12b943 com_select 0 0 2 600 hash_0700152735dd0ac44e6a1d167a763ea03b04f7 com_unlock_table 0 0 2 600 hash_0700152d40a5c9a26a58cddeaaad46f17fb6ce com_update 0 0 2 600 hash_070015b6f9713d6e938ba0968546a4638f3cb0 MySQL Local Statistics - Commands 5 <path_cacti>/scripts/ss_mysql_local.php ss_mysql_commands DELETEs on out Com_delete INSERTs on out Com_insert LOCK TABLEs on out Com_lock_tables REPLACEs on out Com_replace SELECTs on out Com_select UNLOCK TABLEs on out Com_unlock_tables UPDATEs on out Com_update Daily (5 Minute Average) 0.5 1 600 86400 1|3 Weekly (30 Minute Average) 0.5 6 700 604800 1|3 Monthly (2 Hour Average) 0.5 24 775 2678400 1|3 Yearly (1 Day Average) 0.5 288 797 33053184 1|3 Hourly (1 Minute Average) 0.5 1 500 14400 1|3 Normal %8.2lf %s MySQL Local Statistics - Open Items 1 120 500 on on 2 0 on on 100 0 1000 Items hash_0800155c0504f5c0805c7ee9e74184bc9f7af7 002A97 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Open Files 1 hash_0800155c0504f5c0805c7ee9e74184bc9f7af7 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_0800155c0504f5c0805c7ee9e74184bc9f7af7 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_0800155c0504f5c0805c7ee9e74184bc9f7af7 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_080015e11c425d1467b392cef9809fc2b6afb0 F51D30 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Open Tables 5 hash_080015e11c425d1467b392cef9809fc2b6afb0 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_080015e11c425d1467b392cef9809fc2b6afb0 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_080015e11c425d1467b392cef9809fc2b6afb0 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 hash_0800154826c61c42098f12b5b726fc2b5161f7 00CF00 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Opened Tables (tbls/sec) 9 hash_0800154826c61c42098f12b5b726fc2b5161f7 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 10 hash_0800154826c61c42098f12b5b726fc2b5161f7 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 11 hash_0800154826c61c42098f12b5b726fc2b5161f7 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 12 Data Source [open_files] task_item_id hash_0000152dce361a7b2f4d0305d5bbea9a3d3d22|hash_00001523cb14fb8dd70d3cc2ce9bbd19e38bff|hash_00001505ebcbc9105cf5bd4e3a47b88e87e0cd|hash_000015d04c472d3505467f0a3fd4ecb6da7c91 Data Source [open_tables] task_item_id hash_000015a87628d350374fe865c7456e68877811|hash_000015ffe02fdf9a520a68d9015d2b37d14b67|hash_0000154f0a1cd0455729a31004c1501e0091e9|hash_000015c62b7a7ba9cc5958bc4adccc0d1436f5 Data Source [opened_tables] task_item_id hash_0000152ff7c638f12475dcd38caf843f3815af|hash_00001502717dd302c0b9d071e1afcb8e9e9c34|hash_000015e9dd8223168788d1eeb21035024fce39|hash_0000152c29d714af3b6920fda51e8ecdb9e253 MySQL Local Statistics - Open Items MySQL Local Statistics - Open Items hash_0300152fc98ec13eac71253a0685dff8d731c3 300 on hash_150015c21df5178e5c955013591239eb0afd46|hash_1500150d9c0af8b8acdc7807943937b3208e29|hash_1500156fc2d038fb42950138b0ce3e9874cc60|hash_150015e36f3adb9f152adfa5dc50fd2b23337e|hash_150015283ea2bf1634d92ce081ec82a634f513 open_streams 0 0 1 600 hash_070015d5b18cfcdb7bbec3625b337d0edabe14 opened_tables 0 0 2 600 hash_0700151292e1ed894d935a0d1b3c9ba580d076 open_tables 0 0 1 600 hash_070015c83275d9b517c30f61b52e709dc81372 open_files 0 0 1 600 hash_07001514bc9e5ef9aca0e1558a6eb6cb81eee2 MySQL Local Statistics - Open Objects 5 <path_cacti>/scripts/ss_mysql_local.php ss_mysql_open Number of currently open files on out Open_files Number of currently open streams on out Open_streams Number of currently open tables on out Open_tables Total number of times a table has been opened on out Opened_tables Daily (5 Minute Average) 0.5 1 600 86400 1|3 Weekly (30 Minute Average) 0.5 6 700 604800 1|3 Monthly (2 Hour Average) 0.5 24 775 2678400 1|3 Yearly (1 Day Average) 0.5 288 797 33053184 1|3 Hourly (1 Minute Average) 0.5 1 500 14400 1|3 Normal %8.2lf %s MySQL Local Statistics - Queries 1 120 500 on on 2 0 on on 100 0 1000 Queries per second hash_0800152e20198b98f6613445330c671db87b68 002A97 FF 7 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Queries 1 hash_0800152e20198b98f6613445330c671db87b68 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_0800152e20198b98f6613445330c671db87b68 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_0800152e20198b98f6613445330c671db87b68 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_080015eaec7ac9d2ef561c899f79b7d7fbf101 F51D30 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Slow Queries 5 hash_0800158424b3ceca0a6696f701176ade3a6c00 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_080015999a4c78a603e8c604f91b961d79721d 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_08001577e34e0dbf518102bf28f28571d9c2c9 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 Data Source [queries] task_item_id hash_0000154b0c5304575067a22063435efc5777f7|hash_000015ce383ff92c1dd5e3f138a082d83b11ee|hash_000015b9c8b85b12a5b89d0dfbf470e2765610|hash_00001534613b35f26ddb8a9645ebf2a47acc5d Data Source [slow_queries] task_item_id hash_000015c02177f18710ec69379d21d9180c74ab|hash_000015ef7dd67d5cb83c846ecb56478d0d036b|hash_000015fcdd544882db7fe1730475f42c758915|hash_000015db5c283fc009742849583ef76b1d6cc8 MySQL Local Statistics - Queries MySQL Local Statistics - Queries hash_030015f3db96f92b7c398e9cf5b4edb1f0a939 300 on hash_150015c21df5178e5c955013591239eb0afd46|hash_1500150d9c0af8b8acdc7807943937b3208e29|hash_1500156fc2d038fb42950138b0ce3e9874cc60|hash_150015e36f3adb9f152adfa5dc50fd2b23337e|hash_150015283ea2bf1634d92ce081ec82a634f513 slow_queries 0 0 2 600 hash_070015ca60ce940fad0acea6be7c6f334d4a98 queries 0 0 2 600 hash_070015b270e92a1ec43c3b2094886b40c3e18b queries_per_second 0 0 1 600 hash_0700150f4acb7284fbcaf8940cf72bc28633fb MySQL Local Statistics - Queries 5 <path_cacti>/scripts/ss_mysql_local.php ss_mysql_queries Total number of queries the server has received on out Questions The average number of QPS since the server was started on out Queries_per_second Number of slow queries since the server was started on out Slow_queries Daily (5 Minute Average) 0.5 1 600 86400 1|3 Weekly (30 Minute Average) 0.5 6 700 604800 1|3 Monthly (2 Hour Average) 0.5 24 775 2678400 1|3 Yearly (1 Day Average) 0.5 288 797 33053184 1|3 Hourly (1 Minute Average) 0.5 1 500 14400 1|3 Normal %8.2lf %s MySQL Local Statistics - Query Cache 1 120 500 on on 2 0 on on 100 0 1000 Queries per second hash_080015ffc1342cb81bea63bf9b84ed88882a3c 002A97 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Inserts 1 hash_080015ffc1342cb81bea63bf9b84ed88882a3c 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_080015ffc1342cb81bea63bf9b84ed88882a3c 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_080015ffc1342cb81bea63bf9b84ed88882a3c 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_080015a71ad19dbc58f3af7422e86e0962d8c0 F51D30 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Low Mem Prunes 5 hash_080015a71ad19dbc58f3af7422e86e0962d8c0 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_080015a71ad19dbc58f3af7422e86e0962d8c0 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_080015a71ad19dbc58f3af7422e86e0962d8c0 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 hash_08001516fc6caabf85afe55996525d5f2b53a9 00CF00 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Not Cached 9 hash_08001516fc6caabf85afe55996525d5f2b53a9 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 10 hash_08001516fc6caabf85afe55996525d5f2b53a9 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 11 hash_08001516fc6caabf85afe55996525d5f2b53a9 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 12 Data Source [qcache_not_cached] task_item_id hash_0000150c3b197ce5a1a0aa0c3578b92a4b5b32|hash_000015743bdede4996fcd0772356a6a8235076|hash_000015394a1a4097a329ae481ebacd6944dfcc|hash_0000156c7087aa0c5f0736f1d234f16e8d357b Data Source [qcache_prunes] task_item_id hash_00001524a7008629afc942efb5a285bf1349fc|hash_0000152cb615f56898d981f850ae92dd9c4e09|hash_000015e995cc06ccf3d7b5dfc7548b9a594a2f|hash_00001542f44614e0773ddb4d917d8b5c2d4bce Data Source [qcache_inserts] task_item_id hash_00001565544c6f3e6df292688c3b20a43bc6c3|hash_0000153b872b7b3b138ac007b1d0ad124a37ee|hash_0000153fc74246a83a9cb2ac21dc61d2d09e42|hash_000015f3a7382ac0ee4ccba36e248a85c97c55 MySQL Local Statistics - Query Cache MySQL Local Statistics - Query Cache hash_030015eece6a8c92394e390edd6c0b748ea262 300 on hash_150015c21df5178e5c955013591239eb0afd46|hash_1500150d9c0af8b8acdc7807943937b3208e29|hash_1500156fc2d038fb42950138b0ce3e9874cc60|hash_150015e36f3adb9f152adfa5dc50fd2b23337e|hash_150015283ea2bf1634d92ce081ec82a634f513 qcache_hits 0 0 2 600 hash_0700151e4071dedf4002cd04cd394659394fce qcache_free_mem 0 0 1 600 hash_070015d6802c9e36d86f21c9333780906c5a57 qcache_free_blocks 0 0 1 600 0 qcache_inserts 0 0 2 600 hash_0700156b8bc078431926fa7a61afbc7c4c386e qcache_prunes 0 0 2 600 hash_0700152beb80bc6763117c62f3845b93cc6b6e qcache_not_cached 0 0 2 600 hash_07001505091072366ce24a3e145729a90da5ff qcache_qcount 0 0 1 600 hash_070015f59834577965f1c86de88be2a26bd10c qcache_total_blocks 0 0 1 600 hash_07001511a7db8f97f9fe8bbe7e418a9652cced qcache_hit_rate 0 0 1 600 hash_070015e9e3b7d90cd6b153755e1dcfcd3c8b22 MySQL Local Statistics - Query Cache 5 <path_cacti>/scripts/ss_mysql_local.php ss_mysql_qcache Hit rate (percentage) since the server was started on out Qcache_hit_rate Number of free memory blocks in the cache on out Qcache_free_blocks Amount of free memory in the cache on out Qcache_free_memory Cache hits on out Qcache_hits Number of queries added to the cache on out Qcache_inserts Cache prunes due to low cache memory on out Qcache_lowmem_prunes Number of queries that were not cached on out Qcache_not_cached Number of queries in the cache on out Qcache_queries_in_cache Number of blocks in the cache on out Qcache_total_blocks Daily (5 Minute Average) 0.5 1 600 86400 1|3 Weekly (30 Minute Average) 0.5 6 700 604800 1|3 Monthly (2 Hour Average) 0.5 24 775 2678400 1|3 Yearly (1 Day Average) 0.5 288 797 33053184 1|3 Hourly (1 Minute Average) 0.5 1 500 14400 1|3 Normal %8.2lf %s MySQL Local Statistics - Threads 1 120 500 on on 2 0 on on 100 0 1000 hash_0800159b472b29f0370f78939052b68066998f 002A97 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Created 1 hash_0800159b472b29f0370f78939052b68066998f 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_0800159b472b29f0370f78939052b68066998f 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_0800159b472b29f0370f78939052b68066998f 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_080015165cb081b99c472aad836fccf56cda74 00CF00 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Running 5 hash_080015165cb081b99c472aad836fccf56cda74 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_080015165cb081b99c472aad836fccf56cda74 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_080015165cb081b99c472aad836fccf56cda74 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 hash_0800159f72e1014d33786e32ada70ad6398237 00A0C1 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Cached 9 hash_0800159f72e1014d33786e32ada70ad6398237 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 10 hash_0800159f72e1014d33786e32ada70ad6398237 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 11 hash_0800159f72e1014d33786e32ada70ad6398237 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 12 hash_080015f65389dc5a7cd7acc860bf580ff1daab F51D30 FF 4 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Miss rate (%) 13 hash_080015f65389dc5a7cd7acc860bf580ff1daab 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 14 hash_080015f65389dc5a7cd7acc860bf580ff1daab 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 15 hash_080015f65389dc5a7cd7acc860bf580ff1daab 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 16 Data Source [threads_created] task_item_id hash_0000159e510c319ee0d80edbc592749fee1779|hash_000015846c4167f633f340b8e5d1bf35622132|hash_0000158a7cdf87a3508e257163134d55474046|hash_000015de95f403b5c41d391c1d48cee4f85843 Data Source [threads_running] task_item_id hash_0000155a12acd3d19a22f404c1d72e52466248|hash_000015884f49e0f844ba8c82692ab4181518cb|hash_000015bc7b2709c292ef32bfd321c6021e0113|hash_000015689a9a3f7e3d0362b7c4bea1394ae3e7 Data Source [threads_cached] task_item_id hash_00001567c89dc9bde2b626ec5e01715ba2b9f3|hash_00001537178fa43d4e2a9e1bb277e43f202028|hash_000015dc4a0af9650745786eb1ec35b71eaf43|hash_00001504cbff7a3611af9dea5e5114d7560b53 Data Source [threads_miss_rate] task_item_id hash_0000157c33d2546846fb3d7ab9fecd7aafe912|hash_000015f39777daee4af262bae16dff01571e48|hash_00001528808994026f85fcaa2d9710298e67fc|hash_000015758e00b6310097fe51ad9dceeb54c86e MySQL Local Statistics - Threads MySQL Local Statistics - Threads hash_030015018fccf7634169770b1ae1a01f49c468 300 on hash_150015c21df5178e5c955013591239eb0afd46|hash_1500150d9c0af8b8acdc7807943937b3208e29|hash_1500156fc2d038fb42950138b0ce3e9874cc60|hash_150015e36f3adb9f152adfa5dc50fd2b23337e|hash_150015283ea2bf1634d92ce081ec82a634f513 threads_connected 0 0 1 600 hash_07001579db13d2b09d9817e18e3fb36b0baa8a threads_created 0 0 1 600 hash_070015fefbb73141be50300372482b64e609c7 threads_cached 0 0 1 600 hash_070015ac349fc40350804b4db84d4d2c7b9362 threads_miss_rate 0 100 1 600 hash_0700152e6202bcd28c2ed11333aefe9f7bb53c threads_running 0 0 1 600 hash_07001516536fa208acaa138acb582f9c85669e MySQL Local Statistics - Threads 5 <path_cacti>/scripts/ss_mysql_local.php ss_mysql_threads Number of threads sitting in the thread cache on out Threads_cached Number of currently open connections on out Threads_connected Number of threads created to handle connections on out Threads_created Number of threads that are not sleeping on out Threads_running The miss rate of the thread cache (as a percentage) on out Threads_miss_rate Daily (5 Minute Average) 0.5 1 600 86400 1|3 Weekly (30 Minute Average) 0.5 6 700 604800 1|3 Monthly (2 Hour Average) 0.5 24 775 2678400 1|3 Yearly (1 Day Average) 0.5 288 797 33053184 1|3 Hourly (1 Minute Average) 0.5 1 500 14400 1|3 Normal %8.2lf %s MySQL Local Statistics - Traffic 1 120 500 on on 2 0 on on 100 0 1000 Bytes hash_080015a9fe3cfe0ff84351f590a375155b4dd4 001D61 FF 7 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Received 1 hash_080015a9fe3cfe0ff84351f590a375155b4dd4 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_080015a9fe3cfe0ff84351f590a375155b4dd4 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_080015a9fe3cfe0ff84351f590a375155b4dd4 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_08001533619317c59a53bc4f87e7fa516d54a6 00A0C1 FF 7 1 hash_0500153d352eed9fa8f7b2791205b3273708c7 hash_060015e9c43831e54eca8069317a2ce8c6f751 Sent 5 hash_08001533619317c59a53bc4f87e7fa516d54a6 0 FF 9 4 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_08001533619317c59a53bc4f87e7fa516d54a6 0 FF 9 1 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_08001533619317c59a53bc4f87e7fa516d54a6 0 FF 9 3 0 hash_060015e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 Data Source [bytes_recv] task_item_id hash_000015bd208f61c73a00fbbf3d1548ac4375da|hash_000015cee812bfcc885881fe57b364e68bd68f|hash_000015fb7428789450201595b75a3ba4b7d7e9|hash_0000151958b41acfffc5ff830c4bcf1df7af55 Data Source [bytes_sent] task_item_id hash_0000154189114f511a4c64e7f9a2a299e2765d|hash_0000158abbfcaea6b8ef395262377c7989168d|hash_0000155cf12a8b6adc46a0bccf112f95065e3d|hash_000015466ff97555341e4c7f5aab25a68794b1 MySQL Local Statistics - Traffic MySQL Local Statistics - Traffic hash_0300156c441901a053b668de69a46ab3edb4d0 300 on hash_150015c21df5178e5c955013591239eb0afd46|hash_1500150d9c0af8b8acdc7807943937b3208e29|hash_1500156fc2d038fb42950138b0ce3e9874cc60|hash_150015e36f3adb9f152adfa5dc50fd2b23337e|hash_150015283ea2bf1634d92ce081ec82a634f513 bytes_sent 0 0 2 600 hash_07001587ddd18346f4e612d29b46bf94ffc5ce bytes_recv 0 0 2 600 hash_070015ce6c75c75f4a890063936fca9fadd9cf MySQL Local Statistics - Traffic 5 <path_cacti>/scripts/ss_mysql_local.php ss_mysql_traffic Bytes Sent on out Bytes_sent Bytes Received on out Bytes_received Daily (5 Minute Average) 0.5 1 600 86400 1|3 Weekly (30 Minute Average) 0.5 6 700 604800 1|3 Monthly (2 Hour Average) 0.5 24 775 2678400 1|3 Yearly (1 Day Average) 0.5 288 797 33053184 1|3 Hourly (1 Minute Average) 0.5 1 500 14400 1|3 Make Stack Negative 1 4 CURRENT_DATA_SOURCE 2 6 -1 3 2 3 Normal %8.2lf %s