Hello , What are Questions in Mysql , I mean is there something know as Questions in Mysql, I got a Script in PHP called as testload.php and it shows me this output :
total processes are 55 Mysql Status is Uptime: 1839 Threads: 55 Questions: 175421 ==> What does this Stands For ??? Slow 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+Apache Optimization > 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] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]