Pandora FMS community forums
pandorafms and mysql queries - Printable Version

+- Pandora FMS community forums (https://pandorafms.com/community-forums)
+-- Forum: Pandora FMS (https://pandorafms.com/community-forums/forum-3.html)
+--- Forum: Advanced troubleshooting and problems (https://pandorafms.com/community-forums/forum-11.html)
+--- Thread: pandorafms and mysql queries (/thread-6862.html)



pandorafms and mysql queries - helplakmal - 12-28-2012


In Pandorafms, operation panel tactical view take too much time to load (about 20 seconds). other pages load quickly without waiting.reason for that is the long sql query which run load that page. when few people working in Pandorafms same time or if we add more agent this loading time (20sec) could be a problem.so i need little help.


Re: pandorafms and mysql queries - luismi - 01-24-2013

I recommend you to migrate MySQL server to Percona Server, that take server resources better than MySQL.

Percona web -> http://www.percona.com/software/percona-server

Other possibility is to optimize MySQL through /etc/my.cnf file. See the following url:

http://www.openideas.info/wiki/index.php?title=Pandora:Documentation_en:Optimization#MySQL_Optimization_for_enterprise_grade_systems

Regards.