From the dashboard i select an IP to see it's request (75000) .
I see 'processing' and many times wont display anything and
some times it will after apprx 30-60 secs.
Is there a way to make that faster? Like deleting old requests?
_
From the dashboard i select an IP to see it's request (75000) .
I see 'processing' and many times wont display anything and
some times it will after apprx 30-60 secs.
Is there a way to make that faster? Like deleting old requests?
_
Are you in the query log, or in the long term data section?
A screen shot would be helpful. In this forum you can paste one directly into a reply.
Processing such an amount of data just needs time. There is no way to speed that up except of beefier hardware.
If you request less queries, it should be faster.
With Pi-hole v6 it should also be faster, because it will support server-side pagination.
There is no way to make this faster, other than more powerful hardware. This process uses PHP, and it is slow.
There is no easy way to delete old requests from the query log.
As those 75,000 requests are from recent queries (as detailed by your screenshot), they are already held in memory, so only more powerful h/w could improve responsiveness, as both yubiuser and jfb have already pointed out.
However, before considering such an upgrade, I'd take a good look into that specific client's behaviour: 75,000 requests by a single IP during the last 24 hours seems a bit excessive.
If possible, it would be favourable to reduce the amount of DNS requests at the source, e.g. by configuring that client accordingly.
Thanks all for the feedback. I narrowed my search to two applications that generate thousands of requests per day:
Stellaris played in linux from the Paradox launcher (not steam) api.paradoxplaza.com
and a buggy weather applet in my Devuan+LXQt making requests to api.openweathermap.org
Also @Bucking_Horn mentioned a 24h window. I wasnt aware of that. How could i make it smaller ? That could help in cases of great load.
This is not unusual. A Pi Zero is a very low powered device, and pushing a lot of traffic through pihole-FTL and PHP is going to tax that device severely. I suspect that you would not see a similar problem on higher end hardware like a Pi 4, for example.
From your htop output, some additional info would be helpful to determine exactly which processes are at work.
Reveal the tree view + custom thread names option and see what this shows.
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.