apache mpm event + mysql 再次效能調校筆記

8 core CPU + 16 GB RAM

不知道主機到底在慢幾點的

隨便亂調一通之後

速度快多了

• /etc/mysql/my.cnf

[mysqld]
query_cache_type = 1
query_cache_size = 1G
#query_cache_size = 0
query_cache_limit = 8M

innodb_buffer_pool_size = 9G
key_buffer_size = 3G

max_connections = 500

innodb_buffer_pool_instances = 8

• /etc/apache2/mods-available/mpm_event.conf

<IfModule mpm_event_module>
#       StartServers                     2
#       MinSpareThreads          25
#       MaxSpareThreads          75
#       ThreadLimit                      64
#       ThreadsPerChild          25
#       MaxRequestWorkers         150

#        StartServers                     4
#        MinSpareThreads          50
#        MaxSpareThreads          150
#        ThreadLimit                      128
#        ThreadsPerChild          50
#        MaxRequestWorkers         300

#        MaxConnectionsPerChild   0

ServerLimit              250
StartServers              10
MinSpareThreads     75
MaxSpareThreads      250
ThreadLimit               64
ThreadsPerChild         32
MaxRequestWorkers   4000
MaxConnectionsPerChild 5000

</IfModule>