Plugin crash cause MySQL query load time

Hi @dreamon11,

Please add the following code to your theme’s functions.php file to force enable Data Sampling:

function wp77654_force_enable_data_sampling(){
    return true;
}
add_filter( 'wpp_data_sampling', 'wp77654_force_enable_data_sampling' );

… or this much shorter version:

add_filter( 'wpp_data_sampling', '__return_true' );

If you have a caching plugin installed, flush its cache afterwards so changes are applied.

Remove this from your theme’s functions.php file when you’re done tweaking WPP’s performance settings.

The query you posted earlier seems to come from the WPP widget. For some reason it’s taking WPP a lot of time to read from your database (which should be a fairly quick operation).

Remove the widget from your site and give it another shot.

That can’t be it, the query would look quite a bit different. The one posted above belongs to the “stock” query WPP builds when displaying the popular lists on the front-end. See:

SELECT p.ID AS id, p.post_title AS title, p.post_author AS uid, p.post_date AS date, SUM(v.pageviews) AS pageviews

None of those fields are used in the back-end.

Other things I’d try:

• Disable all plugins -except for WPP- and check again.
• If the problem persists even after that, try switching to another theme for a moment and check one more time.

So, if I active this option, views older than 180 days will be deleted?

Correct! Records older than N days will be deleted from the database automatically.