Thanks! I find someone else encounter similar problem.
在 2016年8月19日星期五 UTC+8上午4:54:42，Sean Beckett写道： > > With no write or read activity, an InfluxDB system with 11k series should > be fine on 500MB of RAM. > > Running Grafana on the same box may be problematic. I don't know what RAM > needs Grafana has, but webapps that do visualization can quickly eat up RAM. > > On Tue, Aug 16, 2016 at 5:51 AM, <[email protected] <javascript:>> > wrote: > >> 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]> 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]. >>>> 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/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] <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/b93d1e85-6c85-49c4-a89e-4d432061f5cc%40googlegroups.com >> >> <https://groups.google.com/d/msgid/influxdb/b93d1e85-6c85-49c4-a89e-4d432061f5cc%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/e940002e-b0cb-4818-ad26-2d36a16d0fd7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
