{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/5824","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/5824/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/5824/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/5824/events","html_url":"https://github.com/influxdata/influxdb/issues/5824","id":136216502,"number":5824,"title":"Database hang up after simple query","user":{"login":"pga23","id":6552060,"avatar_url":"https://avatars.githubusercontent.com/u/6552060?v=3","gravatar_id":"","url":"https://api.github.com/users/pga23","html_url":"https://github.com/pga23","followers_url":"https://api.github.com/users/pga23/followers","following_url":"https://api.github.com/users/pga23/following{/other_user}","gists_url":"https://api.github.com/users/pga23/gists{/gist_id}","starred_url":"https://api.github.com/users/pga23/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pga23/subscriptions","organizations_url":"https://api.github.com/users/pga23/orgs","repos_url":"https://api.github.com/users/pga23/repos","events_url":"https://api.github.com/users/pga23/events{/privacy}","received_events_url":"https://api.github.com/users/pga23/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-24T23:03:45Z","updated_at":"2016-02-24T23:10:17Z","closed_at":null,"body":"I use InfluxDB database with 18 different measurements.\r\nAlmost no data (below 100k data records total).\r\nOnly simple telemetry data (temperature, humidity, pulse etc.) - just\r\na few columns plus one 16-char tag in every measurement.\r\n\r\nSimple query SELECT * FROM /.*/ LIMIT 1 made by using web UI\r\nhang up whole database in about 2 minutes (every time).\r\nDuring this time there is no way to make another query and CPU\r\nload and memory usage is very high.\r\n\r\nAdditionally getting example all data (just 6.5k records) from single measurement\r\ntakes about 5 sec. It is a little bit too slow - much slower than my old MySQL...\r\n\r\nI haven't noticed this kind of problems in previous versions of InfluxDB.\r\n\r\nI use Python 3.4, innfluxdb 2.12.0 Python library with InfluxDB 0.10.1 with TSM on the single node\r\ndevelopment server. It is single core, 2GB RAM virtual machine with installed 64-bit Ubuntu 14.04.3.\r\nHost machine has AMD FX-6100 six core CPU and 24GB RAM.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/188504691","html_url":"https://github.com/influxdata/influxdb/issues/5824#issuecomment-188504691","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/5824","id":188504691,"user":{"login":"cxreg","id":55474,"avatar_url":"https://avatars.githubusercontent.com/u/55474?v=3","gravatar_id":"","url":"https://api.github.com/users/cxreg","html_url":"https://github.com/cxreg","followers_url":"https://api.github.com/users/cxreg/followers","following_url":"https://api.github.com/users/cxreg/following{/other_user}","gists_url":"https://api.github.com/users/cxreg/gists{/gist_id}","starred_url":"https://api.github.com/users/cxreg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cxreg/subscriptions","organizations_url":"https://api.github.com/users/cxreg/orgs","repos_url":"https://api.github.com/users/cxreg/repos","events_url":"https://api.github.com/users/cxreg/events{/privacy}","received_events_url":"https://api.github.com/users/cxreg/received_events","type":"User","site_admin":false},"created_at":"2016-02-24T23:10:17Z","updated_at":"2016-02-24T23:10:17Z","body":"is this the same issue as https://github.com/influxdata/influxdb/issues/5553 ?"}}