Latest version is trashing server

Hey @tgiokdi,

Is https://www.tikiwebgroup.com/ your website? Because it loads blazingly fast for me.

The updated version introduces a number of CRON jobs that help us improve the performance of the plugin in the long run.

The amount of records in our own table should reflect the amount of public posts you have (this includes attachments). How large is your post table in terms of records?

– Arnaud

I had turned off the plugin while I was figuring out what was going on, that helped mitigate the server load, I’ll try turning it back on today while everyone’s sleeping off the NYE celebrations.

I’m running the network version with about 50 sites, about 700k posts with multiple attachments on each.

Are there limits set on the crons or are they just selecting everything that hasn’t been ported over yet? I’m going to assume this is going to inflate my database a fair bit, yeah?

That’s correct. The plugin needs to create a record for every public post/term you have in our custom tables. We’re also adding records to the actionscheduler_actions table for every action (CRON job) that runs, but in the next update we’re adding some code that will periodically clean that up.

The CRON jobs (or so called actions) are limited to about 50 posts per action, which is a small enough amount so that it shouldn’t stress your site. If you still experience any issues after reactivating, please reach out again and we’ll be happy to tell you where you can lower the amount.

From what I’m seeing in my sql-slow log, the problem might be that it’s querying on an unindexed column? Seeing a lot of these:

# Query_time: 2.969962  Lock_time: 0.000076 Rows_sent: 0  Rows_examined: 211462
SET timestamp=1609522024;
SELECT post_id, meta_value FROM wp_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = 'tdomf/18516/776.jpg'

most of these do not exist, which may be an issue that’s on my end with how attachments are stored for some plugins from 10+ years ago, but having that run on 50+ sites at the same time might be an issue that I can mitigate by just activating the plugin on one site at a time.

is there an easy way to see what progress is being made and how much more is left to go? even if it’s as simple as doing a sql query?