Advertisement
gabrielesilinic

Console output from MySQL id random generation for testing collisions

Jun 20th, 2021
498
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.69 KB | None | 0 0
  1. # this is a manually written note
  2. # there are several types of output lines
  3. # the progress line it's like this
  4. # 0/2000000000, 0.0, 0 collisions so far
  5. # this kind of note lets you know in this order:
  6. # progress now/total, progress ratio and number of collisions
  7. # nothing was meant to be parsed by a computer but it's still possible to parse them.
  8. # uidmax instead tells you the upper value the ID can be randomly chosen
  9. # the range of the randint function here is from 0 to 2147483647.
  10. # this line instead tells you where the collision and what is his order
  11. # here for example the first collision happend while creating the 113661th element:
  12. # collision 1, index 11366
  13. uidmax: 2147483647
  14. 0/2000000000, 0.0, 0 collisions so far
  15. 20000/2000000000, 1e-05, 0 collisions so far
  16. 40000/2000000000, 2e-05, 0 collisions so far
  17. 60000/2000000000, 3e-05, 0 collisions so far
  18. 80000/2000000000, 4e-05, 0 collisions so far
  19. 100000/2000000000, 5e-05, 0 collisions so far
  20. collision 1, index 113661
  21. 120000/2000000000, 6e-05, 1 collisions so far
  22. 140000/2000000000, 7e-05, 1 collisions so far
  23. collision 2, index 143316
  24. collision 3, index 154735
  25. collision 4, index 159337
  26. 160000/2000000000, 8e-05, 4 collisions so far
  27. collision 5, index 168580
  28. collision 6, index 176946
  29. 180000/2000000000, 9e-05, 6 collisions so far
  30. collision 7, index 183227
  31. 200000/2000000000, 0.0001, 7 collisions so far
  32. collision 8, index 200230
  33. collision 9, index 206221
  34. 220000/2000000000, 0.00011, 9 collisions so far
  35. collision 10, index 227511
  36. collision 11, index 227521
  37. collision 12, index 229698
  38. collision 13, index 236745
  39. 240000/2000000000, 0.00012, 13 collisions so far
  40. collision 14, index 241137
  41. collision 15, index 247660
  42. collision 16, index 251140
  43. collision 17, index 258474
  44. 260000/2000000000, 0.00013, 17 collisions so far
  45. collision 18, index 271547
  46. collision 19, index 273090
  47. collision 20, index 273600
  48. 280000/2000000000, 0.00014, 20 collisions so far
  49. collision 21, index 288411
  50. collision 22, index 292009
  51. collision 23, index 295725
  52. collision 24, index 296420
  53. 300000/2000000000, 0.00015, 24 collisions so far
  54. collision 25, index 303121
  55. 320000/2000000000, 0.00016, 25 collisions so far
  56. collision 26, index 332694
  57. collision 27, index 334436
  58. 340000/2000000000, 0.00017, 27 collisions so far
  59. collision 28, index 340394
  60. collision 29, index 344063
  61. collision 30, index 354554
  62. collision 31, index 358695
  63. 360000/2000000000, 0.00018, 31 collisions so far
  64. collision 32, index 360133
  65. collision 33, index 369629
  66. collision 34, index 375527
  67. collision 35, index 377610
  68. collision 36, index 378391
  69. collision 37, index 378464
  70. collision 38, index 379895
  71. collision 39, index 379930
  72. 380000/2000000000, 0.00019, 39 collisions so far
  73. collision 40, index 385933
  74. 400000/2000000000, 0.0002, 40 collisions so far
  75. collision 41, index 406991
  76. collision 42, index 411225
  77. 420000/2000000000, 0.00021, 42 collisions so far
  78. collision 43, index 420360
  79. collision 44, index 422585
  80. collision 45, index 423916
  81. collision 46, index 425760
  82. collision 47, index 426904
  83. collision 48, index 434334
  84. collision 49, index 437647
  85. collision 50, index 437821
  86. collision 51, index 438544
  87. 440000/2000000000, 0.00022, 51 collisions so far
  88. collision 52, index 441213
  89. collision 53, index 444820
  90. collision 54, index 447374
  91. collision 55, index 448031
  92. collision 56, index 452485
  93. 460000/2000000000, 0.00023, 56 collisions so far
  94. collision 57, index 463663
  95. collision 58, index 467012
  96. 480000/2000000000, 0.00024, 58 collisions so far
  97. collision 59, index 492927
  98. collision 60, index 494217
  99. collision 61, index 495234
  100. 500000/2000000000, 0.00025, 61 collisions so far
  101. collision 62, index 509661
  102. 520000/2000000000, 0.00026, 62 collisions so far
  103. collision 63, index 524213
  104. collision 64, index 530719
  105. collision 65, index 535572
  106. collision 66, index 536243
  107. 540000/2000000000, 0.00027, 66 collisions so far
  108. collision 67, index 543717
  109. collision 68, index 544315
  110. collision 69, index 546159
  111. collision 70, index 547038
  112. collision 71, index 549819
  113. collision 72, index 559616
  114. 560000/2000000000, 0.00028, 72 collisions so far
  115. collision 73, index 560372
  116. collision 74, index 564343
  117. collision 75, index 578016
  118. 580000/2000000000, 0.00029, 75 collisions so far
  119. collision 76, index 584201
  120. collision 77, index 585823
  121. collision 78, index 586680
  122. collision 79, index 590926
  123. collision 80, index 597537
  124. collision 81, index 597799
  125. 600000/2000000000, 0.0003, 81 collisions so far
  126. collision 82, index 602508
  127. collision 83, index 605677
  128. collision 84, index 608972
  129. collision 85, index 610950
  130. collision 86, index 612148
  131. 620000/2000000000, 0.00031, 86 collisions so far
  132. collision 87, index 620804
  133. collision 88, index 625380
  134. collision 89, index 627647
  135. collision 90, index 632105
  136. collision 91, index 632170
  137. collision 92, index 635000
  138. collision 93, index 635798
  139. collision 94, index 636403
  140. collision 95, index 637140
  141. 640000/2000000000, 0.00032, 95 collisions so far
  142. collision 96, index 643198
  143. collision 97, index 644061
  144. collision 98, index 644088
  145. collision 99, index 645038
  146. collision 100, index 647408
  147. collision 101, index 649350
  148. collision 102, index 651807
  149. collision 103, index 651962
  150. collision 104, index 656344
  151. 660000/2000000000, 0.00033, 104 collisions so far
  152. collision 105, index 662272
  153. collision 106, index 669815
  154. collision 107, index 670006
  155. collision 108, index 671899
  156. collision 109, index 674660
  157. 680000/2000000000, 0.00034, 109 collisions so far
  158. collision 110, index 680930
  159. collision 111, index 681688
  160. collision 112, index 688104
  161. collision 113, index 689222
  162. collision 114, index 691308
  163. collision 115, index 692671
  164. collision 116, index 693358
  165. collision 117, index 695809
  166. collision 118, index 697983
  167. collision 119, index 698615
  168. collision 120, index 699242
  169. 700000/2000000000, 0.00035, 120 collisions so far
  170. collision 121, index 700022
  171. collision 122, index 705557
  172. collision 123, index 718559
  173. 720000/2000000000, 0.00036, 123 collisions so far
  174. collision 124, index 734501
  175. collision 125, index 739838
  176. 740000/2000000000, 0.00037, 125 collisions so far
  177. collision 126, index 741598
  178. collision 127, index 746388
  179. collision 128, index 753073
  180. collision 129, index 756706
  181. collision 130, index 757292
  182. collision 131, index 758414
  183. collision 132, index 758843
  184. 760000/2000000000, 0.00038, 132 collisions so far
  185. collision 133, index 761070
  186. collision 134, index 763023
  187. collision 135, index 763284
  188. collision 136, index 765324
  189. collision 137, index 773437
  190. 780000/2000000000, 0.00039, 137 collisions so far
  191. collision 138, index 781047
  192. collision 139, index 784220
  193. collision 140, index 785269
  194. collision 141, index 791599
  195. collision 142, index 794071
  196. collision 143, index 794228
  197. 800000/2000000000, 0.0004, 143 collisions so far
  198. collision 144, index 800917
  199. collision 145, index 801899
  200. collision 146, index 802130
  201. collision 147, index 804387
  202. collision 148, index 811510
  203. collision 149, index 812292
  204. collision 150, index 812986
  205. collision 151, index 813207
  206. collision 152, index 819148
  207. collision 153, index 819548
  208. 820000/2000000000, 0.00041, 153 collisions so far
  209. collision 154, index 825784
  210. collision 155, index 826160
  211. collision 156, index 829419
  212. collision 157, index 830652
  213. collision 158, index 831821
  214. collision 159, index 831902
  215. collision 160, index 838244
  216. 840000/2000000000, 0.00042, 160 collisions so far
  217. collision 161, index 841910
  218. collision 162, index 847514
  219. collision 163, index 847846
  220. collision 164, index 853213
  221. collision 165, index 856399
  222. collision 166, index 856515
  223. collision 167, index 856590
  224. collision 168, index 857486
  225. 860000/2000000000, 0.00043, 168 collisions so far
  226. collision 169, index 866326
  227. collision 170, index 866775
  228. collision 171, index 871504
  229. collision 172, index 873155
  230. 880000/2000000000, 0.00044, 172 collisions so far
  231. # Aborted because it was taking ages
  232. # code at https://pastebin.com/iyLNzfg9
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement