<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
Scott Silva wrote:
<blockquote cite="mid:gl7nvs$b8j$1@ger.gmane.org" type="cite">
<pre wrap="">on 1-21-2009 7:14 AM Rob Kampen spake the following:
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->Did you do the obvious and check for table or index corruption?
</pre>
</blockquote>
Yes, mysqlcheck -A shows all OK.<br>
I am not sure this is a mysql problem as all other pages in the app
work fine and some of these also retrieve lots of data with no noticed
lag.<br>
<blockquote cite="mid:gl7nvs$b8j$1@ger.gmane.org" type="cite">
<pre wrap="">
</pre>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
CentOS mailing list
<a class="moz-txt-link-abbreviated" href="mailto:CentOS@centos.org">CentOS@centos.org</a>
<a class="moz-txt-link-freetext" href="http://lists.centos.org/mailman/listinfo/centos">http://lists.centos.org/mailman/listinfo/centos</a>
</pre>
</blockquote>
</body>
</html>