API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 25th, 2019
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.15 KB | None | 0 0
raw download clone embed print report
  1. # MySQL Performance documentation for Node:
  2. db-mysql-hackathon0a.42.wixprod.net
  3.  
  4. Generated by WIX MySQL DATA team v1.0.0
  5.  
  6. 2019-04-15 13:22:35.410520
  7.  
  8. ## Table with no Primary key
  9. |TABLE_SCHEMA|TABLE_NAME|
  10. | --- | --- |
  11. |hackathon_db1|spaces
  12. |hackathon_db26|migration_version
  13. |instance_info|instance_info
  14.  
  15. ## Unused Indexes
  16. |object_schema|NumUnusedIndexes|
  17. | --- | --- |
  18. |hackathon_db26|team_id_idx
  19. |hackathon_db26|room_id_idx
  20. |hackathon_db26|fulltext
  21. |hackathon_db26|fulltext
  22. |hackathon_db26|floor_id_idx
  23. |hackathon_db26|fulltext
  24. |hackathon_db6|name_text_idx
  25. |hackathon_db6|cat_aliases_fulltext_idx
  26. |hackathon_db6|name_fulltext_idx
  27. |hackathon_db6|instance_id
  28. |hackathon_db6|service_type_id_idx
  29. |hackathon_db6|geometry_idx
  30. |hackathon_db6|service_by_creation_time
  31. |hackathon_db6|services_events_by_time
  32. |hackathon_db6|bids_events_by_time
  33. |hackathon_db6|bids_tenant_id_idx
  34. |hackathon_db6|bids_requesting_service_id_idx
  35. |hackathon_db6|bids_requested_service_type_id_idx
  36. |hackathon_db6|geometry_idx
  37. |hackathon_db6|bids_by_creation_time
  38.  
  39. ## Statement performance analyzer
  40. |db|query|full_scan|exec_counts|max_latency|avg_latency|rows_sent_avgs|rows_examined_avgs|last_seen_|digest|
  41. | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
  42. |hackathon_db25|SELECT * FROM `produced_messages` WHERE `topic` = ? |*|3058|4.54 s|265.16 ms|2252|475938|2019-04-15 10:16:39|386356f797a39dee3923a94b3ca9062b
  43. |hackathon_db25|SELECT * FROM `consumed_messages` WHERE `topic` = ? |*|3058|2.79 s|975.55 ms|4100|1635557|2019-04-15 10:16:40|9655bf6974aa1e3cf09de7973a8d25b5
  44. |hackathon_db25|SELECT * FROM `produced_messages` WHERE `message_id` = ? |*|4|2.16 s|2.16 s|0|4018700|2019-04-14 16:31:06|f2d2e0da417290596a81cc8fa6f13d2a
  45. |hackathon_db25|SELECT * FROM `produced_messages` WHERE `topic` = ? LIMIT ? |*|4|2.19 s|2.14 s|3|3963633|2019-04-14 17:50:22|b00c453e190f31412fac0c72009f2fb2
  46. |hackathon_db25|SELECT DISTINCTROW `topic` FROM `produced_messages` |*|8|10.87 s|9.32 s|51|3550273|2019-04-15 07:22:20|b58600d33d937c12e4f8dd80961db9cc
  47. |hackathon_db16|INSERT INTO `track` VALUES (...) /* , ... */ ||1|511.81 ms|511.81 ms|0|0|2019-04-11 09:31:44|cadeb8b0a4bd74fd448bf1cf324f26ce
  48. |hackathon_db16|INSERT INTO `track_ganres` VALUES (...) /* , ... */ ||1|23.83 s|23.83 s|0|0|2019-04-11 09:32:09|3ed4655facd1182798d350a2eb5edbf4
  49. |hackathon_db25|ALTER TABLE `produced_messages ... `p35` , `p36` , `p37` , `p38` ||1|145.81 ms|145.81 ms|0|0|2019-04-14 22:00:00|2a784288a35897cd2aa811d17f5e96df
  50. |hackathon_db25|ALTER TABLE `consumed_messages ... `p35` , `p36` , `p37` , `p38` ||1|144.49 ms|144.49 ms|0|0|2019-04-14 22:00:00|d90224c6b62f47d9ab6eb91917b940b3
  51. |hackathon_db25|ALTER TABLE `produced_messages ... `p36` , `p37` , `p38` , `p39` ||1|157.24 ms|157.24 ms|0|0|2019-04-14 23:00:00|c079ff9c665f2c15177cdd240ec262f7
  52. |hackathon_db25|ALTER TABLE `consumed_messages ... `p36` , `p37` , `p38` , `p39` ||1|148.00 ms|148.00 ms|0|0|2019-04-14 23:00:00|37c74019ee49f61e9f1d9507c485a1ce
  53. |hackathon_db25|ALTER TABLE `produced_messages ... `p37` , `p38` , `p39` , `p40` ||1|168.21 ms|168.21 ms|0|0|2019-04-15 00:00:00|876ec5ba426bd2463ee8b1fb0bd419f7
  54. |hackathon_db25|ALTER TABLE `consumed_messages ... `p37` , `p38` , `p39` , `p40` ||1|168.51 ms|168.51 ms|0|0|2019-04-15 00:00:00|e07236285c824866182d6767c686d99a
  55. |hackathon_db25|ALTER TABLE `produced_messages ... `p38` , `p39` , `p40` , `p41` ||1|160.49 ms|160.49 ms|0|0|2019-04-15 01:00:00|46ac20a99a28a64b8eaafc2c5632fc0d
  56. |hackathon_db25|ALTER TABLE `consumed_messages ... `p38` , `p39` , `p40` , `p41` ||1|163.65 ms|163.65 ms|0|0|2019-04-15 01:00:00|c0e4bf5f0183c4dcf8b0ec8139137188
  57. |hackathon_db25|ALTER TABLE `produced_messages ... `p39` , `p40` , `p41` , `p42` ||1|168.65 ms|168.65 ms|0|0|2019-04-15 02:00:00|668a23650bc99907830d020cda906484
  58. |hackathon_db25|ALTER TABLE `consumed_messages ... `p39` , `p40` , `p41` , `p42` ||1|169.28 ms|169.28 ms|0|0|2019-04-15 02:00:00|d8f7a3fd3d38d3dd12de92b73fb5db7f
  59. |hackathon_db25|ALTER TABLE `produced_messages ... `p40` , `p41` , `p42` , `p43` ||1|167.89 ms|167.89 ms|0|0|2019-04-15 03:00:00|faf5e00a0917c8df26d72e31e1dcf8e6
  60. |hackathon_db25|ALTER TABLE `consumed_messages ... `p40` , `p41` , `p42` , `p43` ||1|170.38 ms|170.38 ms|0|0|2019-04-15 03:00:00|5a9cee7d2742310902509fd6939f82e1
  61. |hackathon_db25|ALTER TABLE `produced_messages ... `p41` , `p42` , `p43` , `p44` ||1|177.32 ms|177.32 ms|0|0|2019-04-15 04:00:00|427a8b646b84d0fb9fd906a5b05f8900
  62. |hackathon_db25|ALTER TABLE `consumed_messages ... `p41` , `p42` , `p43` , `p44` ||1|176.40 ms|176.40 ms|0|0|2019-04-15 04:00:00|a41b901c5d3eddadcf3bcc74650bdab8
  63. |hackathon_db25|ALTER TABLE `produced_messages ... `p42` , `p43` , `p44` , `p45` ||1|192.70 ms|192.70 ms|0|0|2019-04-15 05:00:00|e97297b7c4a57baba38f2f6f4912c57c
  64. |hackathon_db25|ALTER TABLE `consumed_messages ... `p42` , `p43` , `p44` , `p45` ||1|200.04 ms|200.04 ms|0|0|2019-04-15 05:00:00|a56887ac138c898f85d0d3ba5c64dd8d
  65. |hackathon_db25|ALTER TABLE `produced_messages ... `p43` , `p44` , `p45` , `p46` ||1|190.73 ms|190.73 ms|0|0|2019-04-15 06:00:00|5f2677633ec98e2af13cb40f1178596d
  66. |hackathon_db25|ALTER TABLE `consumed_messages ... `p43` , `p44` , `p45` , `p46` ||1|185.75 ms|185.75 ms|0|0|2019-04-15 06:00:00|e8a43e06140759ee79d60ebfb2eef00e
  67. |hackathon_db25|ALTER TABLE `produced_messages ... `p44` , `p45` , `p46` , `p47` ||1|191.86 ms|191.86 ms|0|0|2019-04-15 07:00:00|84a9fad83bb5195f10ccf286a0f831f5
  68. |hackathon_db25|ALTER TABLE `consumed_messages ... `p44` , `p45` , `p46` , `p47` ||1|190.03 ms|190.03 ms|0|0|2019-04-15 07:00:00|0a1cf3eff0eb132147d16cc0d2c696d9
  69. |hackathon_db25|ALTER TABLE `produced_messages ... `p45` , `p46` , `p47` , `p0` ||1|201.27 ms|201.27 ms|0|0|2019-04-15 08:00:00|5f3c97fb7a94b13d643dff2fa08d9dc8
  70. |hackathon_db25|ALTER TABLE `consumed_messages ... `p45` , `p46` , `p47` , `p0` ||1|192.95 ms|192.95 ms|0|0|2019-04-15 08:00:00|8325bc47f948ae0338c1730b63f6d658
  71. |hackathon_db25|ALTER TABLE `produced_messages ... , `p46` , `p47` , `p0` , `p1` ||1|213.50 ms|213.50 ms|0|0|2019-04-15 09:00:00|699f159d3b0bb227a7acd29f243f2898
  72. |hackathon_db25|ALTER TABLE `consumed_messages ... , `p46` , `p47` , `p0` , `p1` ||1|214.41 ms|214.41 ms|0|0|2019-04-15 09:00:00|073d2c1f0878de2d9934ebb0418b14bb
  73. |hackathon_db25|ALTER TABLE `produced_messages ... , `p47` , `p0` , `p1` , `p2` ||1|207.55 ms|207.55 ms|0|0|2019-04-15 10:00:00|5b490cc45aa82986b24262774026070f
  74. |hackathon_db25|ALTER TABLE `consumed_messages ... , `p47` , `p0` , `p1` , `p2` ||1|207.12 ms|207.12 ms|0|0|2019-04-15 10:00:00|de623eed0f99eacdc94170af9b2e385e
  75. |hackathon_db16|INSERT INTO `album` VALUES (...) /* , ... */ ||1|646.51 ms|646.51 ms|0|0|2019-04-11 09:31:37|fe00bfda03d394f22692377969c727e8
  76. |hackathon_db16|INSERT INTO `album_ganres` VALUES (...) /* , ... */ ||1|204.31 ms|204.31 ms|0|0|2019-04-11 09:31:39|55ef28bebfa054625a4746e9f1b7b2c4
  77. |hackathon_db25|DROP TABLE `produced_messages` ||1|260.49 ms|260.49 ms|0|0|2019-04-14 20:50:41|bd4aca1044e041db60251d5138c4d7a9
  78. |hackathon_db25|DROP TABLE `consumed_messages` ||1|287.42 ms|287.42 ms|0|0|2019-04-14 20:50:49|4305853dd7e9340229613b2a48be29b1
  79. |hackathon_db25|CREATE TABLE `produced_message ... RTITION `p41` VALUES IN (?) , ||1|320.13 ms|320.13 ms|0|0|2019-04-14 20:53:07|9bcff9379a93affe7eda53e88371c9e7
  80. |hackathon_db25|CREATE TABLE `consumed_message ... 39` VALUES IN (?) , PARTITION ||1|288.18 ms|288.18 ms|0|0|2019-04-14 20:53:28|89558d754a862064261775c429dc7679
  81.  
  82. ## Index statistics
  83. |table_schema|table_name|index_name|rows__selected|select__latency|rows__inserted|insert__latency|
  84. | --- | --- | --- | --- | --- | --- | --- |
  85. |hackathon_db25|produced_messages|topic|5031780|14.10 s|0|0 ps
  86. |hackathon_db16|user_tunes|u_id|881415|1.80 s|0|0 ps
  87. |hackathon_db16|users|PRIMARY|4657|170.25 ms|0|0 ps
  88. |hackathon_db16|family_ganres|family_id|66755|147.58 ms|0|0 ps
  89. |hackathon_db16|user_ganre_families|u_id|15590|56.25 ms|0|0 ps
  90. |hackathon_db16|album_ganres|album_id|5260|45.69 ms|0|0 ps
  91. |hackathon_db16|track_ganres|track_id|5222|42.57 ms|0|0 ps
  92. |hackathon_db16|track|PRIMARY|2836|34.78 ms|0|0 ps
  93. |hackathon_db16|album|PRIMARY|2201|33.31 ms|0|0 ps
  94. |hackathon_db6|provider_services_events|service_instance_tenant_version_idx|6711|24.91 ms|0|0 ps
  95. |hackathon_db16|ganre_family|PRIMARY|13509|23.32 ms|0|0 ps
  96. |hackathon_db6|provider_services|PRIMARY|524|6.08 ms|0|0 ps
  97. |hackathon_db16|users|username|613|17.43 ms|0|0 ps
  98. |hackathon_db1|likes|PRIMARY|539|12.82 ms|0|0 ps
  99. |hackathon_db26|rooms|PRIMARY|695|12.01 ms|0|0 ps
  100. |hackathon_db16|track|album_id|12326|9.15 ms|0|0 ps
  101. |hackathon_db11|obsfucation|PRIMARY|536|5.82 ms|0|0 ps
  102. |hackathon_db6|handled_events_for_view|PRIMARY|312|4.59 ms|0|0 ps
  103. |hackathon_db5|slack_thread|PRIMARY|128|2.43 ms|0|0 ps
  104. |hackathon_db28|members|PRIMARY|83|1.83 ms|0|0 ps
  105. |sys|sys_config|PRIMARY|125|2.28 ms|0|0 ps
  106. |hackathon_db6|service_bids|PRIMARY|60|735.42 us|0|0 ps
  107. |hackathon_db6|provider_services_events|PRIMARY|137|1.95 ms|0|0 ps
  108. |hackathon_db16|user_tunes|PRIMARY|0|0 ps|0|0 ps
  109. |hackathon_db1|users|PRIMARY|25|534.30 us|0|0 ps
  110. |hackathon_db6|service_bids_events|bids_tenant_tenant_version_idx|55|412.02 us|0|0 ps
  111. |hackathon_db1|users|phoneNumber|15|273.78 us|0|0 ps
  112. |hackathon_db26|tags|PRIMARY|14|216.02 us|0|0 ps
  113. |hackathon_db23|level_results|PRIMARY|7|68.70 us|0|0 ps
  114. |hackathon_db16|ganre_family|familyName|4|71.15 us|0|0 ps
  115. |hackathon_db6|service_bids_events|PRIMARY|4|68.75 us|0|0 ps
  116. |hackathon_db6|catalog_services|category_id_idx|116|44.47 us|0|0 ps
  117. |hackathon_db23|games|PRIMARY|1|26.88 us|0|0 ps
  118. |hackathon_db23|users|PRIMARY|1|23.00 us|0|0 ps
  119. |hackathon_db6|service_bids_events|bids_events_by_time|0|0 ps|0|0 ps
  120. |hackathon_db17|modules|PRIMARY|0|0 ps|0|0 ps
  121. |hackathon_db6|provider_services|instance_id|0|0 ps|0|0 ps
  122. |hackathon_db6|provider_services_events|services_events_by_time|0|0 ps|0|0 ps
  123. |hackathon_db6|service_bids|bids_tenant_id_idx|0|0 ps|0|0 ps
  124. |hackathon_db6|service_bids|bids_requesting_service_id_idx|0|0 ps|0|0 ps
  125. |hackathon_db6|service_bids|bids_requested_service_type_id_idx|0|0 ps|0|0 ps
  126. |hackathon_db6|service_bids|geometry_idx|0|0 ps|0|0 ps
  127. |hackathon_db6|service_bids|bids_by_creation_time|0|0 ps|0|0 ps
  128. |hackathon_db25|produced_messages|PRIMARY|0|0 ps|0|0 ps
  129. |hackathon_db16|album_ganres|PRIMARY|0|0 ps|0|0 ps
  130. |hackathon_db25|consumed_messages|PRIMARY|0|0 ps|0|0 ps
  131. |hackathon_db1|posts|PRIMARY|0|0 ps|0|0 ps
  132. |hackathon_db28|new_table|PRIMARY|0|0 ps|0|0 ps
  133. |hackathon_db26|rooms|fulltext|0|0 ps|0|0 ps
  134. |hackathon_db16|user_ganre_families|PRIMARY|0|0 ps|0|0 ps
  135. |hackathon_db26|people|PRIMARY|0|0 ps|0|0 ps
  136. |hackathon_db26|people|team_id_idx|0|0 ps|0|0 ps
  137. |hackathon_db26|people|room_id_idx|0|0 ps|0|0 ps
  138. |hackathon_db26|people|fulltext|0|0 ps|0|0 ps
  139. |hackathon_db26|teams|PRIMARY|0|0 ps|0|0 ps
  140. |hackathon_db26|teams|fulltext|0|0 ps|0|0 ps
  141. |hackathon_db16|track_ganres|PRIMARY|0|0 ps|0|0 ps
  142. |hackathon_db26|rooms|floor_id_idx|0|0 ps|0|0 ps
  143. |hackathon_db16|family_ganres|PRIMARY|0|0 ps|0|0 ps
  144. |hackathon_db23|results|PRIMARY|0|0 ps|0|0 ps
  145. |hackathon_db29|bookings|PRIMARY|0|0 ps|0|0 ps
  146. |hackathon_db6|catalog_services|PRIMARY|0|0 ps|0|0 ps
  147. |hackathon_db6|catalog_services|name_text_idx|0|0 ps|0|0 ps
  148. |hackathon_db6|catalog_services|cat_aliases_fulltext_idx|0|0 ps|0|0 ps
  149. |hackathon_db6|catalog_services|name_fulltext_idx|0|0 ps|0|0 ps
  150. |hackathon_db6|provider_services|service_type_id_idx|0|0 ps|0|0 ps
  151. |hackathon_db6|provider_services|geometry_idx|0|0 ps|0|0 ps
  152. |hackathon_db6|provider_services|service_by_creation_time|0|0 ps|0|0 ps
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!