3 messages in com.mysql.lists.mysql-deRe: Zu viele mysqld Prozesse| From | Sent On | Attachments |
|---|---|---|
| Marcus Franke | 01 Nov 2004 04:01 | |
| Marcus Franke | 01 Nov 2004 06:16 | |
| Hartmut Holzgraefe | 02 Nov 2004 05:04 |
| Subject: | Re: Zu viele mysqld Prozesse |
|---|---|
| From: | Hartmut Holzgraefe (hart...@php.net) |
| Date: | 11/02/2004 05:04:07 AM |
| List: | com.mysql.lists.mysql-de |
Marcus Franke wrote:
Die absolute Anzahl ist ja auch ok, aber wenn auf der Büchse wenig los ist, dann könnten dort auch gerne nur 3-4 threads vor sich hindümpeln statt 16.
Wenn was los ist, dann sind 16 Threads ja völlig ok
Die Anzahl der 'in Bereitschaft' vorgehaltenen Threads lässt sich über 'thread_cache_size' kontrollieren:
thread_cache_size
How many threads the server should cache for reuse. When a client disconnects, the client's threads are put in the cache if there aren't already thread_cache_size threads there. Requests for threads are satisfied by reusing threads taken from the cache if possible, and only when the cache is empty is a new thread created. This variable can be increased to improve performance if you have a lot of new connections. (Normally this doesn't give a notable performance improvement if you have a good thread implementation.) By examining the difference between the Connections and Threads_created status variables (see section 5.2.4 Server Status Variables for details) you can see how efficient the thread cache is. This variable was added in MySQL 3.23.16.
(http://dev.mysql.com/doc/mysql/en/Server_system_variables.html)
-- Hartmut Holzgraefe <hart...@php.net>