Our BuddyPress/Wordpress site [url removed, login to view] is using a lot of queries. Not unusual when it comes to WP but this is extreme. Our main coder can't figure it out cause he's not used to optimizing code. We need someone who's a master with PHP and MySQL, currently our VPS crashes one or twice per week when there's a lot of traffic.
# Time: 130207 18:27:40
# User@Host: site_hil[site_hil] @ localhost 
# Query_time: [url removed, login to view] Lock_time: [url removed, login to view] Rows_sent: 150 Rows_examined: 5957974
As you can see our queries are taking more than 1 second to execute (on regular load) and are examining almost 6M rows.
Check the site, look at our DB, check our custom PHP code and see if you find anything. You'll get access to WP, FTP and cPanel. WHM access also available. Comment and log everything you edit. Using only a WP cache plugin isn't a solution to bring down queries, we need a smarter solution!
Milestone #1 released once you've made an attempt and sent us a list of edits you've made.
Milestone #2 will be released after 72 hours when the site have had time to test and see if your fixes have reduced server load. We always pay on time, check our reviews!
We don't have a huge budget (the site is our hobby ;) but we'll give you a great review and loads of other work will be available! If you send us a PM, include a "I've read the description" so we know you've actually have. Thanks!