首頁 探索 說明
登入
libf
/
odbtools
1
0
複刻 0
檔案 問題管理 0 合併請求 0 Wiki
目錄樹: ec34f1ccd3
分支列表 標籤列表
odbtools
/
odbctest
/
mql
/
basic
/
24bucket_promdb
/
2130data11.mql

2130data11.mql 18 KB
文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171 
  1. 

  2. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', 
    3. 

  3. 		[{ '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    4. 

  4. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    5. 

  5. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    6. 

  6. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    7. 

  7. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'},
    8. 

  8. 		 { '__name__':'key2', '__value__':8.82, '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'},
    9. 

  9. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'},
    10. 

  10. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'},
    11. 

  11. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'},
    12. 

  12. 		 { '__name__':'key2', '__value__':8.83, '__timestamp__':'2024-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'},
    13. 

  13. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'},
    14. 

  14. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'},
    15. 

  15. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'},
    16. 

  16. 		 { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'},
    17. 

  17. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'},
    18. 

  18. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'},
    19. 

  19. 		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 12:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    20. 

  20. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 12:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    21. 

  21. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 12:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    22. 

  22. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 12:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    23. 

  23. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-28 12:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'},
    24. 

  24. 		 { '__name__':'key2', '__value__':8.82, '__timestamp__':'2024-07-28 12:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'},
    25. 

  25. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-28 12:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'},
    26. 

  26. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-28 12:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'},
    27. 

  27. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 12:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'},
    28. 

  28. 		 { '__name__':'key2', '__value__':8.83, '__timestamp__':'2024-07-29 12:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'},
    29. 

  29. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 12:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'},
    30. 

  30. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 12:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'},
    31. 

  31. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 12:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'},
    32. 

  32. 		 { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 12:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'},
    33. 

  33. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 12:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'},
    34. 

  34. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 12:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] )
    35. 

  35. ;
    36. 

  36. 

  37. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.000';
    38. 

  38. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.001';
    39. 

  39. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.002';
    40. 

  40. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.003';
    41. 

  41. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.004';
    42. 

  42. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.005';
    43. 

  43. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.006';
    44. 

  44. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.007';
    45. 

  45. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.008';
    46. 

  46. 

  47. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.009';
    48. 

  48. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.010';
    49. 

  49. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.011';
    50. 

  50. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.012';
    51. 

  51. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.013';
    52. 

  52. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.014';
    53. 

  53. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.015';
    54. 

  54. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.016';
    55. 

  55. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.017';
    56. 

  56. 

  57. 

  58. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', 
    59. 

  59. 		[{ '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
    60. 

  60. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
    61. 

  61. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
    62. 

  62. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'},
    63. 

  63. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix/test', 'CPU':'CPU1'},
    64. 

  64. 		 { '__name__':'key2', '__value__':8.82, '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix/test', 'CPU':'CPU2'},
    65. 

  65. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
    66. 

  66. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix/test', 'CPU':'CPU48'},
    67. 

  67. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
    68. 

  68. 		 { '__name__':'key2', '__value__':8.83, '__timestamp__':'2024-07-29 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
    69. 

  69. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-29 11:25:19', 'disk':'/opt/matrix/test', 'CPU':'CPU5'},
    70. 

  70. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'},
    71. 

  71. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix', 'CPU':'CPU1'},
    72. 

  72. 		 { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 11:25:18', 'disk':'/opt/matrix', 'CPU':'CPU2'},
    73. 

  73. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 11:25:19', 'disk':'/opt/matrix', 'CPU':'CPU5'},
    74. 

  74. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix', 'CPU':'CPU48'}] )
    75. 

  75. ;
    76. 

  76. 

  77. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.000';
    78. 

  78. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.001';
    79. 

  79. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.002';
    80. 

  80. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.003';
    81. 

  81. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.004';
    82. 

  82. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.005';
    83. 

  83. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.006';
    84. 

  84. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.007';
    85. 

  85. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key3', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.008';
    86. 

  86. 

  87. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:24:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:24:00.009';
    88. 

  88. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:25:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:25:00.010';
    89. 

  89. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:26:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:26:00.011';
    90. 

  90. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:27:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:27:00.012';
    91. 

  91. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:28:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:28:00.013';
    92. 

  92. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:29:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:29:00.014';
    93. 

  93. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:30:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:30:00.015';
    94. 

  94. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:31:00', 'disk':'/opt/matrix/test', 'CPU':'CPU1'}] ) at '2024-11-28 11:31:00.016';
    95. 

  95. insert into /test/bucketpromdbnocache (id, prom_nocache) values ('bucketpromdbnocache:wecise11', [{ '__name__':'key1.key2.key4', '__value__':2.7, '__timestamp__':'2024-11-28 11:32:00', 'disk':'/opt/matrix', 'CPU':'CPU1'}] ) at '2024-11-28 11:32:00.017';
    96. 

  96. 

  97. 

  98. insert into /test/bucketpromdbnocache (id, prom_nocache) values (?, ? )
    99. 

  99. /**
    100. 

  100. loop(1000)
    101. 

  101. set(ct,"2024-10-28 11:24:17")
    102. 

  102. beforerun(
    103. 

  103.     add(ct,mqli,second)
    104. 

  104. )
    105. 

  105. params("bucketpromdbnocache:wecise", [
    106. 

  106. 			{"name": "key1", "value": 2, "timestamp": "{%t,ct}"},
    107. 

  107. 			{"name": "key2", "value": 1.8, "timestamp": "{%t,ct}"},
    108. 

  108. 			{"name": "key3", "value": 2.9, "timestamp": "{%t,ct}"},
    109. 

  109. 			{"name": "keys1", "value": "sss", "timestamp": "{%t,ct}"},
    110. 

  110. 			{"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "{%t,ct}"},
    111. 

  111. 			{"name": "key48", "value": 2.9, "timestamp": "{%t,ct}"}])
    112. 

  112. **/;
    113. 

  113. 

  114. 

  115. insert into /test/bucketpromdbnocache (id, prom_nocache) values (?, ? )
    116. 

  116. /**
    117. 

  117. loop(1000)
    118. 

  118. set(ct,"2024-10-28 15:24:17")
    119. 

  119. beforerun(
    120. 

  120.     add(ct,mqli,second)
    121. 

  121. )
    122. 

  122. params("bucketpromdbnocache:wecise", [
    123. 

  123. 			{"name": "key1", "value": 2.7, "timestamp": "{%t,ct}"},
    124. 

  124. 			{"name": "key2", "value": 1.9, "timestamp": "{%t,ct}"},
    125. 

  125. 			{"name": "key3", "value": 3.9, "timestamp": "{%t,ct}"},
    126. 

  126. 			{"name": "keys1", "value": "ssss", "timestamp": "{%t,ct}"},
    127. 

  127. 			{"name": "keys2", "value": "ss这是中文长字符串sssss", "timestamp": "{%t,ct}"},
    128. 

  128. 			{"name": "key48", "value": 3.9, "timestamp": "{%t,ct}"}])
    129. 

  129. **/;
    130. 

  130. 

  131. 

  132. insert into /test/bucketpromdbnocache (id, prom_nocache) values (?, ? )
    133. 

  133. /**
    134. 

  134. params("bucketpromdbnocache:wecise", [
    135. 

  135. 		{"name": "key1", "value": 2.9, "timestamp": "2024-07-29 11:24:17", "disk": "/opt/matrix", "CPU": "CPU1"},
    136. 

  136. 		{"name": "key2", "value": 2, "timestamp": "2024-07-29 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
    137. 

  137. 		{"name": "key3", "value": 2.9, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"},
    138. 

  138. 		{"name": "keys1", "value": "sss", "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    139. 

  139. 		{"name": "keys2", "value": "这是中文长字符串sssss", "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    140. 

  140. 		{"name": "key48", "value": 2.9, "timestamp": "2024-07-29 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
    141. 

  141. **/;
    142. 

  142. 

  143. 

  144. insert into /test/bucketpromdbnocache (id, prom_nocache) values (?, ? )
    145. 

  145. /**
    146. 

  146. params("bucketpromdbnocache:wecise", [
    147. 

  147. 		{"__name__": "key1", "__value__": 5.2, "__timestamp__": "2024-07-30 11:24:17", "disk": "/opt/matrix/test", "CPU": "CPU1"},
    148. 

  148. 		{"__name__": "key2", "__value__": 4.8, "__timestamp__": "2024-07-30 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
    149. 

  149. 		{"__name__": "key3", "__value__": 2.9, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    150. 

  150. 		{"__name__": "keys1", "__value__": "sss", "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    151. 

  151. 		{"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    152. 

  152. 		{"__name__": "key48", "__value__": 2.9, "__timestamp__": "2024-07-30 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}])
    153. 

  153. **/;
    154. 

  154. 

  155. 

  156. insert into /test/bucketpromdbnocache (id, prom_nocache) values (?, ? ) at ?
    157. 

  157. /**
    158. 

  158. params("bucketpromdbnocache:wecise", [
    159. 

  159. 		{"__name__": "key1", "__value__": 6.0, "__timestamp__": "2024-07-31 11:24:17", "disk": "/opt/matrix/test", "CPU": "CPU1"},
    160. 

  160. 		{"__name__": "key2", "__value__": 3, "__timestamp__": "2024-07-31 11:25:18", "disk": "/opt/matrix", "CPU": "CPU2"},
    161. 

  161. 		{"__name__": "key3", "__value__": 2.9, "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix/test", "CPU": "CPU3"},
    162. 

  162. 		{"__name__": "keys1", "__value__": "sss", "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    163. 

  163. 		{"__name__": "keys2", "__value__": "这是中文长字符串sssss", "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU3"},
    164. 

  164. 		{"__name__": "key48", "__value__": 2.9, "__timestamp__": "2024-07-31 11:25:19", "disk": "/opt/matrix", "CPU": "CPU48"}], "2024-07-31 11:24:17")
    165. 

  165. **/;
    166. 

  166. 

  167. 

  168. /**
    169. 

  169. sleep(1s)
    170. 

  170. **/
    171. 

  171. ;
    172.