Skip to content
Public Ticket #9979

WEbsite Slow

Conversation thread

Penci Design replied

6 years ago
Staff Reply

Hi,

I disable post count view module on your site.

use "Query Monitor" plugin to check and don't see '_count-views_week' meta working.

Please remove cache, debug log and re-check it again 

Best Regards,

PenciDesign

Agenparl replied

6 years ago
Customer Reply

Time                 Id Command    Argument
# Time: 191027  3:32:47
# User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 485881
# Query_time: 40.499701  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 132194
use agenparl_agenparl2019;
SET timestamp=1572143567;
UPDATE wp_postmeta SET meta_value = '0' WHERE meta_key = '_count-views_week';
# User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 485922
# Query_time: 22.820718  Lock_time: 17.724347 Rows_sent: 0  Rows_examined: 11
SET timestamp=1572143567;
UPDATE `wp_postmeta` SET `meta_value` = '32' WHERE `post_id` = 798730 AND `meta_key` = '_count-views_all';
# User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 485937
# Query_time: 10.744701  Lock_time: 5.648295 Rows_sent: 0  Rows_examined: 9
SET timestamp=1572143567;
UPDATE `wp_postmeta` SET `meta_value` = '17' WHERE `post_id` = 803631 AND `meta_key` = '_count-views_all';
# Time: 191027  3:33:22
# User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 485973
# Query_time: 18.452750  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 132194
SET timestamp=1572143602;
UPDATE wp_postmeta SET meta_value = '0' WHERE meta_key = '_count-views_week';
# Time: 191027  3:33:49
# User@Host: agenparl_wp2019[agenparl_wp2019] @ localhost []  Id: 486036
# Query_time: 3.191662  Lock_time: 0.000094 Rows_sent: 0  Rows_examined: 130039
SET timestamp=1572143629;

This is the slowest query on my mysql server, this log come from my server provider....

Penci Design replied

6 years ago
Staff Reply

Hi,

I disable post count view on your site .

I use "Query Monitor" plugin to check  and i don't see query come from post count view.

Please check it again and tell me about tool you check query.

Best Regards,

PenciDesign

Agenparl replied

6 years ago
Customer Reply

Yeah the count views was hided but not disabled. My slowest query reguarding the count view. Can i disable it totally?  the post view count still in background! 

Penci Design replied

6 years ago
Staff Reply

Hi,

Please go to Custiomizer > General Options then scrolldown and check  "Hide Post Count Views" option as screenshot http://prntscr.com/prdm6x

Best Regards,

PenciDesign

Agenparl replied

6 years ago
Customer Reply

Yeah! i've a busy website with a lot of posts...and need to complete disable post count view

Penci Design replied

6 years ago
Staff Reply

Hi,

Do you want disable  post count view  on your site.

Best Regards,

PenciDesign

Agenparl started the conversation

6 years ago
Conversation Start

Hi, i have a lot of request in my sql db like this:

UPDATE wp_postmeta SET meta_value = '0' WHERE meta_key = '_count-views_week';

Is possible to disable view count and update?

Want to join this conversation or access attachments? Sign in first.

Login to Reply