Christos Chatzaras

I tested it, and by adding this to functions.php, I was able to modify the optimizer settings successfully:

https://dpaste.com/DKB466R9U.txt

So, can the following be added before your query?

$wpdb->query(“SET SESSION optimizer_switch=’derived_merge=off'”);

And this after your query?

$wpdb->query(“SET SESSION optimizer_switch=’derived_merge=on'”);

Let me know if you need any further information.

I manage the web hosting for the @mygreektaste website, so I can offer more details.

Here’s an unusual issue we encountered:

Without Redis cache enabled, this URL: https://www.mygreektaste.com/our-brands/ does not display the taxonomies and as a result the brand icons.

However, when I enable Redis cache, the brand icons appear on the URL.

Normally, if there was an issue with Redis, I’d expect the website to have problems, not the other way around.

EDIT: The website also uses WPML.

• This reply was modified 1 year ago by Christos Chatzaras.
• This reply was modified 1 year ago by Christos Chatzaras.

Few years ago when Media Cleaner was using the WordPress trash and if you were using another plugin that automatically empty the trash you would end with removed entries from the database, so even you had the images in wpmc-trash it was not possible to restore anything. I remember that I had report this to Jordy and he already had plans to replace this with a separate Trash, which he done after few days.

Thank you. It solve the issue.

I found the query using mysqladmin processlist status while visiting the page. As it took ~3 seconds for the page to load, I was able to see the query. And I identified your plugin because the query containts _whols_mark_this_product_as_wholesale_only

In table wp_postmeta for the same post_id there are multiple entries for meta_key (for example _stock):

post_id = 1 & _stock = 10
post_id = 1 & _stock = 9

Does it remove the extra entries in this case?

Or it will only delete and keep only one if we have this:

post_id = 1 & _stock = 10
post_id = 1 & _stock = 10

• This reply was modified 2 years, 1 month ago by Christos Chatzaras.

If you have SSH access create a symbolic link:

mv wp-content/bfu-temp wp-content/uploads/bfu-temp
ln -s wp-content/uploads/bfu-temp wp-content/bfu-temp

Maybe it works.

1) The “pro” version has option (filesystem scan) to delete unused images that don’t exist in Media Library. The question is if it will be able to delete the physical file, as you already wrote that it fails when you delete an image from Media Library. Looks like something is broken in your installation.

2) Jordy does a great work with this plugin, but sometimes it may show as unused an image that is used. So I don’t think it’s good idea to automate this. When you delete the unused images then the images files are moved in wpmc-trash and you can visit your website using a private tab (or make sure you clear browser cache). This way you can find easily for false positives and restore them.

You can run it as :

php wp

or you can run it as:

./wp

The ./ at the beginning is needed because wp file is not located in a directory that you can see if you run:

echo $PATH

If you moved the wp file in /usr/local/bin then as this directory is in the $PATH then you could simple run:

wp

To move the file there, you need to run the mv command as root. As you don’t have much experience with linux commands I recommend you not to do anything as root.

The php command may use different php.ini than your web-server so try this:

php -d max_execution_time=3000000 ./wp media-cleaner scan

This command renames wp-cli.phar to wp :

mv wp-cli.phar wp

Also I forgot that you need to make it executable:

chmod 755 wp

You can also upload the file using a FTP client. Don’t forget to change the permissions to 755.

I am using Media Cleaner Pro in a lot of websites with more than 100k images each. I use it both from wp-admin and from wp-cli without any issues. If you have any issues maybe related to your website or your server.

To download wp-cli SSH on your server with the username of the hosting account and run these commands:

cd public_html
curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar
mv wp-cli.phar wp

and then to scan the images run:

./wp media-cleaner scan

You need the Pro version:

https://meowapps.com/media-cleaner/tutorial/#Basic_Commands

For example wp_actionscheduler_logs which can become huge if you use actionscheduler a lot, for example plugins that sync products with facebook, etc. Also the wp_actionscheduler_actions would be nice to have an option to delete entries that are not in “pending” status, such as “failed”, “complete”.

You can also add these features in the paid version, for example to autoclean these two tables with entries older than 7 days.

Another more automated way is a button to grep through wp-content/plugins/* .php files trying to find which “unknown” tables are used and by which plugin. The scan would not take long as .php files are small.

After the scan is completed it should show a button that user clicks to send you these details by a POST request to your server. Then you add them in the core of Database Cleaner in an upcoming version.

If you don’t want to update the core frequently, maybe you can keep these information at your database and have a “fetch table data” button, which will make a call to your server, your server replies with a XML and update only the plugins table list. Also this could be done automatically, for example once per day using wp cron.

If you want me to test new versions my e-mail is chris [at] cretaforce.gr

• This reply was modified 2 years, 8 months ago by Christos Chatzaras.

Yes everything is ok now.