首页 发现 帮助
登录
libf
/
odbtools
1
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
目录树: ec34f1ccd3
分支列表 标签列表
odbtools
/
odbctest
/
mql
/
basic
/
24bucket_promdb
/
1930data9.mql

1930data9.mql 11 KB
文件历史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123 
  1. 

  2. insert into /test/bucketsplit (id, prom_split) values (?, ? )
    3. 

  3. /**
    4. 

  4. loop(1440)
    5. 

  5. set(ct,"2024-07-20 00:00:00")
    6. 

  6. beforerun(
    7. 

  7.     add(ct,60,second)
    8. 

  8. )
    9. 

  9. params("bucketsplit:wecise", [
    10. 

  10. 			{"name": "key1", "value": 2, "timestamp": "{%t,ct}"},
    11. 

  11. 			{"name": "key2", "value": 1.8, "timestamp": "{%t,ct}"},
    12. 

  12. 			{"name": "key3", "value": 2.9, "timestamp": "{%t,ct}"},
    13. 

  13. 			{"name": "key4", "value": 2, "timestamp": "{%t,ct}"},
    14. 

  14. 			{"name": "key5", "value": 1.8, "timestamp": "{%t,ct}"},
    15. 

  15. 			{"name": "key6", "value": 2.9, "timestamp": "{%t,ct}"},
    16. 

  16. 			{"name": "key7", "value": 2, "timestamp": "{%t,ct}"},
    17. 

  17. 			{"name": "key8", "value": 1.8, "timestamp": "{%t,ct}"},
    18. 

  18. 			{"name": "key9", "value": 2.9, "timestamp": "{%t,ct}"},
    19. 

  19. 			{"name": "key1", "disk": "/opt/matrix1", "CPU": "CPU1", "value": 2, "timestamp": "{%t,ct}"},
    20. 

  20. 			{"name": "key2", "disk": "/opt/matrix1", "CPU": "CPU1", "value": 1.8, "timestamp": "{%t,ct}"},
    21. 

  21. 			{"name": "key3", "disk": "/opt/matrix1", "CPU": "CPU2", "value": 2.9, "timestamp": "{%t,ct}"},
    22. 

  22. 			{"name": "key4", "disk": "/opt/matrix1", "CPU": "CPU2", "value": 2, "timestamp": "{%t,ct}"},
    23. 

  23. 			{"name": "key5", "disk": "/opt/matrix1", "CPU": "CPU3", "value": 1.8, "timestamp": "{%t,ct}"},
    24. 

  24. 			{"name": "key6", "disk": "/opt/matrix1", "CPU": "CPU3", "value": 2.9, "timestamp": "{%t,ct}"},
    25. 

  25. 			{"name": "key7", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 2, "timestamp": "{%t,ct}"},
    26. 

  26. 			{"name": "key8", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 1.8, "timestamp": "{%t,ct}"},
    27. 

  27. 			{"name": "key9", "disk": "/opt/matrix1", "CPU": "CPU4", "value": 2.9, "timestamp": "{%t,ct}"}])
    28. 

  28. **/;
    29. 

  29. 

  30. insert into /test/bucketsplit (id, prom_split) values ('bucketsplit:wecise', 
    31. 

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

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

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

  34. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-25 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    35. 

  35. 		 
    36. 

  36. 		 { '__name__':'key1', '__value__':200, '__timestamp__':'2024-07-25 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    37. 

  37. 		 { '__name__':'key2', '__value__':80.81, '__timestamp__':'2024-07-25 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    38. 

  38. 		 { '__name__':'key5', '__value__':20.9, '__timestamp__':'2024-07-25 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    39. 

  39. 		 { '__name__':'key48', '__value__':20.9, '__timestamp__':'2024-07-25 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    40. 

  40. 		 
    41. 

  41. 		 
    42. 

  42. 		 { '__name__':'key1', '__value__':20, '__timestamp__':'2024-07-26 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    43. 

  43. 		 { '__name__':'key2', '__value__':800.81, '__timestamp__':'2024-07-26 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    44. 

  44. 		 { '__name__':'key5', '__value__':20.9, '__timestamp__':'2024-07-26 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    45. 

  45. 		 { '__name__':'key48', '__value__':200.9, '__timestamp__':'2024-07-26 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    46. 

  46. 		 
    47. 

  47. 		 { '__name__':'key1', '__value__':20, '__timestamp__':'2024-07-26 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    48. 

  48. 		 { '__name__':'key2', '__value__':800.81, '__timestamp__':'2024-07-26 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    49. 

  49. 		 { '__name__':'key5', '__value__':20.9, '__timestamp__':'2024-07-26 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    50. 

  50. 		 { '__name__':'key48', '__value__':20.9, '__timestamp__':'2024-07-26 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    51. 

  51. 		 
    52. 

  52. 		 { '__name__':'key1', '__value__':20, '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    53. 

  53. 		 { '__name__':'key2', '__value__':800.81, '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    54. 

  54. 		 { '__name__':'key5', '__value__':20.9, '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    55. 

  55. 		 { '__name__':'key48', '__value__':200.9, '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    56. 

  56. 		 
    57. 

  57. 		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 11:34:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    58. 

  58. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 11:35:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    59. 

  59. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 11:35:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    60. 

  60. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 11:36:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    61. 

  61. 		 
    62. 

  62. 		 
    63. 

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

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

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

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

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

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

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

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

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

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

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

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

  75. 		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-25 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    76. 

  76. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-25 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    77. 

  77. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-25 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    78. 

  78. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-25 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    79. 

  79. 		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-26 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    80. 

  80. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-26 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    81. 

  81. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-26 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    82. 

  82. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-26 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    83. 

  83. 		 { '__name__':'key1', '__value__':2, '__timestamp__':'2024-07-27 09:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    84. 

  84. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':'2024-07-27 09:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    85. 

  85. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-27 09:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    86. 

  86. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-27 09:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    87. 

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

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

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

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

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

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

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

  94. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':'2024-07-29 09:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'},
    95. 

  95. 		 { '__name__':'key1', '__value__':2.7, '__timestamp__':'2024-07-30 09:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'},
    96. 

  96. 		 { '__name__':'key2', '__value__':8.84, '__timestamp__':'2024-07-30 09:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'},
    97. 

  97. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':'2024-07-30 09:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'},
    98. 

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

  99. ;
    100. 

  100. 

  101. insert into /test/bucketsplit (id, prom_split) values ('bucketsplit:wecise', 
    102. 

  102. 		[{ '__name__':'key1', '__value__':2, '__timestamp__':1627702037000.12345, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    103. 

  103. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':1627702098000.23333, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    104. 

  104. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':1627702099000.23456, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    105. 

  105. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702159000.75678, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    106. 

  106. 		 { '__name__':'key1', '__value__':2, '__timestamp__':1627701977000.34567, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    107. 

  107. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':1627702038000.6789, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    108. 

  108. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':1627702039000.21345, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    109. 

  109. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702099000.34567, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    110. 

  110. 		 { '__name__':'key1', '__value__':2, '__timestamp__':1627701917000.34556, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    111. 

  111. 		 { '__name__':'key2', '__value__':8.81, '__timestamp__':1627701978000.234, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    112. 

  112. 		 { '__name__':'key5', '__value__':2.9, '__timestamp__':1627701979000.234, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    113. 

  113. 		 { '__name__':'key48', '__value__':2.9, '__timestamp__':1627702039000.1, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    114. 

  114. 		 { '__name__':'key1', '__value__':20, '__timestamp__':1627701857000.23423, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    115. 

  115. 		 { '__name__':'key2', '__value__':88.1, '__timestamp__':1627701918000.78, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    116. 

  116. 		 { '__name__':'key5', '__value__':29, '__timestamp__':1627701919000.63, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    117. 

  117. 		 { '__name__':'key48', '__value__':29, '__timestamp__':1627701979000.123, 'disk':'/opt/matrix4', 'CPU':'CPU48'}	] )
    118. 

  118. ;
    119. 

  119. 

  120. /**
    121. 

  121. sleep(1s)
    122. 

  122. **/
    123. 

  123. ;
    124.