stressing mysql - configuration advice
Received: from 213.39.151.4 by freemailng1402.web.de with HTTP; Sun, 11 Apr 2004 12:47:20 +0200 Date: Sun, 11 Apr 2004 12:47:20 +0200 Message-Id: <[EMAIL PROTECTED]> --- END HEADERS --- Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application. Now I am trying to configure the server for huge load. To stress test it, I installed the Microsoft stress test tool which simulates 300 threads in this case. I configureed the server with following settings: key_buffer = 348M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 Problem is: The server can't satisfy each query request once more than 200 threads are issued. Result is that the application does not respond anymore. I have a php script which redirects users if the db does not respond to a query. This is the only site they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin _ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stressing mysql - configuration advice
Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application. Now I am trying to configure the server for huge load. To stress test it, I installed the Microsoft stress test tool which simulates 300 threads in this case. I configureed the server with following settings: key_buffer = 348M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 Problem is: The server can't satisfy each query request once more than 200 threads are issued. Result is that the application does not respond anymore. I have a php script which redirects users if the db does not respond to a query. This is the only site they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin _ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stressing mysql - configuration advice
Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application. Now I am trying to configure the server for huge load. To stress test it, I installed the Microsoft stress test tool which simulates 300 threads in this case. I configureed the server with following settings: key_buffer = 348M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 Problem is: The server can't satisfy each query request once more than 200 threads are issued. Result is that the application does not respond anymore. I have a php script which redirects users if the db does not respond to a query. This is the only site they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stressing mysql - configuration advice
Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application. Now I am trying to configure the server for huge load. To stress test it, I installed the Microsoft stress test tool which simulates 300 threads in this case. I configureed the server with following settings: key_buffer = 348M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 Problem is: The server can't satisfy each query request once more than 200 threads are issued. Result is that the application does not respond anymore. I have a php script which redirects users if the db does not respond to a query. This is the only site they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
