Hello, Thank you for the Reply, I'll follow you suggestions and will post the results here, Also I use connect only and not aothers.
Thank you again..... ;) Vishal. ----- Original Message ----- From: "my5ql _" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, 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 the following changes: > > Apache: Turn KeepAlives off + increase your MaxRequestsPerChild. Apache is > probably spending too much time recreating httpd processes. (I presume > Apache & MySQL are running on the same box). Also are your using > mysql_connect() or pconnects? > > MySQL: Try increasing your table cache. Does your thread cache need to be > that high? Maybe you should increase the thread concurrency first. According > to the my.cnf, you can increase this based on the amount of CPUs, you start > off by setting it to 24-32? > > Your max_connections settings is high and that will take up a fair amount of > file descriptors. I suspect your table cache isn't big enough (try 2048 as a > starting point, see http://www.mysql.com/doc/en/Table_cache.html for more > info) > > (Not intending to hijack this thread), but I'm going through a similar issue > with my Dual Xeon, 6GB RAM and RAID5 SCSI, but I'm running out of > file-descriptors and max_connections=520 > > I hope my suggestions are useful and it'll be interesting to see whether > they help... > > httpd.conf > ======= > KeepAlive Off > MaxRequestsPerChild 9000 > > my.cnf > ====== > [mysqld] > table_cache = 2048 > thread_cache_size = 256 > thread_concurrency= 32 > > _________________________________________________________________ > It's fast, it's easy and it's free. Get MSN Messenger today! > http://www.msn.co.uk/messenger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
