{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/3531","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/3531/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/3531/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/3531/events","html_url":"https://github.com/influxdb/influxdb/issues/3531","id":98564373,"number":3531,"title":"Weird performance downgrade from 0.8.8 to 0.9.2","user":{"login":"dalibor","id":48384,"avatar_url":"https://avatars.githubusercontent.com/u/48384?v=3","gravatar_id":"","url":"https://api.github.com/users/dalibor","html_url":"https://github.com/dalibor","followers_url":"https://api.github.com/users/dalibor/followers","following_url":"https://api.github.com/users/dalibor/following{/other_user}","gists_url":"https://api.github.com/users/dalibor/gists{/gist_id}","starred_url":"https://api.github.com/users/dalibor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dalibor/subscriptions","organizations_url":"https://api.github.com/users/dalibor/orgs","repos_url":"https://api.github.com/users/dalibor/repos","events_url":"https://api.github.com/users/dalibor/events{/privacy}","received_events_url":"https://api.github.com/users/dalibor/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-08-01T22:01:50Z","updated_at":"2015-08-14T10:13:45Z","closed_at":"2015-08-03T18:54:44Z","body":"I see very weird (and huge) performance downgrade from 0.8.8 to 0.9.2 on 64bit Ubuntu 14.04.2 using pre-built packages (influxdb_0.8.8_amd64.deb and influxdb_0.9.2_amd64.deb). I use the default configs, start service, ensure blank DB (drop/create) and then do 10000 inserts via apache benchmark (same performance issue when testing with the ruby client).\r\n\r\n- 0.8.8\r\n\r\n```\r\nab -n 10000 -c 1 -p post1.txt 'http://localhost:8086/db/mydb/series?time_precision=s&u=root&p=root'\r\n```\r\n\r\nTotal time is `5.746` seconds. post1.txt content:\r\n\r\n```\r\n[{\"name\":\"emails\",\"points\":[[0,\"email1@example.com\",\"example\",\"10.0.0.2\"]],\"columns\":[\"duration\",\"from\",\"sld\",\"ip\"]}]\r\n```\r\n\r\n- 0.9.2\r\n\r\n```\r\nab -n 10000 -c 1 -p post2.txt 'http://localhost:8086/write?db=mydb&precision=s&u=root&p=root'\r\n```\r\n\r\nTotal time is `272.571` seconds. post2.txt content:\r\n\r\n```\r\nemails,type=example,sld=yahoo,ip=10.0.0.2 interval=123\r\n```\r\n\r\nI consistently get similar results (~ 50 times slower 0.9.2 vs 0.8.8) after switching versions multiple times. Any ideas what could be causing this?\r\n\r\nOne weird thing I notice in the log for 0.9.2 is that after every `stop` service command and then when starting the service I get one more line like below added vs the previous start (meaning on the last start I have that line printed out 70 times -- not sure if that could be somehow related).\r\n\r\n```\r\n[metastore] 2015/08/01 23:35:44 [DEBUG] raft: Node 127.0.0.1:8088 updated peer set (2): [127.0.0.1:8088]\r\n```\r\n\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/131058841","html_url":"https://github.com/influxdb/influxdb/issues/3531#issuecomment-131058841","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/3531","id":131058841,"user":{"login":"thetcc","id":687430,"avatar_url":"https://avatars.githubusercontent.com/u/687430?v=3","gravatar_id":"","url":"https://api.github.com/users/thetcc","html_url":"https://github.com/thetcc","followers_url":"https://api.github.com/users/thetcc/followers","following_url":"https://api.github.com/users/thetcc/following{/other_user}","gists_url":"https://api.github.com/users/thetcc/gists{/gist_id}","starred_url":"https://api.github.com/users/thetcc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thetcc/subscriptions","organizations_url":"https://api.github.com/users/thetcc/orgs","repos_url":"https://api.github.com/users/thetcc/repos","events_url":"https://api.github.com/users/thetcc/events{/privacy}","received_events_url":"https://api.github.com/users/thetcc/received_events","type":"User","site_admin":false},"created_at":"2015-08-14T10:13:45Z","updated_at":"2015-08-14T10:13:45Z","body":"@gunnaraasen \r\nThank you for your reply，the version is 0.9.2.\r\nI'm not doing a bulk write request, I know. That might be faster.\r\nLike mysql database, insert records one by one, you can insert more than 10,000 records in one second, in my macbook pro.\r\nBut the 0.9.2 version of influxdb, 10000 records, one by one to write, takes more than 30 seconds.\r\n\r\nIf influxdb only batch write performance was high. I think influxdb upon receipt of written request should first cached, when accumulated to a certain amount, then a batch write. Rather than letting the caller must be accumulated to a certain amount in order to do batch write.\r\n"}}