Tune MySQL Performance on NetBSD 10

my.cnf

[mysqld]
innodb_buffer_pool_size        = 4G
innodb_buffer_pool_instances   = 4
innodb_log_file_size           = 512M
innodb_flush_log_at_trx_commit = 1
innodb_flush_method            = O_DIRECT
max_connections                = 200
thread_cache_size...

Tune MySQL Performance on OpenBSD 7.5

my.cnf

[mysqld]
innodb_buffer_pool_size        = 4G
innodb_buffer_pool_instances   = 4
innodb_log_file_size           = 512M
innodb_flush_log_at_trx_commit = 1
innodb_flush_method            = O_DIRECT
max_connections                = 200
thread_cache_size...

Tune MySQL Performance on RHEL 9

my.cnf

[mysqld]
innodb_buffer_pool_size        = 4G
innodb_buffer_pool_instances   = 4
innodb_log_file_size           = 512M
innodb_flush_log_at_trx_commit = 1
innodb_flush_method            = O_DIRECT
max_connections                = 200
thread_cache_size...

Tune MySQL Performance on Ubuntu 24.04

my.cnf

[mysqld]
innodb_buffer_pool_size        = 4G
innodb_buffer_pool_instances   = 4
innodb_log_file_size           = 512M
innodb_flush_log_at_trx_commit = 1
innodb_flush_method            = O_DIRECT
max_connections                = 200
thread_cache_size...

Tune PHP OPcache on AlmaLinux 9

Edit /etc/php.d/10-opcache.ini

opcache.enable=1
opcache.enable_cli=0
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=20000
opcache.revalidate_freq=60
opcache.validate_timestamps=1
; JIT (PHP 8.x)
opcache.jit=tracing...

Tune PHP OPcache on Arch Linux

Edit /etc/php/conf.d/opcache.ini

opcache.enable=1
opcache.enable_cli=0
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=20000
opcache.revalidate_freq=60
opcache.validate_timestamps=1
; JIT (PHP 8.x)
opcache.jit=tracin...

Tune PHP OPcache on Debian 12

Edit /etc/php/8.2/fpm/conf.d/10-opcache.ini

opcache.enable=1
opcache.enable_cli=0
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=20000
opcache.revalidate_freq=60
opcache.validate_timestamps=1
; JIT (PHP 8.x)
opcache....

Tune PHP OPcache on Gentoo Linux

Edit /etc/php/fpm-php8.2/ext-active/opcache.ini

opcache.enable=1
opcache.enable_cli=0
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=20000
opcache.revalidate_freq=60
opcache.validate_timestamps=1
; JIT (PHP 8.x)
o...

Tune PHP OPcache on NetBSD 10

Edit /etc/php.d/opcache.ini

opcache.enable=1
opcache.enable_cli=0
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=20000
opcache.revalidate_freq=60
opcache.validate_timestamps=1
; JIT (PHP 8.x)
opcache.jit=tracing
opca...

Tune PHP OPcache on OpenBSD 7.5

Edit /etc/php.d/opcache.ini

opcache.enable=1
opcache.enable_cli=0
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=20000
opcache.revalidate_freq=60
opcache.validate_timestamps=1
; JIT (PHP 8.x)
opcache.jit=tracing
op...

Tune PHP OPcache on RHEL 9

Edit /etc/php.d/10-opcache.ini

opcache.enable=1
opcache.enable_cli=0
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=20000
opcache.revalidate_freq=60
opcache.validate_timestamps=1
; JIT (PHP 8.x)
opcache.jit=tracing
opca...

Tune PHP OPcache on Ubuntu 24.04

Edit /etc/php/8.3/fpm/conf.d/10-opcache.ini

opcache.enable=1
opcache.enable_cli=0
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=20000
opcache.revalidate_freq=60
opcache.validate_timestamps=1
; JIT (PHP 8.x)
opcac...

Tune PHP-FPM Performance on AlmaLinux 9

Estimate pm.max_children

ps -ylC php-fpm --no-headers | awk '{sum+=$8} END {print sum/NR/1024 " MB avg"}'
# Divide available RAM (minus OS+DB) by average size

Recommended dynamic settings

pm = dynamic
pm.max_children      = 50
pm.start_servers     = 1...

Tune PHP-FPM Performance on Arch Linux

Estimate pm.max_children

ps -ylC php-fpm --no-headers | awk '{sum+=$8} END {print sum/NR/1024 " MB avg"}'
# Divide available RAM (minus OS+DB) by average size

Recommended dynamic settings

pm = dynamic
pm.max_children      = 50
pm.start_servers     = 10...

Tune PHP-FPM Performance on Debian 12

Estimate pm.max_children

ps -ylC php-fpm --no-headers | awk '{sum+=$8} END {print sum/NR/1024 " MB avg"}'
# Divide available RAM (minus OS+DB) by average size

Recommended dynamic settings

pm = dynamic
pm.max_children      = 50
pm.start_servers     = 10...

Tune PHP-FPM Performance on Gentoo Linux

Estimate pm.max_children

ps -ylC php-fpm --no-headers | awk '{sum+=$8} END {print sum/NR/1024 " MB avg"}'
# Divide available RAM (minus OS+DB) by average size

Recommended dynamic settings

pm = dynamic
pm.max_children      = 50
pm.start_servers     =...

Tune PHP-FPM Performance on NetBSD 10

Estimate pm.max_children

ps -ylC php-fpm --no-headers | awk '{sum+=$8} END {print sum/NR/1024 " MB avg"}'
# Divide available RAM (minus OS+DB) by average size

Recommended dynamic settings

pm = dynamic
pm.max_children      = 50
pm.start_servers     = 10...

Tune PHP-FPM Performance on OpenBSD 7.5

Estimate pm.max_children

ps -ylC php-fpm --no-headers | awk '{sum+=$8} END {print sum/NR/1024 " MB avg"}'
# Divide available RAM (minus OS+DB) by average size

Recommended dynamic settings

pm = dynamic
pm.max_children      = 50
pm.start_servers     = 1...

Tune PHP-FPM Performance on RHEL 9

Estimate pm.max_children

ps -ylC php-fpm --no-headers | awk '{sum+=$8} END {print sum/NR/1024 " MB avg"}'
# Divide available RAM (minus OS+DB) by average size

Recommended dynamic settings

pm = dynamic
pm.max_children      = 50
pm.start_servers     = 10
pm....

Tune PHP-FPM Performance on Ubuntu 24.04

Estimate pm.max_children

ps -ylC php-fpm --no-headers | awk '{sum+=$8} END {print sum/NR/1024 " MB avg"}'
# Divide available RAM (minus OS+DB) by average size

Recommended dynamic settings

pm = dynamic
pm.max_children      = 50
pm.start_servers     =...

Tune PostgreSQL Performance on AlmaLinux 9

postgresql.conf

# Memory
shared_buffers          = 2GB       # 25% of RAM
effective_cache_size    = 6GB       # 50-75% of RAM
work_mem                = 64MB      # per-sort/hash
maintenance_work_mem    = 512MB

# Checkpoints
checkpoint_completion_target...

Tune PostgreSQL Performance on Arch Linux

postgresql.conf

# Memory
shared_buffers          = 2GB       # 25% of RAM
effective_cache_size    = 6GB       # 50-75% of RAM
work_mem                = 64MB      # per-sort/hash
maintenance_work_mem    = 512MB

# Checkpoints
checkpoint_completion_target...

Tune PostgreSQL Performance on Debian 12

postgresql.conf

# Memory
shared_buffers          = 2GB       # 25% of RAM
effective_cache_size    = 6GB       # 50-75% of RAM
work_mem                = 64MB      # per-sort/hash
maintenance_work_mem    = 512MB

# Checkpoints
checkpoint_completion_target =...

Tune PostgreSQL Performance on Gentoo Linux

postgresql.conf

# Memory
shared_buffers          = 2GB       # 25% of RAM
effective_cache_size    = 6GB       # 50-75% of RAM
work_mem                = 64MB      # per-sort/hash
maintenance_work_mem    = 512MB

# Checkpoints
checkpoint_completion_targe...