No long strings. Now, lenght of the value of tags is less than 50 chars and will never bigger than 100 chars.
I start a grafana on the same machine. Will this make the problem? Under normal Condition, how many memory influxDB will used when it has a series cardinality of 11k ? 在 2016年8月16日星期二 UTC+8上午1:13:12，Sean Beckett写道： > > A series cardinality of 11k should not be problematic for a machine with > 4GB of RAM. Do you have long strings in your tags or measurement names? > > On Mon, Aug 15, 2016 at 6:06 AM, <[email protected] <javascript:>> > wrote: > >> Thanks very much for your reply. >> >> One of the tags has about one hundred different values. >> >> The result of the sql you mentioned is 11K. >> >> 在 2016年8月9日星期二 UTC+8上午4:58:19，Mike Schroll写道： >>> >>> Are any of your tags highly variable data? >>> >>> Search docs for cardinality to learn more. >>> >>> Run this command to return what your cardinality is: >>> SELECT sum(numSeries) AS "total_series" FROM "_internal".."database" >>> WHERE time > now() - 10s; >>> >>> On Tuesday, August 2, 2016 at 5:27:07 AM UTC-7, [email protected] >>> wrote: >>>> >>>> I am using influxdb 0.13. in Radhat 6.5 with 2 cpu and 4G memory. >>>> >>>> >>>> There are about 70 million points in one measurement. Each point has >>>> 4tags and 5 fields. It can excute count funtion without specify time >>>> window successfully. But when query "select * from measurement limit 10", >>>> influxdb eat up my memory and killed by systerm. And if i specify the time >>>> window, it runs fine. >>>> >>>> So, i wonder how the limit works. Why it eat up memory even though i >>>> limit the results to 10 >>>> >>> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/3b16fc87-db2c-4833-acf7-00fef93c28f4%40googlegroups.com >> >> <https://groups.google.com/d/msgid/influxdb/3b16fc87-db2c-4833-acf7-00fef93c28f4%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sean Beckett > Director of Support and Professional Services > InfluxDB > -- 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/b93d1e85-6c85-49c4-a89e-4d432061f5cc%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
