Hello, I have a problem when I read data from influxdb by http. I find my influxdb use too many memory and cpu of my computer.And the disk io is in high usage,too.But I find My frequency of reading data from influxdb is not high.It’s highest frequency is 116qps.I’m very curious about why influxdb use too many resources of my computer.
This is my requests frequency:
This is system info when reading from influxdb
And my request is like this
select *,day_epoch::integer, created_at::integer from one_year.load where symbol = 'node1' order by desc limit 6&epoch=ms
this is the debug info I created by folloing commands while I quering data from influxdb
curl -o profiles.tar.gz "http://localhost:8086/debug/pprof/all?cpu=true" curl -o vars.txt "http://localhost:8086/debug/vars" iostat -xd 1 30 > iostat.txt
Do you have any suggestions to help performance tunning?