MySQL
The InnoDB buffer pool gets a share of memory based on the server's role, and the connection limit grows with the amount of RAM. The slow query log is turned on with a 2-second threshold.
innodb_buffer_pool_size40% of memory- 3200M
innodb_log_file_sizea quarter of the buffer pool- 800M
max_connections100 + 50 per GB- 500
max_allowed_packet256M from 4 GB of memory, 64M otherwise- 256M
slow_query_logslow query log- on
long_query_timeslow query threshold, seconds- 2.00