Wordpress database expert needed ASAP - PHP, MySQL, Not optimization of Wordpress
$30-5000 USD
Completed
Posted almost 12 years ago
$30-5000 USD
Paid on delivery
Hi We have a large WordPress site that is not a blog. for the past 2 weeks we have Intermittent slow home page load on all major browsers. Sometimes loads fast sometimes slow but then when click side link that accesses the database or search on the side which also accesses the database it just spins and spins.
We have paid someone to optimize the WordPress site, tried a CDM, worked with Hostgator, nothing changes the intermittent show load form page or side links.
We don't think it is WordPress issue (Well possibly caching involved), or the server. We think it is the database, something that was loaded into it - You can look at Project Id: 1,909,970 to see what we already had someone do. I am putting in the additional info what Host gator suggests at this point.
We need a database PHP MySQL (we think) guru to get in here and figure out the mystery. We have optimized, disabled, tweaked - all to no avail.
Here is what host gator suggests next (See below) and please read additional info. What could be done in the next 12 to 24 hours would be ideal.
Hello,
I took at look at the server and it appears there were some slow queries, most of these tables appears to be related to "Pods CMS Framework" plugin which appears to be active still. As for the W3-Total-Cache I see that you have DB cache and Object caching enabled, without having MemCached or APC installed we recommend disabling those two types of caches as they can have a negative impact on the performance of your web site.
You may also want to recompile the latest version of PHP and we can also compile mod_deflate, which would be responsible for serving compressed html, js, and css content. Additionally, you may want to consider using a CDN such as cloud-flare help with some to the static content of your sites such as small images and such.
## Deliverables
This is the last response from hostagor
Hello,
I took at look at the server and it appears there were some slow queries, most of these tables appears to be related to "Pods CMS Framework" plugin which appears to be active still. As for the W3-Total-Cache I see that you have DB cache and Object caching enabled, without having MemCached or APC installed we recommend disabling those two types of caches as they can have a negative impact on the performance of your web site.
You may also want to recompile the latest version of PHP and we can also compile mod_deflate, which would be responsible for serving compressed html, js, and css content. Additionally, you may want to consider using a CDN such as cloud-flare help with some to the static content of your sites such as small images and such.
We have the following articles on Optimizing your WordPress:
<[login to view URL]>
<[login to view URL]>
<[login to view URL]>
<[login to view URL]>
root@app [/home/lisaowen/public_html]# mysql -e 'select * from mysql.slow_log order by start_time desc limit 10;'
+---------------------+-----------------------------------+------------+-----------+-----------+---------------+----+----------------+-----------+-----------+-------------------------------------------------------+
| start_time | user_host | query_time | lock_time | rows_sent | rows_examined | db | last_insert_id | insert_id | server_id | sql_text |
+---------------------+-----------------------------------+------------+-----------+-----------+---------------+----+----------------+-----------+-----------+-------------------------------------------------------+
| 2012-06-23 12:35:55 | lisaowen[lisaowen] @ localhost [] | 00:00:30 | 00:00:00 | 5240 | 5240 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_pod_tbl_companies` |
| 2012-06-23 12:35:23 | lisaowen[lisaowen] @ localhost [] | 00:00:23 | 00:00:00 | 2724 | 2724 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_pod_tbl_clients` |
| 2012-06-22 12:16:21 | lisaowen[lisaowen] @ localhost [] | 00:00:39 | 00:00:00 | 5240 | 5240 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_pod_tbl_companies` |
| 2012-06-22 12:15:37 | lisaowen[lisaowen] @ localhost [] | 00:00:31 | 00:00:00 | 2724 | 2724 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_pod_tbl_clients` |
| 2012-06-22 12:14:20 | lisaowen[lisaowen] @ localhost [] | 00:00:28 | 00:00:00 | 443 | 443 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_options` |
| 2012-06-22 10:37:32 | lisaowen[lisaowen] @ localhost [] | 00:00:21 | 00:00:00 | 2877 | 2877 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_postmeta` |
| 2012-06-22 10:37:06 | lisaowen[lisaowen] @ localhost [] | 00:00:41 | 00:00:00 | 5240 | 5240 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_pod_tbl_companies` |
| 2012-06-22 10:36:19 | lisaowen[lisaowen] @ localhost [] | 00:00:35 | 00:00:00 | 2724 | 2724 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_pod_tbl_clients` |
| 2012-06-22 10:35:33 | lisaowen[lisaowen] @ localhost [] | 00:00:20 | 00:00:00 | 8005 | 8005 | | 0 | 0 | 0 | SELECT * FROM `lisaowen_wrdp1`.`wp_pod` |
+---------------------+-----------------------------------+------------+-----------+-----------+---------------+----+----------------+-----------+-----------+-------------------------------------------------------+
This is from our optimizer
In my view Optimization is Done, just some images that can be further compressed.
------------------------------------
What Have I done:
1. Backup & Upgraded WordPress Installation, Plugins
2. Optimized Images (Home Page ones & installed WP-Smushit for further compression), Database (must be done once in a month)
3. Cleaned up the Old Caching plugins & traces of them from files.
4. Cleaned up Htaccess file & put on a new htaccess file.
5. Again tried using Caching Plugins (W3TC & WP Super Cache) but things did not work & server was also having issues so disabled them back.
6. Analyzed DB (SQL Queries) but none of them were at fault.
7. Optimized CSS files of website & also JS files.
8. Linked Up JS files to Google Network to decrease load time.
9. Enabled CDN using wp super cache.
10. Caching & Compression enabled with HTACCESS 11. Deleted un-used plugins & files.
12. Added Analytics Code manually (no need of a separate plugin, just increases overhead)
Active Plugins:
Applause Custom POD UI
Enable Media Replace
Filosofo Remove Dashboard
Google XML Sitemaps
HeadSpace 2
HMD Email Editor
Light Box Gallery
Peter's Login Redirect
POD CMS Framework
Regenerate Thumbnails
Use Google Libraries
Vendor & Company Management
WP-Email
WP-Stats
Disabled:
FB Share
Formbuilder
Akismet
Google Analytics (Yoast) [I added Analytics code manually] Optimize DB PODS UI Pods UI Demo SB Welcome Mail Editor Sidebar Login User Role Editor
w3 Total Cache
[login to view URL] Stats
WP Database Backup
WP importer
WP Client CSV to Database
WP CSV to Database
Wp Super Cache
Tweet Button