# Is there any max limit on measurements in a database?

**URL:** <https://community.influxdata.com/t/is-there-any-max-limit-on-measurements-in-a-database/5860>\
**Category:** Store\
**Tags:** influxdb\
**Created:** [July 11, 2018, 11:19pm UTC](https://community.influxdata.com/t/is-there-any-max-limit-on-measurements-in-a-database/5860 "2018-07-11T23:19:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mritunjaykumar](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/mritunjaykumar/32/1499_2.png) [@mritunjaykumar](https://community.influxdata.com/u/mritunjaykumar)\
**Post date:** [July 11, 2018, 11:19pm UTC](https://community.influxdata.com/t/is-there-any-max-limit-on-measurements-in-a-database/5860/1 "2018-07-11T23:19:29Z")

</div>

I know that influxdb cares about series cardinality, and measurement name is part of a series. In one of the design choices that I have to make, I can swap one of the tags with the measurement name and it will improve design from categorization perspective. By doing that of course I am not changing overall series cardinality, but I will definitely increase the number of measurements in the database.  
So, my question is - Does Influxdb care about number of measurements in a database when I am not changing the series cardinality?

Thanks,  
Jay

---

<div class="post-metadata">

**Author:** ![mritunjaykumar](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/mritunjaykumar/32/1499_2.png) [@mritunjaykumar](https://community.influxdata.com/u/mritunjaykumar)\
**Post date:** [August 7, 2018, 12:42am UTC](https://community.influxdata.com/t/is-there-any-max-limit-on-measurements-in-a-database/5860/2 "2018-08-07T00:42:45Z")

</div>

Given, I didn’t hear from anybody, I did my own test. I am trying to use Influxdb to support multiple tenants. So, earlier I was thinking of using measurement names for the tenants. I did multiple tests (at least 25 test runs) with various combinations of RAM and tenants (as measurement names and databases). I know that ID fields add to the cardinality, so in one of the run I had removed ID column from the tag list. However, as I need to run group-by on ID column, I didn’t have that choice. So, I brought ID column back to tagset.  
Finally, at the end, for an Influxdb instance, I am settled with 32GB RAM, and one database per tenant. I was able to run that instance with 25 tenants (read 25 databases). Each of these 25 tenants has around 300K series, and I saw that influxdb memory consumption was hovering around a little over 50%.  
I hope this helps somebody who is in similar situation.

---

<div class="post-metadata">

**Author:** ![philb](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/philb/32/1805_2.png) [@philb](https://community.influxdata.com/u/philb)\
**Post date:** [August 7, 2018, 12:14pm UTC](https://community.influxdata.com/t/is-there-any-max-limit-on-measurements-in-a-database/5860/3 "2018-08-07T12:14:14Z")

</div>

I do believe there are limits to the series you can store per database (1 million i think)

You can increase this though, but it will increase series cardinality in the database.

[Config example](https://github.com/influxdata/influxdb/blob/master/etc/config.sample.toml)

Just before the [coordinator] configuration options, there are some defaults. You can change them, but as i say it will increase the series cardinality for your individual databases.

Hope that helps

---

<div class="post-metadata">

**Author:** ![Gates](https://avatars.discourse-cdn.com/v4/letter/g/ea666f/32.png) [@Gates](https://community.influxdata.com/u/Gates)\
**Post date:** [December 18, 2018, 2:08am UTC](https://community.influxdata.com/t/is-there-any-max-limit-on-measurements-in-a-database/5860/4 "2018-12-18T02:08:23Z")

</div>

Hi, i reckon that can we set a lot fields instead of many measurements?