@DL6ER did we change something in FTL startup order that might have affected this? Not dug too deeply but here are some logs after adding a local DNS entry via the web interface
My main Pihole running `:beta-v5.9`
[2021-07-06 07:51:50.626 584M] ########## FTL started on pihole-docker! ##########
[2021-07-06 07:51:50.626 584M] FTL branch: release/v5.9
[2021-07-06 07:51:50.626 584M] FTL version: vDev-8980cc8
[2021-07-06 07:51:50.627 584M] FTL commit: 8980cc8a
[2021-07-06 07:51:50.627 584M] FTL date: 2021-07-06 07:40:50 +0200
[2021-07-06 07:51:50.627 584M] FTL user: root
[2021-07-06 07:51:50.627 584M] Compiled for x86_64 (compiled on CI) using gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516
[2021-07-06 07:51:50.627 584M] Creating mutex
[2021-07-06 07:51:50.627 584M] Creating mutex
[2021-07-06 07:51:50.627 584M] Starting config file parsing (/etc/pihole/pihole-FTL.conf)
[2021-07-06 07:51:50.627 584M] SOCKET_LISTENING: only local
[2021-07-06 07:51:50.628 584M] AAAA_QUERY_ANALYSIS: Show AAAA queries
[2021-07-06 07:51:50.628 584M] MAXDBDAYS: max age for stored queries is 365 days
[2021-07-06 07:51:50.628 584M] RESOLVE_IPV6: Resolve IPv6 addresses
[2021-07-06 07:51:50.628 584M] RESOLVE_IPV4: Resolve IPv4 addresses
[2021-07-06 07:51:50.628 584M] DBINTERVAL: saving to DB file every minute
[2021-07-06 07:51:50.628 584M] DBFILE: Using /etc/pihole/pihole-FTL.db
[2021-07-06 07:51:50.628 584M] MAXLOGAGE: Importing up to 24.0 hours of log data
[2021-07-06 07:51:50.628 584M] PRIVACYLEVEL: Set to 0
[2021-07-06 07:51:50.628 584M] IGNORE_LOCALHOST: Show queries from localhost
[2021-07-06 07:51:50.628 584M] BLOCKINGMODE: Null IPs for blocked domains
[2021-07-06 07:51:50.628 584M] ANALYZE_ONLY_A_AND_AAAA: Disabled. Analyzing all queries
[2021-07-06 07:51:50.628 584M] DBIMPORT: Importing history from database
[2021-07-06 07:51:50.628 584M] PIDFILE: Using /run/pihole-FTL.pid
[2021-07-06 07:51:50.629 584M] PORTFILE: Using /run/pihole-FTL.port
[2021-07-06 07:51:50.629 584M] SOCKETFILE: Using /run/pihole/FTL.sock
[2021-07-06 07:51:50.629 584M] SETUPVARSFILE: Using /etc/pihole/setupVars.conf
[2021-07-06 07:51:50.629 584M] MACVENDORDB: Using /etc/pihole/macvendor.db
[2021-07-06 07:51:50.629 584M] GRAVITYDB: Using /etc/pihole/gravity.db
[2021-07-06 07:51:50.629 584M] PARSE_ARP_CACHE: Active
[2021-07-06 07:51:50.629 584M] CNAME_DEEP_INSPECT: Active
[2021-07-06 07:51:50.629 584M] DELAY_STARTUP: No delay requested.
[2021-07-06 07:51:50.629 584M] BLOCK_ESNI: Enabled, blocking _esni.{blocked domain}
[2021-07-06 07:51:50.629 584M] NICE: Cannot change niceness to -10 (permission denied)
[2021-07-06 07:51:50.630 584M] MAXNETAGE: Removing IP addresses and host names from network table after 365 days
[2021-07-06 07:51:50.630 584M] NAMES_FROM_NETDB: Enabled, trying to get names from network database
[2021-07-06 07:51:50.630 584M] EDNS0_ECS: Overwrite client from ECS information
[2021-07-06 07:51:50.630 584M] REFRESH_HOSTNAMES: Periodically refreshing IPv4 names
[2021-07-06 07:51:50.630 584M] RATE_LIMIT: Rate-limiting client making more than 1000 queries in 60 seconds
[2021-07-06 07:51:50.630 584M] REPLY_ADDR4: Automatic interface-dependent detection of address
[2021-07-06 07:51:50.630 584M] REPLY_ADDR6: Automatic interface-dependent detection of address
[2021-07-06 07:51:50.630 584M] SHOW_DNSSEC: Enabled, showing automatically generated DNSSEC queries
[2021-07-06 07:51:50.630 584M] MOZILLA_CANARY: Enabled
[2021-07-06 07:51:50.630 584M] Finished config file parsing
[2021-07-06 07:51:50.630 584M] WARNING: Starting pihole-FTL as user root is not recommended
[2021-07-06 07:51:50.631 584M] Database version is 9
[2021-07-06 07:51:50.631 584M] Resizing "FTL-strings" from 40960 to (81920 * 1) == 81920 (/dev/shm: 688.1KB used, 67.1MB total, FTL uses 676.2KB)
[2021-07-06 07:51:50.631 584M] Imported 0 alias-clients
[2021-07-06 07:51:50.632 584M] Database successfully initialized
[2021-07-06 07:51:50.632 584M] New upstream server: 8.8.4.4:53 (0/32)
[2021-07-06 07:51:50.637 584M] New upstream server: 192.168.0.1:53 (1/32)
[2021-07-06 07:51:50.683 584M] New upstream server: 8.8.8.8:53 (2/32)
[2021-07-06 07:51:50.721 584M] Resizing "FTL-domains" from 12288 to (1024 * 24) == 24576 (/dev/shm: 729.1KB used, 67.1MB total, FTL uses 717.1KB)
[2021-07-06 07:51:50.850 584M] Resizing "FTL-queries" from 229376 to (8192 * 56) == 458752 (/dev/shm: 741.4KB used, 67.1MB total, FTL uses 729.4KB)
[2021-07-06 07:51:51.053 584M] Resizing "FTL-queries" from 458752 to (12288 * 56) == 688128 (/dev/shm: 970.8KB used, 67.1MB total, FTL uses 958.8KB)
[2021-07-06 07:51:51.319 584M] Resizing "FTL-queries" from 688128 to (16384 * 56) == 917504 (/dev/shm: 1.2MB used, 67.1MB total, FTL uses 1.2MB)
[2021-07-06 07:51:51.416 584M] Resizing "FTL-domains" from 24576 to (1536 * 24) == 36864 (/dev/shm: 1.4MB used, 67.1MB total, FTL uses 1.4MB)
[2021-07-06 07:51:51.531 584M] Resizing "FTL-queries" from 917504 to (20480 * 56) == 1146880 (/dev/shm: 1.4MB used, 67.1MB total, FTL uses 1.4MB)
[2021-07-06 07:51:51.824 584M] Resizing "FTL-queries" from 1146880 to (24576 * 56) == 1376256 (/dev/shm: 1.7MB used, 67.1MB total, FTL uses 1.7MB)
[2021-07-06 07:51:52.112 584M] Resizing "FTL-queries" from 1376256 to (28672 * 56) == 1605632 (/dev/shm: 1.9MB used, 67.1MB total, FTL uses 1.9MB)
[2021-07-06 07:51:52.513 584M] Resizing "FTL-queries" from 1605632 to (32768 * 56) == 1835008 (/dev/shm: 2.1MB used, 67.1MB total, FTL uses 2.1MB)
[2021-07-06 07:51:52.591 584M] Resizing "FTL-domains" from 36864 to (2048 * 24) == 49152 (/dev/shm: 2.4MB used, 67.1MB total, FTL uses 2.3MB)
[2021-07-06 07:51:52.817 584M] Resizing "FTL-queries" from 1835008 to (36864 * 56) == 2064384 (/dev/shm: 2.4MB used, 67.1MB total, FTL uses 2.4MB)
[2021-07-06 07:51:52.920 584M] Resizing "FTL-strings" from 81920 to (122880 * 1) == 122880 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 07:51:53.149 584M] Resizing "FTL-queries" from 2064384 to (40960 * 56) == 2293760 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 07:51:53.349 584M] Resizing "FTL-queries" from 2293760 to (45056 * 56) == 2523136 (/dev/shm: 2.9MB used, 67.1MB total, FTL uses 2.9MB)
[2021-07-06 07:51:53.508 584M] Resizing "FTL-queries" from 2523136 to (49152 * 56) == 2752512 (/dev/shm: 3.1MB used, 67.1MB total, FTL uses 3.1MB)
[2021-07-06 07:51:53.715 584M] Imported 46763 queries from the long-term database
[2021-07-06 07:51:53.716 584M] -> Total DNS queries: 46763
[2021-07-06 07:51:53.716 584M] -> Cached DNS queries: 10039
[2021-07-06 07:51:53.716 584M] -> Forwarded DNS queries: 28265
[2021-07-06 07:51:53.716 584M] -> Blocked DNS queries: 7943
[2021-07-06 07:51:53.716 584M] -> Unknown DNS queries: 0
[2021-07-06 07:51:53.716 584M] -> Unique domains: 2010
[2021-07-06 07:51:53.716 584M] -> Unique clients: 23
[2021-07-06 07:51:53.716 584M] -> Known forward destinations: 3
[2021-07-06 07:51:53.716 584M] Successfully accessed setupVars.conf
[2021-07-06 07:51:53.716 584M] *************************************************************************
[2021-07-06 07:51:53.716 584M] * WARNING: Required Linux capability CAP_NET_ADMIN not available *
[2021-07-06 07:51:53.716 584M] *************************************************************************
[2021-07-06 07:51:53.717 584M] *************************************************************************
[2021-07-06 07:51:53.717 584M] * WARNING: Required Linux capability CAP_SYS_NICE not available *
[2021-07-06 07:51:53.717 584M] *************************************************************************
[2021-07-06 07:51:53.719 584M] listening on 0.0.0.0 port 53
[2021-07-06 07:51:53.719 584M] listening on :: port 53
[2021-07-06 07:51:53.721 584M] PID of FTL process: 584
[2021-07-06 07:51:53.723 584M] INFO: FTL is running as root
[2021-07-06 07:51:53.722 584/T585] Listening on port 4711 for incoming IPv4 telnet connections
[2021-07-06 07:51:53.723 584/T587] Listening on Unix socket
[2021-07-06 07:51:53.725 584M] Reloading DNS cache
[2021-07-06 07:51:53.725 584M] Blocking status is enabled
[2021-07-06 07:51:54.865 584/T588] Compiled 0 whitelist and 0 blacklist regex filters for 23 clients in 0.3 msec
And then switching back to `:v5.8.1`
[2021-07-06 07:55:21.209 544M] ########## FTL started! ##########
[2021-07-06 07:55:21.209 544M] FTL branch: master
[2021-07-06 07:55:21.210 544M] FTL version: v5.8.1
[2021-07-06 07:55:21.210 544M] FTL commit: b90ab8b1
[2021-07-06 07:55:21.210 544M] FTL date: 2021-04-21 20:03:47 +0100
[2021-07-06 07:55:21.210 544M] FTL user: root
[2021-07-06 07:55:21.210 544M] Compiled for x86_64 (compiled on CI) using gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516
[2021-07-06 07:55:21.210 544M] Creating mutex
[2021-07-06 07:55:21.211 544M] Starting config file parsing (/etc/pihole/pihole-FTL.conf)
[2021-07-06 07:55:21.211 544M] SOCKET_LISTENING: only local
[2021-07-06 07:55:21.211 544M] AAAA_QUERY_ANALYSIS: Show AAAA queries
[2021-07-06 07:55:21.211 544M] MAXDBDAYS: max age for stored queries is 365 days
[2021-07-06 07:55:21.211 544M] RESOLVE_IPV6: Resolve IPv6 addresses
[2021-07-06 07:55:21.211 544M] RESOLVE_IPV4: Resolve IPv4 addresses
[2021-07-06 07:55:21.211 544M] DBINTERVAL: saving to DB file every minute
[2021-07-06 07:55:21.211 544M] DBFILE: Using /etc/pihole/pihole-FTL.db
[2021-07-06 07:55:21.211 544M] MAXLOGAGE: Importing up to 24.0 hours of log data
[2021-07-06 07:55:21.211 544M] PRIVACYLEVEL: Set to 0
[2021-07-06 07:55:21.212 544M] IGNORE_LOCALHOST: Show queries from localhost
[2021-07-06 07:55:21.212 544M] BLOCKINGMODE: Null IPs for blocked domains
[2021-07-06 07:55:21.212 544M] ANALYZE_ONLY_A_AND_AAAA: Disabled. Analyzing all queries
[2021-07-06 07:55:21.212 544M] DBIMPORT: Importing history from database
[2021-07-06 07:55:21.212 544M] PIDFILE: Using /run/pihole-FTL.pid
[2021-07-06 07:55:21.212 544M] PORTFILE: Using /run/pihole-FTL.port
[2021-07-06 07:55:21.212 544M] SOCKETFILE: Using /run/pihole/FTL.sock
[2021-07-06 07:55:21.212 544M] SETUPVARSFILE: Using /etc/pihole/setupVars.conf
[2021-07-06 07:55:21.212 544M] MACVENDORDB: Using /etc/pihole/macvendor.db
[2021-07-06 07:55:21.212 544M] GRAVITYDB: Using /etc/pihole/gravity.db
[2021-07-06 07:55:21.212 544M] PARSE_ARP_CACHE: Active
[2021-07-06 07:55:21.213 544M] CNAME_DEEP_INSPECT: Active
[2021-07-06 07:55:21.213 544M] DELAY_STARTUP: No delay requested.
[2021-07-06 07:55:21.213 544M] BLOCK_ESNI: Enabled, blocking _esni.{blocked domain}
[2021-07-06 07:55:21.213 544M] NICE: Cannot change niceness to -10 (permission denied)
[2021-07-06 07:55:21.213 544M] MAXNETAGE: Removing IP addresses and host names from network table after 365 days
[2021-07-06 07:55:21.213 544M] NAMES_FROM_NETDB: Enabled, trying to get names from network database
[2021-07-06 07:55:21.213 544M] EDNS0_ECS: Overwrite client from ECS information
[2021-07-06 07:55:21.213 544M] REFRESH_HOSTNAMES: Periodically refreshing IPv4 names
[2021-07-06 07:55:21.213 544M] RATE_LIMIT: Rate-limiting client making more than 1000 queries in 60 seconds
[2021-07-06 07:55:21.213 544M] REPLY_ADDR4: Automatic interface-dependent detection of address
[2021-07-06 07:55:21.213 544M] REPLY_ADDR6: Automatic interface-dependent detection of address
[2021-07-06 07:55:21.213 544M] Finished config file parsing
[2021-07-06 07:55:21.213 544M] WARNING: Starting pihole-FTL as user root is not recommended
[2021-07-06 07:55:21.214 544M] Database version is 9
[2021-07-06 07:55:21.214 544M] Imported 0 alias-clients
[2021-07-06 07:55:21.215 544M] Database successfully initialized
[2021-07-06 07:55:21.215 544M] Resizing "FTL-strings" from 40960 to (81920 * 1) == 81920 (/dev/shm: 720.9KB used, 67.1MB total, FTL uses 708.9KB)
[2021-07-06 07:55:21.215 544M] New upstream server: 8.8.4.4:53 (0/512)
[2021-07-06 07:55:21.218 544M] New upstream server: 192.168.0.1:53 (1/512)
[2021-07-06 07:55:21.225 544M] New upstream server: 8.8.8.8:53 (2/512)
[2021-07-06 07:55:21.229 544M] Resizing "FTL-domains" from 12288 to (1024 * 24) == 24576 (/dev/shm: 761.9KB used, 67.1MB total, FTL uses 749.9KB)
[2021-07-06 07:55:21.241 544M] Resizing "FTL-queries" from 262144 to (8192 * 64) == 524288 (/dev/shm: 774.1KB used, 67.1MB total, FTL uses 762.1KB)
[2021-07-06 07:55:21.260 544M] Resizing "FTL-queries" from 524288 to (12288 * 64) == 786432 (/dev/shm: 1.0MB used, 67.1MB total, FTL uses 1.0MB)
[2021-07-06 07:55:21.283 544M] Resizing "FTL-queries" from 786432 to (16384 * 64) == 1048576 (/dev/shm: 1.3MB used, 67.1MB total, FTL uses 1.3MB)
[2021-07-06 07:55:21.292 544M] Resizing "FTL-domains" from 24576 to (1536 * 24) == 36864 (/dev/shm: 1.6MB used, 67.1MB total, FTL uses 1.5MB)
[2021-07-06 07:55:21.303 544M] Resizing "FTL-queries" from 1048576 to (20480 * 64) == 1310720 (/dev/shm: 1.6MB used, 67.1MB total, FTL uses 1.6MB)
[2021-07-06 07:55:21.327 544M] Resizing "FTL-queries" from 1310720 to (24576 * 64) == 1572864 (/dev/shm: 1.8MB used, 67.1MB total, FTL uses 1.8MB)
[2021-07-06 07:55:21.351 544M] Resizing "FTL-queries" from 1572864 to (28672 * 64) == 1835008 (/dev/shm: 2.1MB used, 67.1MB total, FTL uses 2.1MB)
[2021-07-06 07:55:21.381 544M] Resizing "FTL-queries" from 1835008 to (32768 * 64) == 2097152 (/dev/shm: 2.4MB used, 67.1MB total, FTL uses 2.3MB)
[2021-07-06 07:55:21.388 544M] Resizing "FTL-domains" from 36864 to (2048 * 24) == 49152 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 07:55:21.406 544M] Resizing "FTL-queries" from 2097152 to (36864 * 64) == 2359296 (/dev/shm: 2.6MB used, 67.1MB total, FTL uses 2.6MB)
[2021-07-06 07:55:21.414 544M] Resizing "FTL-strings" from 81920 to (122880 * 1) == 122880 (/dev/shm: 2.9MB used, 67.1MB total, FTL uses 2.9MB)
[2021-07-06 07:55:21.432 544M] Resizing "FTL-queries" from 2359296 to (40960 * 64) == 2621440 (/dev/shm: 2.9MB used, 67.1MB total, FTL uses 2.9MB)
[2021-07-06 07:55:21.450 544M] Resizing "FTL-queries" from 2621440 to (45056 * 64) == 2883584 (/dev/shm: 3.2MB used, 67.1MB total, FTL uses 3.2MB)
[2021-07-06 07:55:21.467 544M] Resizing "FTL-queries" from 2883584 to (49152 * 64) == 3145728 (/dev/shm: 3.5MB used, 67.1MB total, FTL uses 3.4MB)
[2021-07-06 07:55:21.482 544M] Imported 46807 queries from the long-term database
[2021-07-06 07:55:21.483 544M] -> Total DNS queries: 46807
[2021-07-06 07:55:21.483 544M] -> Cached DNS queries: 10040
[2021-07-06 07:55:21.483 544M] -> Forwarded DNS queries: 28316
[2021-07-06 07:55:21.483 544M] -> Blocked DNS queries: 7935
[2021-07-06 07:55:21.484 544M] -> Unknown DNS queries: 0
[2021-07-06 07:55:21.484 544M] -> Unique domains: 2010
[2021-07-06 07:55:21.484 544M] -> Unique clients: 23
[2021-07-06 07:55:21.484 544M] -> Known forward destinations: 3
[2021-07-06 07:55:21.484 544M] Successfully accessed setupVars.conf
[2021-07-06 07:55:21.484 544M] *************************************************************************
[2021-07-06 07:55:21.484 544M] * WARNING: Required Linux capability CAP_NET_ADMIN not available *
[2021-07-06 07:55:21.484 544M] *************************************************************************
[2021-07-06 07:55:21.485 544M] *************************************************************************
[2021-07-06 07:55:21.485 544M] * WARNING: Required Linux capability CAP_SYS_NICE not available *
[2021-07-06 07:55:21.485 544M] *************************************************************************
[2021-07-06 07:55:21.487 544M] PID of FTL process: 544
[2021-07-06 07:55:21.487 544/T545] Listening on port 4711 for incoming IPv4 telnet connections
[2021-07-06 07:55:21.487 544M] INFO: FTL is running as root
[2021-07-06 07:55:21.488 544/T547] Listening on Unix socket
[2021-07-06 07:55:21.488 544M] Reloading DNS cache
[2021-07-06 07:55:21.489 544M] Blocking status is enabled
[2021-07-06 07:55:22.636 544/T548] Compiled 0 whitelist and 0 blacklist regex filters for 23 clients in 0.2 msec
I do note a fairly significant time difference in the Resizing...
parts (same db). Any thoughts?
(edit: Note to add I will add those capabilities, but don't think they're the cause as the difference is quite clear between the two)
Double Edit:
I think on beta it is 10x slower? 3 whole seconds vs ~300 milliseconds on 5.8.1