Are those patches already includes in 5.5 community version?
For pathces like : *EBay Patches (5.0)* have included: - variable length memory storage engine - pool of threads - Virtual columns and others like *Google Patches (5.0 5.1)* included improvements in : - statistics/monitoring - lock contention - binlog - malloc() - filesorts - innodb I/O and wait statistics - SHOW …STATISTICS statements - smp scalability - I/O scalability - semisync replication - many more *Percona Patches (5.0)* focus on - statistics/monitoring - performance/scalability - buffer pool content/mutexes - microslow patch Thx -- Regards Zhu Chao
Re: Are those patches already includes in 5.5 community version?
Just looked at version 5.5/5.6 document: http://dev.mysql.com/doc/refman/5.5/en/memory-storage-engine.html at least the variable length memory patch is not included, i guess same with others; It is disappointed MySQL is not including those into the 5.5/5.6 version; BTW: i was reading http://ronaldbradford.com/blog/beyond-mysql-ga-patches-storage-engines-forks-and-pre-releases-fosdem-2010-2010-02-11/previously; On Tue, Apr 26, 2011 at 12:34 AM, Zhu,Chao zhuc...@gmail.com wrote: For pathces like : *EBay Patches (5.0)* have included: - variable length memory storage engine - pool of threads - Virtual columns and others like *Google Patches (5.0 5.1)* included improvements in : - statistics/monitoring - lock contention - binlog - malloc() - filesorts - innodb I/O and wait statistics - SHOW …STATISTICS statements - smp scalability - I/O scalability - semisync replication - many more *Percona Patches (5.0)* focus on - statistics/monitoring - performance/scalability - buffer pool content/mutexes - microslow patch Thx -- Regards Zhu Chao -- Regards Zhu Chao
Re: Practical connection limits MySQL 5.1/5.5
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
Re: mysql using aio/raw device on linux
option very, very carefully against the risk of losing data before you go through with this. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=a...@apple.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=zhuc...@gmail.com -- Regards Zhu Chao
Re: mysql using aio/raw device on linux
option very, very carefully against the risk of losing data before you go through with this. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=a...@apple.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=zhuc...@gmail.com -- Regards Zhu Chao
mysql using aio/raw device on linux
hi, Guys One Q: Can mysql binlog use raw device on Linux? Can we use asynch IO for binlog writing? sequential non-qio fsync is slowing our throughput... Thx -- Regards Zhu Chao