Guest User

Manticore

a guest
Jul 12th, 2021
33
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MySQL [(none)]> CREATE TABLE `videos_test` (
  2. -> `source_id` string,
  3. -> `provider_id` uint,
  4. -> `title_unique` bool,
  5. -> `title` text,
  6. -> `summary` text,
  7. -> `tags` text,
  8. -> `names` text,
  9. -> `duration` uint,
  10. -> `thumb_exists` bool,
  11. -> `thumb_url` text stored,
  12. -> `flipbook` text stored,
  13. -> `straight` bool,
  14. -> `added_at` timestamp,
  15. -> `affected_at` timestamp,
  16. -> `removed_at` timestamp,
  17. -> `unlisted_at` timestamp,
  18. -> `hidden` bool
  19. -> ) ngram_len='1' ngram_chars='cjk' morphology='stem_enru'
  20. -> stopwords_unstemmed='1' stopwords='en ru zh ja ko'
  21. -> rt_mem_limit='2G';
  22. Query OK, 0 rows affected (0.030 sec)
  23.  
  24. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky', 'videos_test');
  25. +------+-----------+------------+
  26. | qpos | tokenized | normalized |
  27. +------+-----------+------------+
  28. | 1 | risky | riski |
  29. | 2 | things | thing |
  30. | 4 | risky | riski |
  31. +------+-----------+------------+
  32. 3 rows in set (0.002 sec)
  33.  
  34. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky', 'videos_test', 1 AS `stats`);
  35. +------+-----------+------------+------+------+
  36. | qpos | tokenized | normalized | docs | hits |
  37. +------+-----------+------------+------+------+
  38. | 1 | risky | riski | 0 | 0 |
  39. | 2 | things | thing | 0 | 0 |
  40. | 4 | risky | riski | 0 | 0 |
  41. +------+-----------+------------+------+------+
  42. 3 rows in set (0.001 sec)
  43.  
  44. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky-risky-risky!', 'videos_test', 1 AS `stats`);
  45. +------+-----------+------------+------+------+
  46. | qpos | tokenized | normalized | docs | hits |
  47. +------+-----------+------------+------+------+
  48. | 1 | risky | riski | 0 | 0 |
  49. | 2 | things | thing | 0 | 0 |
  50. | 4 | risky | riski | 0 | 0 |
  51. | 5 | risky | riski | 0 | 0 |
  52. | 6 | risky | riski | 0 | 0 |
  53. +------+-----------+------------+------+------+
  54. 5 rows in set (0.001 sec)
  55.  
  56. MySQL [(none)]> INSERT INTO `videos_test` (`id`, `source_id`, `provider_id`, `title_unique`, `title`, `summary`, `tags`, `names`, `duration`, `thumb_exists`, `thumb_url`, `flipbook`, `straight`, `added_at`, `affected_at`, `removed_at`, `unlisted_at`, `hidden`) VALUES (1, 'gsdg', 532, 1, 'ghfh', 'risky', 'things', 'risky', 352, 0, 'adgsdg', '111', 1, 64, 134, 0, 13, 1);
  57. Query OK, 1 row affected (0.104 sec)
  58.  
  59. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky', 'videos_test');
  60. +------+-----------+------------+
  61. | qpos | tokenized | normalized |
  62. +------+-----------+------------+
  63. | 1 | risky | riski |
  64. | 2 | things | thing |
  65. | 4 | risky | riski |
  66. +------+-----------+------------+
  67. 3 rows in set (0.001 sec)
  68.  
  69. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky', 'videos_test', 1 AS `stats`);
  70. +------+-----------+------------+------+------+
  71. | qpos | tokenized | normalized | docs | hits |
  72. +------+-----------+------------+------+------+
  73. | 1 | risky | riski | 1 | 2 |
  74. | 2 | things | thing | 1 | 1 |
  75. | 4 | risky | riski | 1 | 2 |
  76. +------+-----------+------------+------+------+
  77. 3 rows in set (0.001 sec)
  78.  
  79. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky-risky-risky!', 'videos_test', 1 AS `stats`);
  80. +------+-----------+------------+------+------+
  81. | qpos | tokenized | normalized | docs | hits |
  82. +------+-----------+------------+------+------+
  83. | 1 | risky | riski | 1 | 2 |
  84. | 2 | things | thing | 1 | 1 |
  85. | 4 | risky | riski | 1 | 2 |
  86. | 5 | risky | riski | 1 | 2 |
  87. | 6 | risky | riski | 1 | 2 |
  88. +------+-----------+------------+------+------+
  89. 5 rows in set (0.001 sec)
  90.  
  91. MySQL [(none)]> SHOW INDEX `videos_test` STATUS;
  92. +-----------------------------+--------------------------------------------------------------------------+
  93. | Variable_name | Value |
  94. +-----------------------------+--------------------------------------------------------------------------+
  95. | index_type | rt |
  96. | indexed_documents | 1 |
  97. | indexed_bytes | 29 |
  98. | ram_bytes | 6731 |
  99. | disk_bytes | 1207 |
  100. | disk_mapped | 0 |
  101. | disk_mapped_cached | 0 |
  102. | disk_mapped_doclists | 0 |
  103. | disk_mapped_cached_doclists | 0 |
  104. | disk_mapped_hitlists | 0 |
  105. | disk_mapped_cached_hitlists | 0 |
  106. | killed_documents | 0 |
  107. | killed_rate | 0.00% |
  108. | ram_chunk | 651 |
  109. | ram_chunk_segments_count | 1 |
  110. | disk_chunks | 0 |
  111. | mem_limit | 2147483648 |
  112. | ram_bytes_retired | 3259880177665 |
  113. | tid | 1 |
  114. | tid_saved | 0 |
  115. | query_time_1min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  116. | query_time_5min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  117. | query_time_15min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  118. | query_time_total | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  119. | found_rows_1min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  120. | found_rows_5min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  121. | found_rows_15min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  122. | found_rows_total | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  123. +-----------------------------+--------------------------------------------------------------------------+
  124. 28 rows in set (0.001 sec)
  125.  
  126. MySQL [(none)]> SHOW INDEX `videos` STATUS;
  127. +-----------------------------+-----------------------------------------------------------------------------------------------------------+
  128. | Variable_name | Value |
  129. +-----------------------------+-----------------------------------------------------------------------------------------------------------+
  130. | index_type | rt |
  131. | indexed_documents | 16302693 |
  132. | indexed_bytes | 12974319705 |
  133. | ram_bytes | 3314876237 |
  134. | disk_bytes | 7585329445 |
  135. | disk_mapped | 2381554573 |
  136. | disk_mapped_cached | 2381660160 |
  137. | disk_mapped_doclists | 1024353941 |
  138. | disk_mapped_cached_doclists | 1024372736 |
  139. | disk_mapped_hitlists | 419116213 |
  140. | disk_mapped_cached_hitlists | 419127296 |
  141. | killed_documents | 0 |
  142. | killed_rate | 0.00% |
  143. | ram_chunk | 933180485 |
  144. | ram_chunk_segments_count | 7 |
  145. | disk_chunks | 7 |
  146. | mem_limit | 2147483648 |
  147. | ram_bytes_retired | 0 |
  148. | tid | 261 |
  149. | tid_saved | 261 |
  150. | query_time_1min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  151. | query_time_5min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  152. | query_time_15min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  153. | query_time_total | {"queries":1139, "avg_sec":0.274, "min_sec":0.001, "max_sec":4.628, "pct95_sec":1.017, "pct99_sec":3.029} |
  154. | found_rows_1min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  155. | found_rows_5min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  156. | found_rows_15min | {"queries":0, "avg":"-", "min":"-", "max":"-", "pct95":"-", "pct99":"-"} |
  157. | found_rows_total | {"queries":1139, "avg":579956, "min":0, "max":11905486, "pct95":2554543, "pct99":6673374} |
  158. +-----------------------------+-----------------------------------------------------------------------------------------------------------+
  159. 28 rows in set (0.030 sec)
  160.  
  161. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky', 'videos');
  162. +------+-----------+------------+
  163. | qpos | tokenized | normalized |
  164. +------+-----------+------------+
  165. | 1 | risky | riski |
  166. | 2 | things | thing |
  167. | 4 | risky | riski |
  168. +------+-----------+------------+
  169. 3 rows in set (0.001 sec)
  170.  
  171. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky', 'videos', 1 AS `stats`);
  172. +------+-----------+------------+-------+-------+
  173. | qpos | tokenized | normalized | docs | hits |
  174. +------+-----------+------------+-------+-------+
  175. | 2 | things | thing | 47448 | 49831 |
  176. | 4 | risky | riski | 27666 | 39158 |
  177. +------+-----------+------------+-------+-------+
  178. 2 rows in set (0.010 sec)
  179.  
  180. MySQL [(none)]> CALL KEYWORDS ('Risky things are risky-risky-risky!', 'videos', 1 AS `stats`);
  181. +------+-----------+------------+-------+-------+
  182. | qpos | tokenized | normalized | docs | hits |
  183. +------+-----------+------------+-------+-------+
  184. | 2 | things | thing | 47448 | 49831 |
  185. | 6 | risky | riski | 55332 | 78316 |
  186. +------+-----------+------------+-------+-------+
  187. 2 rows in set (0.003 sec)
RAW Paste Data