SELECT SQL_CALC_FOUND_ROWS
SELECT SQL_CALC_FOUND_ROWS
Company: tvqc
Job Type: Project
Location: Quebec
Job Description:
Well i didnt have any news in the wp forum, i post this project with spécific need. This seem to be a recuring issue with large wp site.
My site is a large wordpress site with more than 6000 posts with a good amouth of traffic (5000-10000 pageview a day) . i have a strong dedicated server. The site is crashing very often when im doing a new post
My new SSD drive is in place but we are still seeing issues with your database. I went ahead and did a full process list and provide an attached t. The issue is basically a large number of the same things running that look similar to this:
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id) WHERE 1=1 AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘sympatico’, ‘gab_gallery’) AND (wp_posts.post_status = ‘publish’) AND (wp_postmeta.meta_key = ‘iframe’
OR mt1.meta_key = ‘video’
OR mt2.meta_key = ‘videoflv’ ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 8 |
How to Apply: jeff@tvqc.com
Job Type: Project
Location: Quebec
Job Description:
Well i didnt have any news in the wp forum, i post this project with spécific need. This seem to be a recuring issue with large wp site.
My site is a large wordpress site with more than 6000 posts with a good amouth of traffic (5000-10000 pageview a day) . i have a strong dedicated server. The site is crashing very often when im doing a new post
My new SSD drive is in place but we are still seeing issues with your database. I went ahead and did a full process list and provide an attached t. The issue is basically a large number of the same things running that look similar to this:
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id) WHERE 1=1 AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘sympatico’, ‘gab_gallery’) AND (wp_posts.post_status = ‘publish’) AND (wp_postmeta.meta_key = ‘iframe’
OR mt1.meta_key = ‘video’
OR mt2.meta_key = ‘videoflv’ ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 8 |
How to Apply: jeff@tvqc.com
Permissions in this forum:
You cannot reply to topics in this forum
|
|
Tue Oct 08, 2013 1:53 pm by ctsseo
» Hey I am The Head developer of MinecraftStuff
Fri Mar 29, 2013 1:13 pm by Admin
» PHP and Notepad++
Fri Dec 28, 2012 3:21 am by MinecraftStuffDev
» Pakistan Cricket Team Face 1st T20 Against India On 25th Dec 2012
Tue Dec 25, 2012 9:46 am by tallat
» Learning SEO
Sun Dec 23, 2012 5:19 am by GordonH
» Guest Blogging ?
Sun Dec 23, 2012 5:18 am by GordonH
» SEO strategies for 2012!
Sun Dec 23, 2012 5:15 am by GordonH
» The best way to get traffic for your site
Sun Dec 23, 2012 5:10 am by GordonH
» How Can I increase the traffic for my Web site??????
Wed Oct 24, 2012 6:15 am by kevin619