Milter Multithread

[nicola.piazzi]

In some hours of the day my efa take long time to deliver because to much emails incoming accumulate on Milter Inbound

Screenshot 2024-04-11 173859.png (3.62 KiB) Viewed 17200 times

I found that mysqld daemon is at 100% of a single cpu also i have 16 cpu on box
I think that this is milter problem that cant split on more queues, is possible to have more milter ?

Screenshot 2024-04-11 174007.png (20.79 KiB) Viewed 17200 times

[henk]

Hi Nicolca,

can you show your Mysql config

Code: Select all

/etc/my.cnf.d/mariadb-server.cnf

My config

Code: Select all

# This group is only read by MariaDB-10.1 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
#[mariadb-10.1]
[mariadb-10.4]
bind-address = 127.0.0.1
innodb-defragment = 1
innodb_buffer_pool_instances = 1
innodb_buffer_pool_size = 1G
innodb_file_per_table = 1
innodb_log_buffer_size = 32M
innodb_log_file_size = 125M
join_buffer_size = 512K
key_cache_segments = 4
max_allowed_packet = 16M
max_heap_table_size = 32M
query_cache_size = 0M
query_cache_type = OFF
read_buffer_size = 2M
read_rnd_buffer_size = 1M
skip-external-locking
skip-host-cache
sort_buffer_size = 4M
thread_cache_size = 16
tmp_table_size = 32M
skip-name-resolve

and Mysqltuner ouput?

Sice there's swapfile use, check

Code: Select all

cat /etc/sysctl.d/vm.swappiness.conf

Source and howto: https://mariadb.com/kb/en/configuring-swappiness/

(Assuming your Unbound recursive DNS service is checked and ok and you checked the logfiles)

Little DNS check script to check basics

viewtopic.php?t=3032

[shawniverson]

I agree with henk this isn't a milter problem. The Milter Inbound count are emails that are in the queue after being processed by the milter, so the bottleneck is elsewhere.

Are you on the latest release of eFa 4? There are some performance fixes that will directly impact mariadb utilization as well.