View Single Post
Old 01-09-2013, 08:45 AM  
fris
Too lazy to set a custom title
 
fris's Avatar
 
Industry Role:
Join Date: Aug 2002
Posts: 55,530
Anyone care to share your my.cnf optimizations?

Curious what you guys have for your setups.

here is mine

Quote:
skip-external-locking
bind-address = 127.0.0.1
key_buffer = 300M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 384
max_connections = 400
table_cache = 1800
tmp_table_size = 64M
max_heap_table_size = 64M
max_connect_errors = 1000
wait_timeout = 7200
connect_timeout = 20
query_cache_limit = 4M
query_cache_size = 128M
thread_concurrency = 10
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 1M
sort_buffer_size = 64M
__________________
Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.


My Cam Feeds Script / Gallery Scraper / WPXXX Theme / Free Templates
fris is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote