{"id":3160,"date":"2017-12-27T12:25:14","date_gmt":"2017-12-27T11:25:14","guid":{"rendered":"https:\/\/pandorafms.com\/library\/?p=3160"},"modified":"2024-03-05T12:06:01","modified_gmt":"2024-03-05T11:06:01","slug":"mysql-monitoring","status":"publish","type":"post","link":"https:\/\/pandorafms.com\/library\/mysql-monitoring\/","title":{"rendered":"MySQL monitoring                                                   <img src=\"https:\/\/pandorafms.com\/library\/wp-content\/uploads\/2017\/12\/icono-modulo-enterprise.png\" alt=\"enterprise\" \/>"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<div class=\"maint-error\">\n  <img decoding=\"async\" src=\"http:\/\/pandorafms.com\/library\/wp-content\/uploads\/2024\/02\/Plugin-out-of-maintenance-alt.png\"><\/p>\n<p><strong>Important Notice:<\/strong> This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support.<\/p>\n<\/div>\n<p><\/p>\n<p>This plugin monitors a MySQL server, reporting following modules:<br \/>\n<br \/>\n<b>Database engine monitoring:<\/b><\/p>\n<ul>\n<li>mysql connection<\/li>\n<li>restart detection<\/li>\n<li>queries<\/li>\n<li>query rate<\/li>\n<li>query select<\/li>\n<li>query update<\/li>\n<li>query delete<\/li>\n<li>query insert<\/li>\n<li>current connections<\/li>\n<li>connections ratio<\/li>\n<li>aborted connections<\/li>\n<li>Innodb buffer pool pages total<\/li>\n<li>Innodb buffer pool read requests<\/li>\n<li>Innodb buffer pool write requests<\/li>\n<li>Innodb disk reads<\/li>\n<li>Innodb disk writes<\/li>\n<li>Innodb disk data read<\/li>\n<li>Innodb disk data written<\/li>\n<li>query cache enabled<\/li>\n<li>query hit ratio<\/li>\n<\/ul>\n<p>\n<b>Specific database monitoring:<\/b><\/p>\n<ul>\n<li>mysql [dbname] connection<\/li>\n<li>mysql [dbname] average fragmentation<\/li>\n<li>custom queries<\/li>\n<\/ul>\n<p>In addition you can launch your own queries with this plugin to monitor internal data of your application.<\/p>\n<h2>Files<\/h2>\n<br\/><p class=\"no-enterprise\">Only enterprise users can view the download links.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Important Notice: This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support. This plugin monitors a MySQL server, reporting following modules: Database engine monitoring: mysql connection restart detection queries query rate query select query update query delete query [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"<div class=\"maint-error\">\r\n  <img src=\"http:\/\/pandorafms.com\/library\/wp-content\/uploads\/2024\/02\/Plugin-out-of-maintenance-alt.png\">\r\n  <p><strong>Important Notice:<\/strong> This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support.<p>\r\n<\/div>\r\n\r\n<br>\r\n\r\nThis plugin monitors a MySQL server, reporting following modules:\r\n<br>\r\n<b>Database engine monitoring:<\/b><ul>\r\n \t<li>mysql connection<\/li>\r\n \t<li>restart detection<\/li>\r\n \t<li>queries<\/li>\r\n \t<li>query rate<\/li>\r\n \t<li>query select<\/li>\r\n \t<li>query update<\/li>\r\n \t<li>query delete<\/li>\r\n \t<li>query insert<\/li>\r\n \t<li>current connections<\/li>\r\n \t<li>connections ratio<\/li>\r\n \t<li>aborted connections<\/li>\r\n \t<li>Innodb buffer pool pages total<\/li>\r\n \t<li>Innodb buffer pool read requests<\/li>\r\n \t<li>Innodb buffer pool write requests<\/li>\r\n \t<li>Innodb disk reads<\/li>\r\n \t<li>Innodb disk writes<\/li>\r\n \t<li>Innodb disk data read<\/li>\r\n \t<li>Innodb disk data written<\/li>\r\n \t<li>query cache enabled<\/li>\r\n \t<li>query hit ratio<\/li>\r\n<\/ul>\r\n<br>\r\n<b>Specific database monitoring:<\/b><ul>\r\n \t<li>mysql [dbname] connection<\/li>\r\n \t<li>mysql [dbname] average fragmentation<\/li>\r\n \t<li>custom queries<\/li>\r\n<\/ul>\r\nIn addition you can launch your own queries with this plugin to monitor internal data of your application.\r\n<h2>Files<\/h2>\r\n[enterprise]\r\n\r\n<a href=\"https:\/\/pandorafms.com\/library\/wp-content\/uploads\/2019\/01\/ES-MySQL-plugin.pdf\">Spanish documentation<\/a>\r\n\r\n<a href=\"https:\/\/pandorafms.com\/library\/wp-content\/uploads\/2019\/01\/EN-MySQL-plugin.pdf\">English documentation<\/a>\r\n\r\n<a href=\"https:\/\/pandorafms.com\/library\/wp-content\/uploads\/2019\/01\/pandora_mysql.tar.gz\">MySQL plugin (Linux)<\/a>\r\n\r\n<a href=\"https:\/\/pandorafms.com\/library\/wp-content\/uploads\/2019\/01\/pandora_mysql_windows.zip\">MySQL plugin (windows)<\/a>\r\n\r\n\r\n[\/enterprise]","_et_gb_content_width":"","footnotes":""},"categories":[5,15,45],"tags":[],"_links":{"self":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/3160"}],"collection":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/comments?post=3160"}],"version-history":[{"count":2,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/3160\/revisions"}],"predecessor-version":[{"id":8391,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/3160\/revisions\/8391"}],"wp:attachment":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/media?parent=3160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/categories?post=3160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/tags?post=3160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}