API tools faq
paste
Advertisement
matrox445

pt_query_slow_log

matrox445
Mar 11th, 2022
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 44.25 KB | None | 0 0
raw download clone embed print report
  1. # 1448.9s user time, 8s system time, 0 rss, 0 vsz
  2. # Current date: Fri Mar 11 09:25:00 2022
  3. # Hostname: HTPC-PC
  4. # Files: slow.log
  5. # Overall: 8.79M total, 999 unique, 101.69 QPS, 0.13x concurrency ________
  6. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  7. # Attribute total min max avg 95% stddev median
  8. # ============ ======= ======= ======= ======= ======= ======= =======
  9. # Exec time 11175s 0 37s 1ms 1ms 113ms 167us
  10. # Lock time 1669s 0 37s 189us 167us 59ms 42us
  11. # Rows sent 45.59M 0 10.72M 5.44 18.53 3.67k 0.99
  12. # Rows examine 1.14G 0 10.72M 138.96 299.03 4.56k 0
  13. # Rows affecte 879.32k 0 30 0.10 0.99 0.31 0
  14. # Bytes sent 7.42G 0 1.97G 906.36 1.86k 703.98k 59.77
  15. # Merge passes 0 0 0 0 0 0 0
  16. # Tmp tables 1.07M 1 6 1.00 0.99 0.04 0.99
  17. # Tmp disk tbl 1.96k 0 2 0.00 0 0.04 0
  18. # Tmp tbl size 49.96G 0 51.92M 46.84k 0 381.43k 0
  19. # Query size 2.12G 11 27.53k 258.96 833.10 288.40 102.22
  20. # Boolean:
  21. # Filesort 56% yes, 43% no
  22. # Full join 0% yes, 99% no
  23. # Full scan 2% yes, 97% no
  24. # Priority que 1% yes, 98% no
  25. # Tmp table 97% yes, 2% no
  26. # Tmp table on 0% yes, 99% no
  27.  
  28. # Profile
  29. # Rank Query ID Response time Calls R/Call
  30. # ==== =================================== =============== ======= ======
  31. # 1 0x17B1C4DB3F12B1AB31877446EA11A1C8 4075.3845 36.5% 460942 0.0088 6.50 SELECT my_domain_enseignant.passations
  32. # 2 0xABCFC031D6132CC1F1E480C73EE97D85 1358.4377 12.2% 630492 0.0022 8.85 SELECT my_domain_enseignant.groupes_eleves my_domain_enseignant.eleves my_domain_enseignant.eleves_activity my_domain_enseignant.eleves_tchat
  33. # 3 0x98205FA012B180D8E091A1131A0EDE74 1063.0018 9.5% 364096 0.0029 14.73 UPDATE my_domain_enseignant.eleves_activity
  34. # 4 0xA4757EE6DB0B7291D3DD960E892F0BE4 853.5529 7.6% 238629 0.0036 15.28 UPDATE users
  35. # 5 0xDACB713896514474A95F17FA269DFBD6 390.4078 3.5% 277908 0.0014 16.64 SELECT my_domain_enseignant.groupes_calibrations my_domain_enseignant.groupes users
  36. # 6 0xA4F12637945C38DD11BE566323E4B67B 383.0355 3.4% 107749 0.0036 22.42 UPDATE my_domain_enseignant.eleves_entrainements
  37. # 7 0x3178B70DE18B966617C8C998A3ECFF14 284.9736 2.6% 277908 0.0010 8.55 SELECT my_domain_enseignant.groupes_evaluations my_domain_enseignant.groupes users my_domain_enseignant.eleves_evaluations
  38. # 8 0xADF484ECF53FC9A87A25678B34FCB3C6 267.1974 2.4% 1687872 0.0002 0.07 SELECT my_domain_enseignant.eleves_tchat
  39. # 9 0xDDDEDCE4FCEA9321858B1A74F6321ED7 266.3669 2.4% 461335 0.0006 5.25 SELECT my_domain_enseignant.groupes_eleves
  40. # 10 0x7AE18E5FFCC4B4150973CC672E7A0611 211.7926 1.9% 116950 0.0018 9.91 SELECT my_domain_enseignant.passations
  41. # 11 0x72B026008FF6FA5ED227C4DEF09F5E28 194.8564 1.7% 277908 0.0007 8.52 SELECT my_domain_enseignant.groupes_entrainements my_domain_enseignant.groupes users my_domain_enseignant.eleves_entrainements
  42. # 12 0xE0E72E5DFD65D72794F47D77E06C3C33 189.2598 1.7% 116848 0.0016 17.59 SELECT my_domain_enseignant.eleves_entrainements
  43. # 13 0x537259425900F38C3A8C572140C12DDD 178.2021 1.6% 57971 0.0031 13.23 SELECT my_domain_enseignant.groupes_eleves my_domain_enseignant.groupes users
  44. # 14 0xB8AD06E6E2CD1AADBA9EC5C99D2A729B 172.7845 1.5% 21860 0.0079 16.47 INSERT my_domain_enseignant.passations
  45. # 15 0xC92D5A3B71E57D4FCC39C8866466FDA5 135.0161 1.2% 40118 0.0034 8.85 SELECT my_domain_enseignant.passations my_domain_enseignant.eleves my_domain_enseignant.groupes_eleves
  46. # 16 0x95C35A7EC678D7D868D7830A48A5308D 127.5792 1.1% 116191 0.0011 11.48 INSERT my_domain_enseignant.passations
  47. # 17 0x0C5F08D29A567CB87E35AFDBF1DB0E32 93.1577 0.8% 74414 0.0013 6.24 SELECT my_domain_enseignant.eleves_evaluations my_domain_enseignant.groupes_eleves my_domain_enseignant.groupes
  48. # 18 0x39F09CC45DDED067110B75DF0148EAEF 86.6072 0.8% 36153 0.0024 13.44 SELECT users etablissements communes pays
  49. # 19 0x451084DDC0DC3C16A9C8DE00C43A8043 72.5848 0.6% 6080 0.0119 33.64 UPDATE my_domain_enseignant.eleves_activity
  50. # 20 0x045F24444067A1520DC7AD881DAF54BF 63.6756 0.6% 85222 0.0007 12.41 SELECT my_domain_enseignant.eleves_entrainements
  51. # MISC 0xMISC 706.8822 6.3% 3335720 0.0002 0.0 <979 ITEMS>
  52.  
  53. # Query 1: 5.33 QPS, 0.05x concurrency, ID 0x17B1C4DB3F12B1AB31877446EA11A1C8 at byte 4157966081
  54. # This item is included in the report because it matches --limit.
  55. # Scores: V/M = 6.50
  56. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  57. # Attribute pct total min max avg 95% stddev median
  58. # ============ === ======= ======= ======= ======= ======= ======= =======
  59. # Count 5 460942
  60. # Exec time 36 4075s 126us 33s 9ms 23ms 240ms 3ms
  61. # Lock time 1 25s 26us 23ms 54us 98us 40us 49us
  62. # Rows sent 0 450.14k 1 1 1 1 0 1
  63. # Rows examine 80 937.02M 0 22.56k 2.08k 8.46k 2.58k 1.14k
  64. # Rows affecte 0 0 0 0 0 0 0 0
  65. # Bytes sent 0 28.04M 56 64 63.78 62.76 1.39 62.76
  66. # Query size 8 177.07M 271 613 402.80 511.45 67.69 400.73
  67. # String:
  68. # Databases my_domain_common
  69. # Hosts localhost
  70. # Users my_domain
  71. # Query_time distribution
  72. # 1us
  73. # 10us
  74. # 100us #############
  75. # 1ms ################################################################
  76. # 10ms #################
  77. # 100ms #
  78. # 1s #
  79. # 10s+ #
  80. # Tables
  81. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'passations'\G
  82. # SHOW CREATE TABLE `my_domain_enseignant`.`passations`\G
  83. # EXPLAIN /*!50100 PARTITIONS*/
  84. SELECT MAX(`id`) AS `id`
  85. FROM my_domain_enseignant.passations
  86. WHERE `id_eleve` IN ('499613','499611','499612','499614','499615','499616','499617','499618','499619','499620','499621','499622','499623','499624','499625','499626','499627','499628','499629','499630','499631','499632','499633','499634')
  87. AND `id_module` = '1'
  88. AND `type_seance` = 'normale'
  89. AND `type_question` = 'principale'
  90. AND `methode` = 'entrainement'
  91. AND `premier` = 1\G
  92.  
  93. # Query 2: 7.29 QPS, 0.02x concurrency, ID 0xABCFC031D6132CC1F1E480C73EE97D85 at byte 4157824226
  94. # This item is included in the report because it matches --limit.
  95. # Scores: V/M = 8.85
  96. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  97. # Attribute pct total min max avg 95% stddev median
  98. # ============ === ======= ======= ======= ======= ======= ======= =======
  99. # Count 7 630492
  100. # Exec time 12 1358s 246us 33s 2ms 1ms 138ms 657us
  101. # Lock time 5 91s 60us 19ms 144us 236us 70us 131us
  102. # Rows sent 30 14.08M 0 144 23.42 46.83 15.19 21.45
  103. # Rows examine 6 77.38M 0 1.05k 128.70 299.03 100.04 97.36
  104. # Rows affecte 0 0 0 0 0 0 0 0
  105. # Bytes sent 12 979.14M 334 8.43k 1.59k 2.89k 862.23 1.46k
  106. # Merge passes 0 0 0 0 0 0 0 0
  107. # Tmp tables 56 615.71k 1 1 1 1 0 1
  108. # Tmp disk tbl 0 0 0 0 0 0 0 0
  109. # Tmp tbl size 0 0 0 0 0 0 0 0
  110. # Query size 23 509.31M 833 939 847.04 874.75 14.68 833.10
  111. # Boolean:
  112. # Filesort 100% yes, 0% no
  113. # Tmp table 100% yes, 0% no
  114. # String:
  115. # Databases my_domain_common
  116. # Hosts localhost
  117. # Users my_domain
  118. # Query_time distribution
  119. # 1us
  120. # 10us
  121. # 100us ################################################################
  122. # 1ms #########
  123. # 10ms #
  124. # 100ms #
  125. # 1s #
  126. # 10s+ #
  127. # Tables
  128. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes_eleves'\G
  129. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes_eleves`\G
  130. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves'\G
  131. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves`\G
  132. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_activity'\G
  133. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_activity`\G
  134. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_tchat'\G
  135. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_tchat`\G
  136. # EXPLAIN /*!50100 PARTITIONS*/
  137. SELECT `groupes_eleves`.`id_eleve` as `id`, `eleves_activity`.`last_activity`, COUNT(DISTINCT eleves_tchat.id) AS nb_messages, DATE_FORMAT(eleves_activity.connexion, "%d/%m/%Y à %H:%i") AS connexion, AES_DECRYPT(eleves.nom, 'key') as nom, AES_DECRYPT(eleves.prenom, 'key') as prenom
  138. FROM `my_domain_enseignant`.`groupes_eleves`
  139. JOIN `my_domain_enseignant`.`eleves` ON `eleves`.`id` = `my_domain_enseignant`.`groupes_eleves`.`id_eleve`
  140. JOIN `my_domain_enseignant`.`eleves_activity` ON `eleves_activity`.`id_eleve` = `my_domain_enseignant`.`groupes_eleves`.`id_eleve`
  141. LEFT JOIN `my_domain_enseignant`.`eleves_tchat` ON (`eleves_tchat`.`id_eleve` = `my_domain_enseignant`.`groupes_eleves`.`id_eleve` AND `auteur` = "eleve" AND `lu` = "false")
  142. WHERE `my_domain_enseignant`.`groupes_eleves`.`id_groupe` IN ('44100','44194')
  143. GROUP BY `my_domain_enseignant`.`groupes_eleves`.`id_eleve`\G
  144.  
  145. # Query 3: 4.21 QPS, 0.01x concurrency, ID 0x98205FA012B180D8E091A1131A0EDE74 at byte 386438491
  146. # This item is included in the report because it matches --limit.
  147. # Scores: V/M = 14.73
  148. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:32
  149. # Attribute pct total min max avg 95% stddev median
  150. # ============ === ======= ======= ======= ======= ======= ======= =======
  151. # Count 4 364096
  152. # Exec time 9 1063s 90us 36s 3ms 424us 207ms 236us
  153. # Lock time 31 523s 18us 36s 1ms 89us 186ms 47us
  154. # Rows sent 0 0 0 0 0 0 0 0
  155. # Rows examine 0 355.56k 1 1 1 1 0 1
  156. # Rows affecte 40 354.43k 0 1 1.00 0.99 0.06 0.99
  157. # Bytes sent 0 18.06M 52 52 52 52 0 52
  158. # Query size 1 36.09M 95 104 103.92 102.22 0.87 102.22
  159. # String:
  160. # Databases my_domain_common
  161. # Hosts localhost
  162. # Users my_domain
  163. # Query_time distribution
  164. # 1us
  165. # 10us #
  166. # 100us ################################################################
  167. # 1ms #
  168. # 10ms #
  169. # 100ms #
  170. # 1s #
  171. # 10s+ #
  172. # Tables
  173. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_activity'\G
  174. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_activity`\G
  175. UPDATE `my_domain_enseignant`.`eleves_activity` SET `last_activity` = 1646889907
  176. WHERE `id_eleve` = '456599'\G
  177. # Converted for EXPLAIN
  178. # EXPLAIN /*!50100 PARTITIONS*/
  179. select `last_activity` = 1646889907 from `my_domain_enseignant`.`eleves_activity` where `id_eleve` = '456599'\G
  180.  
  181. # Query 4: 2.76 QPS, 0.01x concurrency, ID 0xA4757EE6DB0B7291D3DD960E892F0BE4 at byte 386423495
  182. # This item is included in the report because it matches --limit.
  183. # Scores: V/M = 15.28
  184. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:32
  185. # Attribute pct total min max avg 95% stddev median
  186. # ============ === ======= ======= ======= ======= ======= ======= =======
  187. # Count 2 238629
  188. # Exec time 7 854s 185us 37s 4ms 626us 234ms 403us
  189. # Lock time 18 316s 115us 37s 1ms 332us 167ms 224us
  190. # Rows sent 0 0 0 0 0 0 0 0
  191. # Rows examine 0 233.04k 1 1 1 1 0 1
  192. # Rows affecte 25 220.46k 0 1 0.95 0.99 0.22 0.99
  193. # Bytes sent 0 11.83M 52 52 52 52 0 52
  194. # Query size 0 17.97M 75 79 78.96 76.28 0.10 76.28
  195. # String:
  196. # Databases my_domain_common
  197. # Hosts localhost
  198. # Users my_domain
  199. # Query_time distribution
  200. # 1us
  201. # 10us
  202. # 100us ################################################################
  203. # 1ms #
  204. # 10ms #
  205. # 100ms #
  206. # 1s #
  207. # 10s+ #
  208. # Tables
  209. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'users'\G
  210. # SHOW CREATE TABLE `my_domain_common`.`users`\G
  211. UPDATE `users` SET `last_activity` = 1646889906
  212. WHERE `users`.`id` IN ('75640')\G
  213. # Converted for EXPLAIN
  214. # EXPLAIN /*!50100 PARTITIONS*/
  215. select `last_activity` = 1646889906 from `users` where `users`.`id` IN ('75640')\G
  216.  
  217. # Query 5: 3.21 QPS, 0.00x concurrency, ID 0xDACB713896514474A95F17FA269DFBD6 at byte 4157827113
  218. # This item is included in the report because it matches --limit.
  219. # Scores: V/M = 16.64
  220. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  221. # Attribute pct total min max avg 95% stddev median
  222. # ============ === ======= ======= ======= ======= ======= ======= =======
  223. # Count 3 277908
  224. # Exec time 3 390s 95us 33s 1ms 490us 153ms 260us
  225. # Lock time 1 26s 32us 16ms 93us 159us 62us 84us
  226. # Rows sent 0 0 0 0 0 0 0 0
  227. # Rows examine 0 74.18k 0 7 0.27 0 1.35 0
  228. # Rows affecte 0 0 0 0 0 0 0 0
  229. # Bytes sent 1 104.42M 394 394 394 394 0 394
  230. # Query size 4 108.32M 407 455 408.70 400.73 6.57 400.73
  231. # String:
  232. # Databases my_domain_common
  233. # Hosts localhost
  234. # Users my_domain
  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 `my_domain_enseignant` LIKE 'groupes_calibrations'\G
  246. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes_calibrations`\G
  247. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes'\G
  248. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes`\G
  249. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'users'\G
  250. # SHOW CREATE TABLE `my_domain_common`.`users`\G
  251. # EXPLAIN /*!50100 PARTITIONS*/
  252. SELECT `groupes_calibrations`.`id`, `groupes_calibrations`.`description`, `users`.`prenom`, `users`.`nom`, `groupes`.`id` as `id_groupe`
  253. FROM `my_domain_enseignant`.`groupes_calibrations`
  254. JOIN `my_domain_enseignant`.`groupes` ON `groupes`.`id` = `groupes_calibrations`.`id_groupe`
  255. JOIN `users` ON `users`.`id` = `groupes`.`id_enseignant`
  256. WHERE `id_groupe` IN ('48587')
  257. AND `groupes_calibrations`.`statut` = 'ouvert'\G
  258.  
  259. # Query 6: 1.25 QPS, 0.00x concurrency, ID 0xA4F12637945C38DD11BE566323E4B67B at byte 386414328
  260. # This item is included in the report because it matches --limit.
  261. # Scores: V/M = 22.42
  262. # Time range: 2022-03-10 00:01:34 to 2022-03-11 00:02:25
  263. # Attribute pct total min max avg 95% stddev median
  264. # ============ === ======= ======= ======= ======= ======= ======= =======
  265. # Count 1 107749
  266. # Exec time 3 383s 64us 37s 4ms 260us 282ms 138us
  267. # Lock time 13 219s 21us 37s 2ms 66us 240ms 31us
  268. # Rows sent 0 0 0 0 0 0 0 0
  269. # Rows examine 0 105.22k 1 1 1 1 0 1
  270. # Rows affecte 11 104.71k 0 1 1.00 0.99 0.07 0.99
  271. # Bytes sent 0 5.34M 52 52 52 52 0 52
  272. # Query size 1 30.51M 291 304 296.92 299.03 6.39 284.79
  273. # String:
  274. # Databases my_domain_common
  275. # Hosts localhost
  276. # Users my_domain
  277. # Query_time distribution
  278. # 1us
  279. # 10us ##
  280. # 100us ################################################################
  281. # 1ms #
  282. # 10ms #
  283. # 100ms #
  284. # 1s #
  285. # 10s+ #
  286. # Tables
  287. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_entrainements'\G
  288. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_entrainements`\G
  289. UPDATE `my_domain_enseignant`.`eleves_entrainements` SET `date` = '2022-03-10 06:25:06', `items_passes` = '1', `items_reussis` = '0', `temps` = '53', `format_principale` = 'qcm', `mots_bleus` = 'false', `question_preparatoire` = 'false'
  290. WHERE `my_domain_enseignant`.`eleves_entrainements`.`id` IN ('4243408')\G
  291. # Converted for EXPLAIN
  292. # EXPLAIN /*!50100 PARTITIONS*/
  293. select `date` = '2022-03-10 06:25:06', `items_passes` = '1', `items_reussis` = '0', `temps` = '53', `format_principale` = 'qcm', `mots_bleus` = 'false', `question_preparatoire` = 'false' from `my_domain_enseignant`.`eleves_entrainements` where `my_domain_enseignant`.`eleves_entrainements`.`id` IN ('4243408')\G
  294.  
  295. # Query 7: 3.21 QPS, 0.00x concurrency, ID 0x3178B70DE18B966617C8C998A3ECFF14 at byte 4157828735
  296. # This item is included in the report because it matches --limit.
  297. # Scores: V/M = 8.55
  298. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  299. # Attribute pct total min max avg 95% stddev median
  300. # ============ === ======= ======= ======= ======= ======= ======= =======
  301. # Count 3 277908
  302. # Exec time 2 285s 151us 20s 1ms 445us 94ms 236us
  303. # Lock time 1 19s 41us 11ms 69us 119us 38us 60us
  304. # Rows sent 1 578.91k 0 8 2.13 4.96 1.48 1.96
  305. # Rows examine 0 3.82M 0 88 14.43 44.60 11.81 9.83
  306. # Rows affecte 0 0 0 0 0 0 0 0
  307. # Bytes sent 2 174.05M 574 894 656.70 755.64 60.10 621.67
  308. # Query size 8 183.85M 692 740 693.70 685.39 5.10 685.39
  309. # String:
  310. # Databases my_domain_common
  311. # Hosts localhost
  312. # Users my_domain
  313. # Query_time distribution
  314. # 1us
  315. # 10us
  316. # 100us ################################################################
  317. # 1ms #
  318. # 10ms #
  319. # 100ms
  320. # 1s #
  321. # 10s+ #
  322. # Tables
  323. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes_evaluations'\G
  324. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes_evaluations`\G
  325. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes'\G
  326. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes`\G
  327. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'users'\G
  328. # SHOW CREATE TABLE `my_domain_common`.`users`\G
  329. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_evaluations'\G
  330. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_evaluations`\G
  331. # EXPLAIN /*!50100 PARTITIONS*/
  332. SELECT `groupes_evaluations`.`id`, `groupes_evaluations`.`id_module`, `groupes_evaluations`.`num`, `users`.`prenom`, `users`.`nom`, `groupes`.`id` as `id_groupe`, `eleves_evaluations`.`items_passes`
  333. FROM `my_domain_enseignant`.`groupes_evaluations`
  334. JOIN `my_domain_enseignant`.`groupes` ON `groupes`.`id` = `groupes_evaluations`.`id_groupe`
  335. JOIN `users` ON `users`.`id` = `groupes`.`id_enseignant`
  336. LEFT JOIN `my_domain_enseignant`.`eleves_evaluations` ON (`eleves_evaluations`.`id_eleve` = 506332 AND `eleves_evaluations`.`id_module` = `groupes_evaluations`.`id_module` AND `eleves_evaluations`.`num` = groupes_evaluations.num)
  337. WHERE `id_groupe` IN ('48587')
  338. AND `groupes_evaluations`.`statut` = 'ouvert'\G
  339.  
  340. # Query 8: 19.52 QPS, 0.00x concurrency, ID 0xADF484ECF53FC9A87A25678B34FCB3C6 at byte 4157007544
  341. # This item is included in the report because it matches --limit.
  342. # Scores: V/M = 0.07
  343. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  344. # Attribute pct total min max avg 95% stddev median
  345. # ============ === ======= ======= ======= ======= ======= ======= =======
  346. # Count 19 1687872
  347. # Exec time 2 267s 42us 4s 158us 287us 3ms 125us
  348. # Lock time 6 102s 15us 20ms 60us 119us 51us 49us
  349. # Rows sent 3 1.61M 1 1 1 1 0 1
  350. # Rows examine 0 0 0 0 0 0 0 0
  351. # Rows affecte 0 0 0 0 0 0 0 0
  352. # Bytes sent 1 92.07M 56 62 57.20 59.77 2.22 54.21
  353. # Query size 6 146.48M 91 91 91 91 0 91
  354. # String:
  355. # Databases my_domain_common
  356. # Hosts localhost
  357. # Users my_domain
  358. # Query_time distribution
  359. # 1us
  360. # 10us #######################
  361. # 100us ################################################################
  362. # 1ms #
  363. # 10ms #
  364. # 100ms
  365. # 1s #
  366. # 10s+
  367. # Tables
  368. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_tchat'\G
  369. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_tchat`\G
  370. # EXPLAIN /*!50100 PARTITIONS*/
  371. SELECT MAX(`id`) AS `id`
  372. FROM `my_domain_enseignant`.`eleves_tchat`
  373. WHERE `id_eleve` = '465155'\G
  374.  
  375. # Query 9: 5.34 QPS, 0.00x concurrency, ID 0xDDDEDCE4FCEA9321858B1A74F6321ED7 at byte 4136331479
  376. # This item is included in the report because it matches --limit.
  377. # Scores: V/M = 5.25
  378. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  379. # Attribute pct total min max avg 95% stddev median
  380. # ============ === ======= ======= ======= ======= ======= ======= =======
  381. # Count 5 461335
  382. # Exec time 2 266s 89us 14s 577us 467us 55ms 236us
  383. # Lock time 1 31s 18us 18ms 66us 125us 50us 57us
  384. # Rows sent 0 450.52k 1 1 1 1 0 1
  385. # Rows examine 0 6.88M 1 44 15.64 27.38 7.49 15.25
  386. # Rows affecte 0 0 0 0 0 0 0 0
  387. # Bytes sent 0 75.90M 70 373 172.51 258.32 52.43 174.84
  388. # Merge passes 0 0 0 0 0 0 0 0
  389. # Tmp tables 41 450.52k 1 1 1 1 0 1
  390. # Tmp disk tbl 0 0 0 0 0 0 0 0
  391. # Tmp tbl size 0 0 0 0 0 0 0 0
  392. # Query size 2 55.88M 127 127 127 127 0 127
  393. # Boolean:
  394. # Tmp table 100% yes, 0% no
  395. # String:
  396. # Databases my_domain_common
  397. # Hosts localhost
  398. # Users my_domain
  399. # Query_time distribution
  400. # 1us
  401. # 10us #
  402. # 100us ################################################################
  403. # 1ms #
  404. # 10ms #
  405. # 100ms
  406. # 1s #
  407. # 10s+ #
  408. # Tables
  409. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes_eleves'\G
  410. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes_eleves`\G
  411. # EXPLAIN /*!50100 PARTITIONS*/
  412. SELECT GROUP_CONCAT(groupes_eleves.id_eleve) as ids_eleves
  413. FROM `my_domain_enseignant`.`groupes_eleves`
  414. WHERE `id_groupe` = '48793'\G
  415.  
  416. # Query 10: 1.35 QPS, 0.00x concurrency, ID 0x7AE18E5FFCC4B4150973CC672E7A0611 at byte 4157952705
  417. # This item is included in the report because it matches --limit.
  418. # Scores: V/M = 9.91
  419. # Time range: 2022-03-10 00:01:34 to 2022-03-11 00:02:25
  420. # Attribute pct total min max avg 95% stddev median
  421. # ============ === ======= ======= ======= ======= ======= ======= =======
  422. # Count 1 116950
  423. # Exec time 1 212s 139us 30s 2ms 1ms 134ms 568us
  424. # Lock time 0 8s 27us 15ms 65us 108us 85us 57us
  425. # Rows sent 0 114.21k 1 1 1 1 0 1
  426. # Rows examine 1 15.52M 0 1.91k 139.15 400.73 151.53 97.36
  427. # Rows affecte 0 0 0 0 0 0 0 0
  428. # Bytes sent 0 6.91M 62 62 62 62 0 62
  429. # Query size 1 34.86M 309 315 312.53 313.99 3 299.03
  430. # String:
  431. # Databases my_domain_common
  432. # Hosts localhost
  433. # Users my_domain
  434. # Query_time distribution
  435. # 1us
  436. # 10us
  437. # 100us ################################################################
  438. # 1ms ##########
  439. # 10ms #
  440. # 100ms #
  441. # 1s #
  442. # 10s+ #
  443. # Tables
  444. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'passations'\G
  445. # SHOW CREATE TABLE `my_domain_enseignant`.`passations`\G
  446. # EXPLAIN /*!50100 PARTITIONS*/
  447. SELECT COUNT(*) AS `numrows`
  448. FROM my_domain_enseignant.passations
  449. WHERE `id_eleve` = '447749'
  450. AND `id_module` = '1'
  451. AND `id_item` = '204'
  452. AND `premier` = 1
  453. AND `methode` = 'entrainement'
  454. AND `timestamp_entrainement` = '1644396851911'
  455. AND `type_question` = 'principale'\G
  456.  
  457. # Query 11: 3.21 QPS, 0.00x concurrency, ID 0x72B026008FF6FA5ED227C4DEF09F5E28 at byte 4140543871
  458. # This item is included in the report because it matches --limit.
  459. # Scores: V/M = 8.52
  460. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  461. # Attribute pct total min max avg 95% stddev median
  462. # ============ === ======= ======= ======= ======= ======= ======= =======
  463. # Count 3 277908
  464. # Exec time 1 195s 171us 21s 701us 596us 77ms 332us
  465. # Lock time 1 21s 51us 11ms 75us 119us 36us 66us
  466. # Rows sent 1 500.61k 0 8 1.84 3.89 1.11 1.96
  467. # Rows examine 0 9.67M 0 808 36.47 97.36 42.76 23.65
  468. # Rows affecte 0 0 0 0 0 0 0 0
  469. # Bytes sent 5 442.58M 1.28k 3.26k 1.63k 2.06k 245.96 1.61k
  470. # Query size 13 285.89M 1.05k 1.10k 1.05k 1.04k 7.90 1.04k
  471. # String:
  472. # Databases my_domain_common
  473. # Hosts localhost
  474. # Users my_domain
  475. # Query_time distribution
  476. # 1us
  477. # 10us
  478. # 100us ################################################################
  479. # 1ms #
  480. # 10ms #
  481. # 100ms
  482. # 1s
  483. # 10s+ #
  484. # Tables
  485. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes_entrainements'\G
  486. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes_entrainements`\G
  487. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes'\G
  488. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes`\G
  489. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'users'\G
  490. # SHOW CREATE TABLE `my_domain_common`.`users`\G
  491. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_entrainements'\G
  492. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_entrainements`\G
  493. # EXPLAIN /*!50100 PARTITIONS*/
  494. SELECT `groupes_entrainements`.`id`, `groupes_entrainements`.`id_module`, `groupes_entrainements`.`type_seance`, `groupes_entrainements`.`statut`, `date_debut`, `heure_debut`, `date_fin`, `heure_fin`, `groupes_entrainements`.`items`, `items_passes`, `users`.`prenom`, `users`.`nom`, `users`.`fuseau`, `groupes`.`id` as `id_groupe`, DATE_FORMAT(date_fin, "%d/%m/%Y") AS date_fin_texte
  495. FROM `my_domain_enseignant`.`groupes_entrainements`
  496. JOIN `my_domain_enseignant`.`groupes` ON `groupes`.`id` = `groupes_entrainements`.`id_groupe`
  497. JOIN `users` ON `users`.`id` = `groupes`.`id_enseignant`
  498. LEFT JOIN `my_domain_enseignant`.`eleves_entrainements` ON (`eleves_entrainements`.`id_eleve` = `groupes_entrainements`.`id_eleve` AND `eleves_entrainements`.`id_groupe` = `groupes`.`id` AND `eleves_entrainements`.`id_module` = `groupes_entrainements`.`id_module` AND `eleves_entrainements`.`timestamp_reset` = groupes_entrainements.timestamp_reset)
  499. WHERE `groupes_entrainements`.`id_groupe` IN ('44703')
  500. AND `groupes_entrainements`.`id_eleve` = '453535'
  501. AND `groupes_entrainements`.`statut` = 'ouvert'\G
  502.  
  503. # Query 12: 1.35 QPS, 0.00x concurrency, ID 0xE0E72E5DFD65D72794F47D77E06C3C33 at byte 4140545717
  504. # This item is included in the report because it matches --limit.
  505. # Scores: V/M = 17.59
  506. # Time range: 2022-03-10 00:01:34 to 2022-03-11 00:02:25
  507. # Attribute pct total min max avg 95% stddev median
  508. # ============ === ======= ======= ======= ======= ======= ======= =======
  509. # Count 1 116848
  510. # Exec time 1 189s 63us 22s 2ms 204us 169ms 93us
  511. # Lock time 0 4s 17us 12ms 33us 66us 45us 27us
  512. # Rows sent 0 114.11k 1 1 1 1 0 1
  513. # Rows examine 0 114.11k 1 1 1 1 0 1
  514. # Rows affecte 0 0 0 0 0 0 0 0
  515. # Bytes sent 2 223.08M 1.95k 1.96k 1.95k 1.86k 4 1.86k
  516. # Query size 0 13.36M 118 120 119.86 118.34 1 118.34
  517. # String:
  518. # Databases my_domain_common
  519. # Hosts localhost
  520. # Users my_domain
  521. # Query_time distribution
  522. # 1us
  523. # 10us ################################################################
  524. # 100us ######################################
  525. # 1ms #
  526. # 10ms #
  527. # 100ms
  528. # 1s #
  529. # 10s+ #
  530. # Tables
  531. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_entrainements'\G
  532. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_entrainements`\G
  533. # EXPLAIN /*!50100 PARTITIONS*/
  534. SELECT *
  535. FROM `my_domain_enseignant`.`eleves_entrainements`
  536. WHERE `my_domain_enseignant`.`eleves_entrainements`.`id` = '4248835'\G
  537.  
  538. # Query 13: 0.67 QPS, 0.00x concurrency, ID 0x537259425900F38C3A8C572140C12DDD at byte 4157810510
  539. # This item is included in the report because it matches --limit.
  540. # Scores: V/M = 13.23
  541. # Time range: 2022-03-10 00:01:29 to 2022-03-11 00:02:33
  542. # Attribute pct total min max avg 95% stddev median
  543. # ============ === ======= ======= ======= ======= ======= ======= =======
  544. # Count 0 57971
  545. # Exec time 1 178s 139us 19s 3ms 490us 202ms 287us
  546. # Lock time 0 5s 38us 16ms 85us 138us 72us 80us
  547. # Rows sent 0 66.89k 0 7 1.18 1.96 0.74 0.99
  548. # Rows examine 0 205.50k 0 21 3.63 5.75 2.33 2.90
  549. # Rows affecte 0 0 0 0 0 0 0 0
  550. # Bytes sent 0 28.97M 465 842 524.02 563.87 41.40 511.45
  551. # Query size 1 23.39M 423 423 423 423 0 423
  552. # String:
  553. # Databases my_domain_common
  554. # Hosts localhost
  555. # Users my_domain
  556. # Query_time distribution
  557. # 1us
  558. # 10us
  559. # 100us ################################################################
  560. # 1ms #
  561. # 10ms #
  562. # 100ms
  563. # 1s #
  564. # 10s+ #
  565. # Tables
  566. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes_eleves'\G
  567. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes_eleves`\G
  568. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes'\G
  569. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes`\G
  570. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'users'\G
  571. # SHOW CREATE TABLE `my_domain_common`.`users`\G
  572. # EXPLAIN /*!50100 PARTITIONS*/
  573. SELECT `id_eleve`, `id_groupe`, `groupes`.`nom`, `groupes`.`modules`, `users`.`nom` as `nom_enseignant`, `users`.`prenom` as `prenom_enseignant`
  574. FROM `my_domain_enseignant`.`groupes_eleves`
  575. JOIN `my_domain_enseignant`.`groupes` ON `groupes`.`id` = `my_domain_enseignant`.`groupes_eleves`.`id_groupe`
  576. JOIN `users` ON `users`.`id` = `groupes`.`id_enseignant`
  577. WHERE `id_eleve` = '464068'
  578. AND `groupes`.`deleted_at` = '0000-00-00 00:00:00'\G
  579.  
  580. # Query 14: 0.26 QPS, 0.00x concurrency, ID 0xB8AD06E6E2CD1AADBA9EC5C99D2A729B at byte 386411174
  581. # This item is included in the report because it matches --limit.
  582. # Scores: V/M = 16.47
  583. # Time range: 2022-03-10 00:02:22 to 23:00:34
  584. # Attribute pct total min max avg 95% stddev median
  585. # ============ === ======= ======= ======= ======= ======= ======= =======
  586. # Count 0 21860
  587. # Exec time 1 173s 112us 26s 8ms 348us 361ms 194us
  588. # Lock time 7 130s 24us 26s 6ms 80us 337ms 40us
  589. # Rows sent 0 0 0 0 0 0 0 0
  590. # Rows examine 0 0 0 0 0 0 0 0
  591. # Rows affecte 2 21.35k 1 1 1 1 0 1
  592. # Bytes sent 0 405.61k 19 19 19 19 0 19
  593. # Query size 0 6.99M 314 463 335.41 363.48 18.53 329.68
  594. # String:
  595. # Databases my_domain_common
  596. # Hosts localhost
  597. # Users my_domain
  598. # Query_time distribution
  599. # 1us
  600. # 10us
  601. # 100us ################################################################
  602. # 1ms #
  603. # 10ms #
  604. # 100ms #
  605. # 1s #
  606. # 10s+ #
  607. # Tables
  608. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'passations'\G
  609. # SHOW CREATE TABLE `my_domain_enseignant`.`passations`\G
  610. INSERT INTO `my_domain_enseignant`.`passations` (`id_eleve`, `id_module`, `id_item`, `date`, `heure`, `type_question`, `duree`, `score`, `premier`, `num_reponse`, `reponses`, `age`, `methode`, `num_eval`) VALUES ('511822', '1', '173', '2022-03-10', '06:25:17', 'principale', 32, 0, 1, 1, 'Oui', '11.33', 'evaluation', '1')\G
  611.  
  612. # Query 15: 0.49 QPS, 0.00x concurrency, ID 0xC92D5A3B71E57D4FCC39C8866466FDA5 at byte 4157955194
  613. # This item is included in the report because it matches --limit.
  614. # Scores: V/M = 8.85
  615. # Time range: 2022-03-10 01:11:30 to 2022-03-11 00:02:29
  616. # Attribute pct total min max avg 95% stddev median
  617. # ============ === ======= ======= ======= ======= ======= ======= =======
  618. # Count 0 40118
  619. # Exec time 1 135s 233us 19s 3ms 1ms 173ms 725us
  620. # Lock time 0 5s 49us 22ms 117us 194us 113us 103us
  621. # Rows sent 0 43.76k 0 2 1.12 1.96 0.40 0.99
  622. # Rows examine 0 4.04M 0 1.88k 105.49 234.30 86.93 76.28
  623. # Rows affecte 0 0 0 0 0 0 0 0
  624. # Bytes sent 1 113.90M 2.69k 4.32k 2.91k 3.04k 123.86 2.76k
  625. # Query size 1 24.38M 628 641 637.25 621.67 0 621.67
  626. # String:
  627. # Databases my_domain_common
  628. # Hosts localhost
  629. # Users my_domain
  630. # Query_time distribution
  631. # 1us
  632. # 10us
  633. # 100us ################################################################
  634. # 1ms ######################
  635. # 10ms #
  636. # 100ms #
  637. # 1s #
  638. # 10s+ #
  639. # Tables
  640. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'passations'\G
  641. # SHOW CREATE TABLE `my_domain_enseignant`.`passations`\G
  642. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves'\G
  643. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves`\G
  644. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes_eleves'\G
  645. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes_eleves`\G
  646. # EXPLAIN /*!50100 PARTITIONS*/
  647. SELECT `passations`.*, AES_DECRYPT(eleves.nom, 'key') as nom, AES_DECRYPT(eleves.prenom, 'key') as prenom
  648. FROM my_domain_enseignant.passations
  649. JOIN `my_domain_enseignant`.`eleves` ON `eleves`.`id` = `my_domain_enseignant`.`passations`.`id_eleve`
  650. JOIN `my_domain_enseignant`.`groupes_eleves` ON `groupes_eleves`.`id_eleve` = `passations`.`id_eleve`
  651. WHERE `id_module` = '1'
  652. AND `groupes_eleves`.`id_groupe` = '46298'
  653. AND `id_item` = '751'
  654. AND `type_seance` = 'normale'
  655. AND `passations`.`id_eleve` = '451282'
  656. AND `timestamp_entrainement` = '1646919320605'
  657. AND `methode` = 'entrainement'
  658. AND `premier` = 1\G
  659.  
  660. # Query 16: 1.34 QPS, 0.00x concurrency, ID 0x95C35A7EC678D7D868D7830A48A5308D at byte 4157971072
  661. # This item is included in the report because it matches --limit.
  662. # Scores: V/M = 11.48
  663. # Time range: 2022-03-10 00:01:34 to 2022-03-11 00:02:25
  664. # Attribute pct total min max avg 95% stddev median
  665. # ============ === ======= ======= ======= ======= ======= ======= =======
  666. # Count 1 116191
  667. # Exec time 1 128s 116us 20s 1ms 332us 112ms 176us
  668. # Lock time 0 6s 32us 3ms 49us 80us 22us 42us
  669. # Rows sent 0 0 0 0 0 0 0 0
  670. # Rows examine 0 0 0 0 0 0 0 0
  671. # Rows affecte 12 113.47k 1 1 1 1 0 1
  672. # Bytes sent 0 2.11M 19 19 19 19 0 19
  673. # Query size 3 75.66M 635 2.48k 682.84 685.39 205.25 621.67
  674. # String:
  675. # Databases my_domain_common
  676. # Hosts localhost
  677. # Users my_domain
  678. # Query_time distribution
  679. # 1us
  680. # 10us
  681. # 100us ################################################################
  682. # 1ms #
  683. # 10ms #
  684. # 100ms #
  685. # 1s #
  686. # 10s+ #
  687. # Tables
  688. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'passations'\G
  689. # SHOW CREATE TABLE `my_domain_enseignant`.`passations`\G
  690. INSERT INTO `my_domain_enseignant`.`passations` (`id_eleve`, `id_module`, `type_seance`, `id_item`, `date`, `heure`, `format_question`, `type_question`, `duree`, `score`, `premier`, `num_reponse`, `reponses`, `age`, `methode`, `niveau`, `timestamp_entrainement`, `mots_bleus`, `question_preparatoire`, `lecture_audio`, `font_size`, `line_height`, `letter_spacing`, `word_spacing`, `font_family`, `lire_couleur`, `phonemes`) VALUES ('481362', '1', 'normale', '1168', '2022-03-10', '17:36:46', 'qcm', 'principale', 16, 1, 1, 0, 'En Pologne', '10.25', 'entrainement', '5', '1646725403993', 'false', 'false', 'false', '14', '25', '0', '0', '1', 'normal', '')\G
  691.  
  692. # Query 17: 0.86 QPS, 0.00x concurrency, ID 0x0C5F08D29A567CB87E35AFDBF1DB0E32 at byte 4140917871
  693. # This item is included in the report because it matches --limit.
  694. # Scores: V/M = 6.24
  695. # Time range: 2022-03-10 00:06:03 to 2022-03-11 00:02:31
  696. # Attribute pct total min max avg 95% stddev median
  697. # ============ === ======= ======= ======= ======= ======= ======= =======
  698. # Count 0 74414
  699. # Exec time 0 93s 174us 12s 1ms 725us 88ms 424us
  700. # Lock time 0 7s 32us 12ms 90us 159us 62us 76us
  701. # Rows sent 3 1.78M 0 85 25.08 59.77 18.46 22.53
  702. # Rows examine 0 3.96M 0 185 55.79 112.70 34.99 46.83
  703. # Rows affecte 0 0 0 0 0 0 0 0
  704. # Bytes sent 2 167.78M 859 5.84k 2.31k 4.27k 1.09k 2.16k
  705. # Query size 1 23.77M 335 335 335 335 0 335
  706. # String:
  707. # Databases my_domain_common
  708. # Hosts localhost
  709. # Users my_domain
  710. # Query_time distribution
  711. # 1us
  712. # 10us
  713. # 100us ################################################################
  714. # 1ms #
  715. # 10ms #
  716. # 100ms
  717. # 1s #
  718. # 10s+ #
  719. # Tables
  720. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_evaluations'\G
  721. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_evaluations`\G
  722. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes_eleves'\G
  723. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes_eleves`\G
  724. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'groupes'\G
  725. # SHOW CREATE TABLE `my_domain_enseignant`.`groupes`\G
  726. # EXPLAIN /*!50100 PARTITIONS*/
  727. SELECT `my_domain_enseignant`.`eleves_evaluations`.*
  728. FROM `my_domain_enseignant`.`eleves_evaluations`
  729. JOIN `my_domain_enseignant`.`groupes_eleves` ON `groupes_eleves`.`id_eleve` = `eleves_evaluations`.`id_eleve`
  730. JOIN `my_domain_enseignant`.`groupes` ON `groupes`.`id` = `groupes_eleves`.`id_groupe`
  731. WHERE `id_module` = '1'
  732. AND `groupes`.`id` = '47794'\G
  733.  
  734. # Query 18: 0.42 QPS, 0.00x concurrency, ID 0x39F09CC45DDED067110B75DF0148EAEF at byte 4157849571
  735. # This item is included in the report because it matches --limit.
  736. # Scores: V/M = 13.44
  737. # Time range: 2022-03-10 00:01:30 to 2022-03-11 00:02:24
  738. # Attribute pct total min max avg 95% stddev median
  739. # ============ === ======= ======= ======= ======= ======= ======= =======
  740. # Count 0 36153
  741. # Exec time 0 87s 122us 20s 2ms 467us 179ms 287us
  742. # Lock time 0 3s 38us 8ms 95us 144us 48us 89us
  743. # Rows sent 0 35.31k 1 1 1 1 0 1
  744. # Rows examine 0 35.31k 1 1 1 1 0 1
  745. # Rows affecte 0 0 0 0 0 0 0 0
  746. # Bytes sent 1 93.38M 2.60k 2.81k 2.64k 2.62k 48.66 2.62k
  747. # Query size 1 23.82M 687 691 690.90 685.39 0 685.39
  748. # String:
  749. # Databases my_domain_common
  750. # Hosts localhost
  751. # Users my_domain
  752. # Query_time distribution
  753. # 1us
  754. # 10us
  755. # 100us ################################################################
  756. # 1ms #
  757. # 10ms
  758. # 100ms #
  759. # 1s #
  760. # 10s+ #
  761. # Tables
  762. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'users'\G
  763. # SHOW CREATE TABLE `my_domain_common`.`users`\G
  764. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'etablissements'\G
  765. # SHOW CREATE TABLE `my_domain_common`.`etablissements`\G
  766. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'communes'\G
  767. # SHOW CREATE TABLE `my_domain_common`.`communes`\G
  768. # SHOW TABLE STATUS FROM `my_domain_common` LIKE 'pays'\G
  769. # SHOW CREATE TABLE `my_domain_common`.`pays`\G
  770. # EXPLAIN /*!50100 PARTITIONS*/
  771. SELECT `users`.*, `etablissements`.`code_uai`, `etablissements`.`type` AS `type_etablissement`, `etablissements`.`precision` AS `precision_etablissement`, `etablissements`.`nom` AS `nom_etablissement`, `etablissements`.`id_pays`, `etablissements`.`id_commune`, `etablissements`.`adresse`, `etablissements`.`telephone`, `communes`.`commune` AS `nom_commune`, `communes`.`code_postal` AS `code_postal`, `pays`.`nom` as `pays`, `pays`.`periode_scolaire`
  772. FROM `users`
  773. JOIN `etablissements` ON `etablissements`.`id` = `users`.`id_etablissement`
  774. JOIN `communes` ON `communes`.`id` = `etablissements`.`id_commune`
  775. JOIN `pays` ON `pays`.`id` = `etablissements`.`id_pays`
  776. WHERE `users`.`id` = '54832'\G
  777.  
  778. # Query 19: 0.07 QPS, 0.00x concurrency, ID 0x451084DDC0DC3C16A9C8DE00C43A8043 at byte 386427079
  779. # This item is included in the report because it matches --limit.
  780. # Scores: V/M = 33.64
  781. # Time range: 2022-03-10 00:01:34 to 2022-03-11 00:02:05
  782. # Attribute pct total min max avg 95% stddev median
  783. # ============ === ======= ======= ======= ======= ======= ======= =======
  784. # Count 0 6080
  785. # Exec time 0 73s 80us 37s 12ms 224us 634ms 113us
  786. # Lock time 4 72s 18us 37s 12ms 49us 634ms 23us
  787. # Rows sent 0 0 0 0 0 0 0 0
  788. # Rows examine 0 5.94k 1 1 1 1 0 1
  789. # Rows affecte 0 5.93k 0 1 1.00 0.99 0.04 0.99
  790. # Bytes sent 0 308.75k 52 52 52 52 0 52
  791. # Query size 0 787.45k 132 134 132.62 130.47 0 130.47
  792. # String:
  793. # Databases my_domain_common
  794. # Hosts localhost
  795. # Users my_domain
  796. # Query_time distribution
  797. # 1us
  798. # 10us ###
  799. # 100us ################################################################
  800. # 1ms #
  801. # 10ms
  802. # 100ms
  803. # 1s
  804. # 10s+ #
  805. # Tables
  806. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_activity'\G
  807. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_activity`\G
  808. UPDATE `my_domain_enseignant`.`eleves_activity` SET `nb_connexions` = 30, `connexion` = '2022-03-10 06:25:06'
  809. WHERE `id_eleve` = '456590'\G
  810. # Converted for EXPLAIN
  811. # EXPLAIN /*!50100 PARTITIONS*/
  812. select `nb_connexions` = 30, `connexion` = '2022-03-10 06:25:06' from `my_domain_enseignant`.`eleves_activity` where `id_eleve` = '456590'\G
  813.  
  814. # Query 20: 0.99 QPS, 0.00x concurrency, ID 0x045F24444067A1520DC7AD881DAF54BF at byte 4140533214
  815. # This item is included in the report because it matches --limit.
  816. # Scores: V/M = 12.41
  817. # Time range: 2022-03-10 00:01:41 to 2022-03-11 00:02:27
  818. # Attribute pct total min max avg 95% stddev median
  819. # ============ === ======= ======= ======= ======= ======= ======= =======
  820. # Count 0 85222
  821. # Exec time 0 64s 111us 25s 747us 490us 96ms 273us
  822. # Lock time 0 4s 16us 19ms 48us 84us 70us 42us
  823. # Rows sent 0 77.30k 0 1 0.93 0.99 0.26 0.99
  824. # Rows examine 0 1.26M 0 214 15.56 40.45 18.42 10.84
  825. # Rows affecte 0 0 0 0 0 0 0 0
  826. # Bytes sent 2 162.06M 1.84k 1.96k 1.95k 1.86k 31.14 1.86k
  827. # Query size 0 11.78M 145 145 145 145 0 145
  828. # String:
  829. # Databases my_domain_common
  830. # Hosts localhost
  831. # Users my_domain
  832. # Query_time distribution
  833. # 1us
  834. # 10us
  835. # 100us ################################################################
  836. # 1ms #
  837. # 10ms #
  838. # 100ms
  839. # 1s
  840. # 10s+ #
  841. # Tables
  842. # SHOW TABLE STATUS FROM `my_domain_enseignant` LIKE 'eleves_entrainements'\G
  843. # SHOW CREATE TABLE `my_domain_enseignant`.`eleves_entrainements`\G
  844. # EXPLAIN /*!50100 PARTITIONS*/
  845. SELECT *
  846. FROM `my_domain_enseignant`.`eleves_entrainements`
  847. WHERE `id_eleve` = '466602'
  848. AND `id_module` = '1'
  849. AND `timestamp_reset` = '1646469742326'\G
  850.  
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!