MySQL 6.0, Libevent

最新推荐文章于 2024-07-26 16:15:06 发布

最新推荐文章于 2024-07-26 16:15:06 发布 · 178 阅读

文章标签：

#MySQL #CouchDB #Solaris #thread #UP

MySQL 6.0 版本引入了 Libevent 支持，该功能由 Damien Katz 完成，旨在解决多核处理器上的线程竞争问题。通过使用 Libevent，MySQL 可以将连接映射到线程池中，从而提高系统效率。测试显示，在高并发场景下，特别是在 8 核机器上，这种方法可以显著减少处理时间。

http://krow.livejournal.com/2008/01/01/

MySQL 6.0, Libevent
Jan. 1st, 2008 | 11:30 am

Currently in the 6.0 tree we have support for Libevent. This is one of those things I've been wanting to see
us do for years and it was finally completed a few weeks ago by Damien
Katz (aka CouchDB) with some help from Dmitri Lenev.

So what does this do? MySQL uses a 1:1 ratio for connections and
threads. Libevent allows us to pull threads into pools and use them
for connections. This is pretty awesome for 8way machines since
partially solves thread contention issues. Below is an example of
MyISAM doing large number of inserts with the number of users doing
inserts increasing (1-300 users). The graph shows the time taken for
each test run. Similar numbers show up when you run benchmarks with
Innodb (leave concurrent set to zero as you should normally do, this
will allow libevent to more effectively control the thread usage).
The green line shows the test running with 20 threads, while the blue
is unlimited. I do not have good rules of thumb yet for thread number
vs processors. The machine I used for this test is an 8way that I have
on loan from Intel. I will work out a similar test for Solaris once I
can get the code to compile there.