Skip to content

sansom/mysql-plugin-threadpool

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 

Repository files navigation

mysql-plugin-threadpool

Why thread pool

By default, MySQL using one thread to handle each connection to execute queries. As more client connections, more threads are created. Performance will degrades because of context switching, memory usage, resouce contention. A thread pool will reduces the creation of theads and improves performance on high concurrency scane. MySQL Enterprise provides a thread pool plugin, and some thirdpart fork like percona server, mariadb also provides this feature. But if you are using MySQL Community, this plugin will helps.

Usage

CAUTION:

mysql version >= 5.6.20 is REQUIRED

mysql plugins MUST be built using the same version of the source code and the same build arguments. If mysqld is built as a debug version without cmake parameter -DBUILD_CONFIG, the parameter must not be added when compiling plugins.

First, compile the plugin and install in to plugin dir

cp -r src /path/to/mysql-src/plugin/threadpool
cd /path/to/mysql-src
cmake . -DBUILD_CONFIG=mysql_release
cd plugin/threadpool
make
make install

Then, load the plugin into mysql

mysql> INSTALL PLUGIN THREADPOOL SONAME 'threadpool.so';

About

MySQL threadpool plugin transplanted from percona server

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C++ 94.7%
  • C 3.8%
  • CMake 1.5%