API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2016
113
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.80 KB | None | 0 0
raw download clone embed print report
  1.  
  2. ./run.sh employees.cfg "droptable=true createtable=true poolNumber=56 repeatNumber=1000"
  3. MAIN SECTION
  4. ==============
  5. DeleteClass = com.mysql.stresstool.RunnableQueryDeleteEmployees
  6. InsertClass = com.mysql.stresstool.RunnableQueryInsertEmployees
  7. SelectClass = com.mysql.stresstool.RunnableQuerySelectEmployees
  8. AppendLogReport = true
  9. AppendLogStat = true
  10. ConnUrl = jdbc:mysql://192.168.51.40:3311/test?user=stress_RW&password=test&autoReconnect=true
  11. ConnectString = localhost:1186
  12. Createtable = true
  13. DbType = MySQL
  14. Debug = false
  15. DoBatch = true
  16. DoDelete = true
  17. DoReport = true
  18. DoSimplePk = false
  19. Dolog = false
  20. Droptable = true
  21. ElasticUrl = test1:9300
  22. ErrorLog = /tmp/error_test.log
  23. HasElasticSearch = false
  24. IgnoreBinlog = false
  25. InsertStatHeaders = true
  26. LogPathReport = /tmp/report_.txt
  27. LogPathStatReport = /tmp/reportstat_.txt
  28. LogPathStats = /tmp/stats_.csv
  29. NumberOfIntervalKeys = 10000
  30. NumberOfJoinTables = 1
  31. NumberOfSecondaryTables = 20
  32. NumberOfprimaryTables = 20
  33. OnDuplicateKey = 0
  34. OperationShort = true
  35. PctDelete = 0.0
  36. PctInsert = 100.0
  37. PctSelect = 0.0
  38. PoolNumber = 56
  39. RepeatNumber = 1000
  40. TableEngine = InnoDB
  41. Truncate = false
  42.  
  43. APPLICATION SECTION
  44. ====================
  45. FKEnable = true
  46. selectForceAutocommitOff = true
  47. stikyconnection = true
  48. debug = false
  49. partitionType = range #range or key
  50. yearstart = 2015
  51. monthstart = 4
  52. daystart = 7
  53. daystotal = 90
  54. lazyInterval = 50
  55. numberOfprimaryTables = 20
  56. numberOfSecondaryTables = 20
  57. useAutoIncrement = true
  58. numberOfJoinTables = 1
  59. joinField = emp_no
  60. forceIndex = false
  61. indexName = IDX_a
  62. numberOfIntervalKeys = 10000
  63. selectFilterMethod = match
  64. selectLimit = 1000
  65. sleepWrite = 50
  66. sleepSelect = 100
  67. sleepDelete = 1000
  68. useFK = true
  69. deleterowmaxpct = 0.003
  70. deleterowsinterval = 500
  71. output log =
  72. STARTING ON = 03-08-2016 06:03:03
  73. **** Please wait DROP table tbtest_child1 it could take a LOT of time *******
  74. **** Please wait DROP table tbtest_child2 it could take a LOT of time *******
  75. **** Please wait DROP table tbtest_child3 it could take a LOT of time *******
  76. **** Please wait DROP table tbtest_child4 it could take a LOT of time *******
  77. **** Please wait DROP table tbtest_child5 it could take a LOT of time *******
  78. **** Please wait DROP table tbtest_child6 it could take a LOT of time *******
  79. **** Please wait DROP table tbtest_child7 it could take a LOT of time *******
  80. **** Please wait DROP table tbtest_child8 it could take a LOT of time *******
  81. **** Please wait DROP table tbtest_child9 it could take a LOT of time *******
  82. **** Please wait DROP table tbtest_child10 it could take a LOT of time *******
  83. **** Please wait DROP table tbtest_child11 it could take a LOT of time *******
  84. **** Please wait DROP table tbtest_child12 it could take a LOT of time *******
  85. **** Please wait DROP table tbtest_child13 it could take a LOT of time *******
  86. **** Please wait DROP table tbtest_child14 it could take a LOT of time *******
  87. **** Please wait DROP table tbtest_child15 it could take a LOT of time *******
  88. **** Please wait DROP table tbtest_child16 it could take a LOT of time *******
  89. **** Please wait DROP table tbtest_child17 it could take a LOT of time *******
  90. **** Please wait DROP table tbtest_child18 it could take a LOT of time *******
  91. **** Please wait DROP table tbtest_child19 it could take a LOT of time *******
  92. **** Please wait DROP table tbtest_child20 it could take a LOT of time *******
  93. ****============================================================================*******
  94. **** Please wait DROP table tbtest1 it could take a LOT of time *******
  95. **** Please wait DROP table tbtest2 it could take a LOT of time *******
  96. **** Please wait DROP table tbtest3 it could take a LOT of time *******
  97. **** Please wait DROP table tbtest4 it could take a LOT of time *******
  98. **** Please wait DROP table tbtest5 it could take a LOT of time *******
  99. **** Please wait DROP table tbtest6 it could take a LOT of time *******
  100. **** Please wait DROP table tbtest7 it could take a LOT of time *******
  101. **** Please wait DROP table tbtest8 it could take a LOT of time *******
  102. **** Please wait DROP table tbtest9 it could take a LOT of time *******
  103. **** Please wait DROP table tbtest10 it could take a LOT of time *******
  104. **** Please wait DROP table tbtest11 it could take a LOT of time *******
  105. **** Please wait DROP table tbtest12 it could take a LOT of time *******
  106. **** Please wait DROP table tbtest13 it could take a LOT of time *******
  107. **** Please wait DROP table tbtest14 it could take a LOT of time *******
  108. **** Please wait DROP table tbtest15 it could take a LOT of time *******
  109. **** Please wait DROP table tbtest16 it could take a LOT of time *******
  110. **** Please wait DROP table tbtest17 it could take a LOT of time *******
  111. **** Please wait DROP table tbtest18 it could take a LOT of time *******
  112. **** Please wait DROP table tbtest19 it could take a LOT of time *******
  113. **** Please wait DROP table tbtest20 it could take a LOT of time *******
  114. **** DROP finished *******
  115. ****============================================================================*******
  116.  
  117. Thread to run for Insert:56.0
  118. Thread to run for Select:0.0
  119. Thread to run for Delete:0.0
  120. Class handling Insert :com.mysql.stresstool.RunnableQueryInsertEmployees
  121. Class handling Select :com.mysql.stresstool.RunnableQuerySelectEmployees
  122. Class handling Delete :com.mysql.stresstool.RunnableQueryDeleteEmployees
  123. Starting Insert: 0
  124. Starting Insert: 1
  125. Starting Insert: 2
  126. Starting Insert: 3
  127. Starting Insert: 4
  128. Starting Insert: 5
  129. Starting Insert: 6
  130. Starting Insert: 7
  131. Starting Insert: 8
  132. Starting Insert: 9
  133. Starting Insert: 10
  134. Starting Insert: 11
  135. Starting Insert: 12
  136. Starting Insert: 13
  137. Starting Insert: 14
  138. Starting Insert: 15
  139. Starting Insert: 16
  140. Starting Insert: 17
  141. Starting Insert: 18
  142. Starting Insert: 19
  143. Starting Insert: 20
  144. Starting Insert: 21
  145. Starting Insert: 22
  146. Starting Insert: 23
  147. Starting Insert: 24
  148. Starting Insert: 25
  149. Starting Insert: 26
  150. Starting Insert: 27
  151. Starting Insert: 28
  152. Starting Insert: 29
  153. Starting Insert: 30
  154. Starting Insert: 31
  155. Starting Insert: 32
  156. Starting Insert: 33
  157. Starting Insert: 34
  158. Starting Insert: 35
  159. Starting Insert: 36
  160. Starting Insert: 37
  161. Starting Insert: 38
  162. Starting Insert: 39
  163. Starting Insert: 40
  164. Starting Insert: 41
  165. Starting Insert: 42
  166. Starting Insert: 43
  167. Starting Insert: 44
  168. Starting Insert: 45
  169. Starting Insert: 46
  170. Starting Insert: 47
  171. Starting Insert: 48
  172. Starting Insert: 49
  173. Starting Insert: 50
  174. Starting Insert: 51
  175. Starting Insert: 52
  176. Starting Insert: 53
  177. Starting Insert: 54
  178. Starting Insert: 55
  179. [_____________________________________________________________________________________________________]
  180. [***com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  181.  
  182. The last packet successfully received from the server was 144 milliseconds ago. The last packet sent successfully to the server was 58 milliseconds ago.
  183. at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
  184. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  185. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  186. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  187. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
  188. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3938)
  189. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2551)
  190. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
  191. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
  192. at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5333)
  193. at com.mysql.stresstool.RunnableQueryInsertBasic.run(RunnableQueryInsertBasic.java:235)
  194. at com.mysql.stresstool.RunnableQueryInsertEmployees.run(RunnableQueryInsertEmployees.java:121)
  195. at java.lang.Thread.run(Thread.java:745)
  196. Caused by: java.net.SocketException: Broken pipe
  197. at java.net.SocketOutputStream.socketWrite0(Native Method)
  198. at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
  199. at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
  200. at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
  201. at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
  202. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3919)
  203. ... 7 more
  204. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  205.  
  206. The last packet successfully received from the server was 145 milliseconds ago. The last packet sent successfully to the server was 61 milliseconds ago.
  207. at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
  208. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  209. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  210. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  211. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
  212. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3938)
  213. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2551)
  214. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
  215. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
  216. at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5333)
  217. at com.mysql.stresstool.RunnableQueryInsertBasic.run(RunnableQueryInsertBasic.java:235)
  218. at com.mysql.stresstool.RunnableQueryInsertEmployees.run(RunnableQueryInsertEmployees.java:121)
  219. at java.lang.Thread.run(Thread.java:745)
  220. Caused by: java.net.SocketException: Broken pipe
  221. at java.net.SocketOutputStream.socketWrite0(Native Method)
  222. at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
  223. at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
  224. at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
  225. at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
  226. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3919)
  227. ... 7 more
  228. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  229.  
  230. The last packet successfully received from the server was 356 milliseconds ago. The last packet sent successfully to the server was 61 milliseconds ago.
  231. at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
  232. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  233. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  234. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  235. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
  236. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3938)
  237. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2551)
  238. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
  239. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
  240. at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5333)
  241. at com.mysql.stresstool.RunnableQueryInsertBasic.run(RunnableQueryInsertBasic.java:235)
  242. at com.mysql.stresstool.RunnableQueryInsertEmployees.run(RunnableQueryInsertEmployees.java:121)
  243. at java.lang.Thread.run(Thread.java:745)
  244. Caused by: java.net.SocketException: Broken pipe
  245. at java.net.SocketOutputStream.socketWrite0(Native Method)
  246. at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
  247. at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
  248. at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
  249. at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
  250. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3919)
  251. ... 7 more
  252. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
  253. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  254. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  255. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  256. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  257. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  258. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  259. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
  260. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
  261. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
  262. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
  263. at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:5062)
  264. at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4654)
  265. at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1630)
  266. at com.mysql.stresstool.RunnableQueryInsertBasic.run(RunnableQueryInsertBasic.java:425)
  267. at com.mysql.stresstool.RunnableQueryInsertEmployees.run(RunnableQueryInsertEmployees.java:121)
  268. at java.lang.Thread.run(Thread.java:745)
  269. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
  270. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  271. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  272. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  273. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  274. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  275. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  276. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
  277. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
  278. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
  279. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
  280. at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:5062)
  281. at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4654)
  282. at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1630)
  283. at com.mysql.stresstool.RunnableQueryInsertBasic.run(RunnableQueryInsertBasic.java:425)
  284. at com.mysql.stresstool.RunnableQueryInsertEmployees.run(RunnableQueryInsertEmployees.java:121)
  285. at java.lang.Thread.run(Thread.java:745)
  286. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
  287. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  288. at sun
  289.  
  290.  
  291.  
  292. HID: 500 , address: 192.168.51.21 , port: 3306 , weight: 1000000000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  293. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  294. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  295. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  296. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  297. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  298. HID: 500 , address: 192.168.51.21 , port: 3306 , weight: 1000000000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  299. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  300. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  301. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  302. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  303. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  304. HID: 500 , address: 192.168.51.21 , port: 3306 , weight: 1000000000 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  305. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  306. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  307. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  308. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  309. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  310. 2016-08-03 06:03:22 MySQL_HostGroups_Manager.cpp:356:commit(): [WARNING] Removed server at address 140255745413248, hostgroup 500, address 192.168.51.21 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
  311. HID: 500 , address: 192.168.51.21 , port: 3306 , weight: 1000000000 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  312. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  313. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  314. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  315. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  316. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  317. HID: 500 , address: 192.168.51.21 , port: 3306 , weight: 1000000000 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  318. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  319. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  320. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  321. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  322. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  323. 2016-08-03 06:03:22 MySQL_HostGroups_Manager.cpp:505:generate_mysql_replication_hostgroups_table(): [INFO] New mysql_replication_hostgroups table
  324. writer_hostgroup: 500 , reader_hostgroup: 501
  325. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  326. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  327. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  328. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  329. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  330. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  331. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  332. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  333. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  334. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  335. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  336. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  337. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  338. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  339. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  340. 2016-08-03 06:03:22 MySQL_Session.cpp:1154:handler(): [WARNING] Retrying query.
  341. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  342. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  343. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  344. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  345. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  346. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  347. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  348. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  349. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  350. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  351. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  352. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  353. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  354. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  355. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  356. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  357. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  358. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  359. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  360. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  361. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  362. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  363. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  364. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  365. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  366. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  367. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  368. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  369. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  370. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  371. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  372. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  373. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  374. 2016-08-03 06:03:22 MySQL_Session.cpp:1146:handler(): [ERROR] Detected an offline server during query: 192.168.51.21, 3306
  375. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  376. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  377. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  378. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  379. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  380. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  381. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  382. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  383. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  384. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  385. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  386. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  387. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  388. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  389. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  390. HID: 500 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  391. HID: 501 , address: 192.168.51.23 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  392. HID: 501 , address: 192.168.51.22 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  393. HID: 501 , address: 192.168.51.31 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  394. HID: 501 , address: 192.168.51.32 , port: 3306 , weight: 100 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  395. HID: 501 , address: 192.168.51.21 , port: 3306 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0
  396. 2016-08-03 06:03:23 MySQL_HostGroups_Manager.cpp:505:generate_mysql_replication_hostgroups_table(): [INFO] New mysql_replication_hostgroups table
  397. writer_hostgroup: 500 , reader_hostgroup: 501
  398.  
  399.  
  400. admin@127.0.0.1:am) [(none)]>show global variables;
  401. +----------------------------------------+---------------------------------------+
  402. | Variable_name | Value |
  403. +----------------------------------------+---------------------------------------+
  404. | admin-admin_credentials | admin:admin |
  405. | admin-debug | false |
  406. | admin-mysql_ifaces | 0.0.0.0:3310;/tmp/proxysql_admin.sock |
  407. | admin-read_only | false |
  408. | admin-refresh_interval | 2000 |
  409. | admin-stats_credentials | stats:stats |
  410. | admin-telnet_admin_ifaces | (null) |
  411. | admin-telnet_stats_ifaces | (null) |
  412. | admin-version | 1.2.1_DEBUG |
  413. | mysql-client_found_rows | true |
  414. | mysql-commands_stats | true |
  415. | mysql-connect_retries_delay | 1 |
  416. | mysql-connect_retries_on_failure | 5 |
  417. | mysql-connect_timeout_server | 10000 |
  418. | mysql-connect_timeout_server_max | 10000 |
  419. | mysql-connection_max_age_ms | 0 |
  420. | mysql-default_charset | utf8 |
  421. | mysql-default_max_latency_ms | 1000 |
  422. | mysql-default_query_delay | 0 |
  423. | mysql-default_query_timeout | 36000000 |
  424. | mysql-default_reconnect | true |
  425. | mysql-default_schema | information_schema |
  426. | mysql-enforce_autocommit_on_reads | false |
  427. | mysql-eventslog_filename | |
  428. | mysql-eventslog_filesize | 104857600 |
  429. | mysql-free_connections_pct | 10 |
  430. | mysql-have_compress | true |
  431. | mysql-init_connect | (null) |
  432. | mysql-interfaces | 0.0.0.0:3311;/tmp/proxysql.sock |
  433. | mysql-long_query_time | 1000 |
  434. | mysql-max_allowed_packet | 4194304 |
  435. | mysql-max_connections | 2048 |
  436. | mysql-max_transaction_time | 14400000 |
  437. | mysql-monitor_connect_interval | 200000 |
  438. | mysql-monitor_connect_timeout | 200 |
  439. | mysql-monitor_enabled | true |
  440. | mysql-monitor_history | 120000 |
  441. | mysql-monitor_password | test |
  442. | mysql-monitor_ping_interval | 30000 |
  443. | mysql-monitor_ping_max_failures | 3 |
  444. | mysql-monitor_ping_timeout | 100 |
  445. | mysql-monitor_query_interval | 60000 |
  446. | mysql-monitor_query_timeout | 100 |
  447. | mysql-monitor_read_only_interval | 1000 |
  448. | mysql-monitor_read_only_timeout | 100 |
  449. | mysql-monitor_replication_lag_interval | 10000 |
  450. | mysql-monitor_replication_lag_timeout | 1000 |
  451. | mysql-monitor_username | monitor |
  452. | mysql-monitor_writer_is_also_reader | true |
  453. | mysql-multiplexing | true |
  454. | mysql-ping_interval_server_msec | 10000 |
  455. | mysql-ping_timeout_server | 200 |
  456. | mysql-poll_timeout | 2000 |
  457. | mysql-poll_timeout_on_failure | 100 |
  458. | mysql-query_digests | true |
  459. | mysql-query_retries_on_failure | 1 |
  460. | mysql-server_capabilities | 47626 |
  461. | mysql-server_version | 5.1.30 |
  462. | mysql-servers_stats | true |
  463. | mysql-session_debug | true |
  464. | mysql-sessions_sort | true |
  465. | mysql-shun_on_failures | 5 |
  466. | mysql-shun_recovery_time_sec | 10 |
  467. | mysql-ssl_p2s_ca | (null) |
  468. | mysql-ssl_p2s_cert | (null) |
  469. | mysql-ssl_p2s_cipher | (null) |
  470. | mysql-ssl_p2s_key | (null) |
  471. | mysql-stacksize | 1048576 |
  472. | mysql-threads | 124 |
  473. | mysql-threshold_query_length | 524288 |
  474. | mysql-threshold_resultset_size | 4194304 |
  475. | mysql-wait_timeout | 28800000 |
  476. +----------------------------------------+---------------------------------------+
  477. 72 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!