Find Jobs
Hire Freelancers

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
Project ID: 2754046

About the project

4 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$8.50 USD in 3 days
5.0 (374 reviews)
7.3
7.3
4 freelancers are bidding on average $252 USD for this job
User Avatar
See private message.
$150.45 USD in 3 days
5.0 (18 reviews)
3.7
3.7
User Avatar
See private message.
$500.65 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$350 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Dallas, United States
5.0
178
Payment method verified
Member since Sep 27, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.