Database Query Optimization

Database Query Optimization

Optimize database connections for both security and performance:

# Apache - PHP database connection pooling
<IfModule mod_php7.c>
    php_value mysqli.allow_persistent On
    php_value mysqli.max_persistent 20
    php_value mysqli.max_links 20
    php_value mysqli.connect_timeout 10
    
    # Security settings
    php_admin_value open_basedir /var/www/html:/tmp
    php_admin_value disable_functions "exec,passthru,shell_exec,system"
    php_admin_flag display_errors Off
    php_admin_value error_log /var/log/php/errors.log
</IfModule>

# Nginx - FastCGI optimization
location ~ \.php$ {
    fastcgi_pass unix:/var/run/php/php-fpm.sock;
    fastcgi_index index.php;
    
    # Connection pooling
    fastcgi_keep_conn on;
    fastcgi_connect_timeout 60s;
    fastcgi_send_timeout 180s;
    fastcgi_read_timeout 180s;
    
    # Buffer optimization
    fastcgi_buffer_size 128k;
    fastcgi_buffers 256 16k;
    fastcgi_busy_buffers_size 256k;
    fastcgi_temp_file_write_size 256k;
    
    # Security
    fastcgi_param PHP_VALUE "open_basedir=/var/www/html:/tmp";
    fastcgi_param PHP_ADMIN_VALUE "disable_functions=exec,passthru,shell_exec,system";
}