Java開發人員常用的服務配置（Nginx、Tomcat、JVM、Mysql、Redis）

Nginx

Nginx是一款由C語言編寫的高效能、輕量級的HTTP和反向代理伺服器，同時也是一款IMAP/POP3/SMTP伺服器。

1. nginx.conf：Nginx核心配置檔案，linux下預設安裝在/etc/nginx/

# Nginx所用使用者和組，window下不指定  
user  www-data;  
# 工作的子程式數量（通常等於CPU數量或者2倍於CPU）  
worker_processes  auto;  
# pid存放檔案  
pid  /run/nginx.pid; 

# 簡化除錯 此指令不得用於生產環境 
#master_process  off;
# 簡化除錯 此指令可以用到生產環境
#daemon off;
  
# 最大檔案描述符
worker_rlimit_nofile 51200;

events {  
    # 使用網路IO模型linux建議epoll，FreeBSD建議採用kqueue，window下不指定。  
    #use epoll;  
      
    # 允許最大連線數  
    worker_connections 1024;  
    
    # 此指令的作用是立即接受所有連線放到監聽佇列中，使得Nginx Worker能夠在獲得新連線通知時儘可能多的接受連線
    #multi_accept on;
} 

# load modules compiled as Dynamic Shared Object (DSO)
#
#dso {
#    load ngx_http_fastcgi_module.so;
#    load ngx_http_rewrite_module.so;
#}
  
http {  

    # 反向代理相關配置（自行新建），參考下面的proxy.conf
    #include  /etc/nginx/conf.d/proxy.conf;;
    # GZIP壓縮相關配置（自行新建），參考下面的gzip.conf
    #include  /etc/nginx/conf.d//gzip.conf;

    ##
    # Basic Settings
    ##
    
    sendfile on;
    # 在一個資料包裡傳送所有標頭檔案，而不是一個接一個的傳送
    tcp_nopush on;
    # 不快取資料，而是一段一段的傳送
    tcp_nodelay on;
    # 設定客戶端keep-alive超時時間
    keepalive_timeout 65;
    types_hash_max_size 2048;
      
    client_header_timeout  10;  
    client_body_timeout  10;  
    send_timeout  10;  
   
    client_header_buffer_size    1k;  
    large_client_header_buffers  4  4k; 
    
    # 允許客戶端請求的最大單檔案位元組數
    client_max_body_size 10m; 

    client_body_in_single_buffer on;
    # 緩衝區代理緩衝使用者端請求的最大位元組數
    client_body_buffer_size 128k;
    
    # 關閉Nginx的版本號和系統發行版本顯示，預設是on
    # server_tokens off;

    # server_names_hash_bucket_size 64;
    # server_name_in_redirect off;

    # 設定檔案使用的預設的MIME-type
    include  /etc/nginx/mime.types;
    default_type  application/octet-stream;  
    
    ##
    # SSL Settings
    ##

    ssl_protocols TLSv1 TLSv1.1 TLSv1.2; # Dropping SSLv3, ref: POODLE
    ssl_prefer_server_ciphers on;

    ##
    # Logging Settings
    ##
    
    # 自定義access_log日誌格式和級別  
    #log_format  main  `$remote_addr - $remote_user [$time_local] $request "$status" $body_bytes_sent "$http_referer" "$http_user_agent" "$http_x_forwarded_for"`; 

    # 關閉日誌可配置off
    # 訪問和錯誤日誌存放路徑，常見日誌級別有[ debug | info | notice | warn | error | crit | alert | emerg ]，級別越高記錄的資訊越少。 
    access_log /var/log/nginx/access.log main;
    error_log /var/log/nginx/error.log notice;
    
    # 負載均衡配置
    upstream upstream_test{  
    
        # 負載策略，常見有輪詢（預設）、指定權重(weight 預設為1.weight越大，負載的權重就越大)、IP繫結(ip_hash)、fair（第三方）、url_hash（第三方）
        #ip_hash;
    
        server 127.0.0.1:9090 down; (down 表示當前server暫時不參與負載) 
        server 127.0.0.1:8080 weight=10;
        server 127.0.0.1:8081 weight=5;
        server 127.0.0.1:7070 backup; (其它所有的非backup機器down掉或者忙碌時候，請求backup機器) 
      
        ## Tengine config
        #check interval=300 rise=10 fall=10 timeout=100 type=http port=80;
        #check_http_send "GET / HTTP/1.0

";
        #check_http_expect_alive http_2xx http_3xx;

        ## Tengine config
        #session_sticky cookie=cookieTest mode=insert;
    }  
  
    # server配置，同時支援監聽80和443埠
    server {  
        listen  80;
        # https配置
        listen 443 ssl http2; #default_server;
        listen [::]:443 ssl http2; #default_server;
        ssl_certificate "/etc/nginx/ssh_cert/1_domain.cn_bundle.crt";
        ssl_certificate_key "/etc/nginx/ssh_cert/2_domain.cn.key";
        ssl_session_cache shared:SSL:1m;
        ssl_session_timeout  10m;
        ssl_ciphers HIGH:!aNULL:!MD5;
        ssl_prefer_server_ciphers on;

        # 可使用萬用字元形式配置，如*.domain.com;
        server_name  domain.com  www.domain.com;;  
    
        # 如果訪問時沒有加www，則跳轉至www.domain.com
        if ($host !~* www.domain.com) { 
            rewrite ^(.*)$ http://www.domain.com/$1 permanent;
        }
  
        location / {
            # 指定目錄位置
             root /etc/nginx/; 
            # 開啟目錄瀏覽
            autoindex  on;
            # 預設為on，顯示出檔案的確切大小，單位是bytes。改為off後，顯示出檔案的大概大小，單位是kB或者MB或者GB
            autoindex_exact_size  off;
            # 預設為off，顯示的檔案時間為GMT時間。改為on後，顯示的檔案時間為檔案的伺服器時間
            autoindex_localtime on; 
            # 10m之後下載速度為10k
            #limit_rate_after 10m;
            #limit_rate 10k;
        } 
         
    # 根據User-Agent過濾網路爬蟲
    location /spider {
            if ($http_user_agent ~* "python|curl|java|wget|httpclient|okhttp") {
                return 503;
            }
    }

        location /proxy {
            proxy_pass http://upstream_test;  
            # 配置跨域訪問
            add_header `Access-Control-Allow-Headers` `Content-Type`;  
            add_header `Access-Control-Allow-Origin` `*`;  
            add_header `Access-Control-Allow-Methods` `GET`;
            add_header `Access-Control-Expose-Headers` `Access-Control-Allow-Origin,Access-Control-Allow-Credentials`;
        } 
      
        # static resources config
        location ~* ^/static/.*.(jpg|jpeg|gif|png|html|htm|swf|js|css)$ {
            root /etc/nginx/static/;
            access_log  off;
            expires  30d;
        }

        # 當頁面發生異常時，可以指定跳轉到location中，也可以跳轉到指定URL
        error_page 404 http://www.error404.com/;
        error_page 500 502 503 504  /50x.html;
        location = /50x.html {
            root  html;
        }
    }
 
}

1. gzip.conf

        ##
        # Gzip Settings
        ##

        gzip on;
        # IE6或更低版本禁用壓縮
        gzip_disable "msie6";
        # 對資料啟用壓縮的最少位元組數，建議最少大於1000位元組 
        gzip_min_length 1k;
        gzip_vary on;
        # 允許或者禁止壓縮基於請求和響應的響應流，設定為any意味著將會壓縮所有的請求
        gzip_proxied any;
        # 設定資料壓縮的等級，範圍是1-9之間的任意數值，9是最慢但壓縮比最大
        gzip_comp_level 6;
        gzip_buffers 16 8k;
        gzip_http_version 1.1;
        #指定壓縮的檔案型別 
        gzip_types application/font-woff text/plain application/javascript application/json text/css application/xml text/javascript image/jpg image/jpeg image/png image/gif image/x-icon;

1. proxy.conf

#後端的Web伺服器可以通過X-Forwarded-For獲取使用者真實IP
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

#nginx跟後端伺服器連線超時時間(代理連線超時)
proxy_connect_timeout  90;

#連線成功後，後端伺服器響應時間(代理接收超時)
proxy_read_timeout  90;

#nginx傳送資料到後端伺服器超時時間(代理髮送超時)
proxy_send_timeout  600; 

#設定代理伺服器（nginx）儲存使用者頭資訊的緩衝區大小
proxy_buffer_size 4k;

#proxy_buffers緩衝區，網頁平均在32k以下的話，這樣設定
proxy_buffers 4 32k;

#高負荷下緩衝大小（proxy_buffers*2）
proxy_busy_buffers_size 64k; 

#設定快取資料夾大小，大於這個值，將從upstream伺服器傳
proxy_temp_file_write_size 64k;

#為了支援新的upstream keepalive選項
proxy_http_version 1.1;
proxy_set_header Connection "";

Tomcat

Java EE開發中常用的一款Web應用伺服器，也是一個免費開源的Servlet容器，類似的還有Jetty、Undertow、Netty等。

server.xml

<Connector port="8080" protocol="org.apache.coyote.http11.Http11AprProtocol"
               connectionTimeout="5000"  
               maxThreads="500" 
               minSpareThreads="20"
               acceptCount="50"
               maxConnections="8192"
               redirectPort="8443" />

JVM

關於JVM引數配置和調優可以參考: 一隻懂JVM引數的狐狸

Redis

Redis是一款使用C語言編寫的高效能Key-Value開源資料庫，支援儲存的value型別包括有string(字串)、list(連結串列)、set(集合)、zset(sorted set , 有序集合)和hash（雜湊型別）。

redis.conf: redis核心配置檔案

# By default Redis does not run as a daemon. Use `yes` if you need it.
# Note that Redis will write a pid file in /var/run/redis.pid when daemonized.
# 設定此選項使得redis以守護程式方式執行
daemonize yes

# When running daemonized, Redis writes a pid file in /var/run/redis.pid by
# default. You can specify a custom pid file location here.
# 以守護程式執行時，pid的存放路徑
pidfile /var/run/redis.pid

# Accept connections on the specified port, default is 6379.
# If port 0 is specified Redis will not listen on a TCP socket.
# 埠
port 6379

# If you want you can bind a single interface, if the bind option is not
# specified all the interfaces will listen for incoming connections.
# 指定Redis可接收請求的IP地址,不設定將處理所有請求,建議生產環境中設定
# bind 127.0.0.1

# Close the connection after a client is idle for N seconds (0 to disable)
# 客戶端連線的超時時間,單位為秒,超時後會關閉連線
timeout 0

# Specify the log file name. Also `stdout` can be used to force
# Redis to log on the standard output. Note that if you use standard
# output for logging but daemonize, logs will be sent to /dev/null
# 配置 log 檔案地址,預設列印在命令列終端的視窗上
logfile stdout

# Set the number of databases. The default database is DB 0, you can select
# a different one on a per-connection basis using SELECT <dbid> where
# dbid is a number between 0 and `databases`-1
# 設定資料庫的個數,可以使用 SELECT <dbid>命令來切換資料庫。預設使用的資料庫是 0
databases 16

#
# Save the DB on disk:
#
# save <seconds> <changes>
#
# Will save the DB if both the given number of seconds and the given
# number of write operations against the DB occurred.
#
# In the example below the behaviour will be to save:
# after 900 sec (15 min) if at least 1 key changed
# after 300 sec (5 min) if at least 10 keys changed
# after 60 sec if at least 10000 keys changed
#
# Note: you can disable saving at all commenting all the "save" lines.
# RDB備份的頻率。
# 900秒之內有1個keys發生變化時
# 30秒之內有10個keys發生變化時
# 60秒之內有10000個keys發生變化時
save 900 1
save 300 10
save 60 10000

# Compress string objects using LZF when dump .rdb databases?
# For default that`s set to `yes` as it`s almost always a win.
# If you want to save some CPU in the saving child set it to `no` but
# the dataset will likely be bigger if you have compressible values or keys.
# 在進行映象備份時,是否進行壓縮
rdbcompression yes

# The filename where to dump the DB
# 映象備份檔案的檔名
dbfilename dump.rdb

# The working directory.
#
# The DB will be written inside this directory, with the filename specified
# above using the `dbfilename` configuration directive.
# 
# Also the Append Only File will be created inside this directory.
# 
# Note that you must specify a directory here, not a file name.
# 資料庫映象備份的檔案放置的路徑。這裡的路徑跟檔名要分開配置是因為 Redis 在進行備份時,先會將當前資料庫的狀態寫入到一個臨時檔案中,等備份完成時,再把該該臨時檔案替換為上面所指定的檔案,
# 而這裡的臨時檔案和上面所配置的備份檔案都會放在這個指定的路徑當中
dir ./

# Master-Slave replication. Use slaveof to make a Redis instance a copy of
# another Redis server. Note that the configuration is local to the slave
# so for example it is possible to configure the slave to save the DB with a
# different interval, or to listen to another port, and so on.
# 設定該資料庫為其他資料庫的從資料庫
# slaveof <masterip> <masterport>

# If the master is password protected (using the "requirepass" configuration
# directive below) it is possible to tell the slave to authenticate before
# starting the replication synchronization process, otherwise the master will
# refuse the slave request.
# 指定與主資料庫連線時需要的密碼驗證
# masterauth <master-password>

# Require clients to issue AUTH <PASSWORD> before processing any other
# commands. This might be useful in environments in which you do not trust
# others with access to the host running redis-server.
#
# This should stay commented out for backward compatibility and because most
# people do not need auth (e.g. they run their own servers).
# 
# Warning: since Redis is pretty fast an outside user can try up to
# 150k passwords per second against a good box. This means that you should
# use a very strong password otherwise it will be very easy to break.
# 設定客戶端連線後進行任何其他指定前需要使用的密碼。警告:redis速度相當快,一個外部的使用者可以在一秒鐘進行150K次的密碼嘗試,你需要指定非常非常強大的密碼來防止暴力破解。
requirepass foobared

# Set the max number of connected clients at the same time. By default there
# is no limit, and it`s up to the number of file descriptors the Redis process
# is able to open. The special value `0` means no limits.
# Once the limit is reached Redis will close all the new connections sending
# an error `max number of clients reached`.
# 限制同時連線的客戶數量。當連線數超過這個值時,redis 將不再接收其他連線請求,客戶端嘗試連線時將收到 error 資訊
# maxclients 128

# Don`t use more memory than the specified amount of bytes.
# When the memory limit is reached Redis will try to remove keys
# accordingly to the eviction policy selected (see maxmemmory-policy).
#
# If Redis can`t remove keys according to the policy, or if the policy is
# set to `noeviction`, Redis will start to reply with errors to commands
# that would use more memory, like SET, LPUSH, and so on, and will continue
# to reply to read-only commands like GET.
#
# This option is usually useful when using Redis as an LRU cache, or to set
# an hard memory limit for an instance (using the `noeviction` policy).
# 當記憶體達到設定上限時，記憶體的淘汰策略
# maxmemmory-policy [volatile-lru or volatile-tt or volatile-randowm or allkeys-lru or allkeys-random] 

# WARNING: If you have slaves attached to an instance with maxmemory on,
# the size of the output buffers needed to feed the slaves are subtracted
# from the used memory count, so that network problems / resyncs will
# not trigger a loop where keys are evicted, and in turn the output
# buffer of slaves is full with DELs of keys evicted triggering the deletion
# of more keys, and so forth until the database is completely emptied.
#
# In short… if you have slaves attached it is suggested that you set a lower
# limit for maxmemory so that there is some free RAM on the system for slave
# output buffers (but this is not needed if the policy is `noeviction`).
# 設定redis能夠使用的最大記憶體。當記憶體滿了的時候,如果還接收到set命令,redis將先嚐試剔除設定過expire資訊的key,而不管該key的過期時間還沒有到達。
# 在刪除時,將按照過期時間進行刪除,最早將要被過期的key將最先被刪除。如果帶有expire資訊的key都刪光了,那麼將返回錯誤。
# 這樣,redis將不再接收寫請求,只接收get請求。maxmemory的設定比較適合於把redis當作於類似memcached 的快取來使用
# maxmemory <bytes>

# By default Redis asynchronously dumps the dataset on disk. If you can live
# with the idea that the latest records will be lost if something like a crash
# happens this is the preferred way to run Redis. If instead you care a lot
# about your data and don`t want to that a single record can get lost you should
# enable the append only mode: when this mode is enabled Redis will append
# every write operation received in the file appendonly.aof. This file will
# be read on startup in order to rebuild the full dataset in memory.
#
# Note that you can have both the async dumps and the append only file if you
# like (you have to comment the "save" statements above to disable the dumps).
# Still if append only mode is enabled Redis will load the data from the
# log file at startup ignoring the dump.rdb file.
#
# IMPORTANT: Check the BGREWRITEAOF to check how to rewrite the append
# log file in background when it gets too big.
# 預設情況下,redis 會在後臺非同步的把資料庫映象備份到磁碟,但是該備份是非常耗時的,而且備份也不能很頻繁,如果發生諸如拉閘限電、拔插頭等狀況,那麼將造成比較大範圍的資料丟失。
# 所以redis提供了另外一種更加高效的資料庫備份及災難恢復方式。
# 開啟appendonly 模式之後,redis 會把所接收到的每一次寫操作請求都追加到appendonly.aof 檔案中,當redis重新啟動時,會從該檔案恢復出之前的狀態。
# 但是這樣會造成 appendonly.aof 檔案過大,所以redis還支援了BGREWRITEAOF 指令,對appendonly.aof進行重新整理
appendonly no

# The fsync() call tells the Operating System to actually write data on disk
# instead to wait for more data in the output buffer. Some OS will really flush 
# data on disk, some other OS will just try to do it ASAP.
#
# Redis supports three different modes:
#
# no: don`t fsync, just let the OS flush the data when it wants. Faster.
# always: fsync after every write to the append only log . Slow, Safest.
# everysec: fsync only if one second passed since the last fsync. Compromise.
#
# The default is "everysec" that`s usually the right compromise between
# speed and data safety. It`s up to you to understand if you can relax this to
# "no" that will will let the operating system flush the output buffer when
# it wants, for better performances (but if you can live with the idea of
# some data loss consider the default persistence mode that`s snapshotting),
# or on the contrary, use "always" that`s very slow but a bit safer than
# everysec.
#
# If unsure, use "everysec".
# 設定對 appendonly.aof 檔案進行同步的頻率。always 表示每次有寫操作都進行同步,everysec 表示對寫操作進行累積,每秒同步一次。
# appendfsync always
appendfsync everysec
# appendfsync no

# Virtual Memory allows Redis to work with datasets bigger than the actual
# amount of RAM needed to hold the whole dataset in memory.
# In order to do so very used keys are taken in memory while the other keys
# are swapped into a swap file, similarly to what operating systems do
# with memory pages.
#
# To enable VM just set `vm-enabled` to yes, and set the following three
# VM parameters accordingly to your needs.
# 是否開啟虛擬記憶體支援。因為 redis 是一個記憶體資料庫,而且當記憶體滿的時候,無法接收新的寫請求,所以在redis2.0中,提供了虛擬記憶體的支援。
# 但是需要注意的是,redis中,所有的key都會放在記憶體中,在記憶體不夠時,只會把value 值放入交換區。
# 這樣保證了雖然使用虛擬記憶體,但效能基本不受影響,同時,你需要注意的是你要把vm-max-memory設定到足夠來放下你的所有的key
vm-enabled no
# vm-enabled yes

# This is the path of the Redis swap file. As you can guess, swap files
# can`t be shared by different Redis instances, so make sure to use a swap
# file for every redis process you are running. Redis will complain if the
# swap file is already in use.
#
# The best kind of storage for the Redis swap file (that`s accessed at random) 
# is a Solid State Disk (SSD).
#
# *** WARNING *** if you are using a shared hosting the default of putting
# the swap file under /tmp is not secure. Create a dir with access granted
# only to Redis user and configure Redis to create the swap file there.
# 設定虛擬記憶體的交換檔案路徑
vm-swap-file /tmp/redis.swap

# vm-max-memory configures the VM to use at max the specified amount of
# RAM. Everything that deos not fit will be swapped on disk *if* possible, that
# is, if there is still enough contiguous space in the swap file.
#
# With vm-max-memory 0 the system will swap everything it can. Not a good
# default, just specify the max amount of RAM you can in bytes, but it`s
# better to leave some margin. For instance specify an amount of RAM
# that`s more or less between 60 and 80% of your free RAM.
# 這裡設定開啟虛擬記憶體之後,redis將使用的最大實體記憶體的大小。預設為0,redis將把他所有的能放到交換檔案的都放到交換檔案中,以儘量少的使用實體記憶體。
# 在生產環境下,需要根據實際情況設定該值,最好不要使用預設的 0
vm-max-memory 0

# Redis swap files is split into pages. An object can be saved using multiple
# contiguous pages, but pages can`t be shared between different objects.
# So if your page is too big, small objects swapped out on disk will waste
# a lot of space. If you page is too small, there is less space in the swap
# file (assuming you configured the same number of total swap file pages).
#
# If you use a lot of small objects, use a page size of 64 or 32 bytes.
# If you use a lot of big objects, use a bigger page size.
# If unsure, use the default 
# 設定虛擬記憶體的頁大小,如果你的 value 值比較大,比如說你要在 value 中放置部落格、新聞之類的所有文章內容,就設大一點,如果要放置的都是很小的內容,那就設小一點
vm-page-size 32

# Number of total memory pages in the swap file.
# Given that the page table (a bitmap of free/used pages) is taken in memory,
# every 8 pages on disk will consume 1 byte of RAM.
#
# The total swap size is vm-page-size * vm-pages
#
# With the default of 32-bytes memory pages and 134217728 pages Redis will
# use a 4 GB swap file, that will use 16 MB of RAM for the page table.
#
# It`s better to use the smallest acceptable value for your application,
# but the default is large in order to work in most conditions.
# 設定交換檔案的總的 page 數量,需要注意的是,page table資訊會放在實體記憶體中,每8個page 就會佔據RAM中的 1 個 byte。
# 總的虛擬記憶體大小 = vm-page-size * vm-pages
vm-pages 134217728

# Max number of VM I/O threads running at the same time.
# This threads are used to read/write data from/to swap file, since they
# also encode and decode objects from disk to memory or the reverse, a bigger
# number of threads can help with big objects even if they can`t help with
# I/O itself as the physical device may not be able to couple with many
# reads/writes operations at the same time.
#
# The special value of 0 turn off threaded I/O and enables the blocking
# Virtual Memory implementation.
# 設定 VM IO 同時使用的執行緒數量。
vm-max-threads 4

# Hashes are encoded in a special way (much more memory efficient) when they
# have at max a given numer of elements, and the biggest element does not
# exceed a given threshold. You can configure this limits with the following
# configuration directives.
# redis 2.0 中引入了 hash 資料結構。 
# hash 中包含超過指定元素個數並且最大的元素當沒有超過臨界時,hash 將以zipmap(又稱為 small hash大大減少記憶體使用)來儲存,這裡可以設定這兩個臨界值
hash-max-zipmap-entries 512(hash-max-ziplist-entries for Redis >= 2.6)
hash-max-zipmap-value 64(hash-max-ziplist-value for Redis >= 2.6)

# Active rehashing uses 1 millisecond every 100 milliseconds of CPU time in
# order to help rehashing the main Redis hash table (the one mapping top-level
# keys to values). The hash table implementation redis uses (see dict.c)
# performs a lazy rehashing: the more operation you run into an hash table
# that is rhashing, the more rehashing "steps" are performed, so if the
# server is idle the rehashing is never complete and some more memory is used
# by the hash table.
# 
# The default is to use this millisecond 10 times every second in order to
# active rehashing the main dictionaries, freeing memory when possible.
#
# If unsure:
# use "activerehashing no" if you have hard latency requirements and it is
# not a good thing in your environment that Redis can reply form time to time
# to queries with 2 milliseconds delay.
#
# use "activerehashing yes" if you don`t have such hard requirements but
# want to free memory asap when possible.
# 開啟之後,redis 將在每 100 毫秒時使用 1 毫秒的 CPU 時間來對 redis 的 hash 表進行重新 hash,可以降低記憶體的使用。
# 當你的使用場景中,有非常嚴格的實時性需要,不能夠接受 Redis 時不時的對請求有 2 毫秒的延遲的話,把這項配置為 no。
# 如果沒有這麼嚴格的實時性要求,可以設定為 yes,以便能夠儘可能快的釋放記憶體
activerehashing yes

Mysql

my.cnf: mysql核心配置檔案

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock 

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user = mysql
port = 3306
pid-file = /var/lib/mysql/mysql.pid
#配置此項可以追蹤sql執行記錄
log=存放日誌的路徑/mysql-sql.log
##以下為開啟主從的必要配置
server-id = 1
binlog-do-db=db_nameA #指定對db_nameA記錄二進位制日誌  
binlog-ignore-db=db_namB #指定不對db_namB記錄二進位制日誌
binlog_format = MIXED #binlog格式指定
character-set-server = utf8mb4 #指定資料預設編碼
log_bin = /var/lib/mysql/log/mysql-bin.log
expire_logs_days = 30
character-set-server = utf8mb4
default-storage-engine = InnoDB
#thread connection
max_connections = 1024
max_connect_errors = 1024
# Try number of CPU`s*2 for thread_concurrency
thread_concurrency = 8
thread_cache_size = 256
#*network
skip-name-resolve #跳過dns查詢
max_allowed_packet = 1M
#buffer&cache
table_open_cache = 4096
sort_buffer_size = 256K
join_buffer_size = 256K
#query cache
query_cache_limit = 4M
query_cache_size = 4M
query_cache_type = 1
#temptable
tmp_table_size = 64M
max_heap_table_size = 64M

#自增主鍵配置
auto_increment_offset=1
auto_increment_increment=2

#MyISAM
key_buffer_size = 8M
read_buffer_size = 1M
read_rnd_buffer_size = 256K

#Innodb
innodb_log_file_size = 256M
innodb_log_files_in_group = 2
innodb_status_file = 1

innodb_additional_mem_pool_size = 32M
innodb_buffer_pool_size = 5G
innodb_data_file_path = ibdata1:1G:autoextend
innodb_file_per_table = 1

innodb_additional_mem_pool_size = 32M
innodb_buffer_pool_size = 5G
innodb_data_file_path = ibdata1:1G:autoextend
innodb_file_per_table = 1

innodb_force_recovery = 0
#innodb_table_locks
innodb_thread_concurrency = 8

innodb_flush_log_at_trx_commit = 2

innodb_force_recovery = 0
#innodb_table_locks
innodb_thread_concurrency = 8

innodb_flush_log_at_trx_commit = 2

#slow log
slow_query_log=1
long_query_time=1
slow_query_log_file=/var/lib/mysql/log/slow.log

[mysqld_safe]
#error log
log-error = /var/log/mysqld.log
pid-file = /var/lib/mysql/mysql.pid
open-files-limit = 40960

[mysqldump]
quick
max_allowed_packet = 48M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default-character-set=utf8

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

相關連結

Nginx
Apache Tomcat
Redis
Mysql