Hi All, I have an old (2004) Intel based server with 4G of ram running Linux ndgonline.net 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 12:03:43 EST 2008 i686 i686 i386 GNU/Linux fully up to date using centOS rpms for apache, php, and mysql. I have just changed from dmraid to md raid for the OS on mirrored 80Gb SATA drives. (long story for another time) Mysql lives on a Intel hardware raid 5 controlled array - as is has for four years. My application has not changed and also runs just fine on another server (although this one is 64 bit) that has a mirrored mysql database replication from this one. I have compared apache conf files, my.cnf and all appears well. The page that times out on our firefox browsers after 30 seconds does have a series of complex mysql queries. There are no log messages other than ssl_error_log that shows: PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/htdocs/ndg/includes/customHandler.inc on line 87 the line number varies as does the file name it reports. It will serve pages that only have a few records, yet on my functioning server even the large pages return over the internet in less than 2 seconds. So I'm thinking not enough memory? - but it was working well last Monday. something slowing mysql?? - all other queries in this app appear just fine php having issues? How do I get some extra log info to track this down? Kind regards Rob -------------- next part -------------- A non-text attachment was scrubbed... Name: rkampen.vcf Type: text/x-vcard Size: 125 bytes Desc: not available URL: <http://lists.centos.org/pipermail/centos/attachments/20090121/532f6924/attachment-0003.vcf>
Rob Kampen wrote:> How do I get some extra log info to track this down?Have you tried to run 'show full processlist' on mysql while the query is running? It should show all active queries, what they are doing and how long they have been running for. Also enable slow query logging and logging when not using indexes, add to /etc/my.cnf and restart mysql: example: log-slow-queries = /var/lib/mysql_logs/slowqueries.log log-queries-not-using-indexes long_query_time = 3 nate
on 1-21-2009 7:14 AM Rob Kampen spake the following:> Hi All, > I have an old (2004) Intel based server with 4G of ram running > Linux ndgonline.net 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 12:03:43 EST > 2008 i686 i686 i386 GNU/Linux > fully up to date using centOS rpms for apache, php, and mysql. > I have just changed from dmraid to md raid for the OS on mirrored 80Gb > SATA drives. (long story for another time) > Mysql lives on a Intel hardware raid 5 controlled array - as is has for > four years. > My application has not changed and also runs just fine on another server > (although this one is 64 bit) that has a mirrored mysql database > replication from this one. > I have compared apache conf files, my.cnf and all appears well. > The page that times out on our firefox browsers after 30 seconds does > have a series of complex mysql queries. > There are no log messages other than ssl_error_log that shows: > PHP Fatal error: Maximum execution time of 30 seconds exceeded in > /var/www/htdocs/ndg/includes/customHandler.inc on line 87 > the line number varies as does the file name it reports. > It will serve pages that only have a few records, yet on my functioning > server even the large pages return over the internet in less than 2 > seconds. > So I'm thinking not enough memory? - but it was working well last Monday. > something slowing mysql?? - all other queries in this app appear just fine > php having issues? > How do I get some extra log info to track this down? >Did you do the obvious and check for table or index corruption? -- MailScanner is like deodorant... You hope everybody uses it, and you notice quickly if they don't!!!! -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 258 bytes Desc: OpenPGP digital signature URL: <http://lists.centos.org/pipermail/centos/attachments/20090121/0c6ff1c3/attachment-0003.sig>