{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/10035","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/10035/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/10035/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/10035/events","html_url":"https://github.com/influxdata/influxdb/issues/10035","id":337989064,"node_id":"MDU6SXNzdWUzMzc5ODkwNjQ=","number":10035,"title":"TSI index version is ignored","user":{"login":"NocturnalShadow","id":25293920,"node_id":"MDQ6VXNlcjI1MjkzOTIw","avatar_url":"https://avatars0.githubusercontent.com/u/25293920?v=4","gravatar_id":"","url":"https://api.github.com/users/NocturnalShadow","html_url":"https://github.com/NocturnalShadow","followers_url":"https://api.github.com/users/NocturnalShadow/followers","following_url":"https://api.github.com/users/NocturnalShadow/following{/other_user}","gists_url":"https://api.github.com/users/NocturnalShadow/gists{/gist_id}","starred_url":"https://api.github.com/users/NocturnalShadow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NocturnalShadow/subscriptions","organizations_url":"https://api.github.com/users/NocturnalShadow/orgs","repos_url":"https://api.github.com/users/NocturnalShadow/repos","events_url":"https://api.github.com/users/NocturnalShadow/events{/privacy}","received_events_url":"https://api.github.com/users/NocturnalShadow/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-03T17:22:33Z","updated_at":"2018-07-05T14:31:40Z","closed_at":null,"author_association":"NONE","body":"Hello, \r\nI've changed `index_version` property under `data `section in `influxdb.conf` from `inmem `to `tsi1`.\r\nThen I've cleared meta, data and wal directories and restarted InfluxDB.\r\n\r\n**Expected behavior:** InfluxDB uses tsi1 engine.\r\n\r\n**Actual behavior:** tsm1 engine is still used. tsi1 option is ignored. \r\n\r\nThat is what I get, when I insert a data-point:\r\n![image](https://user-images.githubusercontent.com/25293920/42234609-c441d2c0-7efd-11e8-999c-84db39ef222b.png)\r\n\r\nThis is crucial, since in the real environment, the whole index is loaded into RAM and takes 14+ GB which is deadly in my case.\r\n\r\nI'm using InfluxDB 1.5.4, but I had the same issues with the earlier versions.\r\n\r\nHere is a related issues: https://github.com/influxdata/influxdb/issues/9817, https://github.com/influxdata/influxdb/issues/9540. People there have similar problem, but by some reason, nobody answered, why tsm1 is still used if tsi1 was specified.\r\n\r\nThank you\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/402742063","html_url":"https://github.com/influxdata/influxdb/issues/10035#issuecomment-402742063","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/10035","id":402742063,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMjc0MjA2Mw==","user":{"login":"NocturnalShadow","id":25293920,"node_id":"MDQ6VXNlcjI1MjkzOTIw","avatar_url":"https://avatars0.githubusercontent.com/u/25293920?v=4","gravatar_id":"","url":"https://api.github.com/users/NocturnalShadow","html_url":"https://github.com/NocturnalShadow","followers_url":"https://api.github.com/users/NocturnalShadow/followers","following_url":"https://api.github.com/users/NocturnalShadow/following{/other_user}","gists_url":"https://api.github.com/users/NocturnalShadow/gists{/gist_id}","starred_url":"https://api.github.com/users/NocturnalShadow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NocturnalShadow/subscriptions","organizations_url":"https://api.github.com/users/NocturnalShadow/orgs","repos_url":"https://api.github.com/users/NocturnalShadow/repos","events_url":"https://api.github.com/users/NocturnalShadow/events{/privacy}","received_events_url":"https://api.github.com/users/NocturnalShadow/received_events","type":"User","site_admin":false},"created_at":"2018-07-05T14:31:40Z","updated_at":"2018-07-05T14:31:40Z","author_association":"NONE","body":"OK, here is the deal:\r\nIt seem that despite of no mentioning of TSI indexing in logs, the InfluxDB will actually use TSI indexing if  the following criteria met:  `[data] -> index_version` set to `tsi1` and **all `index` directories recursively deleted under `influxdb/data`**  after successfully running `influx_inspect buildtsi ...`\r\n\r\nAnd the reason I can know TSI is used instead of in-mem is that in my environment InfluxDB RAM usage  reduced from >15GB to stable ~6GB. However, disc I/O was boosted immensely (`docker stats` shows 5GB / 380GB (I/O) for InfluxDB container).\r\nAlso some queries became significantly slower and some will just fall out with Go-lang panic."}}
{"actor":{"display_login":"NocturnalShadow"}}