No innodb to my knowledge. WP uses MYISAM. You can switch it over, but I'm fearful of that killing off DBs.
Made the switches you suggested. Originally, when log_query was down to 5 i was running constant >10 on the load. Went back to 10 and I'm at 2-3 load.
Well, originally Googlebot and others were hitting the site at 30x times a second. I created a robots.txt a few weeks ago and now it's down to about every 3 seconds there will be a hit or two from a spider. Googlebot is specifically limited to every 7 seconds.
So, nothing in the way of attacks.
ISPC3 on Debian! It's great!
Last edited by crypted; 27th October 2010 at 21:41.