So, if you're one of the five readers here you may have noticed the site gets EXTREMELY slow from time to time. I've been very busy with work, but trying to track down why this is the case. Doing lots of googling about drupal and performance and things like that, which link to all sorts of things like mysql,php,httpd tweaking, optimizing drupal blocks, etc. Well, through much of this I never bothered to look at my.cnf. Yes. I know. Stoooopid. The only memory and performance settings were these:
myisam_sort_buffer_size = 16k
key_buffer_size = 16k
Well fucking duh it's slow. So, per this thread I added the following:
#you really don't need more than 200 connections
max_connections = 200#this can be safely reduced to 32 or even 16M if you have few (0-20) or small (<1gb total) databases
key_buffer = 128Mmyisam_sort_buffer_size = 32M
join_buffer_size = 2M
