USSM slowness and geekery

DMZ · April 10, 2007 at 2:28 pm · Filed Under Site information 

I spent about two hour during today’s game when things were really bad working on making some more performance enhancements, but I’m still worried about tomorrow. I’ll keep at it – getting this right is really tough, frustrating work. Also, please buy the book k thanks bye

So here’s what happened – somehow, query_cache_size got set to 0, which was awesome. I’m not sure why – I can’t find where they hid the my.conf file, which might have caching turned off. So I cranked that up, which threw the load numbers all over the place.

I tried to do some .htaccess caching, and that didn’t help at all.

Looked at thread caching, and… wow. threads_created is frighteningly huge, so I set that to 2x connected threads.

Did some table optimization quickly when I had everyone kicked out for a minute, that didn’t seem to help.


3 Responses to “USSM slowness and geekery”

  1. LB on April 10th, 2007 7:16 pm

    Were you aware that at least two different posters in the SoSH game thread linked to the USSM game thread? I don’t know if that would account for a spike in traffic, but…

    Schadenfreude is a b1tch.

  2. DMZ on April 10th, 2007 7:43 pm

    I did not check into that.

  3. Nat Irons on April 10th, 2007 9:49 pm

    Most unixish systems build a systemwide index of filenames either daily or weekly; the ‘locate’ command queries it. Could be a good way to turn up the missing my.conf file if it’d still help.

    Good luck tomorrow. Enjoying the book.

Leave a Reply

You must be logged in to post a comment.