Tamamlanmış

Wordpress database expert needed ASAP - PHP, MySQL, Not optimization of Wordpress

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:

<[url removed, login to view]>

<[url removed, login to view]>

<[url removed, login to view]>

<[url removed, login to view]>

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

[url removed, login to view] Stats

WP Database Backup

WP importer

WP Client CSV to Database

WP CSV to Database

Wp Super Cache

Tweet Button

Beceriler: Her şey Kabul, Mühendislik, MySQL, PHP, Yazılım Mimarisi, Yazılım Test Etme, Kullanıcı Arayüzü / IA, Web Hosting, Web Sitesi Yönetimi, Web Sitesi Testi, WordPress

Daha fazlasını gör: xml guru, www my best php com, www guru net my, wp client, work from home technical support, work from home mail order, work from home guide, work from home for disabled, work from home editor, work from home disabled, work at home technical support, work at home disabled, work at home database, work as editor from home, wordpress vendor site, wordpress support email, wordpress support 24 7, wordpress pods expert, wordpress org login, wordpress expert support

İşveren Hakkında:
( 178 değerlendirme ) Dallas, United States

Proje NO: #2754046

Seçilen:

khantek

See private message.

%selectedBids___i_period_sub_7% gün içinde 8.5%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(374 Değerlendirme)
7.3

Bu iş için 4 freelancer ortalamada $252 teklif veriyor

jminkler

See private message.

in %bids___i_period_sub_35% gün içinde150.45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)
3.7
phpmysqlcer

See private message.

in %bids___i_period_sub_35% gün içinde500.65%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
pinetechltd

See private message.

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0