-
pandorafms and mysql queries
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.
-
1 Reply
-
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:
Regards.
