MySQL Performance Settings

etc/my.cnf [mysqld] skip-name-resolve myisam_use_mmap=1 max_connections=100 max_user_connections = 50 log-slow-queries=mysql-slow.log long_query_time = 0.1 safe-show-database query_cache_type = 1 query_cache_size = 75M query_cache_limit = 2M join_buffer_size=1M...