MaxScale> show dcbs DCB: 0x11fcb00 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: 0x11ffcb0 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: 131057 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x1200180 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: 0x126b630 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: 2622121 No. of Writes: 0 No. of Buffered Writes: 2693422 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x126bb90 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: 2330293 No. of Writes: 0 No. of Buffered Writes: 2282919 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x126bdf0 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: 1646719 No. of Writes: 0 No. of Buffered Writes: 1621433 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x12ebb20 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: 2604064 No. of Writes: 0 No. of Buffered Writes: 2701743 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x12ec160 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: 2350831 No. of Writes: 0 No. of Buffered Writes: 2279969 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x12ec390 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: 1652755 No. of Writes: 0 No. of Buffered Writes: 1624055 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x13cb0c0 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: 2602698 No. of Writes: 0 No. of Buffered Writes: 2699747 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x128c6e0 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: 2346557 No. of Writes: 0 No. of Buffered Writes: 2276728 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x134adb0 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: 1652436 No. of Writes: 0 No. of Buffered Writes: 1623315 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x1586de0 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: 2595515 No. of Writes: 0 No. of Buffered Writes: 2701508 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x155c390 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: 2350671 No. of Writes: 0 No. of Buffered Writes: 2273848 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x1594e90 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: 1648448 No. of Writes: 0 No. of Buffered Writes: 1617373 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x204c95e0 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: 1459251 No. of Writes: 0 No. of Buffered Writes: 1500943 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x204e24e0 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: 1289542 No. of Writes: 0 No. of Buffered Writes: 1262567 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x204c3d00 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: 940527 No. of Writes: 0 No. of Buffered Writes: 924944 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x5209e3e0 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: 138 No. of Writes: 0 No. of Buffered Writes: 143 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x52025360 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: 119 No. of Writes: 0 No. of Buffered Writes: 117 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x52025540 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: 96 No. of Writes: 0 No. of Buffered Writes: 92 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x520930d0 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: 125 No. of Writes: 0 No. of Buffered Writes: 131 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x52035e10 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: 119 No. of Writes: 0 No. of Buffered Writes: 113 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x5207f230 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: 76 No. of Writes: 0 No. of Buffered Writes: 76 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x50da71d0 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: 110 No. of Writes: 0 No. of Buffered Writes: 114 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x520820d0 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: 94 No. of Writes: 0 No. of Buffered Writes: 92 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x520932b0 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: 77 No. of Writes: 0 No. of Buffered Writes: 74 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x51e767a0 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: 95 No. of Writes: 0 No. of Buffered Writes: 99 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x52060500 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: 90 No. of Writes: 0 No. of Buffered Writes: 86 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x5205dd60 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: 58 No. of Writes: 0 No. of Buffered Writes: 57 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x52063de0 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: 67 No. of Writes: 0 No. of Buffered Writes: 73 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x5205af40 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: 66 No. of Writes: 0 No. of Buffered Writes: 61 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x52050380 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: 43 No. of Writes: 0 No. of Buffered Writes: 41 No. of Accepts: 0 No. of High Water Events: 0 No. of Low Water Events: 0 DCB: 0x52024f70 DCB state: DCB in the polling loop Service: MaxAdmin Service Connected to: 127.0.0.1 Role: Request Handler Statistics: No. of Reads: 4 No. of Writes: 0 No. of Buffered Writes: 565 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: 313168226 No. of epoll cycles with wait: 52342588 No. of epoll calls returning events: 85259587 No. of non-blocking calls returning events: 32917004 No. of read events: 103053838 No. of write events: 103342050 No. of error events: 0 No. of hangup events: 129000 No. of accept events: 130154 No. of times no threads polling: 4 Current event queue length: 1 Maximum event queue length: 15 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 70654810 2 11378588 3 2812740 4 345718 5 60625 6 5782 7 1306 8 12 9 2 >= 10 4 MaxScale> show eventstats Event statistics. Maximum queue time: 500ms Maximum execution time: 300ms Maximum event queue length: 15 Current event queue length: 2 | Number of events Duration | Queued | Executed ---------------+------------+----------- < 100ms | 101925037 | 99560999 100 - 200ms | 1264004 | 3385434 200 - 300ms | 285990 | 529109 300 - 400ms | 450 | 12 400 - 500ms | 68 | 0 500 - 600ms | 6 | 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 C32EEA5AA47045BEDCEBD0C876B310916408A481 FEEDBACK_USER_INFO not_set VERSION 1.4.3 NOW 1464248111 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 0x1128950 (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: 129841 Current no. of conns: 10 Current no. of operations: 2 Server 0x1128810 (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: 129841 Current no. of conns: 10 Current no. of operations: 1 MaxScale> show services Service 0x1127da0 Service: Read-Only Service Router: readconnroute (0x7f53ad9dbc80) State: Started Number of router sessions: 0 Current no. of router sessions: 0 Number of queries forwarded: 0 Started: Tue May 17 09:33:31 2016 Root user access: Enabled Backend databases 10.0.3.26:3306 Protocol: MySQLBackend 10.0.3.27:3306 Protocol: MySQLBackend Users data: 0x115adc0 Total connections: 1 Currently connected: 1 Service 0x1127290 Service: Read-Write Service Router: readwritesplit (0x7f53adbeab80) State: Started Number of router sessions: 129847 Current no. of router sessions: 10 Number of queries forwarded: 20443768 Number of queries forwarded to master: 98057 Number of queries forwarded to slave: 20345711 Number of queries forwarded to all: 19890582 Master/Slave percentage: 0.48% Started: Tue May 17 09:33:35 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: 0x11ffe90 Total connections: 131108 Currently connected: 11 Service 0x11268b0 Service: MaxAdmin Service Router: cli (0x7f53addf3b80) State: Started Started: Tue May 17 09:33:35 2016 Root user access: Disabled Backend databases Users data: 0x1200360 Total connections: 3 Currently connected: 2 MaxScale> show sessions Session 131117 (0x520f4370) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x51e015f0 Client Address: development@127.0.0.1 Connected: Thu May 26 09:37:11 2016 Idle: 1 seconds Session 131116 (0x520cd3d0) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x51d7bbf0 Client Address: development@127.0.0.1 Connected: Thu May 26 09:37:05 2016 Idle: 1 seconds Session 131115 (0x520c4860) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x520c42b0 Client Address: development@127.0.0.1 Connected: Thu May 26 09:37:02 2016 Idle: 0 seconds Session 131114 (0x520dddd0) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x520f3250 Client Address: development@127.0.0.1 Connected: Thu May 26 09:37:01 2016 Idle: 0 seconds Session 131113 (0x520da6e0) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x520f2ff0 Client Address: development@127.0.0.1 Connected: Thu May 26 09:36:58 2016 Idle: 0 seconds Session 131082 (0x520a6e80) State: Session ready for routing Service: MaxAdmin Service (0x11268b0) Client DCB: 0x520a3050 Client Address: 127.0.0.1 Connected: Thu May 26 09:33:47 2016 Idle: 0 seconds Session 43104 (0x204b89a0) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x204c95e0 Client Address: user_j@127.0.0.1 Connected: Fri May 20 07:10:28 2016 Idle: 1 seconds Session 1403 (0x15917b0) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x1586de0 Client Address: user_j@127.0.0.1 Connected: Tue May 17 09:51:23 2016 Idle: 1 seconds Session 1306 (0x137a100) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x13cb0c0 Client Address: user_j@127.0.0.1 Connected: Tue May 17 09:39:11 2016 Idle: 1 seconds Session 1269 (0x12ebf90) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x12ebb20 Client Address: user_j@127.0.0.1 Connected: Tue May 17 09:34:28 2016 Idle: 1 seconds Session 1265 (0x126b9c0) State: Session ready for routing Service: Read-Write Service (0x1127290) Client DCB: 0x126b630 Client Address: user_j@127.0.0.1 Connected: Tue May 17 09:34:28 2016 Idle: 0 seconds Session 3 (0x1200920) State: Listener Session Service: MaxAdmin Service (0x11268b0) Client DCB: 0x1200180 Connected: Tue May 17 09:33:35 2016 Session 2 (0x12000e0) State: Listener Session Service: Read-Write Service (0x1127290) Client DCB: 0x11ffcb0 Connected: Tue May 17 09:33:35 2016 Session 1 (0x11ffb30) State: Listener Session Service: Read-Only Service (0x1127da0) Client DCB: 0x11fcb00 Connected: Tue May 17 09:33:31 2016 MaxScale> show tasks Name | Type | Frequency | Next Due --------------------------+----------+-----------+------------------------- Load Average | Repeated | 10 | Thu May 26 09:37:56 2016 MaxScale> show threads Polling Threads. Historic Thread Load Average: 1.21. 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.40, 5 Minute Average: 0.40, 1 Minute Average: 0.83 ID | State | # fds | Descriptor | Running | Event ----+------------+--------+------------------+----------+--------------- 0 | Processing | 2 | 0x520a3050 | < 100ms | IN|OUT