Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pandorafms and mysql queries
#1

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.
 Reply
#2
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.
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes