eBay once developed a patch for pooled threads, on top of 5.0, to resolve this kind of
issue so they can support 10k+ sessions(massive amount of application need to talk to
those mysql).
Not sure whether they are merged into main version though.
Best regards
Zhuchao
在 2011-4-14，17:59，Reindl Harald <h.reindl@stripped> 写道：
> Am 14.04.2011 11:50, schrieb Johan De Meersman:
>> ----- Original Message -----
>>> From: "Reindl Harald" <h.reindl@stripped>
>>>
>>> even if you have enough memory why will you throw it away for a
>>> unusual connection count instead use the RAm for innodb-buffer-pool,
>>> query-cache, key-buffers?
>>
>> Maybe the application doesn't have support for connection pooling and can't be
> easily replaced.
>
> http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/mysql.html
>
>> Maybe there's just that much clients instead of a central service
>
> Maybe the OP could clarify what he really does
>
>> Maybe there's not just a single application that uses that database.
>
> http://sqlrelay.sourceforge.net/sqlrelay/gettingstarted/mysql.html
>
>> As usual, Harald, you fail to realise that your experience does not encompass the
> whole of human civilisation.
>
> as usual people have questions without any information what they really do
>
>> You seem to have a good technical background, but it might be useful to learn to
>
>> consider problems from the point of view of the people who have them, at times.
>> It tends to be a much appreciated skill in the real world.
>
> this is your point of view, ok
>
> my point of view is instead having headaches about how many connections are
> possible without problems to consider how many connections are really
> needed and without "my.cnf" (buffer settings), any information about the
> workload of the applications the whole question does not make sense
>
