API tools faq
paste
Advertisement
Guest User

Manticore

a guest
Jul 12th, 2021
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.88 KB | None | 0 0
raw download clone embed print report
  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)
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!