{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/6250","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/6250/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/6250/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/6250/events","html_url":"https://github.com/influxdata/influxdb/issues/6250","id":146574268,"number":6250,"title":"InfluxDB starts for 2 hours","user":{"login":"undera","id":2026469,"avatar_url":"https://avatars.githubusercontent.com/u/2026469?v=3","gravatar_id":"","url":"https://api.github.com/users/undera","html_url":"https://github.com/undera","followers_url":"https://api.github.com/users/undera/followers","following_url":"https://api.github.com/users/undera/following{/other_user}","gists_url":"https://api.github.com/users/undera/gists{/gist_id}","starred_url":"https://api.github.com/users/undera/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/undera/subscriptions","organizations_url":"https://api.github.com/users/undera/orgs","repos_url":"https://api.github.com/users/undera/repos","events_url":"https://api.github.com/users/undera/events{/privacy}","received_events_url":"https://api.github.com/users/undera/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/tsm","name":"tsm","color":"e11d21"}],"state":"open","locked":false,"assignee":{"login":"jwilder","id":219935,"avatar_url":"https://avatars.githubusercontent.com/u/219935?v=3","gravatar_id":"","url":"https://api.github.com/users/jwilder","html_url":"https://github.com/jwilder","followers_url":"https://api.github.com/users/jwilder/followers","following_url":"https://api.github.com/users/jwilder/following{/other_user}","gists_url":"https://api.github.com/users/jwilder/gists{/gist_id}","starred_url":"https://api.github.com/users/jwilder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jwilder/subscriptions","organizations_url":"https://api.github.com/users/jwilder/orgs","repos_url":"https://api.github.com/users/jwilder/repos","events_url":"https://api.github.com/users/jwilder/events{/privacy}","received_events_url":"https://api.github.com/users/jwilder/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/influxdata/influxdb/milestones/39","html_url":"https://github.com/influxdata/influxdb/milestones/1.0.0","labels_url":"https://api.github.com/repos/influxdata/influxdb/milestones/39/labels","id":1101423,"number":39,"title":"1.0.0","description":"","creator":{"login":"toddboom","id":53132,"avatar_url":"https://avatars.githubusercontent.com/u/53132?v=3","gravatar_id":"","url":"https://api.github.com/users/toddboom","html_url":"https://github.com/toddboom","followers_url":"https://api.github.com/users/toddboom/followers","following_url":"https://api.github.com/users/toddboom/following{/other_user}","gists_url":"https://api.github.com/users/toddboom/gists{/gist_id}","starred_url":"https://api.github.com/users/toddboom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/toddboom/subscriptions","organizations_url":"https://api.github.com/users/toddboom/orgs","repos_url":"https://api.github.com/users/toddboom/repos","events_url":"https://api.github.com/users/toddboom/events{/privacy}","received_events_url":"https://api.github.com/users/toddboom/received_events","type":"User","site_admin":false},"open_issues":33,"closed_issues":26,"state":"open","created_at":"2015-05-08T06:30:59Z","updated_at":"2016-05-17T23:47:10Z","due_on":null,"closed_at":null},"comments":20,"created_at":"2016-04-07T10:27:49Z","updated_at":"2016-05-18T01:02:57Z","closed_at":null,"body":"This is the continuation of the issue #5764 . The machine I use and database I use is the same.\r\n\r\nI have upgraded influxdb to 0.12 from debian (0.12.0-1). Now the start takes slightly over 2 hours. 33% increase is not bad, but still unacceptable to have downtime of 2 hours just to start. My dream is to replace MySQL server with InfluxDB, because I see InfluxDB is better to store my timeline data. MySQL starts within several seconds (I will keep memory consumption comparison for separate thread). \r\n\r\nCan we improve InfluxDB to beat MySQL? :) I have my feeling that the long startup (and memory consumption also) is the price of being \"schemaless\", but in fact there is a schema that is kept in the memory. Loading that schema at startup takes long time and a lot of RAM (for certain cases). I might be wrong with my assumptions, sorry for being overconfident.\r\n\r\nI've looked into logs, seems there's pretty long shard loads happening, I've grepped from log:\r\ntsm1] 2016/04/06 21:43:56 /var/lib/influxdb/data/Loadosophia/default/512 database index loaded in 11m2.839406822s\r\n[tsm1] 2016/04/06 21:47:00 /var/lib/influxdb/data/Loadosophia/default/513 database index loaded in 14m7.359681031s\r\n[tsm1] 2016/04/06 21:54:48 /var/lib/influxdb/data/Loadosophia/default/525 database index loaded in 21m12.196889089s\r\n[[tsm1] 2016/04/06 22:11:10 /var/lib/influxdb/data/Loadosophia/default/524 database index loaded in 27m14.029874898s\r\n[tsm1] 2016/04/06 22:45:11 /var/lib/influxdb/data/Loadosophia/default/523 database index loaded in 1h12m5.557480759s\r\n[tsm1] 2016/04/06 23:41:10 /var/lib/influxdb/data/Loadosophia/default/527 database index loaded in 1h54m9.795156493s\r\n\r\nAttaching full startup log.\r\n[influxd.20160407.txt](https://github.com/influxdata/influxdb/files/208160/influxd.20160407.txt)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/219898041","html_url":"https://github.com/influxdata/influxdb/issues/6250#issuecomment-219898041","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/6250","id":219898041,"user":{"login":"jwilder","id":219935,"avatar_url":"https://avatars.githubusercontent.com/u/219935?v=3","gravatar_id":"","url":"https://api.github.com/users/jwilder","html_url":"https://github.com/jwilder","followers_url":"https://api.github.com/users/jwilder/followers","following_url":"https://api.github.com/users/jwilder/following{/other_user}","gists_url":"https://api.github.com/users/jwilder/gists{/gist_id}","starred_url":"https://api.github.com/users/jwilder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jwilder/subscriptions","organizations_url":"https://api.github.com/users/jwilder/orgs","repos_url":"https://api.github.com/users/jwilder/repos","events_url":"https://api.github.com/users/jwilder/events{/privacy}","received_events_url":"https://api.github.com/users/jwilder/received_events","type":"User","site_admin":false},"created_at":"2016-05-18T01:02:57Z","updated_at":"2016-05-18T01:02:57Z","body":"`drop measurement` can be expensive if you are dropping a lot of series and/or have many shards.\r\n\r\nIf you grab these profiles, it might help identify the slowness.\r\n\r\n```\r\ncurl -o block.txt \"http://localhost:8086/debug/pprof/block?debug=1\"\r\ncurl -o goroutine.txt \"http://localhost:8086/debug/pprof/goroutine?debug=1\"\r\n```"}}