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]
