I suspect this query kills the db for a while show tag values from <measurement> with key=<keyName>
Any help would be appreciated. My instance could not load a week's worth of metrics with only less than a gb of data on disk.. I must be doing something wrong here. Himanshu On Monday, August 15, 2016 at 5:57:40 PM UTC-7, Himanshu Ghai wrote: > > I tried upgrade to 1.0 beta but that did not help. Also tried to alter > default retention policy duration > "alter retention policy default on influx_prod duration 520w". it did not > help either > > i ran stats output as requested in the github issue. For the db i use it > has this value below > What does the numSeries value signify? > > name: database > tags: database=influx_prod > numMeasurements numSeries > --------------- --------- > 4 2190900 > > > > > > On Monday, August 15, 2016 at 12:24:41 PM UTC-7, Himanshu Ghai wrote: >> >> In this post >> https://github.com/influxdata/influxdb/issues/5440#issuecomment-233230997 >> , >> >> jwilder commented to change the retention policy. Can I save my data and >> still follow >> these steps? The steps mention to create db and set retention policy. I >> did not change >> the retention policy and it is possibly running default. >> >> Thanks for your help >> Himanshu >> >> >> >> On Monday, August 15, 2016 at 11:53:48 AM UTC-7, Himanshu Ghai wrote: >>> >>> >>> >>> - My setup is running on a single 4 cpu instance on aws. 0.13 version >>> - Ingests about 5000 measurements with 4 tags each every 3 hours. >>> - Disk has provisioned iops set to 2000 and i/o wait is not a >>> problem. >>> >>> >>> On simple select queries I get a lot of user cpu spikes(80-90%) and >>> timeouts. If I request again after a while, it may work fine. >>> >>> Can someone help me with pointers on what I should be looking at? >>> >>> Thanks for your help >>> Himanshu >>> >> -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/742b5f74-e7a9-4f7f-b43d-74bb672caba6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
