Re: MySQL+Apache Optimization

2004-01-07 Thread vishal
lt;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 3:25 PM Subject: Re: MySQL+Apache Optimization > Questions - Number of queries sent to the server. > See http://www.mysql.com/doc/en/SHOW_STATUS.html for more info > > > MySQL user > > >From: <[

Re: MySQL+Apache Optimization

2004-01-07 Thread MySQL User Bob
Questions - Number of queries sent to the server. See http://www.mysql.com/doc/en/SHOW_STATUS.html for more info MySQL user From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: MySQL+Apache Optimization Date: Wed, 7 Jan 2004 15:12:19 +0530 Hello , What are Questions in My

Re: MySQL+Apache Optimization

2004-01-07 Thread vishal
low queries: 0 Opens: 142 Flush tables: 1 Open tables: 136 Queries per second avg: 95.389 Any comments will appreciated. Thank you, Vishal. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 2:35 PM Subject: Re: MySQL+Apac

Re: MySQL+Apache Optimization

2004-01-07 Thread vishal
y, January 07, 2004 2:06 PM Subject: MySQL+Apache Optimization > >Can Anyone please tell me why I am not able to get the Load Down and the > >site Load Faster.The server load is always above 5.00 > > > >Thanks in Advance. > > > >Vishal. > > Try t

MySQL+Apache Optimization

2004-01-07 Thread my5ql _
Can Anyone please tell me why I am not able to get the Load Down and the site Load Faster.The server load is always above 5.00 Thanks in Advance. Vishal. Try the following changes: Apache: Turn KeepAlives off + increase your MaxRequestsPerChild. Apache is probably spending too much time recreati

Mysql+apache Optimization.

2004-01-07 Thread vishal
Hello All, Redhat 9 (shrike) Mysql 4.0.15 Apache 1.3.29 PHP 4.3.3 Server Conf [4 CPUs] Dual Xeon 2.4 1GB RAM 73GB SCSI, 80GB IDE HD No of Sites : only 2 (which are very Busy and mysql intensive ) Http.conf = Timeout 300 KeepAlive On MaxKeepAliveRequests 120 KeepAliveTimeo