wp_itsec_distributed_storage: HUGE (8MB)

  • scarpinoc

    (@scarpinoc)


    5 years, 1 month ago

    Hello,

    I would like to ask you hoe can I reduce the size of this table (wp_itsec_distributed_storage).
    It contains only 13 records, but it’s very heavy: 8 MB.

    Thank you!

Viewing 8 replies - 1 through 8 (of 8 total)
  • nlpro

    (@nlpro)

    5 years, 1 month ago

    I would not classify 8MB as HUGE … even with just 13 records.

    The wp_itsec_distributed_storage table includes a longtext data type column (storage_data) which usually contains a (large) list of absolute path/file names.

    DO NOT MANUALLY CLEAR ANY DATA IN THE wp_itsec_distributed_storage TABLE !!

    It is there for a reason (File Change Detection module).

    To prevent any confusion, I’m not iThemes.

    • This reply was modified 5 years, 1 month ago by nlpro.
    Thread Starter scarpinoc

    (@scarpinoc)

    5 years, 1 month ago

    Hello nlpro,
    thank you for your answer.
    Of course, I didn’t delete nothing (^_^)

    Well, so, what do you suggest to do? Is there a method to clear these logs?

    Thank you!

    nlpro

    (@nlpro)

    5 years, 1 month ago

    No, just leave it be.

    Is the current size of the wp_itsec_distributed_storage table causing any problems ?

    If so (what exactly is the problem?), create a screenshot from phpMyAdmin showing the 13 records (no need to display all the data in the storage_data column), upload it somewhere on the internet and link to it in this topic.

    Mainly interested in the data of the storage_group and storage_key columns.

    Obscure any other data you don’t want to share 😉

    • This reply was modified 5 years, 1 month ago by nlpro.
    Thread Starter scarpinoc

    (@scarpinoc)

    5 years, 1 month ago

    Hi,

    no, it’s not a “big” problem nlpro =) .
    I just want to reduce the size of my database, and wp_itsec_distributed_storage is one of the biggest table.
    I have much bigger table in the WPML plug-in (57 MB). This is a bug know problem of WPML, and I should manually remove some data in the database (something that I’m not able to do by myself, too risky).

    View post on imgur.com

    This is a screenshot of the local installation.

    nlpro

    (@nlpro)

    5 years, 1 month ago

    Ok, I see.

    I noticed from the screenshot that this is probably on a Windows local env (C:\/…). If the online/live env is hosted on Linux, please check the size of the wp_itsec_distributed_storage table there…

    I know there are some problems with running the File Change Detection (FCD) module on a Windows based hosting env … and one specific (path) problem (bug) causes duplicate data in the log table !

    So there may very well be some room for improvement (on Windows).
    But it will require some bugfixing in multiple FCD module files.

    I’ll run some tests tomorrow to try and get confirmation. I know the path bug causes duplicate data in the wp_itsec_logs table, but I don’t know whether it also creates duplicate data in the wp_itsec_distributed_storage table.

    Stay tuned 😉

    • This reply was modified 5 years, 1 month ago by nlpro.
    nlpro

    (@nlpro)

    5 years, 1 month ago

    Just a quick update.

    So far, so good. No duplicate data in the wp_itsec_distributed_storage table (on Windows platform). Tomorrow another update with the final results 😉

    jetxpert

    (@jetxpert)

    5 years, 1 month ago

    @scarpinoc,

    The following should help solve your issue:

    (1) Clean Your Logs:

    The plugin, Log Cleaner for iThemes Security, will clean your databases/logs with no issues.

    (2) Disable File Change Detection:

    We do not use the plugin module, File Change Detection, for three main reasons:

    (a) Slows down our website.

    (b) iThemes Security does not detect malware, only file changes. It’s up to the plugin user to determine if the file changes were caused by malware. To date, we haven’t received a response from the plugin developer(s) on the following, related topic: Got Status? (Site Scanner Enhancements).

    (c) We recommend deactivating the File Change Detection Module and instead, perform daily and/or weekly malware scans using the site scanning tools provided here. Our preferences are: Sucuri SiteScan, VirusTotal, and Quttera.

    (3) Clear (Empty) the Distributed Storage Database Table:

    If you decide to deactivate the plugin module, File Change Detection, it’s perfectly OK to clear or empty (not delete) the wp_itsec_distributed_storage database table.

    Let’s hope the plugin developer(s) will soon review the many open topics in this forum and start helping its customers – including Pro users.

    Cheers!

    nlpro

    (@nlpro)

    5 years, 1 month ago

    The information below is provided to help anyone make a better informed decision.

    1. Log Cleaner for iThemes Security plugin

    The Log Cleaner for iThemes Security plugin was created because iThemes decided to remove the Clear Logs button. That button only deleted all records from the wp_itsec_log table (the same table is now named wp_itsec_logs).

    Even though the Log Cleaner for iThemes Security plugin (re)enables you to just delete all records from the wp_itsec_logs table it also provides functionality to delete records from other plugin tables (like amongst others the wp_itsec_distributed_storage table).

    However the iTSec plugin (did not and) does not in any way delete all records from the wp_itsec_distributed_storage table.

    On top of that, if the iTSec plugin is configured properly it will periodically delete data from several plugin tables using WP Cron (again NOT for the wp_itsec_distributed_storage table). IMHO you don’t need the Log Cleaner for iThemes Security plugin.

    So basically, use the Log Cleaner for iThemes Security plugin AT YOUR OWN RISK.

    2. Disabling File Change Detection (FCD) module

    a. Not true. Again if properly configured (WP Cron), FCD will not slow down your website.

    b. The FCD module is not a malware scanner (yet). It just detects file changes. And file changes can be legit or malicious. Indeed the plugin won’t tell you what is what. It’s up to you. But there is an important difference in FCD functionality between the free and Pro plugin. The Pro plugin includes a Compare Files Online option which minimizes the amount of file changes reported. Note that the option description in the Pro plugin still reads:

    When any WordPress core file or file in an iThemes plugin or theme has been changed on your system, this feature will compare it with the version on WordPress.org or iThemes (as appropriate) to determine if the change was malicious. Currently this feature only works with WordPress core files and plugins and themes by iThemes (plugins and themes from other sources will be added as available).

    But it can actually compare files of ALL wordpress.org plugins.

    c. I recommend to install the Pro plugin, enable the FCD module and enable the Compare Files Online option. Less noise;-)

    3. Clear (Empty) the Distributed Storage Database Table:

    I agree IF you plan to never enable the FCD module again…

    • This reply was modified 5 years, 1 month ago by nlpro.
    • This reply was modified 5 years, 1 month ago by nlpro.
Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘wp_itsec_distributed_storage: HUGE (8MB)’ is closed to new replies.