{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/5440","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/5440/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/5440/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/5440/events","html_url":"https://github.com/influxdata/influxdb/issues/5440","id":128490745,"number":5440,"title":"High memory usage ","user":{"login":"tahmasebi","id":3611353,"avatar_url":"https://avatars.githubusercontent.com/u/3611353?v=3","gravatar_id":"","url":"https://api.github.com/users/tahmasebi","html_url":"https://github.com/tahmasebi","followers_url":"https://api.github.com/users/tahmasebi/followers","following_url":"https://api.github.com/users/tahmasebi/following{/other_user}","gists_url":"https://api.github.com/users/tahmasebi/gists{/gist_id}","starred_url":"https://api.github.com/users/tahmasebi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tahmasebi/subscriptions","organizations_url":"https://api.github.com/users/tahmasebi/orgs","repos_url":"https://api.github.com/users/tahmasebi/repos","events_url":"https://api.github.com/users/tahmasebi/events{/privacy}","received_events_url":"https://api.github.com/users/tahmasebi/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":17,"created_at":"2016-01-25T08:58:42Z","updated_at":"2016-06-13T15:34:36Z","closed_at":"2016-06-13T15:34:36Z","body":"Hi,\r\nI install Influxdb on ubuntu server with 4G of memory and use python's requests module to write 10M points into db.\r\nThe python script inserts 20k points per second into db successfully but ubuntu's memory goes high until Influxdb use 97% of Ram.\r\nAfter that I can't query a simple request like \"select * from srcipm limit 1\".\r\nEven after write process is finished, Influxdb doesn't release memory. \r\n\r\nDetails:\r\n- Server: `64bit Ubuntu Server 15.10, 1 Core CPU, 4G RAM`\r\n- InfluxDB Version `0.9.6`\r\n\r\nWrite query in python: \r\n```\r\nrequests.post(\"http://192.168.1.104:8086/write?db=mydb\", \"srcipm,device_id=4,input_snmp=2,output_snmp=3,direction=1,ip=192.168.1.1 bytes=25478\")\r\n```\r\n\r\nWhere is the problem? should I config something or my query is wrong?"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/225618171","html_url":"https://github.com/influxdata/influxdb/issues/5440#issuecomment-225618171","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/5440","id":225618171,"user":{"login":"mjdesa","id":1477539,"avatar_url":"https://avatars.githubusercontent.com/u/1477539?v=3","gravatar_id":"","url":"https://api.github.com/users/mjdesa","html_url":"https://github.com/mjdesa","followers_url":"https://api.github.com/users/mjdesa/followers","following_url":"https://api.github.com/users/mjdesa/following{/other_user}","gists_url":"https://api.github.com/users/mjdesa/gists{/gist_id}","starred_url":"https://api.github.com/users/mjdesa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjdesa/subscriptions","organizations_url":"https://api.github.com/users/mjdesa/orgs","repos_url":"https://api.github.com/users/mjdesa/repos","events_url":"https://api.github.com/users/mjdesa/events{/privacy}","received_events_url":"https://api.github.com/users/mjdesa/received_events","type":"User","site_admin":false},"created_at":"2016-06-13T15:34:36Z","updated_at":"2016-06-13T15:34:36Z","body":"@adilbaig In the example point you listed\r\n```\r\nprice,ric=VOD.L,open=12.3,close=12.3,volume=1200 dummy=1 12345644687\r\n```\r\n\r\n`ric`, `open`, `close`, and `volume` are all tags. Meaning that both key and value will be treated as strings. Additionally they will be index. And presumably will have an absurdly high cardinality. This is most likely why you're seeing so much memory used. Try changing `open`, `close`, and `volume` to be fields instead."}}
{"actor":{"display_login":"mjdesa"}}