Hi Jake On 08/16/2012 03:04 AM, Mark Holmes wrote: ... > In my experience slowness in the GUI tends to be database related.
+1 > I seem to recall there is a section in the admin guide that deals with tuning > MySQL for better performance with PF. > Also think about looking at your MySQL host's CPU usage if it's not on the same server. We are in the process of creating a new Web admin all in Perl. We think we can avoid a lot of the performance issues with the current PHP -> CLI bin/pfcmd/ -> database design. If that sounds too vague and far away, then profiling your environment would be a more immediate option. Start by enabling the slow queries log in your MySQL and sending here (or directly to me) the slower ones. Look at the row count for the tables touched by these. Try also running an EXPLAIN on them and see if they always use indexes. I can interpret that output if you want. This non-free tool does a good job to look into MySQL performance: http://www.jetprofiler.com/fr/. If anyone knows a good open source alternative let me know. Then identify the web pages that are the slowest. I can figure out the code path exercised by these and provide a better diagnostic. But I can only do this after we ruled out MySQL being the culprit. > … or have I been inadvertently exposed to some type of controlled substance… I lol'ed Cheers! -- Olivier Bilodeau [email protected] :: +1.514.447.4918 *115 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
