The slow query log is enabled, but I'm not sure about the long query option. I'm not at a place I can check the config. But to give y'all and idea of what I'm dealing with, I restarted MySQL last night, and as of this morning I already have 57 slow queries.
My slow query log is full of just about every table, some a lot more than others, but it's pretty diverse, except for 2 queries that really stand out. One is a simple standard query that is run on every page. It's an IP table that I use for a bot trap. All it does is lookup up the IP, and if it exists, blocks the bot. It's been logged over 400 times.
The other big hitting slow query has only been logged twice, but the execution time is very very high. But this is another query that runs alot. So only having 2 logged out of maybe 15k executions a day isn't all that bad is it?
One thing I realized over the weekend was that I did enable the faster crawl speed for googlebot a couple of weeks ago. It's hitting me currently at about an average of 16k hits a day with a maximum of 36k hits in one day. I'm guessing (lol) that this isn't helping when I've also gotten that huge increase in live person page visits. I did go ahead and change it back to the normal crawl rate via the google webmaster page, but not sure when it will take effect.