WP site with too many queries needs optimization (PHP and MySQL)


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

SET timestamp=1360250860;

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!

Skills: Database Administration, MySQL, PHP, WordPress

See more: queries wordpress, wp site, wp coder, server load test, i need someone to edit wordpress site, find plugin wordpress site, custom php coder, bring traffic to your site, and mysql, master wordpress, wordpress vps, vps optimization, queries, php code test, php buddypress, php and mysql, optimization wordpress, server load log, mysql master master cpanel, whm mysql, comment mysql, php localhost, mysql optimizing , master budget include, edit mysql rows php

About the Employer:
( 42 reviews ) Gothenbrg, Sweden

Project ID: #4297763

6 freelancers are bidding on average $203 for this job


I am ready and expert in PHP and MySQL.

$199 USD in 7 days
(41 Reviews)

Hello, "I've read the description", Let's start. Thanks.

$200 USD in 7 days
(21 Reviews)

I've read the description

$200 USD in 3 days
(38 Reviews)

hi, Please Check your PMB, Thanks

$220 USD in 5 days
(23 Reviews)

Dear sir, we are wordpress expert. Thanks Voyage Team

$250 USD in 15 days
(12 Reviews)

plz check your pmb....

$170 USD in 2 days
(3 Reviews)

Hi, I am an experienced web developer, having 5+ years of experience in web development. I am very much interested in this job. My Skills includes PHP, Mysql, Ajax, Cake PHP, Codeigniter , Wordpress . I am More

$250 USD in 5 days
(22 Reviews)

Dear Hiring manager, I am an Expert on html5,css3,php,mysql,joomla,wordpress,Prestashop javascript,drupal,magento,c#,asp.net and oracle 11g apex. I have 3 years experience. More

$100 USD in 5 days
(3 Reviews)

Hello, I would be happy to help you with that web site optimization! M. Dimitrov

$180 USD in 14 days
(0 Reviews)