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


# Set Log

Hope it helps someone.


Popular posts from this blog

TCPDF How to show/display Chinese Character?

Using wget bypass htaccess username password 401 authorization

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