@ Olivier & Mark: Thank you very much for the info, I will def. be looking into your suggestions ASAP.
To answer Mark's question about if the processes are truly zombies ... and not just on bath salts apparently... While it is a bit hard to catch them with ps -aux, I generally use top which does show them as defunct, and lists the same number of procs as zombies. But now after reading your emails I think I can see a possible link. If the DB is too slow that could cause apache to declare the process a zombie when infact it is just waiting for a query that is taking a long time. I will most def be looking @ the DB server to ascertain its health. On that note; if I drop all of the unreg'ed nodes from my table in the PF databse will that cause any issues for nodes, that although they are unregistered, still have an open location log? Jake Sallee Godfather of Bandwidth System Engineer University of Mary Hardin-Baylor 900 College St. Belton TX. 76513 Fone: 254-295-4658 Phax: 254-295-4221 HTTP://WWW.UMHB.EDU -----Original Message----- From: Olivier Bilodeau [mailto:[email protected]] Sent: Thursday, August 16, 2012 8:37 AM To: [email protected] Subject: Re: [PacketFence-users] httpd processes getting zombified 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 ------------------------------------------------------------------------------ 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
