High Load – MySQL Reads/Writes

HomeSupportPopular WidgetHigh Load – MySQL Reads/Writes

Tagged: 

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #370373

    lordandy
    Participant

    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,
    Andy

    #373267

    Xpark Media
    Keymaster

    The 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.

    #446765

    lordandy
    Participant

    Hello,
    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,
    Andy

    #449466

    lordandy
    Participant

    But, 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?

    #462943

    Xpark Media
    Keymaster

    Using ‘pop_set_post_view’ and returning false turns off the function. But before returning false you can run any function that process the views.

    #473380

    lordandy
    Participant

    Thanks, I think this will solve my issue so I will write a wrapper with memcached/redis and update the database by WP Cron.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.