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]
