Skip to content

Instantly share code, notes, and snippets.

@Slach

Slach/proxysql.log

Created April 1, 2018 14:56
Show Gist options
  • Save Slach/74ae1d2dae491fc7392c52f6a8305b91 to your computer and use it in GitHub Desktop.
Save Slach/74ae1d2dae491fc7392c52f6a8305b91 to your computer and use it in GitHub Desktop.
Download ZIP
Logs when proxysql failed connection over sysbench after running mysqlrpladmin switchover
Raw
proxysql.log
root@mysql-proxy:/home/vagrant# cat /var/lib/proxysql/proxysql.log
2018-04-01 14:27:30 [INFO] ProxySQL version 1.4.6-1.1
2018-04-01 14:27:30 [INFO] Detected OS: Linux mysql-proxy 4.4.0-116-generic #140-Ubuntu SMP Mon Feb 12 21:23:04 UTC 2018 x86_64
2018-04-01 14:27:30 [INFO] Starting ProxySQL
2018-04-01 14:27:30 [INFO] Sucessfully started
2018-04-01 14:27:30 [INFO] Angel process started ProxySQL process 7834
Standard ProxySQL Cluster rev. 0.1.0702 -- ProxySQL_Cluster.cpp -- Fri Mar 9 07:46:21 2018
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Fri Mar 9 07:46:21 2018
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Fri Mar 9 07:46:21 2018
Standard ProxySQL Admin rev. 0.2.0902 -- ProxySQL_Admin.cpp -- Fri Mar 9 07:46:21 2018
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Fri Mar 9 07:46:21 2018
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Fri Mar 9 07:46:21 2018
2018-04-01 14:27:30 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
2018-04-01 14:27:30 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
2018-04-01 14:27:30 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2018-04-01 14:27:30 [INFO] New mysql_replication_hostgroups table
2018-04-01 14:27:30 [INFO] New mysql_group_replication_hostgroups table
2018-04-01 14:27:30 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
2018-04-01 14:27:30 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
Standard Query Processor rev. 0.2.0902 -- Query_Processor.cpp -- Fri Mar 9 07:46:21 2018
In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Fri Mar 9 07:46:21 2018
Standard MySQL Monitor (StdMyMon) rev. 1.2.0723 -- MySQL_Monitor.cpp -- Fri Mar 9 07:46:21 2018
2018-04-01 14:27:36 ProxySQL_GloVars.cpp:9:term_handler(): [WARNING] Received TERM signal: shutdown in progress...
2018-04-01 14:27:36 [INFO] Starting shutdown...
2018-04-01 14:27:36 [INFO] Shutdown completed!
2018-04-01 14:27:36 [INFO] Exiting...
2018-04-01 14:27:36 [INFO] Shutdown angel process
2018-04-01 14:27:37 [INFO] ProxySQL version 1.4.6-1.1
2018-04-01 14:27:37 [INFO] Detected OS: Linux mysql-proxy 4.4.0-116-generic #140-Ubuntu SMP Mon Feb 12 21:23:04 UTC 2018 x86_64
2018-04-01 14:27:37 [INFO] Starting ProxySQL
2018-04-01 14:27:37 [INFO] Sucessfully started
2018-04-01 14:27:37 [INFO] Angel process started ProxySQL process 8138
Standard ProxySQL Cluster rev. 0.1.0702 -- ProxySQL_Cluster.cpp -- Fri Mar 9 07:46:21 2018
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Fri Mar 9 07:46:21 2018
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Fri Mar 9 07:46:21 2018
Standard ProxySQL Admin rev. 0.2.0902 -- ProxySQL_Admin.cpp -- Fri Mar 9 07:46:21 2018
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Fri Mar 9 07:46:21 2018
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Fri Mar 9 07:46:21 2018
2018-04-01 14:27:37 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
2018-04-01 14:27:37 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
2018-04-01 14:27:37 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2018-04-01 14:27:37 [INFO] New mysql_replication_hostgroups table
2018-04-01 14:27:37 [INFO] New mysql_group_replication_hostgroups table
2018-04-01 14:27:37 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
2018-04-01 14:27:37 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
Standard Query Processor rev. 0.2.0902 -- Query_Processor.cpp -- Fri Mar 9 07:46:21 2018
In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Fri Mar 9 07:46:21 2018
Standard MySQL Monitor (StdMyMon) rev. 1.2.0723 -- MySQL_Monitor.cpp -- Fri Mar 9 07:46:21 2018
2018-04-01 14:27:37 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2018-04-01 14:27:37 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
2018-04-01 14:27:37 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+
2018-04-01 14:27:37 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 1 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2018-04-01 14:27:37 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 1 , reader_hostgroup: 2, master->slave split hostgroups
2018-04-01 14:27:37 [INFO] New mysql_group_replication_hostgroups table
2018-04-01 14:27:37 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 1 , address: mysql1 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql2 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
2018-04-01 14:27:37 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| 1 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459712 |
| 2 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459840 |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
2018-04-01 14:27:37 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2018-04-01 14:27:37 [INFO] Received LOAD MYSQL USERS TO RUNTIME command
2018-04-01 14:27:37 [INFO] Received SAVE MYSQL USERS TO DISK command
2018-04-01 14:27:37 [INFO] Received LOAD MYSQL QUERY RULES TO RUNTIME command
2018-04-01 14:27:37 [INFO] Received SAVE MYSQL QUERY RULES TO DISK command
2018-04-01 14:27:37 [INFO] Received command SET mysql-monitor_enabled = 'false'
2018-04-01 14:27:37 [INFO] Received LOAD MYSQL VARIABLES TO RUNTIME command
2018-04-01 14:27:37 [INFO] Received SAVE MYSQL VARIABLES TO DISK command
2018-04-01 14:30:02 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2018-04-01 14:30:02 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 1 , address: mysql1 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql2 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
2018-04-01 14:30:02 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| 1 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459712 |
| 2 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459840 |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
2018-04-01 14:30:02 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 1 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | mysql2 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2018-04-01 14:30:02 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 1 , reader_hostgroup: 2, master->slave split hostgroups
2018-04-01 14:30:02 [INFO] New mysql_group_replication_hostgroups table
2018-04-01 14:30:02 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 1 , address: mysql1 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql2 , port: 3306 , weight: 1000 , status: OFFLINE_SOFT , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql1 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
2018-04-01 14:30:02 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| 1 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459712 |
| 2 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605460125568 |
| 2 | mysql2 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | | 140605487459840 |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
2018-04-01 14:30:02 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2018-04-01 14:32:31 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2018-04-01 14:32:31 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 1 , address: mysql1 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql2 , port: 3306 , weight: 1000 , status: OFFLINE_SOFT , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql1 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
2018-04-01 14:32:31 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| 1 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459712 |
| 2 | mysql1 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605460125568 |
| 2 | mysql2 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | | 140605487459840 |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
2018-04-01 14:32:31 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 1 | mysql2 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | mysql1 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2018-04-01 14:32:31 MySQL_HostGroups_Manager.cpp:599:commit(): [WARNING] Removed server at address 140605487459712, hostgroup 1, address mysql1 port 3306. Setting status OFFLINE HARD and immediately d
ropping all free connections. Used connections will be dropped when trying to use them
2018-04-01 14:32:31 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 1 , reader_hostgroup: 2, master->slave split hostgroups
2018-04-01 14:32:31 [INFO] New mysql_group_replication_hostgroups table
2018-04-01 14:32:31 MySQL_Session.cpp:2693:handler(): [ERROR] Detected an offline server during query: mysql1, 3306
2018-04-01 14:32:31 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 1 , address: mysql1 , port: 3306 , weight: 1000 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 1 , address: mysql2 , port: 3306 , weight: 1000 , status: OFFLINE_SOFT , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql2 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql1 , port: 3306 , weight: 1000 , status: OFFLINE_SOFT , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
2018-04-01 14:32:31 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| 1 | mysql1 | 3306 | 1000 | 3 | 0 | 1000 | 10 | 0 | 0 | | 140605487459712 |
| 2 | mysql1 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | | 140605460125568 |
| 2 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459840 |
| 1 | mysql2 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | | 140605516572800 |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
2018-04-01 14:32:31 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2018-04-01 14:32:35 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2018-04-01 14:32:35 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 1 , address: mysql2 , port: 3306 , weight: 1000 , status: OFFLINE_SOFT , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql2 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql1 , port: 3306 , weight: 1000 , status: OFFLINE_SOFT , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
2018-04-01 14:32:35 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| 1 | mysql2 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | | 140605516572800 |
| 2 | mysql1 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | | 140605460125568 |
| 2 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459840 |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
2018-04-01 14:32:35 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 1 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | |
| 2 | mysql1 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2018-04-01 14:32:35 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 1 , reader_hostgroup: 2, master->slave split hostgroups
2018-04-01 14:32:35 [INFO] New mysql_group_replication_hostgroups table
2018-04-01 14:32:35 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 1 , address: mysql2 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql2 , port: 3306 , weight: 1000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 2 , address: mysql1 , port: 3306 , weight: 1000 , status: OFFLINE_SOFT , max_connections: 1000 , max_replication_lag: 10 , use_ssl: 0 , max_latency_ms: 0 , comment:
2018-04-01 14:32:35 [INFO] Dumping mysql_servers
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| hostgroup_id | hostname | port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
| 1 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605516572800 |
| 2 | mysql1 | 3306 | 1000 | 2 | 0 | 1000 | 10 | 0 | 0 | | 140605460125568 |
| 2 | mysql2 | 3306 | 1000 | 0 | 0 | 1000 | 10 | 0 | 0 | | 140605487459840 |
+--------------+----------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+
2018-04-01 14:32:35 [INFO] Received SAVE MYSQL SERVERS TO DISK command
Raw
sysbench-processing.log
root@mysql-proxy:/home/vagrant# cat /var/log/sysbench-processing.log
2018-04-01 14:29:40 Statring sysbench...
WARNING: the --test option is deprecated. You can pass a script name or path on the command line without any options.
sysbench 1.0.13 (using bundled LuaJIT 2.1.0-beta2)
Running the test with following options:
Number of threads: 1
Report intermediate results every 1 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 1s ] thds: 1 tps: 42.84 qps: 856.87 (r/w/o: 599.81/171.37/85.69) lat (ms,95%): 47.47 err/s: 0.00 reconn/s: 0.00
[ 2s ] thds: 1 tps: 34.04 qps: 694.90 (r/w/o: 489.64/136.18/69.09) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00
[ 3s ] thds: 1 tps: 49.03 qps: 978.55 (r/w/o: 684.39/196.11/98.06) lat (ms,95%): 28.16 err/s: 0.00 reconn/s: 0.00
[ 4s ] thds: 1 tps: 0.95 qps: 21.95 (r/w/o: 16.22/3.82/1.91) lat (ms,95%): 20.37 err/s: 0.00 reconn/s: 0.00
[ 5s ] thds: 1 tps: 28.35 qps: 553.37 (r/w/o: 383.27/113.40/56.70) lat (ms,95%): 78.60 err/s: 0.00 reconn/s: 0.00
[ 6s ] thds: 1 tps: 46.00 qps: 930.94 (r/w/o: 654.96/183.99/91.99) lat (ms,95%): 33.12 err/s: 0.00 reconn/s: 0.00
[ 7s ] thds: 1 tps: 25.99 qps: 525.77 (r/w/o: 365.84/107.95/51.98) lat (ms,95%): 35.59 err/s: 0.00 reconn/s: 0.00
[ 8s ] thds: 1 tps: 46.01 qps: 920.17 (r/w/o: 644.12/184.03/92.02) lat (ms,95%): 35.59 err/s: 0.00 reconn/s: 0.00
[ 9s ] thds: 1 tps: 68.04 qps: 1357.70 (r/w/o: 952.49/269.14/136.07) lat (ms,95%): 18.28 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 1 tps: 60.97 qps: 1217.46 (r/w/o: 852.62/242.89/121.95) lat (ms,95%): 22.69 err/s: 0.00 reconn/s: 0.00
[ 11s ] thds: 1 tps: 53.01 qps: 1051.12 (r/w/o: 733.08/212.02/106.01) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 12s ] thds: 1 tps: 51.01 qps: 1029.15 (r/w/o: 723.11/204.03/102.02) lat (ms,95%): 25.74 err/s: 0.00 reconn/s: 0.00
[ 13s ] thds: 1 tps: 60.99 qps: 1219.80 (r/w/o: 853.86/243.96/121.98) lat (ms,95%): 23.52 err/s: 0.00 reconn/s: 0.00
[ 14s ] thds: 1 tps: 59.01 qps: 1180.10 (r/w/o: 826.07/236.02/118.01) lat (ms,95%): 23.52 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 1 tps: 55.99 qps: 1105.83 (r/w/o: 770.88/223.96/110.98) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
[ 16s ] thds: 1 tps: 60.99 qps: 1238.73 (r/w/o: 867.81/247.95/122.97) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
[ 17s ] thds: 1 tps: 53.01 qps: 1054.15 (r/w/o: 740.10/208.03/106.01) lat (ms,95%): 22.28 err/s: 0.00 reconn/s: 0.00
[ 18s ] thds: 1 tps: 59.02 qps: 1173.43 (r/w/o: 819.30/236.09/118.04) lat (ms,95%): 21.50 err/s: 0.00 reconn/s: 0.00
[ 19s ] thds: 1 tps: 59.95 qps: 1193.10 (r/w/o: 834.37/239.82/118.91) lat (ms,95%): 24.83 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 1 tps: 46.03 qps: 920.65 (r/w/o: 644.46/184.13/92.07) lat (ms,95%): 31.37 err/s: 0.00 reconn/s: 0.00
[ 21s ] thds: 1 tps: 57.00 qps: 1146.03 (r/w/o: 803.02/228.01/115.00) lat (ms,95%): 25.28 err/s: 0.00 reconn/s: 0.00
[ 22s ] thds: 1 tps: 34.99 qps: 712.84 (r/w/o: 498.89/143.97/69.98) lat (ms,95%): 36.89 err/s: 0.00 reconn/s: 0.00
[ 23s ] thds: 1 tps: 49.00 qps: 963.99 (r/w/o: 674.00/192.00/98.00) lat (ms,95%): 31.94 err/s: 0.00 reconn/s: 0.00
[ 24s ] thds: 1 tps: 53.00 qps: 1063.05 (r/w/o: 745.03/212.01/106.00) lat (ms,95%): 26.68 err/s: 0.00 reconn/s: 0.00
[ 25s ] thds: 1 tps: 43.02 qps: 864.31 (r/w/o: 606.22/172.06/86.03) lat (ms,95%): 35.59 err/s: 0.00 reconn/s: 0.00
[ 26s ] thds: 1 tps: 47.98 qps: 951.53 (r/w/o: 663.67/191.91/95.95) lat (ms,95%): 39.65 err/s: 0.00 reconn/s: 0.00
[ 27s ] thds: 1 tps: 49.00 qps: 992.10 (r/w/o: 698.07/196.02/98.01) lat (ms,95%): 28.16 err/s: 0.00 reconn/s: 0.00
[ 28s ] thds: 1 tps: 42.00 qps: 843.00 (r/w/o: 589.00/170.00/84.00) lat (ms,95%): 33.12 err/s: 0.00 reconn/s: 0.00
[ 29s ] thds: 1 tps: 44.01 qps: 875.21 (r/w/o: 613.15/174.04/88.02) lat (ms,95%): 36.89 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 1 tps: 58.00 qps: 1149.97 (r/w/o: 801.98/231.99/116.00) lat (ms,95%): 25.28 err/s: 0.00 reconn/s: 0.00
[ 31s ] thds: 1 tps: 47.00 qps: 951.00 (r/w/o: 669.00/188.00/94.00) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
[ 32s ] thds: 1 tps: 70.99 qps: 1410.80 (r/w/o: 984.86/283.96/141.98) lat (ms,95%): 17.32 err/s: 0.00 reconn/s: 0.00
[ 33s ] thds: 1 tps: 47.96 qps: 966.22 (r/w/o: 678.45/191.85/95.92) lat (ms,95%): 24.83 err/s: 0.00 reconn/s: 0.00
[ 34s ] thds: 1 tps: 53.05 qps: 1056.04 (r/w/o: 737.73/212.21/106.10) lat (ms,95%): 25.28 err/s: 0.00 reconn/s: 0.00
[ 35s ] thds: 1 tps: 58.00 qps: 1161.05 (r/w/o: 813.04/232.01/116.01) lat (ms,95%): 20.37 err/s: 0.00 reconn/s: 0.00
[ 36s ] thds: 1 tps: 44.98 qps: 911.68 (r/w/o: 637.78/183.94/89.97) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 37s ] thds: 1 tps: 64.01 qps: 1265.26 (r/w/o: 885.18/252.05/128.03) lat (ms,95%): 21.11 err/s: 0.00 reconn/s: 0.00
[ 38s ] thds: 1 tps: 53.98 qps: 1094.56 (r/w/o: 766.69/219.91/107.96) lat (ms,95%): 21.11 err/s: 0.00 reconn/s: 0.00
[ 39s ] thds: 1 tps: 56.02 qps: 1112.38 (r/w/o: 780.27/220.08/112.04) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 1 tps: 47.91 qps: 965.28 (r/w/o: 674.79/194.65/95.83) lat (ms,95%): 30.81 err/s: 0.00 reconn/s: 0.00
[ 41s ] thds: 1 tps: 43.07 qps: 862.50 (r/w/o: 603.05/173.30/86.15) lat (ms,95%): 44.17 err/s: 0.00 reconn/s: 0.00
[ 42s ] thds: 1 tps: 48.02 qps: 960.30 (r/w/o: 672.21/192.06/96.03) lat (ms,95%): 31.37 err/s: 0.00 reconn/s: 0.00
[ 43s ] thds: 1 tps: 50.99 qps: 1007.77 (r/w/o: 705.84/199.96/101.98) lat (ms,95%): 51.02 err/s: 0.00 reconn/s: 0.00
[ 44s ] thds: 1 tps: 70.01 qps: 1407.27 (r/w/o: 987.19/280.05/140.03) lat (ms,95%): 21.11 err/s: 0.00 reconn/s: 0.00
[ 45s ] thds: 1 tps: 16.99 qps: 330.88 (r/w/o: 228.92/67.97/33.99) lat (ms,95%): 31.94 err/s: 0.00 reconn/s: 0.00
[ 46s ] thds: 1 tps: 53.99 qps: 1087.87 (r/w/o: 763.91/215.97/107.99) lat (ms,95%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 47s ] thds: 1 tps: 70.01 qps: 1406.22 (r/w/o: 982.16/284.05/140.02) lat (ms,95%): 17.95 err/s: 0.00 reconn/s: 0.00
[ 48s ] thds: 1 tps: 64.92 qps: 1293.34 (r/w/o: 907.84/255.67/129.83) lat (ms,95%): 19.29 err/s: 0.00 reconn/s: 0.00
[ 49s ] thds: 1 tps: 65.11 qps: 1288.11 (r/w/o: 898.47/260.43/129.21) lat (ms,95%): 20.74 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 1 tps: 47.00 qps: 940.96 (r/w/o: 657.97/187.99/95.00) lat (ms,95%): 36.24 err/s: 0.00 reconn/s: 0.00
[ 51s ] thds: 1 tps: 59.98 qps: 1200.69 (r/w/o: 840.79/239.94/119.97) lat (ms,95%): 25.74 err/s: 0.00 reconn/s: 0.00
[ 52s ] thds: 1 tps: 53.00 qps: 1073.10 (r/w/o: 755.07/212.02/106.01) lat (ms,95%): 33.72 err/s: 0.00 reconn/s: 0.00
[ 53s ] thds: 1 tps: 50.99 qps: 1023.87 (r/w/o: 713.91/207.97/101.99) lat (ms,95%): 23.10 err/s: 0.00 reconn/s: 0.00
[ 54s ] thds: 1 tps: 68.02 qps: 1349.32 (r/w/o: 945.22/268.06/136.03) lat (ms,95%): 20.74 err/s: 0.00 reconn/s: 0.00
[ 55s ] thds: 1 tps: 40.00 qps: 811.05 (r/w/o: 567.04/164.01/80.00) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00
[ 56s ] thds: 1 tps: 62.64 qps: 1235.92 (r/w/o: 864.05/246.59/125.28) lat (ms,95%): 21.11 err/s: 0.00 reconn/s: 0.00
[ 57s ] thds: 1 tps: 57.31 qps: 1163.37 (r/w/o: 815.46/233.28/114.63) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
[ 58s ] thds: 1 tps: 35.01 qps: 695.10 (r/w/o: 489.07/136.02/70.01) lat (ms,95%): 65.65 err/s: 0.00 reconn/s: 0.00
[ 59s ] thds: 1 tps: 47.00 qps: 925.98 (r/w/o: 644.99/188.00/93.00) lat (ms,95%): 37.56 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 1 tps: 73.01 qps: 1472.25 (r/w/o: 1033.18/292.05/147.03) lat (ms,95%): 17.95 err/s: 0.00 reconn/s: 0.00
[ 61s ] thds: 1 tps: 27.99 qps: 565.80 (r/w/o: 394.86/114.96/55.98) lat (ms,95%): 74.46 err/s: 0.00 reconn/s: 0.00
[ 62s ] thds: 1 tps: 51.97 qps: 1035.43 (r/w/o: 726.60/204.89/103.94) lat (ms,95%): 29.72 err/s: 0.00 reconn/s: 0.00
[ 63s ] thds: 1 tps: 49.01 qps: 967.25 (r/w/o: 673.17/196.05/98.03) lat (ms,95%): 25.28 err/s: 0.00 reconn/s: 0.00
[ 64s ] thds: 1 tps: 56.00 qps: 1125.07 (r/w/o: 789.05/224.01/112.01) lat (ms,95%): 28.16 err/s: 0.00 reconn/s: 0.00
[ 65s ] thds: 1 tps: 68.02 qps: 1373.49 (r/w/o: 961.34/276.10/136.05) lat (ms,95%): 19.65 err/s: 0.00 reconn/s: 0.00
[ 66s ] thds: 1 tps: 38.00 qps: 746.09 (r/w/o: 522.06/148.02/76.01) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 67s ] thds: 1 tps: 64.00 qps: 1283.08 (r/w/o: 899.06/256.02/128.01) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
[ 68s ] thds: 1 tps: 67.00 qps: 1341.95 (r/w/o: 939.97/267.99/134.00) lat (ms,95%): 17.32 err/s: 0.00 reconn/s: 0.00
[ 69s ] thds: 1 tps: 69.00 qps: 1384.99 (r/w/o: 970.99/276.00/138.00) lat (ms,95%): 17.95 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 1 tps: 59.99 qps: 1203.73 (r/w/o: 839.81/243.94/119.97) lat (ms,95%): 18.95 err/s: 0.00 reconn/s: 0.00
[ 71s ] thds: 1 tps: 70.01 qps: 1400.13 (r/w/o: 980.09/280.03/140.01) lat (ms,95%): 17.95 err/s: 0.00 reconn/s: 0.00
[ 72s ] thds: 1 tps: 70.00 qps: 1382.05 (r/w/o: 966.03/276.01/140.00) lat (ms,95%): 20.74 err/s: 0.00 reconn/s: 0.00
[ 73s ] thds: 1 tps: 69.01 qps: 1394.22 (r/w/o: 980.15/276.04/138.02) lat (ms,95%): 18.61 err/s: 0.00 reconn/s: 0.00
[ 74s ] thds: 1 tps: 55.97 qps: 1111.32 (r/w/o: 775.53/223.86/111.93) lat (ms,95%): 23.10 err/s: 0.00 reconn/s: 0.00
[ 75s ] thds: 1 tps: 62.03 qps: 1242.61 (r/w/o: 870.43/248.12/124.06) lat (ms,95%): 33.12 err/s: 0.00 reconn/s: 0.00
[ 76s ] thds: 1 tps: 55.01 qps: 1110.13 (r/w/o: 776.09/224.03/110.01) lat (ms,95%): 20.37 err/s: 0.00 reconn/s: 0.00
[ 77s ] thds: 1 tps: 62.99 qps: 1241.75 (r/w/o: 867.82/247.95/125.97) lat (ms,95%): 19.65 err/s: 0.00 reconn/s: 0.00
[ 78s ] thds: 1 tps: 58.00 qps: 1177.92 (r/w/o: 825.94/235.98/115.99) lat (ms,95%): 19.29 err/s: 0.00 reconn/s: 0.00
[ 79s ] thds: 1 tps: 70.98 qps: 1411.59 (r/w/o: 989.71/279.92/141.96) lat (ms,95%): 17.95 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 1 tps: 60.03 qps: 1208.69 (r/w/o: 844.49/244.14/120.07) lat (ms,95%): 21.50 err/s: 0.00 reconn/s: 0.00
[ 81s ] thds: 1 tps: 59.87 qps: 1197.42 (r/w/o: 838.19/239.48/119.74) lat (ms,95%): 22.69 err/s: 0.00 reconn/s: 0.00
[ 82s ] thds: 1 tps: 44.10 qps: 874.89 (r/w/o: 614.33/172.37/88.19) lat (ms,95%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 83s ] thds: 1 tps: 47.98 qps: 966.62 (r/w/o: 674.73/195.92/95.96) lat (ms,95%): 25.28 err/s: 0.00 reconn/s: 0.00
[ 84s ] thds: 1 tps: 67.02 qps: 1340.39 (r/w/o: 938.27/268.08/134.04) lat (ms,95%): 17.63 err/s: 0.00 reconn/s: 0.00
[ 85s ] thds: 1 tps: 65.00 qps: 1286.92 (r/w/o: 900.94/255.98/129.99) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
[ 86s ] thds: 1 tps: 62.97 qps: 1270.35 (r/w/o: 890.54/253.87/125.94) lat (ms,95%): 23.10 err/s: 0.00 reconn/s: 0.00
[ 87s ] thds: 1 tps: 74.01 qps: 1482.19 (r/w/o: 1036.13/298.04/148.02) lat (ms,95%): 17.32 err/s: 0.00 reconn/s: 0.00
[ 88s ] thds: 1 tps: 64.01 qps: 1261.27 (r/w/o: 882.19/252.05/127.03) lat (ms,95%): 18.61 err/s: 0.00 reconn/s: 0.00
[ 89s ] thds: 1 tps: 51.01 qps: 1034.16 (r/w/o: 727.11/204.03/103.02) lat (ms,95%): 29.72 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 1 tps: 67.01 qps: 1329.20 (r/w/o: 927.14/268.04/134.02) lat (ms,95%): 19.65 err/s: 0.00 reconn/s: 0.00
[ 91s ] thds: 1 tps: 49.96 qps: 1004.29 (r/w/o: 704.50/199.86/99.93) lat (ms,95%): 29.72 err/s: 0.00 reconn/s: 0.00
[ 92s ] thds: 1 tps: 58.01 qps: 1171.29 (r/w/o: 819.20/236.06/116.03) lat (ms,95%): 21.11 err/s: 0.00 reconn/s: 0.00
[ 93s ] thds: 1 tps: 61.02 qps: 1211.38 (r/w/o: 849.27/240.08/122.04) lat (ms,95%): 22.28 err/s: 0.00 reconn/s: 0.00
[ 94s ] thds: 1 tps: 66.01 qps: 1324.15 (r/w/o: 928.11/264.03/132.01) lat (ms,95%): 18.28 err/s: 0.00 reconn/s: 0.00
[ 95s ] thds: 1 tps: 61.00 qps: 1223.09 (r/w/o: 855.06/246.02/122.01) lat (ms,95%): 20.37 err/s: 0.00 reconn/s: 0.00
[ 96s ] thds: 1 tps: 68.96 qps: 1381.22 (r/w/o: 965.45/277.84/137.92) lat (ms,95%): 19.29 err/s: 0.00 reconn/s: 0.00
[ 97s ] thds: 1 tps: 51.99 qps: 1036.83 (r/w/o: 727.88/204.97/103.98) lat (ms,95%): 20.37 err/s: 0.00 reconn/s: 0.00
[ 98s ] thds: 1 tps: 54.04 qps: 1064.70 (r/w/o: 742.49/215.14/107.07) lat (ms,95%): 17.95 err/s: 0.00 reconn/s: 0.00
[ 99s ] thds: 1 tps: 63.97 qps: 1298.41 (r/w/o: 909.59/259.88/128.94) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 1 tps: 43.00 qps: 859.95 (r/w/o: 601.97/171.99/86.00) lat (ms,95%): 31.37 err/s: 0.00 reconn/s: 0.00
[ 101s ] thds: 1 tps: 60.01 qps: 1190.25 (r/w/o: 834.18/236.05/120.03) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 102s ] thds: 1 tps: 42.01 qps: 844.14 (r/w/o: 592.10/168.03/84.01) lat (ms,95%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 103s ] thds: 1 tps: 63.00 qps: 1266.09 (r/w/o: 884.06/256.02/126.01) lat (ms,95%): 20.74 err/s: 0.00 reconn/s: 0.00
[ 104s ] thds: 1 tps: 39.00 qps: 778.95 (r/w/o: 545.96/154.99/77.99) lat (ms,95%): 52.89 err/s: 0.00 reconn/s: 0.00
[ 105s ] thds: 1 tps: 67.01 qps: 1324.19 (r/w/o: 925.13/265.04/134.02) lat (ms,95%): 23.52 err/s: 0.00 reconn/s: 0.00
[ 106s ] thds: 1 tps: 58.97 qps: 1191.33 (r/w/o: 837.53/235.87/117.93) lat (ms,95%): 36.24 err/s: 0.00 reconn/s: 0.00
[ 107s ] thds: 1 tps: 81.03 qps: 1619.67 (r/w/o: 1133.47/324.13/162.07) lat (ms,95%): 16.12 err/s: 0.00 reconn/s: 0.00
[ 108s ] thds: 1 tps: 61.02 qps: 1218.33 (r/w/o: 852.23/244.07/122.03) lat (ms,95%): 18.61 err/s: 0.00 reconn/s: 0.00
[ 109s ] thds: 1 tps: 55.99 qps: 1127.72 (r/w/o: 787.80/227.94/111.97) lat (ms,95%): 27.66 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 1 tps: 38.99 qps: 766.88 (r/w/o: 536.92/151.98/77.99) lat (ms,95%): 68.05 err/s: 0.00 reconn/s: 0.00
[ 111s ] thds: 1 tps: 53.96 qps: 1092.15 (r/w/o: 764.40/219.83/107.92) lat (ms,95%): 35.59 err/s: 0.00 reconn/s: 0.00
[ 112s ] thds: 1 tps: 31.03 qps: 615.58 (r/w/o: 433.40/120.11/62.06) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00
[ 113s ] thds: 1 tps: 52.00 qps: 1035.95 (r/w/o: 723.96/207.99/103.99) lat (ms,95%): 31.37 err/s: 0.00 reconn/s: 0.00
[ 114s ] thds: 1 tps: 42.00 qps: 848.07 (r/w/o: 593.05/171.01/84.01) lat (ms,95%): 44.98 err/s: 0.00 reconn/s: 0.00
[ 115s ] thds: 1 tps: 50.00 qps: 987.06 (r/w/o: 690.05/197.01/100.01) lat (ms,95%): 29.72 err/s: 0.00 reconn/s: 0.00
[ 116s ] thds: 1 tps: 51.01 qps: 1020.14 (r/w/o: 714.10/204.03/102.01) lat (ms,95%): 28.67 err/s: 0.00 reconn/s: 0.00
[ 117s ] thds: 1 tps: 64.99 qps: 1299.81 (r/w/o: 909.86/259.96/129.98) lat (ms,95%): 20.74 err/s: 0.00 reconn/s: 0.00
[ 118s ] thds: 1 tps: 46.95 qps: 951.03 (r/w/o: 667.32/189.81/93.90) lat (ms,95%): 46.63 err/s: 0.00 reconn/s: 0.00
[ 119s ] thds: 1 tps: 47.03 qps: 935.66 (r/w/o: 655.46/186.13/94.07) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 1 tps: 55.01 qps: 1104.29 (r/w/o: 773.21/221.06/110.03) lat (ms,95%): 25.28 err/s: 0.00 reconn/s: 0.00
[ 121s ] thds: 1 tps: 30.99 qps: 604.81 (r/w/o: 419.87/122.96/61.98) lat (ms,95%): 51.02 err/s: 0.00 reconn/s: 0.00
[ 122s ] thds: 1 tps: 37.02 qps: 750.36 (r/w/o: 528.25/148.07/74.04) lat (ms,95%): 61.08 err/s: 0.00 reconn/s: 0.00
[ 123s ] thds: 1 tps: 41.00 qps: 825.98 (r/w/o: 577.99/166.00/82.00) lat (ms,95%): 39.65 err/s: 0.00 reconn/s: 0.00
[ 124s ] thds: 1 tps: 27.98 qps: 555.59 (r/w/o: 389.71/109.92/55.96) lat (ms,95%): 66.84 err/s: 0.00 reconn/s: 0.00
[ 125s ] thds: 1 tps: 47.03 qps: 946.52 (r/w/o: 660.36/192.10/94.05) lat (ms,95%): 46.63 err/s: 0.00 reconn/s: 0.00
[ 126s ] thds: 1 tps: 59.00 qps: 1162.93 (r/w/o: 812.95/231.99/117.99) lat (ms,95%): 25.28 err/s: 0.00 reconn/s: 0.00
[ 127s ] thds: 1 tps: 36.99 qps: 745.70 (r/w/o: 523.79/147.94/73.97) lat (ms,95%): 36.89 err/s: 0.00 reconn/s: 0.00
[ 128s ] thds: 1 tps: 44.99 qps: 895.88 (r/w/o: 625.92/179.98/89.99) lat (ms,95%): 33.12 err/s: 0.00 reconn/s: 0.00
[ 129s ] thds: 1 tps: 48.03 qps: 974.63 (r/w/o: 683.44/195.13/96.06) lat (ms,95%): 39.65 err/s: 0.00 reconn/s: 0.00
[ 130s ] thds: 1 tps: 42.00 qps: 826.07 (r/w/o: 577.05/165.01/84.01) lat (ms,95%): 45.79 err/s: 0.00 reconn/s: 0.00
[ 131s ] thds: 1 tps: 52.85 qps: 1053.07 (r/w/o: 736.95/211.41/104.71) lat (ms,95%): 37.56 err/s: 0.00 reconn/s: 0.00
[ 132s ] thds: 1 tps: 50.13 qps: 1018.73 (r/w/o: 715.92/201.54/101.27) lat (ms,95%): 33.72 err/s: 0.00 reconn/s: 0.00
[ 133s ] thds: 1 tps: 31.00 qps: 615.02 (r/w/o: 430.02/123.00/62.00) lat (ms,95%): 31.94 err/s: 0.00 reconn/s: 0.00
[ 134s ] thds: 1 tps: 34.00 qps: 673.98 (r/w/o: 469.99/136.00/68.00) lat (ms,95%): 50.11 err/s: 0.00 reconn/s: 0.00
[ 135s ] thds: 1 tps: 26.00 qps: 527.00 (r/w/o: 371.00/104.00/52.00) lat (ms,95%): 147.61 err/s: 0.00 reconn/s: 0.00
[ 136s ] thds: 1 tps: 54.92 qps: 1087.46 (r/w/o: 757.93/219.69/109.84) lat (ms,95%): 29.19 err/s: 0.00 reconn/s: 0.00
[ 137s ] thds: 1 tps: 44.07 qps: 887.51 (r/w/o: 623.06/176.30/88.15) lat (ms,95%): 51.02 err/s: 0.00 reconn/s: 0.00
[ 138s ] thds: 1 tps: 30.99 qps: 631.76 (r/w/o: 441.83/127.95/61.98) lat (ms,95%): 47.47 err/s: 0.00 reconn/s: 0.00
[ 139s ] thds: 1 tps: 44.01 qps: 864.18 (r/w/o: 604.13/172.04/88.02) lat (ms,95%): 66.84 err/s: 0.00 reconn/s: 0.00
[ 140s ] thds: 1 tps: 59.99 qps: 1215.78 (r/w/o: 851.85/243.96/119.98) lat (ms,95%): 26.68 err/s: 0.00 reconn/s: 0.00
[ 141s ] thds: 1 tps: 34.97 qps: 699.40 (r/w/o: 489.58/139.88/69.94) lat (ms,95%): 44.17 err/s: 0.00 reconn/s: 0.00
[ 142s ] thds: 1 tps: 19.97 qps: 399.36 (r/w/o: 279.55/79.87/39.94) lat (ms,95%): 90.78 err/s: 0.00 reconn/s: 0.00
[ 143s ] thds: 1 tps: 62.15 qps: 1238.94 (r/w/o: 870.07/244.58/124.30) lat (ms,95%): 25.74 err/s: 0.00 reconn/s: 0.00
[ 144s ] thds: 1 tps: 54.99 qps: 1103.71 (r/w/o: 769.80/223.94/109.97) lat (ms,95%): 30.26 err/s: 0.00 reconn/s: 0.00
[ 145s ] thds: 1 tps: 17.00 qps: 336.03 (r/w/o: 238.02/64.01/34.00) lat (ms,95%): 16.71 err/s: 0.00 reconn/s: 0.00
[ 146s ] thds: 1 tps: 75.02 qps: 1487.47 (r/w/o: 1037.33/300.09/150.05) lat (ms,95%): 16.71 err/s: 0.00 reconn/s: 0.00
[ 147s ] thds: 1 tps: 45.99 qps: 936.79 (r/w/o: 656.85/187.96/91.98) lat (ms,95%): 15.83 err/s: 0.00 reconn/s: 0.00
[ 148s ] thds: 1 tps: 14.00 qps: 269.99 (r/w/o: 189.99/52.00/28.00) lat (ms,95%): 158.63 err/s: 0.00 reconn/s: 0.00
[ 149s ] thds: 1 tps: 54.01 qps: 1080.14 (r/w/o: 756.10/216.03/108.01) lat (ms,95%): 33.12 err/s: 0.00 reconn/s: 0.00
[ 150s ] thds: 1 tps: 56.00 qps: 1123.97 (r/w/o: 787.98/223.99/112.00) lat (ms,95%): 30.26 err/s: 0.00 reconn/s: 0.00
[ 151s ] thds: 1 tps: 19.96 qps: 405.16 (r/w/o: 281.42/83.83/39.92) lat (ms,95%): 94.10 err/s: 0.00 reconn/s: 0.00
[ 152s ] thds: 1 tps: 22.05 qps: 431.90 (r/w/o: 303.63/84.17/44.09) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00
[ 153s ] thds: 1 tps: 10.97 qps: 228.41 (r/w/o: 158.59/47.88/21.94) lat (ms,95%): 68.05 err/s: 0.00 reconn/s: 0.00
[ 154s ] thds: 1 tps: 36.08 qps: 707.64 (r/w/o: 495.15/140.32/72.17) lat (ms,95%): 97.55 err/s: 0.00 reconn/s: 0.00
[ 155s ] thds: 1 tps: 49.02 qps: 975.47 (r/w/o: 682.33/196.09/97.05) lat (ms,95%): 28.67 err/s: 0.00 reconn/s: 0.00
[ 156s ] thds: 1 tps: 56.98 qps: 1153.57 (r/w/o: 810.70/227.91/114.96) lat (ms,95%): 23.95 err/s: 0.00 reconn/s: 0.00
[ 157s ] thds: 1 tps: 72.02 qps: 1443.50 (r/w/o: 1009.35/290.10/144.05) lat (ms,95%): 17.01 err/s: 0.00 reconn/s: 0.00
[ 158s ] thds: 1 tps: 37.14 qps: 733.03 (r/w/o: 512.14/146.61/74.28) lat (ms,95%): 39.65 err/s: 0.00 reconn/s: 0.00
[ 159s ] thds: 1 tps: 31.70 qps: 631.94 (r/w/o: 441.74/126.80/63.40) lat (ms,95%): 56.84 err/s: 0.00 reconn/s: 0.00
[ 160s ] thds: 1 tps: 40.04 qps: 809.87 (r/w/o: 569.61/160.17/80.09) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00
[ 161s ] thds: 1 tps: 53.97 qps: 1081.43 (r/w/o: 756.60/216.89/107.94) lat (ms,95%): 24.83 err/s: 0.00 reconn/s: 0.00
[ 162s ] thds: 1 tps: 22.00 qps: 430.06 (r/w/o: 299.04/87.01/44.01) lat (ms,95%): 95.81 err/s: 0.00 reconn/s: 0.00
[ 163s ] thds: 1 tps: 58.86 qps: 1190.10 (r/w/o: 832.97/239.42/117.71) lat (ms,95%): 20.37 err/s: 0.00 reconn/s: 0.00
[ 164s ] thds: 1 tps: 56.17 qps: 1119.29 (r/w/o: 786.31/220.65/112.33) lat (ms,95%): 22.28 err/s: 0.00 reconn/s: 0.00
[ 165s ] thds: 1 tps: 43.99 qps: 867.87 (r/w/o: 603.91/175.97/87.99) lat (ms,95%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 166s ] thds: 1 tps: 43.99 qps: 876.89 (r/w/o: 613.92/175.98/86.99) lat (ms,95%): 40.37 err/s: 0.00 reconn/s: 0.00
[ 167s ] thds: 1 tps: 28.00 qps: 578.93 (r/w/o: 405.95/115.99/56.99) lat (ms,95%): 49.21 err/s: 0.00 reconn/s: 0.00
[ 168s ] thds: 1 tps: 49.99 qps: 983.89 (r/w/o: 687.92/195.98/99.99) lat (ms,95%): 35.59 err/s: 0.00 reconn/s: 0.00
[ 169s ] thds: 1 tps: 57.00 qps: 1155.99 (r/w/o: 810.00/232.00/114.00) lat (ms,95%): 26.20 err/s: 0.00 reconn/s: 0.00
[ 170s ] thds: 1 tps: 43.01 qps: 853.11 (r/w/o: 599.08/168.02/86.01) lat (ms,95%): 41.10 err/s: 0.00 reconn/s: 0.00
FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'COMMIT'
FATAL: `thread_run' function failed: /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua:110: db_query() failed
root@mysql-proxy:/home/vagrant#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment