API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 21st, 2013
223
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.18 KB | None | 0 0
raw download clone embed print report
  1.  
  2. # 670ms user time, 30ms system time, 15.57M rss, 17.75M vsz
  3. # Current date: Thu Nov 21 18:02:09 2013
  4. # Hostname: server1
  5. # Files: /var/lib/mysql/mysql-slow.log
  6. # Overall: 579 total, 32 unique, 3.78 QPS, 0.26x concurrency _____________
  7. # Time range: 2013-11-21 17:59:36 to 18:02:09
  8. # Attribute total min max avg 95% stddev median
  9. # ============ ======= ======= ======= ======= ======= ======= =======
  10. # Exec time 40s 360us 2s 70ms 171ms 121ms 78ms
  11. # Lock time 45ms 32us 2ms 76us 131us 144us 44us
  12. # Rows sent 5.90k 0 698 10.44 24.84 54.64 0.99
  13. # Rows examine 37.40M 0 386.10k 66.15k 380.41k 84.41k 65.68k
  14. # Query size 33.45k 36 113 59.16 84.10 13.20 54.21
  15.  
  16. # Profile
  17. # Rank Query ID Response time Calls R/Call V/M Item
  18. # ==== ================== ============= ===== ====== ===== ===============
  19. # 1 0x213668F0E742AFF4 21.1855 52.5% 232 0.0913 0.20 SELECT odgovori
  20. # 2 0x242ED43E77200BC4 6.4503 16.0% 18 0.3584 0.10 SELECT brojac_posjeta
  21. # 3 0x5A3423C8A1EC8629 3.0474 7.6% 17 0.1793 0.00 SELECT brojac_posjeta
  22. # 4 0x5EA1E21A77174A2A 1.3647 3.4% 9 0.1516 0.52 SELECT notifikacije
  23. # 5 0xA8F4C448BDABB989 1.2075 3.0% 15 0.0805 0.03 SELECT pitanja
  24. # 6 0x9FBAA0B3C0C08581 1.1925 3.0% 9 0.1325 0.02 SELECT notifikacije
  25. # 7 0xF0C38CCA5C9ADDAE 0.9871 2.4% 7 0.1410 0.01 SELECT pitanja
  26. # 8 0x18653A41741F6438 0.8693 2.2% 18 0.0483 0.00 SELECT notifikacije
  27. # 9 0x2F977BDEA6AE8EE6 0.8662 2.1% 15 0.0577 0.00 SELECT pitanja
  28. # 10 0xC275EE0C29404912 0.6306 1.6% 19 0.0332 0.00 SELECT pitanja
  29. # 11 0x42922DF2E5ABB213 0.3552 0.9% 67 0.0053 0.00 SELECT lajkovi
  30. # 12 0xA717E9C69F4CDA3D 0.3432 0.9% 12 0.0286 0.00 SELECT odgovori
  31. # MISC 0xMISC 1.8499 4.6% 141 0.0131 0.0 <20 ITEMS>
  32.  
  33. # Query 1: 1.58 QPS, 0.14x concurrency, ID 0x213668F0E742AFF4 at byte 111002
  34. # This item is included in the report because it matches --limit.
  35. # Scores: V/M = 0.20
  36. # Time range: 2013-11-21 17:59:42 to 18:02:09
  37. # Attribute pct total min max avg 95% stddev median
  38. # ============ === ======= ======= ======= ======= ======= ======= =======
  39. # Count 40 232
  40. # Exec time 52 21s 78ms 2s 91ms 91ms 137ms 78ms
  41. # Lock time 23 10ms 33us 130us 44us 69us 14us 38us
  42. # Rows sent 3 232 1 1 1 1 0 1
  43. # Rows examine 39 14.89M 65.71k 65.71k 65.71k 65.68k 0 65.68k
  44. # Query size 37 12.46k 55 55 55 55 0 55
  45. # String:
  46. # Databases pitajfm_cms
  47. # Hosts localhost
  48. # Users pitajfm_cms
  49. # Query_time distribution
  50. # 1us
  51. # 10us
  52. # 100us
  53. # 1ms
  54. # 10ms ################################################################
  55. # 100ms ##
  56. # 1s #
  57. # 10s+
  58. # Tables
  59. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'odgovori'\G
  60. # SHOW CREATE TABLE `pitajfm_cms`.`odgovori`\G
  61. # EXPLAIN /*!50100 PARTITIONS*/
  62. SELECT * FROM odgovori WHERE uid = 7954 AND pid = 86013\G
  63.  
  64. # Query 2: 0.12 QPS, 0.04x concurrency, ID 0x242ED43E77200BC4 at byte 54422
  65. # This item is included in the report because it matches --limit.
  66. # Scores: V/M = 0.10
  67. # Time range: 2013-11-21 17:59:42 to 18:02:06
  68. # Attribute pct total min max avg 95% stddev median
  69. # ============ === ======= ======= ======= ======= ======= ======= =======
  70. # Count 3 18
  71. # Exec time 15 6s 267ms 1s 358ms 412ms 185ms 308ms
  72. # Lock time 8 4ms 41us 2ms 209us 176us 547us 66us
  73. # Rows sent 0 10 0 1 0.56 0.99 0.49 0.99
  74. # Rows examine 18 6.79M 386.10k 386.10k 386.10k 380.41k 0 380.41k
  75. # Query size 3 1.30k 73 76 74.22 72.65 0 72.65
  76. # String:
  77. # Databases pitajfm_cms
  78. # Hosts localhost
  79. # Users pitajfm_cms
  80. # Query_time distribution
  81. # 1us
  82. # 10us
  83. # 100us
  84. # 1ms
  85. # 10ms
  86. # 100ms ################################################################
  87. # 1s ###
  88. # 10s+
  89. # Tables
  90. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'brojac_posjeta'\G
  91. # SHOW CREATE TABLE `pitajfm_cms`.`brojac_posjeta`\G
  92. # EXPLAIN /*!50100 PARTITIONS*/
  93. SELECT id FROM brojac_posjeta WHERE ko = '185.36.84.113' AND kome = '8074'\G
  94.  
  95. # Query 3: 0.12 QPS, 0.02x concurrency, ID 0x5A3423C8A1EC8629 at byte 66454
  96. # This item is included in the report because it matches --limit.
  97. # Scores: V/M = 0.00
  98. # Time range: 2013-11-21 17:59:42 to 18:02:07
  99. # Attribute pct total min max avg 95% stddev median
  100. # ============ === ======= ======= ======= ======= ======= ======= =======
  101. # Count 2 17
  102. # Exec time 7 3s 169ms 218ms 179ms 189ms 12ms 171ms
  103. # Lock time 3 1ms 50us 143us 85us 108us 27us 80us
  104. # Rows sent 60 3.55k 8 698 213.71 621.67 202.06 166.51
  105. # Rows examine 17 6.41M 386.10k 386.10k 386.10k 380.41k 0 380.41k
  106. # Query size 2 833 49 49 49 49 0 49
  107. # String:
  108. # Databases pitajfm_cms
  109. # Hosts localhost
  110. # Users pitajfm_cms
  111. # Query_time distribution
  112. # 1us
  113. # 10us
  114. # 100us
  115. # 1ms
  116. # 10ms
  117. # 100ms ################################################################
  118. # 1s
  119. # 10s+
  120. # Tables
  121. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'brojac_posjeta'\G
  122. # SHOW CREATE TABLE `pitajfm_cms`.`brojac_posjeta`\G
  123. # EXPLAIN /*!50100 PARTITIONS*/
  124. SELECT id FROM brojac_posjeta WHERE kome = '9464'\G
  125.  
  126. # Query 4: 0.06 QPS, 0.01x concurrency, ID 0x5EA1E21A77174A2A at byte 12969
  127. # This item is included in the report because it matches --limit.
  128. # Scores: V/M = 0.52
  129. # Time range: 2013-11-21 17:59:36 to 18:01:57
  130. # Attribute pct total min max avg 95% stddev median
  131. # ============ === ======= ======= ======= ======= ======= ======= =======
  132. # Count 1 9
  133. # Exec time 3 1s 42ms 950ms 152ms 945ms 282ms 42ms
  134. # Lock time 2 1ms 62us 151us 112us 144us 22us 108us
  135. # Rows sent 0 3 0 1 0.33 0.99 0.47 0
  136. # Rows examine 1 664.41k 73.82k 73.82k 73.82k 72.41k 0 72.41k
  137. # Query size 2 846 94 94 94 94 0 94
  138. # String:
  139. # Databases pitajfm_cms
  140. # Hosts localhost
  141. # Users pitajfm_cms
  142. # Query_time distribution
  143. # 1us
  144. # 10us
  145. # 100us
  146. # 1ms
  147. # 10ms ################################################################
  148. # 100ms ##################
  149. # 1s
  150. # 10s+
  151. # Tables
  152. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'notifikacije'\G
  153. # SHOW CREATE TABLE `pitajfm_cms`.`notifikacije`\G
  154. # EXPLAIN /*!50100 PARTITIONS*/
  155. SELECT * FROM notifikacije WHERE kome = 8443 AND vrsta = 'odgovor' ORDER BY datum DESC LIMIT 5\G
  156.  
  157. # Query 5: 0.10 QPS, 0.01x concurrency, ID 0xA8F4C448BDABB989 at byte 35366
  158. # This item is included in the report because it matches --limit.
  159. # Scores: V/M = 0.03
  160. # Time range: 2013-11-21 17:59:42 to 18:02:07
  161. # Attribute pct total min max avg 95% stddev median
  162. # ============ === ======= ======= ======= ======= ======= ======= =======
  163. # Count 2 15
  164. # Exec time 2 1s 4ms 126ms 81ms 110ms 45ms 110ms
  165. # Lock time 3 2ms 83us 134us 112us 131us 15us 113us
  166. # Rows sent 4 244 4 25 16.27 24.84 7.13 11.95
  167. # Rows examine 2 770.27k 2.17k 72.04k 51.35k 68.96k 28.10k 68.96k
  168. # Query size 3 1.22k 83 83 83 83 0 83
  169. # String:
  170. # Databases pitajfm_cms
  171. # Hosts localhost
  172. # Users pitajfm_cms
  173. # Query_time distribution
  174. # 1us
  175. # 10us
  176. # 100us
  177. # 1ms ######
  178. # 10ms #########################
  179. # 100ms ################################################################
  180. # 1s
  181. # 10s+
  182. # Tables
  183. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'pitanja'\G
  184. # SHOW CREATE TABLE `pitajfm_cms`.`pitanja`\G
  185. # EXPLAIN /*!50100 PARTITIONS*/
  186. SELECT * FROM pitanja WHERE uid = 8443 AND status = '1' ORDER BY id DESC LIMIT 0,25\G
  187.  
  188. # Query 6: 0.06 QPS, 0.01x concurrency, ID 0x9FBAA0B3C0C08581 at byte 12011
  189. # This item is included in the report because it matches --limit.
  190. # Scores: V/M = 0.02
  191. # Time range: 2013-11-21 17:59:36 to 18:01:57
  192. # Attribute pct total min max avg 95% stddev median
  193. # ============ === ======= ======= ======= ======= ======= ======= =======
  194. # Count 1 9
  195. # Exec time 2 1s 107ms 277ms 132ms 266ms 49ms 110ms
  196. # Lock time 1 879us 80us 112us 97us 108us 10us 98us
  197. # Rows sent 0 3 0 2 0.33 1.96 0.66 0
  198. # Rows examine 1 664.41k 73.82k 73.82k 73.82k 72.41k 0 72.41k
  199. # Query size 2 792 88 88 88 88 0 88
  200. # String:
  201. # Databases pitajfm_cms
  202. # Hosts localhost
  203. # Users pitajfm_cms
  204. # Query_time distribution
  205. # 1us
  206. # 10us
  207. # 100us
  208. # 1ms
  209. # 10ms
  210. # 100ms ################################################################
  211. # 1s
  212. # 10s+
  213. # Tables
  214. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'notifikacije'\G
  215. # SHOW CREATE TABLE `pitajfm_cms`.`notifikacije`\G
  216. # EXPLAIN /*!50100 PARTITIONS*/
  217. SELECT * FROM notifikacije WHERE kome = 9464 AND vrsta = 'notifikacija' ORDER BY id DESC\G
  218.  
  219. # Query 7: 0.05 QPS, 0.01x concurrency, ID 0xF0C38CCA5C9ADDAE at byte 12713
  220. # This item is included in the report because it matches --limit.
  221. # Scores: V/M = 0.01
  222. # Time range: 2013-11-21 17:59:46 to 18:01:57
  223. # Attribute pct total min max avg 95% stddev median
  224. # ============ === ======= ======= ======= ======= ======= ======= =======
  225. # Count 1 7
  226. # Exec time 2 987ms 109ms 220ms 141ms 219ms 38ms 116ms
  227. # Lock time 1 723us 43us 157us 103us 152us 30us 98us
  228. # Rows sent 0 8 0 2 1.14 1.96 0.63 0.99
  229. # Rows examine 1 504.26k 72.04k 72.04k 72.04k 68.96k 0 68.96k
  230. # Query size 1 504 72 72 72 72 0 72
  231. # String:
  232. # Databases pitajfm_cms
  233. # Hosts localhost
  234. # Users pitajfm_cms
  235. # Query_time distribution
  236. # 1us
  237. # 10us
  238. # 100us
  239. # 1ms
  240. # 10ms
  241. # 100ms ################################################################
  242. # 1s
  243. # 10s+
  244. # Tables
  245. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'pitanja'\G
  246. # SHOW CREATE TABLE `pitajfm_cms`.`pitanja`\G
  247. # EXPLAIN /*!50100 PARTITIONS*/
  248. SELECT * FROM pitanja WHERE uid = 9464 AND status = '0' ORDER BY id DESC\G
  249.  
  250. # Query 8: 0.13 QPS, 0.01x concurrency, ID 0x18653A41741F6438 at byte 0 __
  251. # This item is included in the report because it matches --limit.
  252. # Scores: V/M = 0.00
  253. # Time range: 2013-11-21 17:59:36 to 18:01:57
  254. # Attribute pct total min max avg 95% stddev median
  255. # ============ === ======= ======= ======= ======= ======= ======= =======
  256. # Count 3 18
  257. # Exec time 2 869ms 35ms 70ms 48ms 61ms 12ms 51ms
  258. # Lock time 7 3ms 51us 1ms 177us 152us 308us 103us
  259. # Rows sent 0 0 0 0 0 0 0 0
  260. # Rows examine 3 1.30M 73.82k 73.82k 73.82k 72.41k 0 72.41k
  261. # Query size 4 1.56k 86 91 88.50 88.31 2.10 88.31
  262. # String:
  263. # Databases pitajfm_cms
  264. # Hosts localhost
  265. # Users pitajfm_cms
  266. # Query_time distribution
  267. # 1us
  268. # 10us
  269. # 100us
  270. # 1ms
  271. # 10ms ################################################################
  272. # 100ms
  273. # 1s
  274. # 10s+
  275. # Tables
  276. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'notifikacije'\G
  277. # SHOW CREATE TABLE `pitajfm_cms`.`notifikacije`\G
  278. # EXPLAIN /*!50100 PARTITIONS*/
  279. SELECT id FROM notifikacije WHERE vrsta = 'notifikacija' AND kome = 9464 AND otvorena = '0'\G
  280.  
  281. # Query 9: 0.11 QPS, 0.01x concurrency, ID 0x2F977BDEA6AE8EE6 at byte 69488
  282. # This item is included in the report because it matches --limit.
  283. # Scores: V/M = 0.00
  284. # Time range: 2013-11-21 17:59:36 to 18:01:57
  285. # Attribute pct total min max avg 95% stddev median
  286. # ============ === ======= ======= ======= ======= ======= ======= =======
  287. # Count 2 15
  288. # Exec time 2 866ms 40ms 105ms 58ms 71ms 17ms 62ms
  289. # Lock time 3 2ms 52us 187us 106us 144us 33us 105us
  290. # Rows sent 0 26 0 15 1.73 2.90 3.54 0.99
  291. # Rows examine 2 1.06M 72.04k 72.04k 72.04k 68.96k 0 68.96k
  292. # Query size 2 870 58 58 58 58 0 58
  293. # String:
  294. # Databases pitajfm_cms
  295. # Hosts localhost
  296. # Users pitajfm_cms
  297. # Query_time distribution
  298. # 1us
  299. # 10us
  300. # 100us
  301. # 1ms
  302. # 10ms ################################################################
  303. # 100ms ####
  304. # 1s
  305. # 10s+
  306. # Tables
  307. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'pitanja'\G
  308. # SHOW CREATE TABLE `pitajfm_cms`.`pitanja`\G
  309. # EXPLAIN /*!50100 PARTITIONS*/
  310. SELECT id FROM pitanja WHERE uid = 9464 AND otvoreno = '0'\G
  311.  
  312. # Query 10: 0.13 QPS, 0.00x concurrency, ID 0xC275EE0C29404912 at byte 12513
  313. # This item is included in the report because it matches --limit.
  314. # Scores: V/M = 0.00
  315. # Time range: 2013-11-21 17:59:36 to 18:02:07
  316. # Attribute pct total min max avg 95% stddev median
  317. # ============ === ======= ======= ======= ======= ======= ======= =======
  318. # Count 3 19
  319. # Exec time 1 631ms 30ms 74ms 33ms 34ms 9ms 30ms
  320. # Lock time 3 1ms 32us 106us 77us 103us 23us 84us
  321. # Rows sent 16 975 2 507 51.32 92.72 105.65 15.10
  322. # Rows examine 3 1.34M 72.04k 72.04k 72.04k 68.96k 0 68.96k
  323. # Query size 2 738 36 39 38.84 38.53 0.80 38.53
  324. # String:
  325. # Databases pitajfm_cms
  326. # Hosts localhost
  327. # Users pitajfm_cms
  328. # Query_time distribution
  329. # 1us
  330. # 10us
  331. # 100us
  332. # 1ms
  333. # 10ms ################################################################
  334. # 100ms
  335. # 1s
  336. # 10s+
  337. # Tables
  338. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'pitanja'\G
  339. # SHOW CREATE TABLE `pitajfm_cms`.`pitanja`\G
  340. # EXPLAIN /*!50100 PARTITIONS*/
  341. SELECT id FROM pitanja WHERE uid = 9464\G
  342.  
  343. # Query 11: 0.68 QPS, 0.00x concurrency, ID 0x42922DF2E5ABB213 at byte 18202
  344. # This item is included in the report because it matches --limit.
  345. # Scores: V/M = 0.00
  346. # Time range: 2013-11-21 17:59:46 to 18:01:25
  347. # Attribute pct total min max avg 95% stddev median
  348. # ============ === ======= ======= ======= ======= ======= ======= =======
  349. # Count 11 67
  350. # Exec time 0 355ms 5ms 25ms 5ms 5ms 2ms 5ms
  351. # Lock time 10 5ms 36us 1ms 67us 80us 160us 40us
  352. # Rows sent 0 0 0 0 0 0 0 0
  353. # Rows examine 1 698.33k 10.42k 10.42k 10.42k 10.42k 0 10.42k
  354. # Query size 12 4.06k 62 62 62 62 0 62
  355. # String:
  356. # Databases pitajfm_cms
  357. # Hosts localhost
  358. # Users pitajfm_cms
  359. # Query_time distribution
  360. # 1us
  361. # 10us
  362. # 100us
  363. # 1ms ################################################################
  364. # 10ms #
  365. # 100ms
  366. # 1s
  367. # 10s+
  368. # Tables
  369. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'lajkovi'\G
  370. # SHOW CREATE TABLE `pitajfm_cms`.`lajkovi`\G
  371. # EXPLAIN /*!50100 PARTITIONS*/
  372. SELECT `id` FROM `lajkovi` WHERE `oid` = 63566 AND `ko` = 8443\G
  373.  
  374. # Query 12: 0.08 QPS, 0.00x concurrency, ID 0xA717E9C69F4CDA3D at byte 3818
  375. # This item is included in the report because it matches --limit.
  376. # Scores: V/M = 0.00
  377. # Time range: 2013-11-21 17:59:42 to 18:02:07
  378. # Attribute pct total min max avg 95% stddev median
  379. # ============ === ======= ======= ======= ======= ======= ======= =======
  380. # Count 2 12
  381. # Exec time 0 343ms 26ms 48ms 29ms 31ms 6ms 26ms
  382. # Lock time 4 2ms 70us 1ms 178us 108us 256us 103us
  383. # Rows sent 5 355 4 95 29.58 59.77 24.80 20.43
  384. # Rows examine 2 788.53k 65.71k 65.71k 65.71k 65.68k 0 65.68k
  385. # Query size 1 480 40 40 40 40 0 40
  386. # String:
  387. # Databases pitajfm_cms
  388. # Hosts localhost
  389. # Users pitajfm_cms
  390. # Query_time distribution
  391. # 1us
  392. # 10us
  393. # 100us
  394. # 1ms
  395. # 10ms ################################################################
  396. # 100ms
  397. # 1s
  398. # 10s+
  399. # Tables
  400. # SHOW TABLE STATUS FROM `pitajfm_cms` LIKE 'odgovori'\G
  401. # SHOW CREATE TABLE `pitajfm_cms`.`odgovori`\G
  402. # EXPLAIN /*!50100 PARTITIONS*/
  403. SELECT id FROM odgovori WHERE uid = 7119\G
  404. root@server1 [~]# top
  405. top - 18:06:18 up 2 days, 21:54, 1 user, load average: 0.85, 0.84, 0.97
  406. Tasks: 86 total, 2 running, 84 sleeping, 0 stopped, 0 zombie
  407. Cpu(s): 15.7%us, 0.7%sy, 0.0%ni, 83.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
  408. Mem: 1034720k total, 990280k used, 44440k free, 96724k buffers
  409. Swap: 0k total, 0k used, 0k free, 668256k cached
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!