【elasticsearch】ES的其他常见的查询项目

1.查看所有的索引 

  1. curl -X GET http://192.168.1.7:9201/_cat/indices?v 
  2. [esadmin@oracle1 translog]$ curl -X GET http://192.168.1.7:9201/_cat/indices?v 
  3. health status index uuid                   pri rep docs.count docs.deleted store.size pri.store.size
  4. green  open   mydb2 eks_TgK5S1-VMF6Xi7IIyw  10   2          2            0     47.4kb         15.8kb
  5. green  open   mydb3 ExaHrWExSGOqbPFG4TaAFQ   3   1          2            0       23kb         11.5kb
  6. green  open   mydb1 R8ovegjBS7i44hlbOA-PUQ   1   1          2            0     26.8kb         13.4kb

2.查看单个索引的分片和副本数 

  1. curl -X GET "192.168.1.7:9201/mydb1/_settings?pretty"
  2. curl -X GET "192.168.1.7:9201/mydb2/_settings?pretty"
  3. curl -X GET "192.168.1.7:9201/mydb3/_settings?pretty"
  4.  
  5. [esadmin@oracle1 translog]$ curl -X GET "192.168.1.7:9201/mydb1/_settings?pretty"
  6. {
  7.   "mydb1" : {
  8.     "settings" : {
  9.       "index" : {
  10.         "creation_date" : "1719458160315",
  11.         "number_of_shards" : "1",
  12.         "number_of_replicas" : "1",
  13.         "uuid" : "R8ovegjBS7i44hlbOA-PUQ",
  14.         "version" : {
  15.           "created" : "7090199"
  16.         },
  17.         "provided_name" : "mydb1"
  18.       }
  19.     }
  20.   }
  21. }
  22. [esadmin@oracle1 translog]$ 
  23. [esadmin@oracle1 translog]$ curl -X GET "192.168.1.7:9201/mydb2/_settings?pretty"
  24. {
  25.   "mydb2" : {
  26.     "settings" : {
  27.       "index" : {
  28.         "creation_date" : "1719459642529",
  29.         "number_of_shards" : "10",
  30.         "number_of_replicas" : "2",
  31.         "uuid" : "eks_TgK5S1-VMF6Xi7IIyw",
  32.         "version" : {
  33.           "created" : "7090199"
  34.         },
  35.         "provided_name" : "mydb2"
  36.       }
  37.     }
  38.   }
  39. }
  40. [esadmin@oracle1 translog]$ curl -X GET "192.168.1.7:9201/mydb3/_settings?pretty"
  41. {
  42.   "mydb3" : {
  43.     "settings" : {
  44.       "index" : {
  45.         "creation_date" : "1719460463245",
  46.         "number_of_shards" : "3",
  47.         "number_of_replicas" : "1",
  48.         "uuid" : "ExaHrWExSGOqbPFG4TaAFQ",
  49.         "version" : {
  50.           "created" : "7090199"
  51.         },
  52.         "provided_name" : "mydb3"
  53.       }
  54.     }
  55.   }
  56. }

3.查看整个集群副本 

  1. curl http://192.168.1.7:9201/_cat/shards?v
  2. [esadmin@oracle1 translog]$ curl http://192.168.1.7:9201/_cat/shards?v
  3. index shard prirep state   docs  store ip          node
  4. mydb2 6     r      STARTED    1  7.1kb 192.168.1.7 esdb-node-3
  5. mydb2 6     p      STARTED    1    7kb 192.168.1.7 esdb-node-2
  6. mydb2 6     r      STARTED    1  7.1kb 192.168.1.7 esdb-node-1
  7. mydb2 5     r      STARTED    0   208b 192.168.1.7 esdb-node-3
  8. mydb2 5     r      STARTED    0   208b 192.168.1.7 esdb-node-2
  9. mydb2 5     p      STARTED    0   208b 192.168.1.7 esdb-node-1
  10. mydb2 2     r      STARTED    0   208b 192.168.1.7 esdb-node-3
  11. mydb2 2     r      STARTED    0   208b 192.168.1.7 esdb-node-2
  12. mydb2 2     p      STARTED    0   208b 192.168.1.7 esdb-node-1
  13. mydb2 7     p      STARTED    0   208b 192.168.1.7 esdb-node-3
  14. mydb2 7     r      STARTED    0   208b 192.168.1.7 esdb-node-2
  15. mydb2 7     r      STARTED    0   208b 192.168.1.7 esdb-node-1
  16. mydb2 3     r      STARTED    0   208b 192.168.1.7 esdb-node-3
  17. mydb2 3     p      STARTED    0   208b 192.168.1.7 esdb-node-2
  18. mydb2 3     r      STARTED    0   208b 192.168.1.7 esdb-node-1
  19. mydb2 8     r      STARTED    0   208b 192.168.1.7 esdb-node-3
  20. mydb2 8     r      STARTED    0   208b 192.168.1.7 esdb-node-2
  21. mydb2 8     p      STARTED    0   208b 192.168.1.7 esdb-node-1
  22. mydb2 1     p      STARTED    0   208b 192.168.1.7 esdb-node-3
  23. mydb2 1     r      STARTED    0   208b 192.168.1.7 esdb-node-2
  24. mydb2 1     r      STARTED    0   208b 192.168.1.7 esdb-node-1
  25. mydb2 9     r      STARTED    0   208b 192.168.1.7 esdb-node-3
  26. mydb2 9     p      STARTED    0   208b 192.168.1.7 esdb-node-2
  27. mydb2 9     r      STARTED    0   208b 192.168.1.7 esdb-node-1
  28. mydb2 4     p      STARTED    1    7kb 192.168.1.7 esdb-node-3
  29. mydb2 4     r      STARTED    1    7kb 192.168.1.7 esdb-node-2
  30. mydb2 4     r      STARTED    1    7kb 192.168.1.7 esdb-node-1
  31. mydb2 0     r      STARTED    0   208b 192.168.1.7 esdb-node-3
  32. mydb2 0     p      STARTED    0   208b 192.168.1.7 esdb-node-2
  33. mydb2 0     r      STARTED    0   208b 192.168.1.7 esdb-node-1
  34. mydb3 2     r      STARTED    1  5.6kb 192.168.1.7 esdb-node-2
  35. mydb3 2     p      STARTED    1  5.6kb 192.168.1.7 esdb-node-1
  36. mydb3 1     p      STARTED    0   208b 192.168.1.7 esdb-node-3
  37. mydb3 1     r      STARTED    0   208b 192.168.1.7 esdb-node-1
  38. mydb3 0     r      STARTED    1  5.6kb 192.168.1.7 esdb-node-3
  39. mydb3 0     p      STARTED    1  5.6kb 192.168.1.7 esdb-node-2
  40. mydb1 0     p      STARTED    2 13.4kb 192.168.1.7 esdb-node-3
  41. mydb1 0     r      STARTED    2 13.4kb 192.168.1.7 esdb-node-1

4.查看单个数据库的分片

  1. curl http://192.168.1.7:9201/mydb1/_search_shards?pretty
  2. [esadmin@oracle1 translog]$ curl http://192.168.1.7:9201/mydb2/_search_shards?pretty
  3. {
  4.   "nodes" : {
  5.     "1M-5yVJyRHakKuwSYpXeNQ" : {
  6.       "name" : "esdb-node-3",
  7.       "ephemeral_id" : "qkYJO8DqRlKGc_VW3kSouw",
  8.       "transport_address" : "192.168.1.7:9303",
  9.       "attributes" : {
  10.         "ml.machine_memory" : "8181784576",
  11.         "ml.max_open_jobs" : "20",
  12.         "xpack.installed" : "true",
  13.         "transform.node" : "true"
  14.       }
  15.     },
  16.     "8bkDoRrrTdyikEJ6mEOKsA" : {
  17.       "name" : "esdb-node-2",
  18.       "ephemeral_id" : "jJyhWE4PTcWP3Nk6Ypsnxw",
  19.       "transport_address" : "192.168.1.7:9302",
  20.       "attributes" : {
  21.         "ml.machine_memory" : "8181784576",
  22.         "ml.max_open_jobs" : "20",
  23.         "xpack.installed" : "true",
  24.         "transform.node" : "true"
  25.       }
  26.     },
  27.     "rVIh8-d2SmKscxM5zlgqfA" : {
  28.       "name" : "esdb-node-1",
  29.       "ephemeral_id" : "wC3Kpkk_S7-85NeWDGPihg",
  30.       "transport_address" : "192.168.1.7:9301",
  31.       "attributes" : {
  32.         "ml.machine_memory" : "8181784576",
  33.         "xpack.installed" : "true",
  34.         "transform.node" : "true",
  35.         "ml.max_open_jobs" : "20"
  36.       }
  37.     }
  38.   },
  39.   "indices" : {
  40.     "mydb2" : { }
  41.   },
  42.   "shards" : [
  43.     [
  44.       {
  45.         "state" : "STARTED",
  46.         "primary" : true,
  47.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  48.         "relocating_node" : null,
  49.         "shard" : 0,
  50.         "index" : "mydb2",
  51.         "allocation_id" : {
  52.           "id" : "V8dDIFfGTsaU-FMYuTY3Fg"
  53.         }
  54.       },
  55.       {
  56.         "state" : "STARTED",
  57.         "primary" : false,
  58.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  59.         "relocating_node" : null,
  60.         "shard" : 0,
  61.         "index" : "mydb2",
  62.         "allocation_id" : {
  63.           "id" : "Nm5yksnXRkiFRGIEveCeTw"
  64.         }
  65.       },
  66.       {
  67.         "state" : "STARTED",
  68.         "primary" : false,
  69.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  70.         "relocating_node" : null,
  71.         "shard" : 0,
  72.         "index" : "mydb2",
  73.         "allocation_id" : {
  74.           "id" : "tNmWx-1bSfyN_Kja3y6kiQ"
  75.         }
  76.       }
  77.     ],
  78.     [
  79.       {
  80.         "state" : "STARTED",
  81.         "primary" : false,
  82.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  83.         "relocating_node" : null,
  84.         "shard" : 1,
  85.         "index" : "mydb2",
  86.         "allocation_id" : {
  87.           "id" : "rtceaoRQRM6WtsIiLYkz0A"
  88.         }
  89.       },
  90.       {
  91.         "state" : "STARTED",
  92.         "primary" : true,
  93.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  94.         "relocating_node" : null,
  95.         "shard" : 1,
  96.         "index" : "mydb2",
  97.         "allocation_id" : {
  98.           "id" : "f2hHyL28S5K3XEgru5ydkA"
  99.         }
  100.       },
  101.       {
  102.         "state" : "STARTED",
  103.         "primary" : false,
  104.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  105.         "relocating_node" : null,
  106.         "shard" : 1,
  107.         "index" : "mydb2",
  108.         "allocation_id" : {
  109.           "id" : "RxAeDvUgS6aVY8Z2l4VRRQ"
  110.         }
  111.       }
  112.     ],
  113.     [
  114.       {
  115.         "state" : "STARTED",
  116.         "primary" : false,
  117.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  118.         "relocating_node" : null,
  119.         "shard" : 2,
  120.         "index" : "mydb2",
  121.         "allocation_id" : {
  122.           "id" : "ib2QnSaiTNuCLLDiFaJnTA"
  123.         }
  124.       },
  125.       {
  126.         "state" : "STARTED",
  127.         "primary" : true,
  128.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  129.         "relocating_node" : null,
  130.         "shard" : 2,
  131.         "index" : "mydb2",
  132.         "allocation_id" : {
  133.           "id" : "BRWJToZXQ2ucYx0vIl5Clw"
  134.         }
  135.       },
  136.       {
  137.         "state" : "STARTED",
  138.         "primary" : false,
  139.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  140.         "relocating_node" : null,
  141.         "shard" : 2,
  142.         "index" : "mydb2",
  143.         "allocation_id" : {
  144.           "id" : "WDcNOtzSSjW2iSoaJKMlgQ"
  145.         }
  146.       }
  147.     ],
  148.     [
  149.       {
  150.         "state" : "STARTED",
  151.         "primary" : false,
  152.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  153.         "relocating_node" : null,
  154.         "shard" : 3,
  155.         "index" : "mydb2",
  156.         "allocation_id" : {
  157.           "id" : "S99FU-XJSBaDe5Q5KUY_1w"
  158.         }
  159.       },
  160.       {
  161.         "state" : "STARTED",
  162.         "primary" : true,
  163.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  164.         "relocating_node" : null,
  165.         "shard" : 3,
  166.         "index" : "mydb2",
  167.         "allocation_id" : {
  168.           "id" : "3QgHZ6d4TZyihLFlPpBerw"
  169.         }
  170.       },
  171.       {
  172.         "state" : "STARTED",
  173.         "primary" : false,
  174.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  175.         "relocating_node" : null,
  176.         "shard" : 3,
  177.         "index" : "mydb2",
  178.         "allocation_id" : {
  179.           "id" : "9WbB7YjWTJ-EDEhYG5XxAg"
  180.         }
  181.       }
  182.     ],
  183.     [
  184.       {
  185.         "state" : "STARTED",
  186.         "primary" : true,
  187.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  188.         "relocating_node" : null,
  189.         "shard" : 4,
  190.         "index" : "mydb2",
  191.         "allocation_id" : {
  192.           "id" : "hxGlMIRbQqqRWgjnx857kA"
  193.         }
  194.       },
  195.       {
  196.         "state" : "STARTED",
  197.         "primary" : false,
  198.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  199.         "relocating_node" : null,
  200.         "shard" : 4,
  201.         "index" : "mydb2",
  202.         "allocation_id" : {
  203.           "id" : "Hmhh1yKrTBGNVi8sU5H5iw"
  204.         }
  205.       },
  206.       {
  207.         "state" : "STARTED",
  208.         "primary" : false,
  209.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  210.         "relocating_node" : null,
  211.         "shard" : 4,
  212.         "index" : "mydb2",
  213.         "allocation_id" : {
  214.           "id" : "r9k170TQQ-uWiEuHDpnRrw"
  215.         }
  216.       }
  217.     ],
  218.     [
  219.       {
  220.         "state" : "STARTED",
  221.         "primary" : false,
  222.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  223.         "relocating_node" : null,
  224.         "shard" : 5,
  225.         "index" : "mydb2",
  226.         "allocation_id" : {
  227.           "id" : "vPczw_9iQS2HkQpacozyFw"
  228.         }
  229.       },
  230.       {
  231.         "state" : "STARTED",
  232.         "primary" : true,
  233.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  234.         "relocating_node" : null,
  235.         "shard" : 5,
  236.         "index" : "mydb2",
  237.         "allocation_id" : {
  238.           "id" : "Rz_A63dASySQ-_B4WmGCQw"
  239.         }
  240.       },
  241.       {
  242.         "state" : "STARTED",
  243.         "primary" : false,
  244.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  245.         "relocating_node" : null,
  246.         "shard" : 5,
  247.         "index" : "mydb2",
  248.         "allocation_id" : {
  249.           "id" : "srSrRO2jSEiQXHqwsG-0wg"
  250.         }
  251.       }
  252.     ],
  253.     [
  254.       {
  255.         "state" : "STARTED",
  256.         "primary" : true,
  257.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  258.         "relocating_node" : null,
  259.         "shard" : 6,
  260.         "index" : "mydb2",
  261.         "allocation_id" : {
  262.           "id" : "GGhrRQ47RXaz8NCXdLNjBA"
  263.         }
  264.       },
  265.       {
  266.         "state" : "STARTED",
  267.         "primary" : false,
  268.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  269.         "relocating_node" : null,
  270.         "shard" : 6,
  271.         "index" : "mydb2",
  272.         "allocation_id" : {
  273.           "id" : "DLI730WDQIaZugMvMFimSA"
  274.         }
  275.       },
  276.       {
  277.         "state" : "STARTED",
  278.         "primary" : false,
  279.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  280.         "relocating_node" : null,
  281.         "shard" : 6,
  282.         "index" : "mydb2",
  283.         "allocation_id" : {
  284.           "id" : "iw-5nzo3QGW4tfhd0wVe3Q"
  285.         }
  286.       }
  287.     ],
  288.     [
  289.       {
  290.         "state" : "STARTED",
  291.         "primary" : false,
  292.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  293.         "relocating_node" : null,
  294.         "shard" : 7,
  295.         "index" : "mydb2",
  296.         "allocation_id" : {
  297.           "id" : "5Xxjliu8QKiUqb6n-AuRLg"
  298.         }
  299.       },
  300.       {
  301.         "state" : "STARTED",
  302.         "primary" : false,
  303.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  304.         "relocating_node" : null,
  305.         "shard" : 7,
  306.         "index" : "mydb2",
  307.         "allocation_id" : {
  308.           "id" : "g18oAgjjQN-RsMzKyrADJA"
  309.         }
  310.       },
  311.       {
  312.         "state" : "STARTED",
  313.         "primary" : true,
  314.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  315.         "relocating_node" : null,
  316.         "shard" : 7,
  317.         "index" : "mydb2",
  318.         "allocation_id" : {
  319.           "id" : "PCZdrbkaTA251OjESqqe0Q"
  320.         }
  321.       }
  322.     ],
  323.     [
  324.       {
  325.         "state" : "STARTED",
  326.         "primary" : true,
  327.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  328.         "relocating_node" : null,
  329.         "shard" : 8,
  330.         "index" : "mydb2",
  331.         "allocation_id" : {
  332.           "id" : "nBsIuKNkT3Se7721Tx04Bw"
  333.         }
  334.       },
  335.       {
  336.         "state" : "STARTED",
  337.         "primary" : false,
  338.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  339.         "relocating_node" : null,
  340.         "shard" : 8,
  341.         "index" : "mydb2",
  342.         "allocation_id" : {
  343.           "id" : "g-ievn2_RROWKFTLNa7X8A"
  344.         }
  345.       },
  346.       {
  347.         "state" : "STARTED",
  348.         "primary" : false,
  349.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  350.         "relocating_node" : null,
  351.         "shard" : 8,
  352.         "index" : "mydb2",
  353.         "allocation_id" : {
  354.           "id" : "Tr4tOTGMTkGz-ycSHkBOxA"
  355.         }
  356.       }
  357.     ],
  358.     [
  359.       {
  360.         "state" : "STARTED",
  361.         "primary" : false,
  362.         "node" : "rVIh8-d2SmKscxM5zlgqfA",
  363.         "relocating_node" : null,
  364.         "shard" : 9,
  365.         "index" : "mydb2",
  366.         "allocation_id" : {
  367.           "id" : "IjSH0BUbST-en0tCakBLVQ"
  368.         }
  369.       },
  370.       {
  371.         "state" : "STARTED",
  372.         "primary" : false,
  373.         "node" : "1M-5yVJyRHakKuwSYpXeNQ",
  374.         "relocating_node" : null,
  375.         "shard" : 9,
  376.         "index" : "mydb2",
  377.         "allocation_id" : {
  378.           "id" : "ay6z-YfNQd2ekNSegqgEYA"
  379.         }
  380.       },
  381.       {
  382.         "state" : "STARTED",
  383.         "primary" : true,
  384.         "node" : "8bkDoRrrTdyikEJ6mEOKsA",
  385.         "relocating_node" : null,
  386.         "shard" : 9,
  387.         "index" : "mydb2",
  388.         "allocation_id" : {
  389.           "id" : "nuO5YbJFTdKXlx0db2l_0A"
  390.         }
  391.       }
  392.     ]
  393.   ]
  394. }

5.将数据推送到指定数据库，指定文档编号。

  1. curl -XPOST http://192.168.1.7:9201/mydb2/_doc/6/?pretty -H 'Content-Type: application/json' -d '{
  2. "id" : "6",
  3. "name" : "xsq006",
  4. "city" : "广州",
  5. "course" : "oracle",
  6. "teacher" : "mazi",
  7. "pxdate": "20240627"
  8. }'
  9. {
  10.   "_index" : "mydb2",
  11.   "_type" : "_doc",
  12.   "_id" : "6",
  13.   "_version" : 1,
  14.   "result" : "created",
  15.   "_shards" : {
  16.     "total" : 3,
  17.     "successful" : 3,
  18.     "failed" : 0
  19.   },
  20.   "_seq_no" : 0,
  21.   "_primary_term" : 1
  22. }

6.健康状态查看 

  1. [esadmin@oracle1 translog]$ curl http://192.168.1.7:9203/_cat/health?pretty -H 'Content-Type: application/json'
  2. 1719461975 04:19:35 escluster1 green 3 3 38 14 0 0 0 0 - 100.0%

7.es集群节点主备情况查询 

  1. [esadmin@oracle1 translog]$ curl http://192.168.1.7:9201/_cat/nodes
  2. 192.168.1.7 32 86 2 0.13 0.06 0.10 dilmt * esdb-node-1
  3. 192.168.1.7 36 86 2 0.13 0.06 0.10 dilmt - esdb-node-2
  4. 192.168.1.7 58 86 2 0.13 0.06 0.10 dilmt - esdb-node-3

8.总结

(1)查看集群健康状态
(2)主备节点观察
(3)所有的数据库的查看 
(4)单个数据库的分片情况 
(5)单个数据库的分片和副本情况查看
(6)所有数据库的分片和副本查看
(7)推送文档到指定数据库的指定文档ID; 

注：本文转载自blog.csdn.net的戒掉贪嗔痴(薛双奇)的文章"https://blog.csdn.net/weixin_43346403/article/details/140010409"。版权归原作者所有，此博客不拥有其著作权，亦不承担相应法律责任。如有侵权，请联系我们删除。
复制链接
相关推荐
发表评论

评论记录：

未查询到任何数据！