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.rei...@thelounge.net> 写道： > Am 14.04.2011 11:50, schrieb Johan De Meersman: >> ----- Original Message ----- >>> From: "Reindl Harald" <h.rei...@thelounge.net> >>> >>> 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
