• Resolved xberg

    (@xberg)


    Hi,

    My database is only using InnoDB tables. I installed your plugin:
    – is the admin dashboard (Tableau de Bord) the only place where I can access your plugin? No admin menu?
    – I have a list of all my tables and next to them I see the value of 1 537 212 416. The same value for each table. Is this normal? At the bottom I see “0 files”.
    – When I click on Nettoyer immédiatement the page takes a few minutes to refresh but then exactly the same display appears: 0 files, and 1.5GB next to each table.
    – Finally I looked into the WP_CRON events and was not able to find a new insertion for your plugin around midnight; do you not use wp_cron?

    thanks

    Blaise

    https://www.ads-software.com/plugins/daily-cleaner-optimizer-lite/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter xberg

    (@xberg)

    Also midnight is not a good time to run optimisation: it’s a very busy time with lots of CRONs. Would be better to allow the user to modify this.

    Plugin Author luciole135

    (@luciole135)

    hi,
    – Yes, the only way to access the plugin is widget on the administration page of WordPress. There is no need to create an admin page or options for a plugin that has no settings to be saved.
    – You can check yourself the status of your database by typing the query in SQL tab of phpMyAdmin:
    SHOW TABLE STATUS

    – There is much discussion on the net about the usefulness or non utility to optimize an InnoDB table. Normally, they do not need.
    – Moreover, optimization of InnoDB tables is to rewrite the table entirely, which differs from MyISAM.
    – To try to understand the problem, we should know the version of PHP, the Apache and the MySQL installed on your server.
    – No, the plugin does not use the CRON WordPress because it is often disabled by the webmaster, it is an internal cron which is just as simple.
    – In fact, the WordPress CRON as well as that of the plugin do not allow to choose the time at which it is being. It allows to choose the time from which it will be carried out. Indeed, it is done from the first visit on the site after midnight.
    Perhaps, I should indicate the first visit after 2:00 in the morning.
    Options are not much here, except to make believe that optimization will take place at such time, while in reality it will take place after such time (at the first visit).

    Thread Starter xberg

    (@xberg)

    Chère Luciole,
    Thanks for your answer. I understand

    About the matter of CRONs: I have disabled the automatic running of WP-CRON triggered by a user and use a real cron to launch WP-Cron every 5 minutes, this way I am not dependant on user behavior to run CRONs.
    I also use the fantastic plugin called Crontrol which allows me to edit each individual CRON within WP-CRON. This is how I saw you you were not using WP-Cron.

    My typical behavior is to go into crontrol and move all daily tasks to run between 2am-5am.

    So if you want to keep your plugin lightweight and without options, you might consider using wp-cron and recommending crontrol…

    Kind regards,

    Blaise

    Plugin Author luciole135

    (@luciole135)

    Indeed, I did not know this plugin, I’ll watch it and use the native WordPress cron instead of my personal cron.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘first run questions’ is closed to new replies.