How do I measure the performance of my database?<\/p>\n

Since Pandora FMS 7.0NG 707 is distributed with the OpenSource server a utility to measure the performance of your MySQL server.<\/p>\n

With this utility you can analyze:<\/p>\n

 <\/p>\n

Database performance:<\/p>\n

\n
• CPU ops \/ ms: CPU operations per ms<\/li>\n
• DB INSERT \/ s: Data insertion capacity (queries per second)<\/li>\n
• DB UPDATE \/ s: Data update capacity (queries per second)<\/li>\n
• DB SELECT \/ s: Data selection capacity (queries per second)<\/li>\n
• DB DELETE \/ s: Data deletion capacity (queries per second)<\/li>\n<\/ul>\n

   <\/p>\n

  Analysis of the main tables of Pandora FMS:<\/p>\n

  \n
  • Agent table<\/li>\n
  • Module table<\/li>\n
  • Data table<\/li>\n
  • String data table<\/li>\n
  • Event table<\/li>\n
  • Access stats<\/li>\n
  • Audit information<\/li>\n<\/ul>\n

     <\/p>\n

    Analysis of the capacity of your Pandora FMS installation:<\/p>\n

    \n
    • Agents per second: Number of XML files that Pandora FMS is capable of processing.<\/li>\n
    • Modules per second: Number of modules that the MySQL database is capable of processing.<\/li>\n
    • Max agents: Maximum capacity of agents that your server should be able to monitor.<\/li>\n
    • Max modules: Maximum number of monitors you can display (to be distributed among all your agents)<\/li>\n<\/ul>\n

       <\/p>\n

      To execute it start:<\/p>\n

      perl \/usr\/share\/pandora_server\/util\/pandora_perf_report \/etc\/pandora\/pandora_server.conf<\/p>\n

      Download it: \/library\/files_repository\/pandora_perf_report.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

      How do I measure the performance of my database? Since Pandora FMS 7.0NG 707 is distributed with the OpenSource server a utility to measure the performance of your MySQL server. With this utility you can analyze:   Database performance: CPU ops \/ ms: CPU operations per ms DB INSERT \/ s: Data insertion capacity (queries […]<\/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":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/2097"}],"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=2097"}],"version-history":[{"count":0,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/2097\/revisions"}],"wp:attachment":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/media?parent=2097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/categories?post=2097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/tags?post=2097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}