1

tuning mysql and apache news server [on hold]

view story
linux-howto

http://serverfault.com – I have news Hybrid server , I need to tuning mysql server . RAM : 7G CPU : 5 Core DEBIAN squeeze 6.0.7 MySQL 5.1.66 APACHE 2.2.16 apache.conf Timeout 300 KeepAlive off KeepAlive off KeepAliveTimeout 0 prefork MPM <IfModule mpm_prefork_module> StartServers 5 MinSpareServers 5 MaxSpareServers 10 ServerLimit 512 MaxClients 512 MaxRequestsPerChild 0 </IfModule> mysql config [mysqld] max_connections=400 max_user_connections=140 key_buffer=1024M join_buffer_size=1M read_buffer_size=8M sort_buffer_size=8M innodb_buffer_pool_size= (HowTos)