WP and Mysql overload

1. Can be ’caused by your plugins and/or theme (bad code, too much mysql query, etc)

2. Number of visitors (use pageviews not unique visitors, due a unique visitor may open 3,5,10, or more page which result additional server usage).

3. Have you try w3 total cache ? Can be used with memcached or opcode.

What is your server configuration ? apache, litespeed, nginx, etc ?

It will be easier if you talk with your host provider. Maybe you need load balancer or use multiple servers.

Perhaps the problem is caused by timthumb.php which is known to cause all types of problems.

ive between 6000 et 15 00 pageview a day.

Ive upgrade timthumb with the vuenability scanner

It’s not about security, but timthumb may kill your server even with multiple servers.

Take a look at wordpress codex, “high traffic wordpress”. You need to optimize your system (host and wordpress ) first.

It’s not about security, but timthumb may kill your server even with multiple servers.

As SNSD news suggested, timthumb can cause serious problems. That is why I pointed to that first. However, you may check other possible problems too.

The issue is pretty new, a few week, never got this issue before, even with timthumb. i’m using this theme for 1 year at least.

For the fact, im not a newbie and i use wordpress for about 5 years now. The site is pretty well optimized and the server is dedicated one. But for about 2 week i get this oveload mysql issue.

Each time im doing a post, the server crash 1 out of 4 post.

right now i use quick cache and varnish is install on the server.

my host jst contact me and send me this mail and tell me what the error is :

The SSD drive is in place but we are still seeing issues with your database. I went ahead and did a full process list for you and attached that to this ticket. 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 |

If you can figure out what is causing this issue, you will resolve all of your WordPress issues with this domain.

up
im ready to pay to gt this issue fixed

im ready to pay to gt this issue fixed

To hire someone, please post at: https://jobs.wordpress.net/