When WP Core updates, is it stopped of reverting the key changes?
-
Hello first thanks for the work you have put in this plugin.
Now jumping to the real thing, we have a site with 63 million rows in the post meta table (I’m already working on removing orphaned metadata), the issue is I’m currently running the commands to re-key the tables in WP CLI, and I’ve hit the 2?hours mark in running time. Which makes ask some questions:
- When WP Core updates, does it get a chance to remove or modify, any changes made by your plugin?
- If (1) is true does your plugin automatically reverts the changes made by the updates?
Those scenarios are important to me, because I wouldn’t enjoy 2+ hours of work whenever WP core reverts 2+ hours computation then your plugin re applies it back, mostly because I have to do some manual benchmarking, reporting, and interpretation of metrics.
The best scenario would be if the plugin won’t allow those modifications to the keys to happen.
Edit: I have a small feature suggestion, could you add some loading spinner to the terminal output? The constant data sent to update the spinner stops the ssh client from closing the pipe when there has not been any responses by the remote server in hours while running the command, ofc there are configurations that stop that in the ssh client but at that point how do we know the server really didn’t hang vs it’s just not having any output ready for us, but this should be already thought in the plugin design.
-
Core updates attempt to revert some of the keys, but this plugin intercepts and suppresses those attempts. So you won’t see a reversion on core update.
I’ll investigate putting some kind of keep-alive spinner output on wp-cli. But this is best done with keepalive packets within ssh. See [this](https://unix.stackexchange.com/questions/20193/how-to-make-putty-to-not-break-my-session-after-some-time) for a puTTY example.
If it’s taking upwards of two hours to rekey your postmeta table, may I suggest you investigate whether your MariaDB / MySQL server needs more RAM?
- The topic ‘When WP Core updates, is it stopped of reverting the key changes?’ is closed to new replies.
