MySQL Monitoring hash_000006032ff3ecba691bc1f0feab408b58e30a|hash_00000601620dca17ddec9e1b373676806e104d|hash_00000680fbbc3de5c5f6e448067c2e38929b04|hash_000006a2ec74c4fddb4c9a00ebcaf979261bcf|hash_000006490a128a2cbba85e1c2f16082f83f95f|hash_000006f2f7c30971bb208248655010b528833c MySQL Queries on 1 on 120 on 500 on 2 on on 100 0 1000 Requêtes hash_0800061498e32d83fd2ceba383e63b56e599ff FF0000 7 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Requêtes lentes 1 hash_0800061498e32d83fd2ceba383e63b56e599ff 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 2 hash_0800061498e32d83fd2ceba383e63b56e599ff 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 3 hash_0800061498e32d83fd2ceba383e63b56e599ff 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 4 hash_0800061498e32d83fd2ceba383e63b56e599ff 0 9 3 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 5 hash_0800066a6c33de997ed66631c6c5661b7e0fcb 7EE600 8 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Requêtes 6 hash_0800066a6c33de997ed66631c6c5661b7e0fcb 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 7 hash_0800066a6c33de997ed66631c6c5661b7e0fcb 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 8 hash_0800066a6c33de997ed66631c6c5661b7e0fcb 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 9 hash_0800066a6c33de997ed66631c6c5661b7e0fcb 0 9 3 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 10 0 0 1 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Généré |date_time|\\r 11 Data Source [Questions] task_item_id hash_000006a1ba04f357d05a676a22743e9a6ca0e5|hash_000006250d2dcd00cbc19d099ab2d0c4d0dbc2|hash_000006c76863d4d91d60bdf6b94fcd673b34dd|hash_000006a717f5375e81dc84c088d529897b2d82|hash_00000694028f2afc10516e9c5ac4cd4f97621a Data Source [Slow_queries] task_item_id hash_00000667936901b9a3d0c254d11d0ccad0ea0d|hash_000006bcf1bb4d711672aaeda4659c725979f5|hash_0000063690f00f22e381dbee90dd8d19368f9b|hash_0000067d2ef62477853f6e2b61600dcbb43626|hash_000006494711d642c2b0e510f77c268b220d91 MySQL Cache Usage on 1 on 120 on 500 on 2 on on 100 0 1000 Requêtes hash_0800066350f29ce663651bc621eba5bd234f70 7CB3F1 7 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Ajout au cache 1 hash_0800066350f29ce663651bc621eba5bd234f70 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 2 hash_0800066350f29ce663651bc621eba5bd234f70 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 3 hash_0800066350f29ce663651bc621eba5bd234f70 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 4 hash_0800066350f29ce663651bc621eba5bd234f70 0 9 3 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 5 hash_080006fab7b82c069c3f19999acbb046cbf594 F5F800 8 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 En cache 6 hash_080006fab7b82c069c3f19999acbb046cbf594 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 7 hash_080006fab7b82c069c3f19999acbb046cbf594 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 8 hash_080006fab7b82c069c3f19999acbb046cbf594 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 9 hash_080006fab7b82c069c3f19999acbb046cbf594 0 9 3 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 10 hash_0800063ee5c725851b77e0411d4dedea7f3554 FF0000 8 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Non cachées 11 hash_0800063ee5c725851b77e0411d4dedea7f3554 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 12 hash_0800063ee5c725851b77e0411d4dedea7f3554 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 13 hash_0800063ee5c725851b77e0411d4dedea7f3554 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 14 hash_0800063ee5c725851b77e0411d4dedea7f3554 0 9 3 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 15 0 0 1 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Généré |date_time|\\r 16 Data Source [CacheInserts] task_item_id hash_0000066dec504e672163ed64d20bb8e45821e6|hash_000006dc8fc58dffbd336850f38e68dc48d1c7|hash_00000691b23938d3774e31aa7badf4a07cd19d|hash_000006338e32792a63ae5addaa70d389059afb|hash_00000697720095e4ea9928a938791722359915 Data Source [CacheHits] task_item_id hash_000006cb7a2450c040f44ebc29bf84ac9e7334|hash_00000617b026d503677435bf948018fd93e1f5|hash_0000061739d327e720c4bc94fcaa120d42c39c|hash_000006142a3200f03b219f7c6545aac36a5ba4|hash_00000693f51cbd0d91c8a73c251e11700d6d32 Data Source [QueriesNotCached] task_item_id hash_00000655d7463bd22f43f301c6f374996bd045|hash_000006588b8192088e827c1b34d76e211aac0b|hash_0000066535db2bbeff2e8b3a0ac44d323c70af|hash_00000662a9f09f94385a96abfb683a4edd1edb|hash_000006f1d91cebd0b6a116e9200c30fcb94bed MySQL Cache Prune 1 on 120 on 500 on 2 on on 100 0 1000 Requêtes hash_080006541712a3119099ca20c6b8332539e9bb FF5700 7 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Supprimées 1 hash_080006541712a3119099ca20c6b8332539e9bb 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 2 hash_080006541712a3119099ca20c6b8332539e9bb 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 3 hash_080006541712a3119099ca20c6b8332539e9bb 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 4 hash_080006541712a3119099ca20c6b8332539e9bb 0 9 3 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 5 0 0 1 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Généré |date_time|\\r 6 Couleur color_id hash_0000064d22cc57d4fbdcbf5cf8dd971aa460a2 Data Source [CacheLMPrunes] task_item_id hash_0000064d22cc57d4fbdcbf5cf8dd971aa460a2|hash_000006acc1c5dce8fd0e2632669fd665497e5c|hash_000006e0e3e7d9acc3eb3e1ff5bda07a662af8|hash_00000642c32a6a9c61eb25738e16b786cd2903|hash_00000681ae06eb2457bead1488507b610e49cf MySQL Cache Free Memory on 1 on 120 on 500 on 2 on on 100 0 1024 hash_0800065221dd834239e570bf4b9521f1be8a2f 00CF00 7 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Mémoire libre 1 hash_0800065221dd834239e570bf4b9521f1be8a2f 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 2 hash_0800065221dd834239e570bf4b9521f1be8a2f 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 3 hash_0800065221dd834239e570bf4b9521f1be8a2f 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 4 hash_0800065221dd834239e570bf4b9521f1be8a2f 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 5 0 0 1 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Généré |date_time|\\r 6 Couleur color_id hash_0000061a66b7bbee2ab55e7b151f905ce66025 Data Source [CacheFreeMemory] task_item_id hash_0000061a66b7bbee2ab55e7b151f905ce66025|hash_0000062987dd71ba4a0e1f8e65be9654a02fc5|hash_0000060eb6c3d95f0e18b0df5461b8b3cd271b|hash_0000064f9623d2b8222d7d575330b8d11d45ea|hash_00000626a7a772f08b578bfe19445fa09debb4 MySQL Cache Blocks 1 on 120 on 500 on 2 on on 100 0 1000 Blocks hash_080006c77d1e77eb70b1f51234e6951e264ea6 96E78A 7 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Blocs libres 1 hash_080006c77d1e77eb70b1f51234e6951e264ea6 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 2 hash_080006c77d1e77eb70b1f51234e6951e264ea6 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 3 hash_080006c77d1e77eb70b1f51234e6951e264ea6 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 4 hash_080006c77d1e77eb70b1f51234e6951e264ea6 0 9 3 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 5 hash_08000663476f498dd3b6c98193b7eaefbdd5ca FF5700 8 1 hash_050006c8eb3c86ba4b8bd1db1c88ac94d279a4 hash_060006e9c43831e54eca8069317a2ce8c6f751 Blocs utilisés 6 hash_08000663476f498dd3b6c98193b7eaefbdd5ca 0 9 4 hash_050006c8eb3c86ba4b8bd1db1c88ac94d279a4 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 7 hash_08000663476f498dd3b6c98193b7eaefbdd5ca 0 9 1 hash_050006c8eb3c86ba4b8bd1db1c88ac94d279a4 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 8 hash_08000663476f498dd3b6c98193b7eaefbdd5ca 0 9 2 hash_050006c8eb3c86ba4b8bd1db1c88ac94d279a4 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 9 hash_08000663476f498dd3b6c98193b7eaefbdd5ca 0 9 3 hash_050006c8eb3c86ba4b8bd1db1c88ac94d279a4 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 10 0 0 1 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Généré |date_time|\\r 11 Data Source [CacheFreeBlocks] task_item_id hash_00000672ca981d965972bb9665adc1faafef63|hash_000006b139889dcedd45c62c28ca44e69ee12f|hash_00000674f66e0b5c1fd744a869296ec3233c45|hash_000006fbaa8b02c91cabebfe944e6deac15219|hash_00000665a157264194d5e09ca3600446fba31c Data Source [CacheTotalBlocks] task_item_id hash_0000064ed4900457a03479753d5bafcf6e2b67|hash_000006b489d21603d51a4fd7c26298a99747f7|hash_000006778e1948864b78f975d316bca6aec957|hash_000006e5e2db9f32370efd6c2eb82c9064c112|hash_0000066fb336f0167ff9c609d684156fa36421 MySQL Cached Queries on 1 on 120 on 500 on 2 on on 100 0 1000 Queries hash_0800061893f84f008830caaaa21f99876bb16f 7CB3F1 7 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Cached queries 1 hash_0800061893f84f008830caaaa21f99876bb16f 0 9 4 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Actuel 2 hash_0800061893f84f008830caaaa21f99876bb16f 0 9 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Moyenne 3 hash_0800061893f84f008830caaaa21f99876bb16f 0 9 2 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Min 4 hash_0800061893f84f008830caaaa21f99876bb16f 0 9 3 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Max on 5 0 0 1 1 0 hash_060006e9c43831e54eca8069317a2ce8c6f751 Généré |date-time|\\r 6 Data Source [QueriesInCache] task_item_id hash_0000062c2fff4c47cb65282989ce8487923dd7|hash_000006548ad6ef97e5eaf6adf643e820894106|hash_000006a9eede8154636737e57599e15e625977|hash_000006a381ec1a65fe909143d2866552ce4fef|hash_000006ac7bec2aa7374bf044b00dbade534c08 Couleur color_id hash_0000062c2fff4c47cb65282989ce8487923dd7 MySql Monitoring on |host_description| - MySQL Monitoring hash_0300062e70e75d6cefca7efccdcec6d9b72c52 300 on hash_150006c21df5178e5c955013591239eb0afd46|hash_1500060d9c0af8b8acdc7807943937b3208e29|hash_1500066fc2d038fb42950138b0ce3e9874cc60|hash_150006e36f3adb9f152adfa5dc50fd2b23337e QueriesInCache 0 0 1 600 hash_070006bc867a5fd62a441c7e0fbfff802ce9a2 CacheInserts 0 0 2 600 hash_0700061df26b1e31a36793503f0f3239024a91 Slow_queries 0 0 2 600 hash_070006596334f57a87656089995aa24799c7f7 Questions 0 0 2 600 hash_0700061ce340d401003f275d139131f375d0e2 CacheHits 0 0 2 600 hash_070006bd292f41788d775cf6138faf32aab6f7 CacheLMPrunes 0 0 2 600 hash_07000620974e22380f7135b138a8097f8302eb QueriesNotCached 0 0 2 600 hash_070006876228169355c7e12dda975a72b3a1d0 CacheFreeMemory 0 0 1 600 hash_070006434d9333fcbb69629f08bdfb5e38b203 CacheFreeBlocks 0 0 1 600 hash_07000650e077c532af4fb09948cc43ab66639c CacheTotalBlocks 0 0 1 600 hash_070006e363cde5acdbff87386e48a886cebbf7 MySQL Monitoring 1 php <path_cacti>/scripts/mysql_monitoring.php Requêtes on out Questions Requêtes lentes on out Slow_queries Requêtes en cache on out Qcache_queries_in_cache Ajout au cache on out Qcache_inserts Requête depuis le cache on out Qcache_hits Suppression du cache on out Qcache_lowmem_prunes Requête non cachées on out Qcache_not_cached Mémoire libre en cache on out Qcache_free_memory Blocs libres en cache on out Qcache_free_blocks Nombre total de blocs en 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 Normal %8.2lf %s MySQL Used Blocks 1 6 b,a,-