Hi warkolm
thanks for your reply. we have 3 nodes with below stats,
timestamp": 1652846048038,
"status": "green",
"indices": {
"count": 23,
"shards": {
"total": 222,
"primaries": 111,
"replication": 1.0,
"index": {
"shards": {
"min": 2,
"max": 10,
"avg": 9.652173913043478
},
"primaries": {
"min": 1,
"max": 5,
"avg": 4.826086956521739
},
"replication": {
"min": 1.0,
"max": 1.0,
"avg": 1.0
}
}
},
"docs": {
"count": 5662128,
"deleted": 1087260
},
"store": {
"size": "21.8gb",
"size_in_bytes": 23453624948,
"throttle_time": "0s",
"throttle_time_in_millis": 0
},
"fielddata": {
"memory_size": "0b",
"memory_size_in_bytes": 0,
"evictions": 0
},
"query_cache": {
"memory_size": "9.5mb",
"memory_size_in_bytes": 10006937,
"total_count": 1211379,
"hit_count": 789060,
"miss_count": 422319,
"cache_size": 9520,
"cache_count": 9520,
"evictions": 0
},
"completion": {
"size": "0b",
"size_in_bytes": 0
},
"segments": {
"count": 1768,
"memory": "345.4mb",
"memory_in_bytes": 362212322,
"terms_memory": "176.5mb",
"terms_memory_in_bytes": 185168612,
"stored_fields_memory": "3.6mb",
"stored_fields_memory_in_bytes": 3805520,
"term_vectors_memory": "0b",
"term_vectors_memory_in_bytes": 0,
"norms_memory": "21.5mb",
"norms_memory_in_bytes": 22625792,
"points_memory": "2.7mb",
"points_memory_in_bytes": 2837646,
"doc_values_memory": "140.9mb",
"doc_values_memory_in_bytes": 147774752,
"index_writer_memory": "0b",
"index_writer_memory_in_bytes": 0,
"version_map_memory": "0b",
"version_map_memory_in_bytes": 0,
"fixed_bit_set": "1.6mb",
"fixed_bit_set_memory_in_bytes": 1764432,
"max_unsafe_auto_id_timestamp": -1,
"file_sizes": {
}
}
},
"nodes": {
"count": {
"total": 3,
"data": 3,
"coordinating_only": 0,
"master": 3,
"ingest": 3
},
"versions": [
"5.6.3"
],
"os": {
"available_processors": 24,
"allocated_processors": 24,
"names": [
{
"name": "Linux",
"count": 3
}
],
"mem": {
"total": "93gb",
"total_in_bytes": 99918176256,
"free": "11.1gb",
"free_in_bytes": 12006846464,
"used": "81.8gb",
"used_in_bytes": 87911329792,
"free_percent": 12,
"used_percent": 88
}
},
"process": {
"cpu": {
"percent": 0
},
"open_file_descriptors": {
"min": 487,
"max": 487,
"avg": 487
}
},
"jvm": {
"max_uptime": "43.1m",
"max_uptime_in_millis": 2587638,
"versions": [
{
"version": "1.8.0_312",
"vm_name": "OpenJDK 64-Bit Server VM",
"vm_version": "25.312-b07",
"vm_vendor": "Private Build",
"count": 3
}
],
"mem": {
"heap_used": "4gb",
"heap_used_in_bytes": 4296081856,
"heap_max": "23.8gb",
"heap_max_in_bytes": 25560612864
},
"threads": 275
},
"fs": {
"total": "145.2gb",
"total_in_bytes": 155930431488,
"free": "82.1gb",
"free_in_bytes": 88170692608,
"available": "82gb",
"available_in_bytes": 88120360960
},
"plugins": [
{
"name": "discovery-ec2",
"version": "5.6.3",
"description": "The EC2 discovery plugin allows to use AWS API for the unicast discovery mechanism.",
"classname": "org.elasticsearch.discovery.ec2.Ec2DiscoveryPlugin",
"has_native_controller": false
}
],
"network_types": {
"transport_types": {
"netty4": 3
},
"http_types": {
"netty4": 3
}
```
could you suggest here how to increase performance of queries.
I had to get response in few milliseconds, I have 3 nodes and all pointed as master but at any point of time, one can be master and 2 are worker but all 3 are data nodes.
hope this data good enough to give some clue,
JVM memory increased from 2 GB to 8 GB.
also, please let me know how to enable log see incoming queries in full format, slowlog is giving just the time but not actual queries.
thanks