Anyone care to share your my.cnf optimizations?
 

Curious what you guys have for your setups.

here is mine

:pimp:thumbsup

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.

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.

good advice right there.

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