MySQL 5.6 Wordpress Optimization

My my.cnf I am setting the blog based on information from: 

High Performance Wordpress
SlideShare of Above link

Use of mysqlreport

# Config start

key_buffer = 256M
sort_buffer_size = 4M
read_buffer_size = 4M
innodb_buffer_pool_size = 256M
innodb_log_buffer_size = 8M
tmp_table_size = 32M
max_heap_table_size = 32M
table_open_cache = 128
thread_cache_size = 64
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 32M

skip-name-resolve

# Set Log
slow_query_log_file=/var/log/mysql-slow-query.log
log_error=/var/log/mysql-error.log

Hope it helps someone.

Comments

Popular posts from this blog

TCPDF How to show/display Chinese Character?

Wordpress Load balancing: 2 web servers 1 MySQL without any Cloud services

Using wget bypass htaccess username password 401 authorization