Pandora FMS community forums

Full Version: pandorafms and mysql queries
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

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.
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...de_systems

Regards.