I use Pihole for DNS servers throughout the company to prevent employees from seeing ads and some websites. However, due to the large number of visits, SQLite performance used by FTL is seriously insufficient. So how to use MySQL as a database?

What are you running Pi-hole on? How much RAM? How much memory is allocated to PHP? What is the webserver? Those are all things to fix before even getting to the database.

Hello Just installed few minutes ago and i'm looking if it possible to use a deported database I am interested too. 2 reason I have a NAS with a mariadb, and it make sense to use it (for me) And on the top of the interest, is to save my SD card. :sweat_smile:

[image] lecameleon99: And on the top of the interest, is to save my SD card. The gravity database is only written to once a week (or on manual interactivity, e.g., when you edit domains, of course). I don't think there will be much to save here. [image] lecameleon99: I have a NAS with a …

Hi Dan, I am using CentOS Linux release 7.8.2003 (Core), with 8GB of RAM, PHP 7.2.31 (memory_limit = 512M). Any advise. Thx.

Would below be a good indicator ? pi@ph5:~ $ php-cgi -q <<< $'<?php echo memory_get_peak_usage(1) . "\n" ?>' 2097152 Bit low but its home use :wink: pi@ph5:~ $ php-cgi -i | grep memory_limit <tr><td class="e">memory_limit</td><td class="v">128M</td><td class="v">128M</td></tr> EDIT: Thinking, ab…

[image] deHakkelaar: EDIT3: Sorry for straying off topic a bit :wink: Well, [image] Hoa_NV: The dashboard is working after take long time to response tell me what I am missing but the dashboard does not do any heavy lifting? Only the Query Log does. So why is the dashboard slow? It sh…

[image] Coro: tell me what I am missing but the dashboard does not do any heavy lifting? May be a language issue. When someone says dashboard I take that to mean the entire admin interface, not just the index page.

Depend on how many client and query you have. With me, I had more than 1200 clients with more than 1m query per day. So: I have to purge database daily by crontab. If i don't do that, the admin page can not load in next day sudo service pihole-FTL stop sudo mv /etc/pihole/pihole-FTL.db /scripts…

Set the memory allocation to everything you've got. See if that's quick enough. I think you'll find the limitation is PHP and not the database.

Pi-hole Userspace

To use MySQL as database

Feature Requests

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled