Lots of database writes with Ajax?

  • I have been a happy user of this plugin for about two years now (or even more). It always worked perfectly.
    I have noticed recently a CPU load increase on my hosting server. It started mid December and it correlates very closely with a growth of database writes. They both follow exactly same pattern. Yesterday I blocked ajax scripts for 10 minutes, my statistics didn’t grow and I had almost no database writes.
    Before last Dec I used to have very little operations on a DB – almost nothing. Now I have about 150 writes per minute with less than 10 reads – these are daily averages. In peak I have 200-400 writes per minute with less than 20 reads. I monitor Innodb_data_reads and Innodb_data_writes.

    I know in the past this plugin had its own js being called on every visit. And I recall that the whole new WP API is quite a new thing.
    Was there a change in how top-10 works around December? And how can it be that with very similar traffic I had almost no writes in November, a and now I have about 50 times more?

    Thank you for any ideas.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Ajay

    (@ajay)

    Thanks for letting me know. I haven’t noticed this on my site yet, but I suspect with your level hits it might be a more intense option.

    Have you tried to use the Tracker type to Query variable?

    Also, currently, in a very early alpha is this addon which should bring back the separate JS file which I had to pull out of Top 10 to keep it in this repo.

    https://github.com/WebberZone/top-10-fast-tracker

    I’m still far away from releasing this publicly as a big part is related to providing auto updates, but the above should be functional now.

    Thread Starter Grzegorz.Janoszka

    (@grzegorzjanoszka)

    Thank you for your answer, I am looking forward for trying that tracker. Could you please confirm or deny that the change from fast tracker to ajax happened more or less last December? I am not sure if that is the real case.

    I checked top-10-fast-tracker and it seems a really small plugin which I am willing to try. How will it be with updates to this plugin, I guess WP will not find it, do you have any RSS or email list to get updates notifications?

    Could you also elaborate a little bit more about why you had to remove the call to separate js to keep the plugin in the WP repo?

    Thank you in advance.

    Thread Starter Grzegorz.Janoszka

    (@grzegorzjanoszka)

    Well, after a few hours of trying the fast tracker I am very happy. What is interesting, the number of writes to DB remained consistent, but the CPU load dropped visibly. I thought they were related as both graphs went up at exactly the same time around middle December. I am not concerned about a number of DB operations as long as CPU and IO load remain low ??

    Thank you so much. I would love to see this as a permanent addition to top-10 plugin.

    Plugin Author Ajay

    (@ajay)

    Thanks for trying this out. It’s still a beta or more like an early stage alpha as I have one major thing to add in there, which is the updates system.

    It wasn’t December, but few months before when I had to pull out this piece of code as the Repo wouldn’t allow the use of the includes (search for wp-load) as it won’t always be compatible with every WordPress install. It’s what has been sitting in the plugin since the beginning.

    Hence, my need for this which will sit on Github as a base and I plan to distribute it through my site.

    For the updates system, I plan to use the Software Licensing addon for EDD which comes at a cost although this is a free addon. But, I think it’s useful for everyone and hopefully alongside this, my hope is to have one or more premium addons that will pay the bills.

    I’m still struggling to get the SL working properly which is why the release is still not public.

    For updates, if you subscribe to https://webberzone.com/feed then you’ll get updates for this, plus all my plugins there. Or alternatively, the newsletter on the site.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Lots of database writes with Ajax?’ is closed to new replies.