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]> 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/ms >>> gid/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 > <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/CALGqCvPtOQGYvY%2B0f8pLGrS-35P5tazdBaFJ9HvAMVUSsSxYDA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
