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]
Re: MySQL+Apache Optimization
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]
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]
Re: MySQL+Apache Optimization
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]