MaxScale> show dcbs DCB: 0x23131d0 DCB state: DCB for listening socket Service: Read-Only Service Role: Service Listener Statistics: No. of Reads: 0 No. of Writes: 0 No. of Buffered Writes: 0 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x23163c0 DCB state: DCB for listening socket Service: Read-Write Service Role: Service Listener Statistics: No. of Reads: 0 No. of Writes: 0 No. of Buffered Writes: 0 No. of Accepts: 75 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x2316750 DCB state: DCB for listening socket Service: MaxAdmin Service Role: Service Listener Statistics: No. of Reads: 0 No. of Writes: 0 No. of Buffered Writes: 0 No. of Accepts: 1 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x2329530 DCB state: DCB in the polling loop Service: Read-Write Service Connected to: 127.0.0.1 Username: user_j Role: Request Handler Statistics: No. of Reads: 4452 No. of Writes: 0 No. of Buffered Writes: 4553 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x2315420 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.26 Port number: 3306 Protocol: MySQLBackend Server status: Master, Running Role: Request Handler Statistics: No. of Reads: 4538 No. of Writes: 0 No. of Buffered Writes: 4414 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x2315750 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.27 Port number: 3306 Protocol: MySQLBackend Server status: Slave, Running Role: Request Handler Statistics: No. of Reads: 2266 No. of Writes: 0 No. of Buffered Writes: 2264 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x233d060 DCB state: DCB in the polling loop Service: Read-Write Service Connected to: 127.0.0.1 Username: user_j Role: Request Handler Statistics: No. of Reads: 4462 No. of Writes: 0 No. of Buffered Writes: 4579 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x233d620 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.26 Port number: 3306 Protocol: MySQLBackend Server status: Master, Running Role: Request Handler Statistics: No. of Reads: 4563 No. of Writes: 0 No. of Buffered Writes: 4421 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x233d950 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.27 Port number: 3306 Protocol: MySQLBackend Server status: Slave, Running Role: Request Handler Statistics: No. of Reads: 2274 No. of Writes: 0 No. of Buffered Writes: 2272 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x237fd40 DCB state: DCB in the polling loop Service: Read-Write Service Connected to: 127.0.0.1 Username: user_j Role: Request Handler Statistics: No. of Reads: 4454 No. of Writes: 0 No. of Buffered Writes: 4613 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x2380310 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.26 Port number: 3306 Protocol: MySQLBackend Server status: Master, Running Role: Request Handler Statistics: No. of Reads: 4592 No. of Writes: 0 No. of Buffered Writes: 4413 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x23805c0 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.27 Port number: 3306 Protocol: MySQLBackend Server status: Slave, Running Role: Request Handler Statistics: No. of Reads: 2272 No. of Writes: 0 No. of Buffered Writes: 2268 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x2394c10 DCB state: DCB in the polling loop Service: Read-Write Service Connected to: 127.0.0.1 Username: user_j Role: Request Handler Statistics: No. of Reads: 4451 No. of Writes: 0 No. of Buffered Writes: 4582 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x2395170 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.26 Port number: 3306 Protocol: MySQLBackend Server status: Master, Running Role: Request Handler Statistics: No. of Reads: 4580 No. of Writes: 0 No. of Buffered Writes: 4414 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x2395420 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.27 Port number: 3306 Protocol: MySQLBackend Server status: Slave, Running Role: Request Handler Statistics: No. of Reads: 2266 No. of Writes: 0 No. of Buffered Writes: 2262 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x25ca7b0 DCB state: DCB in the polling loop Service: MaxAdmin Service Connected to: 127.0.0.1 Role: Request Handler Statistics: No. of Reads: 3 No. of Writes: 0 No. of Buffered Writes: 216 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x25d2ab0 DCB state: DCB in the polling loop Service: Read-Write Service Connected to: 127.0.0.1 Username: development Role: Request Handler Statistics: No. of Reads: 80 No. of Writes: 0 No. of Buffered Writes: 85 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x25d3010 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.26 Port number: 3306 Protocol: MySQLBackend Server status: Master, Running Role: Request Handler Statistics: No. of Reads: 85 No. of Writes: 0 No. of Buffered Writes: 80 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x25d3320 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.27 Port number: 3306 Protocol: MySQLBackend Server status: Slave, Running Role: Request Handler Statistics: No. of Reads: 31 No. of Writes: 0 No. of Buffered Writes: 30 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x259d7c0 DCB state: DCB in the polling loop Service: Read-Write Service Connected to: 127.0.0.1 Username: development Role: Request Handler Statistics: No. of Reads: 77 No. of Writes: 0 No. of Buffered Writes: 82 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x25c1f30 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.26 Port number: 3306 Protocol: MySQLBackend Server status: Master, Running Role: Request Handler Statistics: No. of Reads: 82 No. of Writes: 0 No. of Buffered Writes: 77 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x259d510 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.27 Port number: 3306 Protocol: MySQLBackend Server status: Slave, Running Role: Request Handler Statistics: No. of Reads: 30 No. of Writes: 0 No. of Buffered Writes: 29 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x25bf130 DCB state: DCB in the polling loop Service: Read-Write Service Connected to: 127.0.0.1 Username: development Role: Request Handler Statistics: No. of Reads: 50 No. of Writes: 0 No. of Buffered Writes: 53 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x25c1990 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.26 Port number: 3306 Protocol: MySQLBackend Server status: Master, Running Role: Request Handler Statistics: No. of Reads: 53 No. of Writes: 0 No. of Buffered Writes: 50 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x25bf3e0 DCB state: DCB in the polling loop Service: Read-Write Service Server name/IP: 10.0.3.27 Port number: 3306 Protocol: MySQLBackend Server status: Slave, Running Role: Request Handler Statistics: No. of Reads: 21 No. of Writes: 0 No. of Buffered Writes: 20 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 MaxScale> show epoll Poll Statistics. No. of epoll cycles: 335974 No. of epoll cycles with wait: 54270 No. of epoll calls returning events: 100153 No. of non-blocking calls returning events: 45883 No. of read events: 118159 No. of write events: 118721 No. of error events: 0 No. of hangup events: 71 No. of accept events: 79 No. of times no threads polling: 4 Current event queue length: 1 Maximum event queue length: 4 No. of DCBs with pending events: 0 No. of wakeups with pending queue: 0 No of poll completions with descriptors No. of descriptors No. of poll completions. 1 81908 2 17827 3 365 4 53 5 0 6 0 7 0 8 0 9 0 >= 10 0 MaxScale> show eventstats Event statistics. Maximum queue time: 100ms Maximum execution time: 100ms Maximum event queue length: 4 Current event queue length: 1 | Number of events Duration | Queued | Executed ---------------+------------+----------- < 100ms | 120422 | 120043 100 - 200ms | 25 | 403 200 - 300ms | 0 | 0 300 - 400ms | 0 | 0 400 - 500ms | 0 | 0 500 - 600ms | 0 | 0 600 - 700ms | 0 | 0 700 - 800ms | 0 | 0 800 - 900ms | 0 | 0 900 - 1000ms | 0 | 0 1000 - 1100ms | 0 | 0 1100 - 1200ms | 0 | 0 1200 - 1300ms | 0 | 0 1300 - 1400ms | 0 | 0 1400 - 1500ms | 0 | 0 1500 - 1600ms | 0 | 0 1600 - 1700ms | 0 | 0 1700 - 1800ms | 0 | 0 1800 - 1900ms | 0 | 0 1900 - 2000ms | 0 | 0 2000 - 2100ms | 0 | 0 2100 - 2200ms | 0 | 0 2200 - 2300ms | 0 | 0 2300 - 2400ms | 0 | 0 2400 - 2500ms | 0 | 0 2500 - 2600ms | 0 | 0 2600 - 2700ms | 0 | 0 2700 - 2800ms | 0 | 0 2800 - 2900ms | 0 | 0 2900 - 3000ms | 0 | 0 > 3000ms | 0 | 0 MaxScale> show feedbackreport FEEDBACK_SERVER_UID 37B113963FFB0EB8F9A15775375188098E0A7CAF FEEDBACK_USER_INFO not_set VERSION 1.4.3 NOW 1464248475 PRODUCT maxscale Uname_sysname Linux Uname_distribution undefined module_MySQLBackend_type Protocol module_MySQLBackend_version V2.0.0 module_MySQLBackend_api 1.0.0 module_MySQLBackend_releasestatus GA module_maxscaled_type Protocol module_maxscaled_version V1.0.0 module_maxscaled_api 1.0.0 module_maxscaled_releasestatus GA module_MySQLClient_type Protocol module_MySQLClient_version V1.0.0 module_MySQLClient_api 1.0.0 module_MySQLClient_releasestatus GA module_qc_mysqlembedded_type QueryClassifier module_qc_mysqlembedded_version V1.0.0 module_qc_mysqlembedded_api 1.0.0 module_qc_mysqlembedded_releasestatus In Development module_mysqlmon_type Monitor module_mysqlmon_version V1.4.0 module_mysqlmon_api 3.0.0 module_mysqlmon_releasestatus GA module_regexfilter_type Filter module_regexfilter_version V1.1.0 module_regexfilter_api 1.1.0 module_regexfilter_releasestatus GA module_readconnroute_type Router module_readconnroute_version V1.1.0 module_readconnroute_api 1.0.0 module_readconnroute_releasestatus GA module_readwritesplit_type Router module_readwritesplit_version V1.0.2 module_readwritesplit_api 1.0.0 module_readwritesplit_releasestatus GA module_cli_type Router module_cli_version V1.0.0 module_cli_api 1.0.0 module_cli_releasestatus GA MaxScale> show servers Server 0x223ea50 (sql-101) Server: 10.0.3.27 Status: Slave, Running Protocol: MySQLBackend Port: 3306 Server Version: 5.7.12-log Node Id: 101 Master Id: 201 Slave Ids: Repl Depth: 1 Number of connections: 84 Current no. of conns: 7 Current no. of operations: 0 Server 0x223e910 (sql-201) Server: 10.0.3.26 Status: Master, Running Protocol: MySQLBackend Port: 3306 Server Version: 5.7.12-log Node Id: 201 Master Id: -1 Slave Ids: 101 Repl Depth: 0 Number of connections: 84 Current no. of conns: 7 Current no. of operations: 0 MaxScale> show services Service 0x223dea0 Service: Read-Only Service Router: readconnroute (0x7f4ba1a05c80) State: Started Number of router sessions: 0 Current no. of router sessions: 0 Number of queries forwarded: 0 Started: Thu May 26 09:25:42 2016 Root user access: Enabled Backend databases 10.0.3.26:3306 Protocol: MySQLBackend 10.0.3.27:3306 Protocol: MySQLBackend Users data: 0x23133b0 Total connections: 1 Currently connected: 1 Service 0x223d390 Service: Read-Write Service Router: readwritesplit (0x7f4ba1c14b80) State: Started Number of router sessions: 84 Current no. of router sessions: 7 Number of queries forwarded: 31258 Number of queries forwarded to master: 10241 Number of queries forwarded to slave: 21017 Number of queries forwarded to all: 20528 Master/Slave percentage: 32.76% Started: Thu May 26 09:25:42 2016 Root user access: Enabled Filter chain: InnoDBFilter Backend databases 10.0.3.26:3306 Protocol: MySQLBackend 10.0.3.27:3306 Protocol: MySQLBackend Users data: 0x2312eb0 Total connections: 85 Currently connected: 8 Service 0x223c9b0 Service: MaxAdmin Service Router: cli (0x7f4ba1e1db80) State: Started Started: Thu May 26 09:25:42 2016 Root user access: Disabled Backend databases Users data: 0x2316930 Total connections: 2 Currently connected: 2 MaxScale> show sessions Session 91 (0x25ffef0) State: Session ready for routing Service: Read-Write Service (0x223d390) Client DCB: 0x25f2980 Client Address: development@127.0.0.1 Connected: Thu May 26 09:41:56 2016 Idle: 0 seconds Session 90 (0x260fad0) State: Session ready for routing Service: Read-Write Service (0x223d390) Client DCB: 0x25e6df0 Client Address: development@127.0.0.1 Connected: Thu May 26 09:41:54 2016 Idle: 0 seconds Session 89 (0x2618f60) State: Session ready for routing Service: Read-Write Service (0x223d390) Client DCB: 0x2618bb0 Client Address: development@127.0.0.1 Connected: Thu May 26 09:41:53 2016 Idle: 0 seconds Session 76 (0x25ca990) State: Session ready for routing Service: MaxAdmin Service (0x223c9b0) Client DCB: 0x25ca7b0 Client Address: 127.0.0.1 Connected: Thu May 26 09:39:43 2016 Idle: 0 seconds Session 9 (0x2394fa0) State: Session ready for routing Service: Read-Write Service (0x223d390) Client DCB: 0x2394c10 Client Address: user_j@127.0.0.1 Connected: Thu May 26 09:25:43 2016 Idle: 1 seconds Session 8 (0x2380140) State: Session ready for routing Service: Read-Write Service (0x223d390) Client DCB: 0x237fd40 Client Address: user_j@127.0.0.1 Connected: Thu May 26 09:25:43 2016 Idle: 0 seconds Session 6 (0x233d450) State: Session ready for routing Service: Read-Write Service (0x223d390) Client DCB: 0x233d060 Client Address: user_j@127.0.0.1 Connected: Thu May 26 09:25:43 2016 Idle: 1 seconds Session 5 (0x2315250) State: Session ready for routing Service: Read-Write Service (0x223d390) Client DCB: 0x2329530 Client Address: user_j@127.0.0.1 Connected: Thu May 26 09:25:43 2016 Idle: 0 seconds Session 3 (0x2316e50) State: Listener Session Service: MaxAdmin Service (0x223c9b0) Client DCB: 0x2316750 Connected: Thu May 26 09:25:42 2016 Session 2 (0x2270e40) State: Listener Session Service: Read-Write Service (0x223d390) Client DCB: 0x23163c0 Connected: Thu May 26 09:25:42 2016 Session 1 (0x2317430) State: Listener Session Service: Read-Only Service (0x223dea0) Client DCB: 0x23131d0 Connected: Thu May 26 09:25:42 2016 MaxScale> show tasks Name | Type | Frequency | Next Due --------------------------+----------+-----------+------------------------- Load Average | Repeated | 10 | Thu May 26 09:42:42 2016 MaxScale> show threads Polling Threads. Historic Thread Load Average: 1.19. Current Thread Load Average: 1.00. 15 Minute Average: 1.00, 5 Minute Average: 1.00, 1 Minute Average: 1.00 Pending event queue length averages: 15 Minute Average: 0.00, 5 Minute Average: 0.00, 1 Minute Average: 0.00 ID | State | # fds | Descriptor | Running | Event ----+------------+--------+------------------+----------+--------------- 0 | Processing | 1 | 0x25ca7b0 | < 100ms | IN|OUT