Description:
The number of session threads is not properly configured thus making MySQL accept one request per time. This is a regression caused by the following
patch:
revno: 270
committer: Geert Vanderkelen <geert.vanderkelen@oracle.com>
branch nick: WL7600
timestamp: Fri 2014-07-18 19:26:24 +0200
message:
WL#7600: New interface using the MySQL Protocol
Note thought that MySQL Fabric currently serializes write requests but it should accept multiple read requests (i.e. dump requests from connectors) concurrently. We are working on improving how write requests are handled.
How to repeat:
Check the code or run MySQL Fabric and try to execute more than one request concurrently.
Suggested fix:
Either add the following line to the "protocol.mysql" section in the configuration file:
threads = 5
Or apply the following patch:
--- lib/mysql/fabric/services/manage.py revid:alfranio.correia@oracle.com-20141021080749-eph2gc4wq91t4k4e
+++ lib/mysql/fabric/services/manage.py 2014-10-22 08:42:33 +0000
@@ -317,13 +317,6 @@
# MySQL-RPC service
try:
services['protocol.mysql'] = config.get('protocol.mysql', "address")
-
- try:
- number_threads = config.get('protocol.mysql', "threads")
- number_threads = int(number_threads)
- except (_config.NoOptionError, ValueError):
- number_threads = DEFAULT_N_THREADS
-
except _config.NoSectionError:
# No MySQL-RPC configured
pass