I have a lot of transactions in my indexes however each shard is around 50GB. I dont get any shard failure errors but I do get esaggs 30000ms issue on dashboards. Any idea why this is happening.
Which version are you on? What is the size of your cluster? What does you data look like? What does your queries look like? How much data are you querying when it takes that long? Have you looked at CPU usage and/or disk utilization to see if there is any obvious bottleneck?
size as in total data or cpu/memory?
for 30 days we have about 500MM transactions that could get queried.
How many nodes? How many cores and RAM per node? How much data does 30 days equate to on disk?
Have you looked at CPU usage and/or disk utilization to see if there is any obvious bottleneck?
Just a single node unfortunately 8C, 64GB Ram, 30 days is around is 700-800gb
What type of storage do you have? SSDs?
What does your query look like?
SSDs how do I look at the queries? and what do you mean what does it look like?
Can you show the query?
What does CPU usage look like while the query is processing?
Mmm this is a prod system let me check CPU usage
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.