# Store **URL:** https://community.influxdata.com/c/ts-store/5.md [Latest](https://community.influxdata.com/latest.md) · [Categories](https://community.influxdata.com/categories.md) · [Tags](https://community.influxdata.com/tags.md) --- ## [Time Series Storage](https://community.influxdata.com/t/time-series-storage/15)
**Author:** [@jackzampolin](https://community.influxdata.com/u/jackzampolin)\ **Replies:** 0
Storage is a category that contains questions/comments/how-tos about storing time-series data. It is meant to be a forum to discuss different storage methods and engines. --- ## [Write\_api.write(): Exception: cannot do slice indexing on DatetimeIndex with these indexers \[\] of type str](https://community.influxdata.com/t/write-api-write-exception-cannot-do-slice-indexing-on-datetimeindex-with-these-indexers-of-type-str/58275)
**Author:** [@jm\_wingdm](https://community.influxdata.com/u/jm_wingdm)\ **Replies:** 5\ **Last updated:** [February 17, 2026, 11:17am UTC](https://community.influxdata.com/t/write-api-write-exception-cannot-do-slice-indexing-on-datetimeindex-with-these-indexers-of-type-str/58275 "2026-02-17T11:17:27Z")
I am facing an issue while trying to write into InfluxDB 2.7 with python library influxdb-client==1.48.0. I have created a pandas DataFrame with this schema: signalname float64 imo object dtype: object He… --- ## [Is InfluxDB good for analytics use-case (for Big Data)](https://community.influxdata.com/t/is-influxdb-good-for-analytics-use-case-for-big-data/1151)
**Author:** [@Hitesh\_Jhamb](https://community.influxdata.com/u/Hitesh_Jhamb)\ **Replies:** 13\ **Last updated:** [December 2, 2025, 12:56pm UTC](https://community.influxdata.com/t/is-influxdb-good-for-analytics-use-case-for-big-data/1151 "2025-12-02T12:56:43Z")
I want to know whether below use-case fits for InfluxDB or not ? Requirements- 1. We are generating 200+ GB data daily. We need to produce rollups of daily cubes. 2. Rollup can be any - Standard, and Custom Standard - … --- ## [Best practices for choosing measurement, tags and fields](https://community.influxdata.com/t/best-practices-for-choosing-measurement-tags-and-fields/32556)
**Author:** [@Chris\_KIP](https://community.influxdata.com/u/Chris_KIP)\ **Replies:** 15\ **Last updated:** [August 4, 2025, 4:54am UTC](https://community.influxdata.com/t/best-practices-for-choosing-measurement-tags-and-fields/32556 "2025-08-04T04:54:34Z")
Hi everyone, We are currently facing the challenge of storing various sensor data in an InfluxDB and do not know exactly how to name the measurements, tags and fields optimally. Specifically, we need to store sensors th… --- ## [How to prevent {database}/\_series folder from growing indefinitely](https://community.influxdata.com/t/how-to-prevent-database-series-folder-from-growing-indefinitely/18949)
**Author:** [@frasier](https://community.influxdata.com/u/frasier)\ **Replies:** 1\ **Last updated:** [July 23, 2025, 3:02pm UTC](https://community.influxdata.com/t/how-to-prevent-database-series-folder-from-growing-indefinitely/18949 "2025-07-23T15:02:25Z")
Hi guys, I’m struggling with an issue lately, the files under {database}/\_series keeps growing no matter what I did. I’ve tried the followings: set the retention policy to 1 hour drop series drop measurement Can anyo… --- ## [Not sure what the best way is to structure my DB](https://community.influxdata.com/t/not-sure-what-the-best-way-is-to-structure-my-db/10924)
**Author:** [@Thibaultmol](https://community.influxdata.com/u/Thibaultmol)\ **Replies:** 0\ **Last updated:** [August 17, 2019, 4:13pm UTC](https://community.influxdata.com/t/not-sure-what-the-best-way-is-to-structure-my-db/10924 "2019-08-17T16:13:12Z")
So I’m trying to take a snapshot of a game’s inventory (saved to a .json file) every 30 seconds or 60 seconds. With the goal of having a graph that allows me to see which items in the inventory go up and down over time. … --- ## [Problem with CSV import](https://community.influxdata.com/t/problem-with-csv-import/56416)
**Author:** [@fantastiko](https://community.influxdata.com/u/fantastiko)\ **Replies:** 0\ **Last updated:** [February 18, 2025, 10:01am UTC](https://community.influxdata.com/t/problem-with-csv-import/56416 "2025-02-18T10:01:03Z")
Hello. I am trying to upload a CSV file with Thingspeak measurement data. I have to format the downloaded file according to the guidelines from influxdb. #group,false,false,false,false,false,false,false,false,false #da… --- ## [Strange insertion behavior - Duplicate Point](https://community.influxdata.com/t/strange-insertion-behavior-duplicate-point/39827)
**Author:** [@laurentb](https://community.influxdata.com/u/laurentb)\ **Replies:** 1\ **Last updated:** [December 14, 2024, 11:45am UTC](https://community.influxdata.com/t/strange-insertion-behavior-duplicate-point/39827 "2024-12-14T11:45:44Z")
Dear all, I’m using InfluxDB v1.11.8 and I have a strange behavior when I want to insert a point: # influx -host melcloud -database power -execute 'delete FROM kwh\_tot' # influx -host melcloud -database power -execute … --- ## [Adding data into bucket with a CSV through UI](https://community.influxdata.com/t/adding-data-into-bucket-with-a-csv-through-ui/39449)
**Author:** [@ydorian](https://community.influxdata.com/u/ydorian)\ **Replies:** 0\ **Last updated:** [November 21, 2024, 11:17am UTC](https://community.influxdata.com/t/adding-data-into-bucket-with-a-csv-through-ui/39449 "2024-11-21T11:17:56Z")
I am new to Influx and am trying to add data into a database through a CSV file. When adding the data I keep getting the error: error in csv.from(): failed to read metadata: column “LapTime” has invalid datatype: unsuppo… --- ## [Significant memory usage issues with Influxd.exe on a Windows environment](https://community.influxdata.com/t/significant-memory-usage-issues-with-influxd-exe-on-a-windows-environment/39180)
**Author:** [@KevinHuh](https://community.influxdata.com/u/KevinHuh)\ **Replies:** 1\ **Last updated:** [November 18, 2024, 3:31pm UTC](https://community.influxdata.com/t/significant-memory-usage-issues-with-influxd-exe-on-a-windows-environment/39180 "2024-11-18T15:31:08Z")
I’m experiencing significant memory usage issues with Influxd.exe on a Windows environment and could use some guidance. Here are the details: Problem The Influxd.exe process is consuming over 120GB of memory on our Win… --- ## [Data Storage Schema](https://community.influxdata.com/t/data-storage-schema/35390)
**Author:** [@vinh\_lee](https://community.influxdata.com/u/vinh_lee)\ **Replies:** 4\ **Last updated:** [August 26, 2024, 11:10pm UTC](https://community.influxdata.com/t/data-storage-schema/35390 "2024-08-26T23:10:59Z")
Hi alls! I have been working with influxdb for few months, and sometimes, I still find myself struggling to define which ones is tag and which ones is field. I have been reading many articles to understand it. Let say … --- ## [Creating a counter](https://community.influxdata.com/t/creating-a-counter/35398)
**Author:** [@Luis\_Gasca](https://community.influxdata.com/u/Luis_Gasca)\ **Replies:** 1\ **Last updated:** [August 21, 2024, 6:22pm UTC](https://community.influxdata.com/t/creating-a-counter/35398 "2024-08-21T18:22:44Z")
Hi all, I am trying to implement a counter, so that I need to increment the value of the only field in my schema if the record (tag set + timestamp in seconds) already exists, which is often the case. For example, a giv… --- ## [Backfill 16 years of data](https://community.influxdata.com/t/backfill-16-years-of-data/31925)
**Author:** [@Brenton\_Collins](https://community.influxdata.com/u/Brenton_Collins)\ **Replies:** 3\ **Last updated:** [July 2, 2024, 8:43am UTC](https://community.influxdata.com/t/backfill-16-years-of-data/31925 "2024-07-02T08:43:09Z")
Hello, I have 16 years of data to backfill into InfluxDB v2 The data consists of around 20,000 seperate data streams. Each data stream has a timestamp and value I have a measurement for each data stream and value field… --- ## [Validate backup](https://community.influxdata.com/t/validate-backup/34611)
**Author:** [@Overflowed](https://community.influxdata.com/u/Overflowed)\ **Replies:** 0\ **Last updated:** [June 17, 2024, 7:27am UTC](https://community.influxdata.com/t/validate-backup/34611 "2024-06-17T07:27:23Z")
Hello, I have a question regarding influxDB backups: I want to regularly check whether my backed up data is still valid. When a shard (..tar.gz) is corrputed influx restore skips it but doesn’t show an error message. … --- ## [Storing multidimensional data](https://community.influxdata.com/t/storing-multidimensional-data/34406)
**Author:** [@juha-ylikoski](https://community.influxdata.com/u/juha-ylikoski)\ **Replies:** 2\ **Last updated:** [May 31, 2024, 6:04am UTC](https://community.influxdata.com/t/storing-multidimensional-data/34406 "2024-05-31T06:04:12Z")
Hi, We have a sound like signal which we have transformed with FFT to form an array of values. This array is for us a logical single data point / measurement. How would you recommend storing this data in influxdb (or d… --- ## [Export data of a bucket from a server to another one](https://community.influxdata.com/t/export-data-of-a-bucket-from-a-server-to-another-one/33184)
**Author:** [@Symptom](https://community.influxdata.com/u/Symptom)\ **Replies:** 0\ **Last updated:** [February 12, 2024, 9:19am UTC](https://community.influxdata.com/t/export-data-of-a-bucket-from-a-server-to-another-one/33184 "2024-02-12T09:19:27Z")
Hy, I have currently my influxDB v2 on a server, and would like to transfer it to another one. I already installed the new influxDB on the second server, and I’m currently trying to transfer my buckets to this new one. … --- ## [Schema Design for IoT Metrics](https://community.influxdata.com/t/schema-design-for-iot-metrics/2134)
**Author:** [@resteeee](https://community.influxdata.com/u/resteeee)\ **Replies:** 9\ **Last updated:** [February 12, 2024, 5:07pm UTC](https://community.influxdata.com/t/schema-design-for-iot-metrics/2134 "2024-02-12T17:07:44Z")
Hi guys, We are planning to use InfluxDB as a storage for IoT data (sensors and different measurements). We have that situation: 3000 Devices Each “typical” device has 8 sensors, (4 temperature sensors, 4 Power consu… --- ## [Disk quota exceeded when writing data](https://community.influxdata.com/t/disk-quota-exceeded-when-writing-data/32559)
**Author:** [@kiendev98](https://community.influxdata.com/u/kiendev98)\ **Replies:** 0\ **Last updated:** [December 20, 2023, 1:27pm UTC](https://community.influxdata.com/t/disk-quota-exceeded-when-writing-data/32559 "2023-12-20T13:27:50Z")
I’m using InfluxDB v1.8 to store test data from Jmeter. JMeter executes the test cases and calls the endpoint “/write?db=jmeter” to store the data. However, i’m are having a very strange error related to the disk quota… --- ## [How to save an array?](https://community.influxdata.com/t/how-to-save-an-array/32200)
**Author:** [@pelu](https://community.influxdata.com/u/pelu)\ **Replies:** 1\ **Last updated:** [December 7, 2023, 8:08pm UTC](https://community.influxdata.com/t/how-to-save-an-array/32200 "2023-12-07T20:08:41Z")
Hi folks, is it possible to save an array directly as a value? I need to store a lot of arrays (vectors) that come from a mqtt message (json), i.e.: { "orientation": "front\_left", "latitude": 2.9996022459576714, … --- ## [Optimal way to backfill new field into historical data](https://community.influxdata.com/t/optimal-way-to-backfill-new-field-into-historical-data/929)
**Author:** [@gonber](https://community.influxdata.com/u/gonber)\ **Replies:** 1\ **Last updated:** [November 21, 2023, 8:58am UTC](https://community.influxdata.com/t/optimal-way-to-backfill-new-field-into-historical-data/929 "2023-11-21T08:58:16Z")
What is the most efficient way of backfilling a new field into all the points within a measurement? My current approach is to do a select \* on progressively older time slices. And write back points with the same tag set,… --- ## [High memory usage on TSI mode](https://community.influxdata.com/t/high-memory-usage-on-tsi-mode/16521)
**Author:** [@kwubctdt](https://community.influxdata.com/u/kwubctdt)\ **Replies:** 5\ **Last updated:** [November 16, 2023, 5:48am UTC](https://community.influxdata.com/t/high-memory-usage-on-tsi-mode/16521 "2023-11-16T05:48:45Z")
We are running a stress test with importing certain amount of history records from scratch using InfluxDB v1.8.3 OSS. The goal of the test is to discover the needed parameters to set and the hardware spec in order to gai… --- ## [Collecting and Storing metrics from collectors deployed in highly available fashion](https://community.influxdata.com/t/collecting-and-storing-metrics-from-collectors-deployed-in-highly-available-fashion/31926)
**Author:** [@tejaswiniVadlamudi](https://community.influxdata.com/u/tejaswiniVadlamudi)\ **Replies:** 2\ **Last updated:** [October 27, 2023, 8:31am UTC](https://community.influxdata.com/t/collecting-and-storing-metrics-from-collectors-deployed-in-highly-available-fashion/31926 "2023-10-27T08:31:11Z")
Hi, Does InfluxDB support collecting metrics from telegraph agents and/or Open Telemetry Collectors that are highly available and collecting redundant metrics from services? I couldn’t find any documentation on this pa… --- ## [Storing stock market data for complex queries](https://community.influxdata.com/t/storing-stock-market-data-for-complex-queries/31677)
**Author:** [@Discordia](https://community.influxdata.com/u/Discordia)\ **Replies:** 2\ **Last updated:** [October 1, 2023, 8:47pm UTC](https://community.influxdata.com/t/storing-stock-market-data-for-complex-queries/31677 "2023-10-01T20:47:07Z")
Hi, I am looking at influxdb as storage for stock market data. I only want to stor daily timeframe so one entry per stock per day. And about 252 entries per stock per year. There are about 7000 stocks in the US stock mar… --- ## [What is the maximum string size for a field value?](https://community.influxdata.com/t/what-is-the-maximum-string-size-for-a-field-value/749)
**Author:** [@Drew](https://community.influxdata.com/u/Drew)\ **Replies:** 7\ **Last updated:** [August 18, 2023, 12:15pm UTC](https://community.influxdata.com/t/what-is-the-maximum-string-size-for-a-field-value/749 "2023-08-18T12:15:55Z")
The latest documentation I saw indicated the maximum string size for a field value was 64KB. Is this still the case? Is it configurable? --- ## [Backup command to use gzip's --rsyncable option](https://community.influxdata.com/t/backup-command-to-use-gzips-rsyncable-option/12053)
**Author:** [@maggie](https://community.influxdata.com/u/maggie)\ **Replies:** 2\ **Last updated:** [August 6, 2023, 6:13pm UTC](https://community.influxdata.com/t/backup-command-to-use-gzips-rsyncable-option/12053 "2023-08-06T18:13:37Z")
Hi all, i am using the backup command and duplicati to store my backups. Duplicati has a nice data deduplication method which currently doesn’t seem to be used much on influx backup. I assume that the tar.gz file creati… --- ## [Reducing Retention Policy did not free up space](https://community.influxdata.com/t/reducing-retention-policy-did-not-free-up-space/2479)
**Author:** [@mantzas](https://community.influxdata.com/u/mantzas)\ **Replies:** 2\ **Last updated:** [July 1, 2023, 4:23pm UTC](https://community.influxdata.com/t/reducing-retention-policy-did-not-free-up-space/2479 "2023-07-01T16:23:05Z")
Hi, i have a 1 year retention policy on my db and i want to change this to 30 days due to capacity issues. I altered the existing retention policy to 30d successfully but the old data gets not dropped. Any ideas? --- ## [Shard file created but not written](https://community.influxdata.com/t/shard-file-created-but-not-written/30144)
**Author:** [@Suhanbongo](https://community.influxdata.com/u/Suhanbongo)\ **Replies:** 2\ **Last updated:** [June 7, 2023, 10:26pm UTC](https://community.influxdata.com/t/shard-file-created-but-not-written/30144 "2023-06-07T22:26:29Z")
Hi, We have many buckets, the retention days is set to 60, thus the default shard group duration is 1d. In some cased the newly created shard file (got corrupted?) cannot written by the metrics provider and only influx … --- ## [Introducing infix, a command line tool to alter metadata and rewrite tsm and wal files](https://community.influxdata.com/t/introducing-infix-a-command-line-tool-to-alter-metadata-and-rewrite-tsm-and-wal-files/14292)
**Author:** [@octal](https://community.influxdata.com/u/octal)\ **Replies:** 9\ **Last updated:** [May 17, 2023, 6:59pm UTC](https://community.influxdata.com/t/introducing-infix-a-command-line-tool-to-alter-metadata-and-rewrite-tsm-and-wal-files/14292 "2023-05-17T18:59:42Z")
Hello, InfluxQL does not offer ways to alter the structure of InfluxDB metadata (measurements, series, fields, tags, …). This has been a known limitation for a very long time, see for example the following open feature … --- ## [Best practices for duplicating and restoring data from InfluxDB OSS for later analysis](https://community.influxdata.com/t/best-practices-for-duplicating-and-restoring-data-from-influxdb-oss-for-later-analysis/29874)
**Author:** [@somanyquestions](https://community.influxdata.com/u/somanyquestions)\ **Replies:** 1\ **Last updated:** [May 11, 2023, 1:15pm UTC](https://community.influxdata.com/t/best-practices-for-duplicating-and-restoring-data-from-influxdb-oss-for-later-analysis/29874 "2023-05-11T13:15:14Z")
Hi Everyone, I have a question regarding best practices for backing up InfluxDB data on an edge computer running InfluxDB OSS. To provide some background, we have an edge computer running InfluxDB OSS (on Ubuntu) at a … --- ## [InfluxDb usage statistics](https://community.influxdata.com/t/influxdb-usage-statistics/779)
**Author:** [@tonic8](https://community.influxdata.com/u/tonic8)\ **Replies:** 7\ **Last updated:** [April 24, 2023, 1:25pm UTC](https://community.influxdata.com/t/influxdb-usage-statistics/779 "2023-04-24T13:25:53Z")
Hello First : fantastic suits of tools !!!! i love so much TICS. I would like to know if in influxDB there is a way to get a quick shot of the size usage of hosts/tags/data retention? my scenario is for example, to… [Next page](https://community.influxdata.com/c/ts-store/5.md?page=1)