API tools faq
paste
zergey

Untitled

zergey
Aug 27th, 2016
438
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 37.29 KB | None | 0 0
raw download clone embed print report
  1. mysql> SHOW ENGINE INNODB STATUS\G
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 160827 20:21:51 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 30 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 35469 1_second, 18158 sleeps, 3519 10_second, 286 background, 283 flush
  14. srv_master_thread log flush and writes: 40086
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 1454990, signal count 535276
  19. --Thread 140217710380800 has waited at buf0flu.c line 965 for 0.00 seconds the semaphore:
  20. Mutex at 0x5610a2bcdad8 created file trx0sys.c line 196, lock var 1
  21. waiters flag 1
  22. --Thread 140217671993088 has waited at buf0flu.c line 965 for 0.00 seconds the semaphore:
  23. Mutex at 0x5610a2bcdad8 created file trx0sys.c line 196, lock var 1
  24. waiters flag 1
  25. --Thread 140217665771264 has waited at buf0flu.c line 739 for 0.00 seconds the semaphore:
  26. Mutex at 0x5610a2bcdad8 created file trx0sys.c line 196, lock var 1
  27. waiters flag 1
  28. --Thread 140217640883968 has waited at buf0flu.c line 965 for 0.00 seconds the semaphore:
  29. Mutex at 0x5610a2bcdad8 created file trx0sys.c line 196, lock var 1
  30. waiters flag 1
  31. --Thread 140217652324096 has waited at buf0flu.c line 965 for 0.00 seconds the semaphore:
  32. Mutex at 0x5610a2bcdad8 created file trx0sys.c line 196, lock var 1
  33. waiters flag 1
  34. Mutex spin waits 2001676, rounds 46621202, OS waits 1325937
  35. RW-shared spins 150055, rounds 3644389, OS waits 92410
  36. RW-excl spins 154929, rounds 1801717, OS waits 24146
  37. Spin rounds per wait: 23.29 mutex, 24.29 RW-shared, 11.63 RW-excl
  38. ------------------------
  39. LATEST DETECTED DEADLOCK
  40. ------------------------
  41. 160827 19:00:21
  42. *** (1) TRANSACTION:
  43. TRANSACTION 26A0225B, ACTIVE 1 sec inserting
  44. mysql tables in use 1, locked 1
  45. LOCK WAIT 9 lock struct(s), heap size 1248, 4 row lock(s), undo log entries 5
  46. MySQL thread id 76159, OS thread handle 0x7f86f82ef700, query id 8680738 localhost zabbix update
  47. insert into events (eventid,source,object,objectid,clock,ns,value) values (36612732,3,4,626539,1472313619,365372127,1),(36612733,3,4,630439,1472313619,365223364,1)
  48. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  49. RECORD LOCKS space id 50 page no 263947 n bits 312 index `PRIMARY` of table `zabbix`.`events` trx id 26A0225B lock_mode X insert intention waiting
  50. Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
  51.  0: len 8; hex 73757072656d756d; asc supremum;;
  52.  
  53. *** (2) TRANSACTION:
  54. TRANSACTION 26A0224B, ACTIVE 2 sec inserting
  55. mysql tables in use 1, locked 1
  56. 10 lock struct(s), heap size 1248, 5 row lock(s), undo log entries 5
  57. MySQL thread id 76161, OS thread handle 0x7f86f8bbd700, query id 8681056 localhost zabbix update
  58. insert into events (eventid,source,object,objectid,clock,ns,value) values (36612734,3,4,627618,1472313618,357417449,0),(36612735,3,4,629898,1472313618,364238858,1)
  59. *** (2) HOLDS THE LOCK(S):
  60. RECORD LOCKS space id 50 page no 263947 n bits 312 index `PRIMARY` of table `zabbix`.`events` trx id 26A0224B lock mode S
  61. Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
  62.  0: len 8; hex 73757072656d756d; asc supremum;;
  63.  
  64. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  65. RECORD LOCKS space id 50 page no 263947 n bits 312 index `PRIMARY` of table `zabbix`.`events` trx id 26A0224B lock_mode X insert intention waiting
  66. Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
  67.  0: len 8; hex 73757072656d756d; asc supremum;;
  68.  
  69. *** WE ROLL BACK TRANSACTION (1)
  70. ------------
  71. TRANSACTIONS
  72. ------------
  73. Trx id counter 26A21928
  74. Purge done for trx's n:o < 26A21507 undo n:o < 0
  75. History list length 802
  76. LIST OF TRANSACTIONS FOR EACH SESSION:
  77. ---TRANSACTION 0, not started
  78. MySQL thread id 80492, OS thread handle 0x7f86f5005700, query id 9137672 localhost root
  79. SHOW ENGINE INNODB STATUS
  80. ---TRANSACTION 26A21916, not started
  81. MySQL thread id 80014, OS thread handle 0x7f86f4952700, query id 9137610 localhost zabbix
  82. ---TRANSACTION 26A21329, not started
  83. MySQL thread id 80073, OS thread handle 0x7f86f4dea700, query id 9132669 localhost zabbix
  84. ---TRANSACTION 26A2191A, not started
  85. MySQL thread id 79981, OS thread handle 0x7f86f5592700, query id 9137616 localhost zabbix
  86. ---TRANSACTION 26A21761, not started
  87. MySQL thread id 80071, OS thread handle 0x7f86f5dcd700, query id 9136380 localhost zabbix
  88. ---TRANSACTION 26A211D1, not started
  89. MySQL thread id 79946, OS thread handle 0x7f86f5098700, query id 9131532 localhost zabbix
  90. ---TRANSACTION 26A21197, not started
  91. MySQL thread id 79958, OS thread handle 0x7f86f8010700, query id 9131333 localhost zabbix
  92. ---TRANSACTION 26A2115E, not started
  93. MySQL thread id 79957, OS thread handle 0x7f86f46d5700, query id 9131144 localhost zabbix
  94. ---TRANSACTION 26A2114B, not started
  95. MySQL thread id 79950, OS thread handle 0x7f86f87b8700, query id 9131071 localhost zabbix
  96. ---TRANSACTION 26A21135, not started
  97. MySQL thread id 79967, OS thread handle 0x7f86f4983700, query id 9131027 localhost zabbix
  98. ---TRANSACTION 26A20F96, not started
  99. MySQL thread id 79987, OS thread handle 0x7f86f4611700, query id 9129836 localhost zabbix
  100. ---TRANSACTION 26A20F60, not started
  101. MySQL thread id 80008, OS thread handle 0x7f86f853b700, query id 9129663 localhost zabbix
  102. ---TRANSACTION 26A2135D, not started
  103. MySQL thread id 79951, OS thread handle 0x7f86f6f38700, query id 9132816 localhost zabbix
  104. ---TRANSACTION 26A20F8A, not started
  105. MySQL thread id 79972, OS thread handle 0x7f86f4f10700, query id 9129816 localhost zabbix
  106. ---TRANSACTION 26A20A37, not started
  107. MySQL thread id 79932, OS thread handle 0x7f86f5dfe700, query id 9125496 localhost zabbix
  108. ---TRANSACTION 26A216C3, not started
  109. MySQL thread id 79994, OS thread handle 0x7f86f4e7d700, query id 9135625 localhost zabbix
  110. ---TRANSACTION 26A209CF, not started
  111. MySQL thread id 80102, OS thread handle 0x7f86f4fa3700, query id 9123111 localhost zabbix
  112. ---TRANSACTION 26A20D06, not started
  113. MySQL thread id 80023, OS thread handle 0x7f86f85ce700, query id 9127599 localhost zabbix
  114. ---TRANSACTION 26A20999, not started
  115. MySQL thread id 79954, OS thread handle 0x7f86f4eae700, query id 9122936 localhost zabbix
  116. ---TRANSACTION 26A20954, not started
  117. MySQL thread id 79941, OS thread handle 0x7f86f8105700, query id 9122724 localhost zabbix
  118. ---TRANSACTION 26A2173B, not started
  119. MySQL thread id 80020, OS thread handle 0x7f86f4fd4700, query id 9135972 localhost zabbix
  120. ---TRANSACTION 26A20792, not started
  121. MySQL thread id 80103, OS thread handle 0x7f86f6790700, query id 9121419 localhost zabbix
  122. ---TRANSACTION 26A20CFA, not started
  123. MySQL thread id 79898, OS thread handle 0x7f86f4a16700, query id 9127579 localhost zabbix
  124. ---TRANSACTION 26A2158A, not started
  125. MySQL thread id 80096, OS thread handle 0x7f86f8c50700, query id 9134488 localhost zabbix
  126. ---TRANSACTION 26A20420, not started
  127. MySQL thread id 79971, OS thread handle 0x7f86f8b8c700, query id 9118509 localhost zabbix
  128. ---TRANSACTION 26A2041D, not started
  129. MySQL thread id 79911, OS thread handle 0x7f86f59f9700, query id 9118505 localhost zabbix
  130. ---TRANSACTION 26A20F89, not started
  131. MySQL thread id 79975, OS thread handle 0x7f86f8cb2700, query id 9129814 localhost zabbix
  132. ---TRANSACTION 26A20257, not started
  133. MySQL thread id 80002, OS thread handle 0x7f86f488e700, query id 9116697 localhost zabbix
  134. ---TRANSACTION 26A211A5, not started
  135. MySQL thread id 79902, OS thread handle 0x7f86f70c0700, query id 9131369 localhost zabbix
  136. ---TRANSACTION 26A20242, not started
  137. MySQL thread id 80004, OS thread handle 0x7f86f88de700, query id 9116727 localhost zabbix
  138. ---TRANSACTION 26A21742, not started
  139. MySQL thread id 80006, OS thread handle 0x7f86f8415700, query id 9135983 localhost zabbix
  140. ---TRANSACTION 26A20D21, not started
  141. MySQL thread id 80077, OS thread handle 0x7f86f4f41700, query id 9127658 localhost zabbix
  142. ---TRANSACTION 26A20D94, not started
  143. MySQL thread id 80070, OS thread handle 0x7f86f68b6700, query id 9127970 localhost zabbix
  144. ---TRANSACTION 26A201FC, not started
  145. MySQL thread id 79998, OS thread handle 0x7f86f5c76700, query id 9116690 localhost zabbix
  146. ---TRANSACTION 26A214AF, not started
  147. MySQL thread id 80093, OS thread handle 0x7f86f47ca700, query id 9133821 localhost zabbix
  148. ---TRANSACTION 26A20A30, not started
  149. MySQL thread id 80001, OS thread handle 0x7f86f4aa9700, query id 9125485 localhost zabbix
  150. ---TRANSACTION 26A2175F, not started
  151. MySQL thread id 80026, OS thread handle 0x7f86f7ccf700, query id 9136378 localhost zabbix
  152. ---TRANSACTION 26A214DF, not started
  153. MySQL thread id 80072, OS thread handle 0x7f86f8477700, query id 9133970 localhost zabbix
  154. ---TRANSACTION 26A20F3D, not started
  155. MySQL thread id 80021, OS thread handle 0x7f86f610e700, query id 9129561 localhost zabbix
  156. ---TRANSACTION 26A21310, not started
  157. MySQL thread id 79912, OS thread handle 0x7f86f85ff700, query id 9132577 localhost zabbix
  158. ---TRANSACTION 26A1FE6D, not started
  159. MySQL thread id 79908, OS thread handle 0x7f86f6b33700, query id 9113626 localhost zabbix
  160. ---TRANSACTION 26A214B1, not started
  161. MySQL thread id 80019, OS thread handle 0x7f86f7dc4700, query id 9133823 localhost zabbix
  162. ---TRANSACTION 26A2028D, not started
  163. MySQL thread id 79942, OS thread handle 0x7f86f7b47700, query id 9116777 localhost zabbix
  164. ---TRANSACTION 26A20241, not started
  165. MySQL thread id 79996, OS thread handle 0x7f86f88ad700, query id 9116713 localhost zabbix
  166. ---TRANSACTION 26A210F2, not started
  167. MySQL thread id 79903, OS thread handle 0x7f86f84d9700, query id 9130824 localhost zabbix
  168. ---TRANSACTION 26A1FBF9, not started
  169. MySQL thread id 80016, OS thread handle 0x7f86f52e4700, query id 9107035 localhost zabbix
  170. ---TRANSACTION 26A1FE1F, not started
  171. MySQL thread id 79952, OS thread handle 0x7f86f8a66700, query id 9108512 localhost zabbix
  172. ---TRANSACTION 26A212DC, not started
  173. MySQL thread id 79914, OS thread handle 0x7f86f7f7d700, query id 9132393 localhost zabbix
  174. ---TRANSACTION 26A20605, not started
  175. MySQL thread id 79935, OS thread handle 0x7f86f8136700, query id 9119612 localhost zabbix
  176. ---TRANSACTION 26A1FE62, not started
  177. MySQL thread id 80017, OS thread handle 0x7f86f8630700, query id 9113594 localhost zabbix
  178. ---TRANSACTION 26A1FAFC, not started
  179. MySQL thread id 79896, OS thread handle 0x7f86f5aee700, query id 9106257 localhost zabbix
  180. ---TRANSACTION 26A1FAAE, not started
  181. MySQL thread id 79944, OS thread handle 0x7f86f4c62700, query id 9106063 localhost zabbix
  182. ---TRANSACTION 26A209A3, not started
  183. MySQL thread id 79923, OS thread handle 0x7f86f7e88700, query id 9122971 localhost zabbix
  184. ---TRANSACTION 26A201E8, not started
  185. MySQL thread id 80000, OS thread handle 0x7f86f8ac8700, query id 9116448 localhost zabbix
  186. ---TRANSACTION 26A20DFF, not started
  187. MySQL thread id 79977, OS thread handle 0x7f86f59c8700, query id 9128329 localhost zabbix
  188. ---TRANSACTION 26A205A2, not started
  189. MySQL thread id 79937, OS thread handle 0x7f86f604a700, query id 9119435 localhost zabbix
  190. ---TRANSACTION 26A1FE52, not started
  191. MySQL thread id 79973, OS thread handle 0x7f86f6bc6700, query id 9108609 localhost zabbix
  192. ---TRANSACTION 26A1F718, not started
  193. MySQL thread id 79918, OS thread handle 0x7f86f82be700, query id 9102220 localhost zabbix
  194. ---TRANSACTION 26A20DA8, not started
  195. MySQL thread id 79997, OS thread handle 0x7f86f83e4700, query id 9128037 localhost zabbix
  196. ---TRANSACTION 26A218F6, not started
  197. MySQL thread id 79992, OS thread handle 0x7f86f4a78700, query id 9137561 localhost zabbix
  198. ---TRANSACTION 26A20F3F, not started
  199. MySQL thread id 79993, OS thread handle 0x7f86f8351700, query id 9129564 localhost zabbix
  200. ---TRANSACTION 26A1F558, not started
  201. MySQL thread id 79965, OS thread handle 0x7f86f7401700, query id 9096439 localhost zabbix
  202. ---TRANSACTION 26A201F4, not started
  203. MySQL thread id 80033, OS thread handle 0x7f86f8167700, query id 9116677 localhost zabbix
  204. ---TRANSACTION 26A201F5, not started
  205. MySQL thread id 80031, OS thread handle 0x7f86f5cd8700, query id 9116674 localhost zabbix
  206. ---TRANSACTION 26A21728, not started
  207. MySQL thread id 80003, OS thread handle 0x7f86f64b1700, query id 9135913 localhost zabbix
  208. ---TRANSACTION 26A2010E, not started
  209. MySQL thread id 80007, OS thread handle 0x7f86f77a4700, query id 9115850 localhost zabbix
  210. ---TRANSACTION 26A1FE69, not started
  211. MySQL thread id 80074, OS thread handle 0x7f86f549d700, query id 9113616 localhost zabbix
  212. ---TRANSACTION 26A1F4FD, not started
  213. MySQL thread id 79961, OS thread handle 0x7f86f6ea5700, query id 9096158 localhost zabbix
  214. ---TRANSACTION 26A20604, not started
  215. MySQL thread id 79947, OS thread handle 0x7f86f6fcb700, query id 9119608 localhost zabbix
  216. ---TRANSACTION 26A2173E, not started
  217. MySQL thread id 80032, OS thread handle 0x7f86f57de700, query id 9135978 localhost zabbix
  218. ---TRANSACTION 26A213C9, not started
  219. MySQL thread id 79928, OS thread handle 0x7f86f7d31700, query id 9133108 localhost zabbix
  220. ---TRANSACTION 26A20393, not started
  221. MySQL thread id 79927, OS thread handle 0x7f86f47fb700, query id 9117670 localhost zabbix
  222. ---TRANSACTION 26A1F448, not started
  223. MySQL thread id 80027, OS thread handle 0x7f86f4d88700, query id 9095616 localhost zabbix
  224. ---TRANSACTION 26A20D00, not started
  225. MySQL thread id 80030, OS thread handle 0x7f86f80d4700, query id 9127593 localhost zabbix
  226. ---TRANSACTION 26A21918, not started
  227. MySQL thread id 80009, OS thread handle 0x7f86f49e5700, query id 9137614 localhost zabbix
  228. ---TRANSACTION 26A1FAEA, not started
  229. MySQL thread id 79931, OS thread handle 0x7f86f5a5b700, query id 9106228 localhost zabbix
  230. ---TRANSACTION 26A20401, not started
  231. MySQL thread id 79920, OS thread handle 0x7f86f5a8c700, query id 9118391 localhost zabbix
  232. ---TRANSACTION 26A20A56, not started
  233. MySQL thread id 79922, OS thread handle 0x7f86f7fdf700, query id 9125614 localhost zabbix
  234. ---TRANSACTION 26A20219, not started
  235. MySQL thread id 80012, OS thread handle 0x7f86f5220700, query id 9116680 localhost zabbix
  236. ---TRANSACTION 26A2173C, not started
  237. MySQL thread id 79999, OS thread handle 0x7f86f89d3700, query id 9135975 localhost zabbix
  238. ---TRANSACTION 26A217E8, not started
  239. MySQL thread id 80022, OS thread handle 0x7f86f4d57700, query id 9136809 localhost zabbix
  240. ---TRANSACTION 26A215C0, not started
  241. MySQL thread id 79991, OS thread handle 0x7f86f8756700, query id 9134851 localhost zabbix
  242. ---TRANSACTION 26A1FFC8, not started
  243. MySQL thread id 79930, OS thread handle 0x7f86f638b700, query id 9114860 localhost zabbix
  244. ---TRANSACTION 26A218A7, not started
  245. MySQL thread id 79904, OS thread handle 0x7f86f4a47700, query id 9137323 localhost zabbix
  246. ---TRANSACTION 26A1F100, not started
  247. MySQL thread id 79933, OS thread handle 0x7f86f7742700, query id 9093283 localhost zabbix
  248. ---TRANSACTION 26A21755, not started
  249. MySQL thread id 80010, OS thread handle 0x7f86f4e4c700, query id 9136054 localhost zabbix
  250. ---TRANSACTION 26A1F0DB, not started
  251. MySQL thread id 79943, OS thread handle 0x7f86f5b50700, query id 9093217 localhost zabbix
  252. ---TRANSACTION 26A214EF, not started
  253. MySQL thread id 80143, OS thread handle 0x7f86f515c700, query id 9134053 localhost zabbix
  254. ---TRANSACTION 26A1F052, not started
  255. MySQL thread id 80011, OS thread handle 0x7f86f5282700, query id 9092972 localhost zabbix
  256. ---TRANSACTION 26A2006E, not started
  257. MySQL thread id 79980, OS thread handle 0x7f86f55f4700, query id 9115529 localhost zabbix
  258. ---TRANSACTION 26A1F0DC, not started
  259. MySQL thread id 79913, OS thread handle 0x7f86f8661700, query id 9093222 localhost zabbix
  260. ---TRANSACTION 26A1F028, not started
  261. MySQL thread id 79995, OS thread handle 0x7f86f7d93700, query id 9092891 localhost zabbix
  262. ---TRANSACTION 26A20222, not started
  263. MySQL thread id 79989, OS thread handle 0x7f86f881a700, query id 9116691 localhost zabbix
  264. ---TRANSACTION 26A212F1, not started
  265. MySQL thread id 79982, OS thread handle 0x7f86f4768700, query id 9132469 localhost zabbix
  266. ---TRANSACTION 26A1F862, not started
  267. MySQL thread id 79986, OS thread handle 0x7f86f518d700, query id 9103195 localhost zabbix
  268. ---TRANSACTION 26A1FF9C, not started
  269. MySQL thread id 79976, OS thread handle 0x7f86f80a3700, query id 9114526 localhost zabbix
  270. ---TRANSACTION 26A21756, not started
  271. MySQL thread id 79978, OS thread handle 0x7f86f4b9e700, query id 9136058 localhost zabbix
  272. ---TRANSACTION 26A20A89, not started
  273. MySQL thread id 79966, OS thread handle 0x7f86f65a6700, query id 9125773 localhost zabbix
  274. ---TRANSACTION 26A20CD3, not started
  275. MySQL thread id 79910, OS thread handle 0x7f86f5c45700, query id 9127499 localhost zabbix
  276. ---TRANSACTION 26A1EE72, not started
  277. MySQL thread id 79985, OS thread handle 0x7f86f48f0700, query id 9091760 localhost zabbix
  278. ---TRANSACTION 26A20218, not started
  279. MySQL thread id 79963, OS thread handle 0x7f86f485d700, query id 9116682 localhost zabbix
  280. ---TRANSACTION 26A21786, not started
  281. MySQL thread id 79949, OS thread handle 0x7f86f4cc4700, query id 9136501 localhost zabbix
  282. ---TRANSACTION 26A1FE53, not started
  283. MySQL thread id 79945, OS thread handle 0x7f86f4db9700, query id 9108612 localhost zabbix
  284. ---TRANSACTION 26A1EE5C, not started
  285. MySQL thread id 79956, OS thread handle 0x7f86f850a700, query id 9091380 localhost zabbix
  286. ---TRANSACTION 26A202C3, not started
  287. MySQL thread id 79917, OS thread handle 0x7f86f7f1b700, query id 9117069 localhost zabbix
  288. ---TRANSACTION 26A1FE80, not started
  289. MySQL thread id 79974, OS thread handle 0x7f86f87e9700, query id 9113660 localhost zabbix
  290. ---TRANSACTION 26A209AF, not started
  291. MySQL thread id 80097, OS thread handle 0x7f86f4737700, query id 9122991 localhost zabbix
  292. ---TRANSACTION 26A21121, not started
  293. MySQL thread id 79915, OS thread handle 0x7f86f7d62700, query id 9130952 localhost zabbix
  294. ---TRANSACTION 26A203E6, not started
  295. MySQL thread id 79960, OS thread handle 0x7f86f58d3700, query id 9118314 localhost zabbix
  296. ---TRANSACTION 26A2022B, not started
  297. MySQL thread id 79953, OS thread handle 0x7f86f571a700, query id 9116695 localhost zabbix
  298. ---TRANSACTION 26A1FAA3, not started
  299. MySQL thread id 80025, OS thread handle 0x7f86f79bf700, query id 9106028 localhost zabbix
  300. ---TRANSACTION 26A20DAB, not started
  301. MySQL thread id 79964, OS thread handle 0x7f86f56e9700, query id 9128047 localhost zabbix
  302. ---TRANSACTION 26A1FC6C, not started
  303. MySQL thread id 79955, OS thread handle 0x7f86f83b3700, query id 9107390 localhost zabbix
  304. ---TRANSACTION 26A20B66, not started
  305. MySQL thread id 79925, OS thread handle 0x7f86f8725700, query id 9126444 localhost zabbix
  306. ---TRANSACTION 26A214AE, not started
  307. MySQL thread id 79907, OS thread handle 0x7f86f822b700, query id 9133818 localhost zabbix
  308. ---TRANSACTION 26A1F941, not started
  309. MySQL thread id 80015, OS thread handle 0x7f86f7e26700, query id 9105128 localhost zabbix
  310. ---TRANSACTION 26A20D0D, not started
  311. MySQL thread id 80090, OS thread handle 0x7f86f8a04700, query id 9127606 localhost zabbix
  312. ---TRANSACTION 26A1EDC8, not started
  313. MySQL thread id 80018, OS thread handle 0x7f86f8940700, query id 9090019 localhost zabbix
  314. ---TRANSACTION 26A1FFAF, not started
  315. MySQL thread id 80048, OS thread handle 0x7f86f4f72700, query id 9134523 localhost zabbix
  316. ---TRANSACTION 26A1FFB2, not started
  317. MySQL thread id 80047, OS thread handle 0x7f86f5be3700, query id 9134529 localhost zabbix
  318. ---TRANSACTION 26A1FFBE, not started
  319. MySQL thread id 80050, OS thread handle 0x7f86f8692700, query id 9134537 localhost zabbix
  320. ---TRANSACTION 26A1FFB9, not started
  321. MySQL thread id 80046, OS thread handle 0x7f86f7eea700, query id 9134525 localhost zabbix
  322. ---TRANSACTION 26A1FFA6, not started
  323. MySQL thread id 80051, OS thread handle 0x7f86f890f700, query id 9134494 localhost zabbix
  324. ---TRANSACTION 26A1FFA7, not started
  325. MySQL thread id 80044, OS thread handle 0x7f86f8198700, query id 9134491 localhost zabbix
  326. ---TRANSACTION 26A1FFBF, not started
  327. MySQL thread id 80049, OS thread handle 0x7f86f86f4700, query id 9134533 localhost zabbix
  328. ---TRANSACTION 26A1FFAA, not started
  329. MySQL thread id 80045, OS thread handle 0x7f86f8787700, query id 9134493 localhost zabbix
  330. ---TRANSACTION 26A1FFC2, not started
  331. MySQL thread id 80042, OS thread handle 0x7f86f7a21700, query id 9134536 localhost zabbix
  332. ---TRANSACTION 26A1FFAC, not started
  333. MySQL thread id 80040, OS thread handle 0x7f86f5530700, query id 9134496 localhost zabbix
  334. ---TRANSACTION 26A1FFB8, not started
  335. MySQL thread id 80043, OS thread handle 0x7f86f45e0700, query id 9134531 localhost zabbix
  336. ---TRANSACTION 26A1FFAE, not started
  337. MySQL thread id 80041, OS thread handle 0x7f86f8af9700, query id 9134500 localhost zabbix
  338. ---TRANSACTION 26A1FFB6, not started
  339. MySQL thread id 80039, OS thread handle 0x7f86f6a0d700, query id 9134498 localhost zabbix
  340. ---TRANSACTION 26A1FFBC, not started
  341. MySQL thread id 80038, OS thread handle 0x7f86f8bee700, query id 9134528 localhost zabbix
  342. ---TRANSACTION 26A2158B, not started
  343. MySQL thread id 80037, OS thread handle 0x7f86f7e57700, query id 9134507 localhost zabbix
  344. ---TRANSACTION 26A1FAED, not started
  345. MySQL thread id 79899, OS thread handle 0x7f86f8b2a700, query id 9106232 localhost zabbix
  346. ---TRANSACTION 26A211A6, not started
  347. MySQL thread id 79979, OS thread handle 0x7f86f7df5700, query id 9131372 localhost zabbix
  348. ---TRANSACTION 26A1F7E6, not started
  349. MySQL thread id 79916, OS thread handle 0x7f86f8bbd700, query id 9102810 localhost zabbix
  350. ---TRANSACTION 26A21494, not started
  351. MySQL thread id 80099, OS thread handle 0x7f86f4673700, query id 9133770 localhost zabbix
  352. ---TRANSACTION 26A214A0, not started
  353. MySQL thread id 80100, OS thread handle 0x7f86f5904700, query id 9133794 localhost zabbix
  354. ---TRANSACTION 26A21496, not started
  355. MySQL thread id 80094, OS thread handle 0x7f86f8c81700, query id 9133777 localhost zabbix
  356. ---TRANSACTION 26A21495, not started
  357. MySQL thread id 80095, OS thread handle 0x7f86f8041700, query id 9133771 localhost zabbix
  358. ---TRANSACTION 26A2149C, not started
  359. MySQL thread id 80089, OS thread handle 0x7f86f5561700, query id 9133786 localhost zabbix
  360. ---TRANSACTION 26A2149F, not started
  361. MySQL thread id 80086, OS thread handle 0x7f86f7c9e700, query id 9133793 localhost zabbix
  362. ---TRANSACTION 26A21499, not started
  363. MySQL thread id 80084, OS thread handle 0x7f86f78ca700, query id 9133781 localhost zabbix
  364. ---TRANSACTION 26A2149A, not started
  365. MySQL thread id 80098, OS thread handle 0x7f86f6e74700, query id 9133779 localhost zabbix
  366. ---TRANSACTION 26A21497, not started
  367. MySQL thread id 80088, OS thread handle 0x7f86f8b5b700, query id 9133778 localhost zabbix
  368. ---TRANSACTION 26A2149E, not started
  369. MySQL thread id 80092, OS thread handle 0x7f86f86c3700, query id 9133790 localhost zabbix
  370. ---TRANSACTION 26A2149D, not started
  371. MySQL thread id 80082, OS thread handle 0x7f86f7773700, query id 9133788 localhost zabbix
  372. ---TRANSACTION 26A214A2, not started
  373. MySQL thread id 80083, OS thread handle 0x7f86f5346700, query id 9133797 localhost zabbix
  374. ---TRANSACTION 26A214A1, not started
  375. MySQL thread id 80091, OS thread handle 0x7f86f8ce3700, query id 9133796 localhost zabbix
  376. ---TRANSACTION 26A2149B, not started
  377. MySQL thread id 80087, OS thread handle 0x7f86f7837700, query id 9133795 localhost zabbix
  378. ---TRANSACTION 26A21493, not started
  379. MySQL thread id 80085, OS thread handle 0x7f86f5067700, query id 9133767 localhost zabbix
  380. ---TRANSACTION 26A21498, not started
  381. MySQL thread id 80078, OS thread handle 0x7f86f6608700, query id 9133780 localhost zabbix
  382. ---TRANSACTION 26A21720, not started
  383. MySQL thread id 80076, OS thread handle 0x7f86f5d9c700, query id 9135892 localhost zabbix
  384. ---TRANSACTION 26A2148F, not started
  385. MySQL thread id 80081, OS thread handle 0x7f86f4e1b700, query id 9133758 localhost zabbix
  386. ---TRANSACTION 26A21491, not started
  387. MySQL thread id 80080, OS thread handle 0x7f86f4d26700, query id 9133764 localhost zabbix
  388. ---TRANSACTION 26A2148C, not started
  389. MySQL thread id 80069, OS thread handle 0x7f86f74c5700, query id 9133762 localhost zabbix
  390. ---TRANSACTION 26A21490, not started
  391. MySQL thread id 80068, OS thread handle 0x7f86f4921700, query id 9133760 localhost zabbix
  392. ---TRANSACTION 26A2148D, not started
  393. MySQL thread id 80066, OS thread handle 0x7f86f580f700, query id 9133761 localhost zabbix
  394. ---TRANSACTION 26A2148E, not started
  395. MySQL thread id 80063, OS thread handle 0x7f86f50c9700, query id 9133759 localhost zabbix
  396. ---TRANSACTION 26A21492, not started
  397. MySQL thread id 80064, OS thread handle 0x7f86f72aa700, query id 9133766 localhost zabbix
  398. ---TRANSACTION 26A2148B, not started
  399. MySQL thread id 80062, OS thread handle 0x7f86f69dc700, query id 9133751 localhost zabbix
  400. ---TRANSACTION 26A21927, not started
  401. MySQL thread id 80058, OS thread handle 0x7f86f53d9700, query id 9137671 localhost zabbix
  402. ---TRANSACTION 26A217B2, not started
  403. MySQL thread id 80053, OS thread handle 0x7f86f5d6b700, query id 9136635 localhost zabbix
  404. ---TRANSACTION 26A218FC, not started
  405. MySQL thread id 80052, OS thread handle 0x7f86f8320700, query id 9137566 localhost zabbix
  406. ---TRANSACTION 26A215BF, not started
  407. MySQL thread id 80035, OS thread handle 0x7f86f4bcf700, query id 9137043 localhost zabbix
  408. ---TRANSACTION 26A21841, not started
  409. MySQL thread id 80029, OS thread handle 0x7f86f8a35700, query id 9136912 localhost zabbix
  410. ---TRANSACTION 26A217B6, not started
  411. MySQL thread id 80028, OS thread handle 0x7f86f7153700, query id 9136641 localhost zabbix
  412. ---TRANSACTION 269F3316, not started
  413. MySQL thread id 73593, OS thread handle 0x7f86f64e2700, query id 8461140 localhost zabbix
  414. ---TRANSACTION 26A21914, ACTIVE 2 sec starting index read
  415. mysql tables in use 1, locked 1
  416. LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s)
  417. MySQL thread id 80491, OS thread handle 0x7f86f77d5700, query id 9137604 localhost debian-sys-maint Updating
  418. UPDATE profiles SET value_id='518', type=1 WHERE userid=3 AND idx='web.screens.graphid'
  419. ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED:
  420. RECORD LOCKS space id 106 page no 10 n bits 352 index `profiles_1` of table `zabbix`.`profiles` trx id 26A21914 lock_mode X waiting
  421. Record lock, heap no 142 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
  422. 0: len 8; hex 0000000000000003; asc         ;;
  423. 1: len 19; hex 7765622e73637265656e732e67726170686964; asc web.screens.graphid;;
  424. 2: len 8; hex 0000000000000000; asc         ;;
  425. 3: len 8; hex 0000000000000143; asc        C;;
  426.  
  427. ------------------
  428. ---TRANSACTION 26A215A3, ACTIVE 19 sec starting index read
  429. mysql tables in use 1, locked 1
  430. LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s)
  431. MySQL thread id 80469, OS thread handle 0x7f86f8072700, query id 9134587 localhost debian-sys-maint Updating
  432. UPDATE profiles SET value_id='519', type=1 WHERE userid=3 AND idx='web.screens.graphid'
  433. ------- TRX HAS BEEN WAITING 19 SEC FOR THIS LOCK TO BE GRANTED:
  434. RECORD LOCKS space id 106 page no 10 n bits 352 index `profiles_1` of table `zabbix`.`profiles` trx id 26A215A3 lock_mode X waiting
  435. Record lock, heap no 142 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
  436. 0: len 8; hex 0000000000000003; asc         ;;
  437. 1: len 19; hex 7765622e73637265656e732e67726170686964; asc web.screens.graphid;;
  438. 2: len 8; hex 0000000000000000; asc         ;;
  439. 3: len 8; hex 0000000000000143; asc        C;;
  440.  
  441. ------------------
  442. ---TRANSACTION 26A211CE, ACTIVE 50 sec updating or deleting
  443. mysql tables in use 1, locked 1
  444. 3 lock struct(s), heap size 1248, 2 row lock(s)
  445. MySQL thread id 80438, OS thread handle 0x7f86f6ad1700, query id 9131528 localhost debian-sys-maint Updating
  446. UPDATE profiles SET value_id='519', type=1 WHERE userid=3 AND idx='web.screens.graphid'
  447. ---TRANSACTION 26A20E2A, ACTIVE 78 sec inserting
  448. mysql tables in use 1, locked 1
  449. 2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 287
  450. MySQL thread id 80056, OS thread handle 0x7f86f5f24700, query id 9128663 localhost zabbix update
  451. insert into history_uint (itemid,clock,ns,value) values (612946,1472318196,786259992,0),(29306,1472318196,787040827,49812408),(559732,1472318220,303707549,0),(559733,1472318220,303707549,0),(584746,1472318220,308785770,0),(175855,1472318220,308785770,0),(175856,1472318220,308785770,0),(175857,1472318220,308785770,0),(175858,1472318220,313286746,0),(175677,1472318220,661455364,0),(175679,1472318220,661455364,0),(175678,1472318220,661455364,0),(175680,1472318220,661455364,0),(175681,1472318220,661455364,0),(175682,1472318220,661455364,0),(609264,1472318221,189665406,1),(609269,1472318221,1896654
  452. ---TRANSACTION 26A20E01, ACTIVE 78 sec inserting
  453. mysql tables in use 1, locked 1
  454. 2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 485
  455. MySQL thread id 80057, OS thread handle 0x7f86f887c700, query id 9128464 localhost zabbix update
  456. insert into history_uint (itemid,clock,ns,value) values (613852,1472318231,593171647,1),(605309,1472318231,615330949,1),(605530,1472318231,615330949,1),(605419,1472318231,615330949,1),(605501,1472318231,615330949,1),(611474,1472318231,763351082,1),(604942,1472318231,784303163,1),(604915,1472318231,784303163,1),(604924,1472318231,784303163,1),(604742,1472318231,796655862,1),(604893,1472318231,796655862,1),(590846,1472318231,796655862,1),(590819,1472318231,796655862,1),(627111,1472318231,807730100,1),(626783,1472318231,811385707,1),(626022,1472318231,811385707,1),(623366,1472318231,811385707,1),
  457. ---TRANSACTION 26A207A4, ACTIVE 135 sec inserting
  458. mysql tables in use 1, locked 1
  459. 2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 682
  460. MySQL thread id 80055, OS thread handle 0x7f86f75ba700, query id 9121708 localhost zabbix update
  461. insert into history_uint (itemid,clock,ns,value) values (190409,1472318178,198874987,0),(190410,1472318178,198874987,0),(190411,1472318178,200838249,0),(190412,1472318178,200838249,0),(612651,1472318181,745700964,0),(612652,1472318181,747099692,0),(612653,1472318181,748548707,0),(612654,1472318181,749984661,0),(612655,1472318181,751440730,0),(612656,1472318181,752839528,0),(612657,1472318181,885365464,0),(612658,1472318181,885365464,0),(612659,1472318181,886836548,0),(612660,1472318181,886836548,0),(612642,1472318181,888332776,0),(612661,1472318181,888332776,0),(612662,1472318181,889729410,0),
  462. ---TRANSACTION 26A20399, ACTIVE 170 sec inserting
  463. mysql tables in use 1, locked 1
  464. 12 lock struct(s), heap size 1248, 7 row lock(s), undo log entries 782
  465. MySQL thread id 80054, OS thread handle 0x7f86f828d700, query id 9136373 localhost zabbix update
  466. insert into events (eventid,source,object,objectid,clock,ns,value) values (36629156,3,4,616609,1472318209,121223372,0),(36629157,3,4,621411,1472318211,992448245,1),(36629158,3,4,621710,1472318210,844336407,1),(36629159,3,4,628012,1472318212,999319106,0),(36629160,3,4,628370,1472318210,834254136,1),(36629161,3,4,628850,1472318210,685512534,1),(36629162,3,4,629209,1472318209,32219142,0)
  467. Trx read view will not see trx with id >= 26A2175D, sees < 26A207A4
  468. --------
  469. FILE I/O
  470. --------
  471. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  472. I/O thread 1 state: waiting for completed aio requests (log thread)
  473. I/O thread 2 state: waiting for completed aio requests (read thread)
  474. I/O thread 3 state: waiting for completed aio requests (read thread)
  475. I/O thread 4 state: waiting for completed aio requests (read thread)
  476. I/O thread 5 state: waiting for completed aio requests (read thread)
  477. I/O thread 6 state: waiting for completed aio requests (read thread)
  478. I/O thread 7 state: waiting for completed aio requests (read thread)
  479. I/O thread 8 state: waiting for completed aio requests (read thread)
  480. I/O thread 9 state: waiting for completed aio requests (read thread)
  481. I/O thread 10 state: waiting for completed aio requests (write thread)
  482. I/O thread 11 state: waiting for completed aio requests (write thread)
  483. I/O thread 12 state: waiting for completed aio requests (write thread)
  484. I/O thread 13 state: waiting for completed aio requests (write thread)
  485. I/O thread 14 state: waiting for completed aio requests (write thread)
  486. I/O thread 15 state: waiting for completed aio requests (write thread)
  487. I/O thread 16 state: waiting for completed aio requests (write thread)
  488. I/O thread 17 state: waiting for completed aio requests (write thread)
  489. Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0] ,
  490. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  491. Pending flushes (fsync) log: 0; buffer pool: 1
  492. 935139 OS file reads, 4346218 OS file writes, 694136 OS fsyncs
  493. 0.00 reads/s, 0 avg bytes/read, 47.57 writes/s, 3.63 fsyncs/s
  494. -------------------------------------
  495. INSERT BUFFER AND ADAPTIVE HASH INDEX
  496. -------------------------------------
  497. Ibuf: size 1, free list len 11547, seg size 11549, 35973 merges
  498. merged operations:
  499. insert 115357, delete mark 77, delete 33
  500. discarded operations:
  501. insert 0, delete mark 0, delete 0
  502. Hash table size 18923039, node heap has 5388 buffer(s)
  503. 15844.87 hash searches/s, 3119.66 non-hash searches/s
  504. ---
  505. LOG
  506. ---
  507. Log sequence number 1221403988044
  508. Log flushed up to   1221403985455
  509. Last checkpoint at  1221396927851
  510. 0 pending log writes, 0 pending chkp writes
  511. 47304 log i/o's done, 0.50 log i/o's/second
  512. ----------------------
  513. BUFFER POOL AND MEMORY
  514. ----------------------
  515. Total memory allocated 8791228416; in additional pool allocated 0
  516. Dictionary memory allocated 902876
  517. Buffer pool size   524280
  518. Free buffers       4
  519. Database pages     518888
  520. Old database pages 191419
  521. Modified db pages  15454
  522. Pending reads 0
  523. Pending writes: LRU 0, flush list 10, single page 0
  524. Pages made young 492228, not young 0
  525. 0.00 youngs/s, 0.00 non-youngs/s
  526. Pages read 934686, created 32411, written 4003563
  527. 0.00 reads/s, 0.07 creates/s, 45.53 writes/s
  528. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  529. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  530. LRU len: 518888, unzip_LRU len: 0
  531. I/O sum[15564]:cur[24], unzip sum[0]:cur[0]
  532. ----------------------
  533. INDIVIDUAL BUFFER POOL INFO
  534. ----------------------
  535. ---BUFFER POOL 0
  536. Buffer pool size   87380
  537. Free buffers       1
  538. Database pages     86484
  539. Old database pages 31904
  540. Modified db pages  2471
  541. Pending reads 0
  542. Pending writes: LRU 0, flush list 1, single page 0
  543. Pages made young 80927, not young 0
  544. 0.00 youngs/s, 0.00 non-youngs/s
  545. Pages read 155253, created 5696, written 664363
  546. 0.00 reads/s, 0.00 creates/s, 5.53 writes/s
  547. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  548. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  549. LRU len: 86484, unzip_LRU len: 0
  550. I/O sum[2594]:cur[4], unzip sum[0]:cur[0]
  551. ---BUFFER POOL 1
  552. Buffer pool size   87380
  553. Free buffers       1
  554. Database pages     86492
  555. Old database pages 31907
  556. Modified db pages  2506
  557. Pending reads 0
  558. Pending writes: LRU 0, flush list 2, single page 0
  559. Pages made young 86198, not young 0
  560. 0.00 youngs/s, 0.00 non-youngs/s
  561. Pages read 162749, created 5623, written 664142
  562. 0.00 reads/s, 0.00 creates/s, 8.17 writes/s
  563. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  564. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  565. LRU len: 86492, unzip_LRU len: 0
  566. I/O sum[2594]:cur[4], unzip sum[0]:cur[0]
  567. ---BUFFER POOL 2
  568. Buffer pool size   87380
  569. Free buffers       1
  570. Database pages     86500
  571. Old database pages 31910
  572. Modified db pages  2485
  573. Pending reads 0
  574. Pending writes: LRU 0, flush list 2, single page 0
  575. Pages made young 85015, not young 0
  576. 0.00 youngs/s, 0.00 non-youngs/s
  577. Pages read 160456, created 4959, written 691354
  578. 0.00 reads/s, 0.00 creates/s, 12.17 writes/s
  579. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  580. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  581. LRU len: 86500, unzip_LRU len: 0
  582. I/O sum[2594]:cur[4], unzip sum[0]:cur[0]
  583. ---BUFFER POOL 3
  584. Buffer pool size   87380
  585. Free buffers       0
  586. Database pages     86457
  587. Old database pages 31894
  588. Modified db pages  2455
  589. Pending reads 0
  590. Pending writes: LRU 0, flush list 1, single page 0
  591. Pages made young 75690, not young 0
  592. 0.00 youngs/s, 0.00 non-youngs/s
  593. Pages read 142069, created 5175, written 628528
  594. 0.00 reads/s, 0.07 creates/s, 9.17 writes/s
  595. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  596. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  597. LRU len: 86457, unzip_LRU len: 0
  598. I/O sum[2594]:cur[4], unzip sum[0]:cur[0]
  599. ---BUFFER POOL 4
  600. Buffer pool size   87380
  601. Free buffers       0
  602. Database pages     86472
  603. Old database pages 31900
  604. Modified db pages  2488
  605. Pending reads 0
  606. Pending writes: LRU 0, flush list 2, single page 0
  607. Pages made young 81891, not young 0
  608. 0.00 youngs/s, 0.00 non-youngs/s
  609. Pages read 155391, created 5447, written 667889
  610. 0.00 reads/s, 0.00 creates/s, 3.20 writes/s
  611. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  612. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  613. LRU len: 86472, unzip_LRU len: 0
  614. I/O sum[2594]:cur[4], unzip sum[0]:cur[0]
  615. ---BUFFER POOL 5
  616. Buffer pool size   87380
  617. Free buffers       1
  618. Database pages     86483
  619. Old database pages 31904
  620. Modified db pages  3049
  621. Pending reads 0
  622. Pending writes: LRU 0, flush list 2, single page 0
  623. Pages made young 82507, not young 0
  624. 0.00 youngs/s, 0.00 non-youngs/s
  625. Pages read 158768, created 5511, written 687287
  626. 0.00 reads/s, 0.00 creates/s, 7.30 writes/s
  627. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  628. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  629. LRU len: 86483, unzip_LRU len: 0
  630. I/O sum[2594]:cur[4], unzip sum[0]:cur[0]
  631. --------------
  632. ROW OPERATIONS
  633. --------------
  634. 0 queries inside InnoDB, 0 queries in queue
  635. 2 read views open inside InnoDB
  636. Main thread process no. 20764, id 140217710380800, state: flushing buffer pool pages
  637. Number of rows inserted 5208496, updated 1789278, deleted 22093, read 852115762
  638. 20.73 inserts/s, 7.00 updates/s, 0.00 deletes/s, 19039.93 reads/s
  639. ----------------------------
  640. END OF INNODB MONITOR OUTPUT
  641. ============================
  642.  
  643. 1 row in set (0.03 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!