Anyone care to share your my.cnf optimizations?

[fris]

Curious what you guys have for your setups.

here is mine

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

[AdultEUhost]

it isn't really useful to share as it is very specific to your needs, how much memory you have available etc etc
one might use solely innodb while another does a lot of full text myisam stuff

Use something like MySQL Tuner to get you started

by the way, if you only bind to localhost, you should use skip-networking and connect through socket

[fris]

Originally Posted by AdultEUhost

it isn't really useful to share as it is very specific to your needs, how much memory you have available etc etc
one might use solely innodb while another does a lot of full text myisam stuff

Use something like MySQL Tuner to get you started

by the way, if you only bind to localhost, you should use skip-networking and connect through socket

but when i do that i cant connect to mysql over ssh tunell, which i do to connect via navicat.

[JamesM]

Everyone's is different as per their need/system.

We use mysqltuner.pl for better performance.

[signupdamnit]

Originally Posted by JamesM

Everyone's is different as per their need/system.

We use mysqltuner.pl for better performance.

+1 It will take at least a few days and multiple adjustments to tune things correctly. Sometimes the programs/scripts themselves make a big difference and if they are written poorly it can be impossible or impractical to optimize them without changing the source. It's a good idea to check what others say in regards to 'mysqltuner.pl' settings if you find it tells you to constantly increase a limit. Sometimes it makes sense to leave it because it's the application responsible and increasing it will only make the system worse.

[Why]

Originally Posted by signupdamnit

+1 It will take at least a few days and multiple adjustments to tune things correctly. Sometimes the programs/scripts themselves make a big difference and if they are written poorly it can be impossible or impractical to optimize them without changing the source. It's a good idea to check what others say in regards to 'mysqltuner.pl' settings if you find it tells you to constantly increase a limit. Sometimes it makes sense to leave it because it's the application responsible and increasing it will only make the system worse.

good advice right there.

in some cases you just need to add an index or something.