Home › Support › Popular Widget › High Load – MySQL Reads/Writes
Tagged: high load
-
AuthorPosts
-
September 16, 2015 at 1:47 am #370373lordandyParticipant
Hi all,
We have a site which is totally cached with Varnish and similar to have high performance for a high number of concurrent users on a single server. When using the popular widget on a page with quite high load, it’s the only request being a HTTP POST and reading/writing to the database, for every single user.
Is there any option to move the view database to a memory abstraction layer like memcached or similar, or even a Redis to unload database writes and traffic?Regards,
AndySeptember 21, 2015 at 9:17 pm #373267Xpark MediaKeymasterThe plugin it is Query heavy, specially if you are tracking pageviews instead of visits. It uses post request to accurate register the views.
There is a database cache plugin that my help you but your pageviews/visits will not be accurate. You could also use a hook to change the request and the database write. If you already using memecache you will have to change the request method also.
November 26, 2015 at 7:42 am #446765lordandyParticipantHello,
perfect, thanks a lot. I will check the hooks and maybe write it to memcached/redis, and then import into the DB by CronJob, might be the best idea.Visits Tracking is not possible (only page views) as we do have caching in place without cookies, and I assume the visits are based on user identification/cookies.
Regards,
AndyNovember 30, 2015 at 1:05 am #449466lordandyParticipantBut, just another question. There is no method to exchange the update function at all, correct? I just found the filters “pop_set_post_view” to turn counting on/off, and the before_ and after_ functions, but nothing to really change the update function to write to memcached or redis or similar?
Or did I miss something?December 13, 2015 at 8:51 pm #462943Xpark MediaKeymasterUsing ‘pop_set_post_view’ and returning false turns off the function. But before returning false you can run any function that process the views.
December 29, 2015 at 6:12 am #473380lordandyParticipantThanks, I think this will solve my issue so I will write a wrapper with memcached/redis and update the database by WP Cron.
-
AuthorPosts
- You must be logged in to reply to this topic.