Trang chủ Khám phá Trợ giúp
Đăng nhập
libf
/
odbtools
1
0
Fork 0
Các tập tin Các vấn đề 0 Yêu cầu khéo về 0 Wiki
Tree: ec34f1ccd3
Branches Tags
odbtools
/
odbctest
/
mql
/
basic
/
24bucket_promdb
/
2030data10.mql

2030data10.mql 8.3 KB
Lịch sử Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 
  1. 

  2. insert into /test/promdb_string (id, prom_str) values ('promdb_string:wecise', 
    3. 

  3. 		[{ '__name__':'key1', '__value__':'这是string测试 hello world', '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    4. 

  4. 		 { '__name__':'key2', '__value__':'这是string测试 queries: info: client 192.168.174.115#43747', '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    5. 

  5. 		 { '__name__':'key5', '__value__':'这是string测试 queries: info: client 192.168.174.115#36176 (rx.thegov.win): query: rx.thegov.win IN A + (192.168.174.124)', '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    6. 

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

  7. 		 { '__name__':'key1', '__value__':'这是string测试 error', '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'},
    8. 

  8. 		 { '__name__':'key2', '__value__':'这是string测试 error', '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'},
    9. 

  9. 		 { '__name__':'key5', '__value__':'这是string测试 host tiger', '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'},
    10. 

  10. 		 { '__name__':'key48', '__value__':'这是string测试 homeway', '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'},
    11. 

  11. 		 { '__name__':'key1', '__value__':'这是string测试 error', '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'},
    12. 

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

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

  14. 		 { '__name__':'key48', '__value__':'这是string测试 resolver: debug 1: createfetch: deb.thegov.win A', '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'},
    15. 

  15. 		 { '__name__':'key1', '__value__':"这是string测试 error (network unreachable) resolving './NS/IN': 2001:500:84::b#53", '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'},
    16. 

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

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

  18. 		 { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}] )
    19. 

  19. ;
    20. 

  20. 

  21. insert into /test/promdb_string (id, prom_str) values ('promdb_string:wecise', 
    22. 

  22. 		[{ '__name__':'key1', '__value__':'这是string测试 queries: info: client 192.168.174.115#43747', '__timestamp__':1627702037000.123451111, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    23. 

  23. 		 { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':1627702098000.23333, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    24. 

  24. 		 { '__name__':'key5', '__value__':'这是string测试 resolver: debug 1: createfetch: deb.thegov.win A', '__timestamp__':1627702099000.234561111, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    25. 

  25. 		 { '__name__':'key48', '__value__':'这是string测试 queries: info: client 192.168.174.115#36176 (rx.thegov.win): query: rx.thegov.win IN A + (192.168.174.124)', '__timestamp__':1627702159000.756781111, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    26. 

  26. 		 { '__name__':'key1', '__value__':'这是string测试', '__timestamp__':1627701977000.34567111, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    27. 

  27. 		 { '__name__':'key2', '__value__':"这是string测试 error (network unreachable) resolving './NS/IN': 2001:500:84::b#53", '__timestamp__':1627702038000.678911111, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    28. 

  28. 		 { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':1690774039000.2134511111, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    29. 

  29. 		 { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':1627702099000.345671111, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    30. 

  30. 		 { '__name__':'key1', '__value__':'这是string测试', '__timestamp__':1627701917000.345561111, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    31. 

  31. 		 { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':1627701978000.2341111, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    32. 

  32. 		 { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':1627701979000.2341111, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    33. 

  33. 		 { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':1627702039000.111111, 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    34. 

  34. 		 { '__name__':'key1', '__value__':'这是string测试', '__timestamp__':1627701857000.234231111, 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    35. 

  35. 		 { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':1627701918000.78111111, 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    36. 

  36. 		 { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':1627701919000.63111111, 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    37. 

  37. 		 { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':1627701979000.123111111, 'disk':'/opt/matrix4', 'CPU':'CPU48'}	] )
    38. 

  38. ;
    39. 

  39. 

  40. insert into /test/promdb_string (id, prom_str) values (?, ?)
    41. 

  41. /**
    42. 

  42. set(ct,now)
    43. 

  43. params("promdb_string:wecise", [
    44. 

  44. 		{"name": "pkey1", "value": 2, "timestamp": "{%t,ct}"},
    45. 

  45. 		{"name": "pkey2", "value": 1.8, "timestamp": "{%t,ct}"},
    46. 

  46. 		{"name": "pkey3", "value": 2.9, "timestamp": "{%t,ct}"},
    47. 

  47. 		{"name": "pkeys1", "value": "sss", "timestamp": "{%t,ct}"},
    48. 

  48. 		{"name": "pkeys2", "value": "这是中文长字符串sssss", "timestamp": "{%t,ct}"},
    49. 

  49. 		{"name": "pkey48", "value": 2.9, "timestamp": "{%t,ct}"}])
    50. 

  50. **/;
    51. 

  51. 

  52. insert into /test/promdb_string2 (id, prom_str2) values ('promdb_string2:wecise', 
    53. 

  53. 		[{ '__name__':'key1', '__value__':'这是string测试 hello world', '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'}])
    54. 

  54. ;
    55. 

  55. 

  56. insert into /test/promdb_string2 (id, prom_str2) values ('promdb_string2:wecise', 
    57. 

  57. 		[{ '__name__':'key1', '__value__':'这是string测试 hello world', '__timestamp__':'2024-07-27 11:24:17', 'disk':'/opt/matrix1', 'CPU':'CPU1'},
    58. 

  58. 		 { '__name__':'key2', '__value__':'这是string测试 queries: info: client 192.168.174.115#43747', '__timestamp__':'2024-07-27 11:25:18', 'disk':'/opt/matrix2', 'CPU':'CPU2'},
    59. 

  59. 		 { '__name__':'key5', '__value__':'这是string测试 queries: info: client 192.168.174.115#36176 (rx.thegov.win): query: rx.thegov.win IN A + (192.168.174.124)', '__timestamp__':'2024-07-27 11:25:19', 'disk':'/opt/matrix3', 'CPU':'CPU5'},
    60. 

  60. 		 { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':'2024-07-27 11:26:19', 'disk':'/opt/matrix4', 'CPU':'CPU48'},
    61. 

  61. 		 { '__name__':'key1', '__value__':'这是string测试 error', '__timestamp__':'2024-07-28 11:24:17', 'disk':'/opt/matrix5', 'CPU':'CPU1'},
    62. 

  62. 		 { '__name__':'key2', '__value__':'这是string测试 error', '__timestamp__':'2024-07-28 11:25:18', 'disk':'/opt/matrix6', 'CPU':'CPU2'},
    63. 

  63. 		 { '__name__':'key5', '__value__':'这是string测试 host tiger', '__timestamp__':'2024-07-28 11:25:19', 'disk':'/opt/matrix7', 'CPU':'CPU5'},
    64. 

  64. 		 { '__name__':'key48', '__value__':'这是string测试 homeway', '__timestamp__':'2024-07-28 11:26:19', 'disk':'/opt/matrix8', 'CPU':'CPU48'},
    65. 

  65. 		 { '__name__':'key1', '__value__':'这是string测试 error', '__timestamp__':'2024-07-29 11:24:17', 'disk':'/opt/matrix9', 'CPU':'CPU1'},
    66. 

  66. 		 { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':'2024-07-29 11:25:18', 'disk':'/opt/matrix10', 'CPU':'CPU2'},
    67. 

  67. 		 { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':'2024-07-29 11:25:19', 'disk':'/opt/matrix11', 'CPU':'CPU5'},
    68. 

  68. 		 { '__name__':'key48', '__value__':'这是string测试 resolver: debug 1: createfetch: deb.thegov.win A', '__timestamp__':'2024-07-29 11:26:19', 'disk':'/opt/matrix12', 'CPU':'CPU48'},
    69. 

  69. 		 { '__name__':'key1', '__value__':"这是string测试 error (network unreachable) resolving './NS/IN': 2001:500:84::b#53", '__timestamp__':'2024-07-30 11:24:17', 'disk':'/opt/matrix12', 'CPU':'CPU1'},
    70. 

  70. 		 { '__name__':'key2', '__value__':'这是string测试', '__timestamp__':'2024-07-30 11:25:18', 'disk':'/opt/matrix13', 'CPU':'CPU2'},
    71. 

  71. 		 { '__name__':'key5', '__value__':'这是string测试', '__timestamp__':'2024-07-30 11:25:19', 'disk':'/opt/matrix13', 'CPU':'CPU5'},
    72. 

  72. 		 { '__name__':'key48', '__value__':'这是string测试', '__timestamp__':'2024-07-30 11:26:19', 'disk':'/opt/matrix13', 'CPU':'CPU48'}])
    73. 

  73. ;
    74. 

  74. 

  75. /**
    76. 

  76. sleep(1s)
    77. 

  77. **/
    78. 

  78. ;
    79.