MySQL Configuration and Optimization

Display

Following Commands are Executed in MySQL

View Running Engines;

show engines;

Find open_files_limit;

SHOW GLOBAL VARIABLES LIKE 'open_files_limit';

Configuration

Enable Query Cache;

SET GLOBAL query_cache_type=1;

Validate Query Cache is Enabled;

show variables like 'query_cache_size';

Optimize

Enable Query Cache Limits;
(Add the following to my.cnf file)

query_cache_type = 1
query_cache_size = 256M
query_cache_limit = 2M
query_cache_strip_comments = 1

Enable Temporary Table Size and Max Heap Size Restriction;
(Add the following to my.cnf file)

tmp_table_size=32M
max_heap_table_size=32M

Enable InnoDB Buffer Pool Size Restriction;
(Add the following to my.cnf file)

innodb_buffer_pool_size = 512M

Skip DNS Name Resolution;
(Add the following to my.cnf file)

skip-name-resolve