Hello all, Guys Where will i Find out If Mysql database is Optimized or Not, I have read the Documentation given on Mysql.com and also checked the database which tells that It has been Optimized well, Actually When I See the Mysql processlists it put all the Update Statement and Select Count(col1) from table name statements, Only one table is Heavily used. I also thought of Killing Mysql connections after a Specific time, where will i configure that ???
Thanks for any comments. Vishal. ----- Original Message ----- From: "MySQL User Bob" <[EMAIL PROTECTED]> To: <[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: <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Subject: Re: MySQL+Apache Optimization > >Date: Wed, 7 Jan 2004 15:12:19 +0530 > > > >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] > > > > _________________________________________________________________ > 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]
