Multisite – Ghost Tables remain after site deletion

  • MB-Jan

    (@mb-jan)


    3 years, 1 month ago

    Hi there,

    Great plugin! I use it on multiple sites for many years. I just noticed that if a site in a multisite network is deleted, the following tables remain in the database:
    prefix_aiowps_events
    prefix_aiowps_failed_logins
    prefix_aiowps_global_meta
    prefix_aiowps_login_activity
    prefix_aiowps_login_lockdown
    prefix_aiowps_permanent_block
    (prefix is a placeholder for the database prefix selected for WordPress)

    It would be great if those can be deleted as well upon site deletion.

    Thank you.

    – Jan

    • This topic was modified 3 years, 1 month ago by MB-Jan.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    3 years, 1 month ago

    Thank you for your 3 star review 🙂

    In regards to your question, the plugin currently keeps those tables because most time people just want to delete the plugin and install it again because they where locked out.

    If you have any questions or require support, please create a support thread using the following link.

    https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/

    Kind regards

    Thread Starter MB-Jan

    (@mb-jan)

    3 years, 1 month ago

    Hey there,

    Thanks for your feedback. I would like to clarify that I am not referring to deleting the plugin. I agree with you that, if the plugin is deleted, those tables should remain in case a user re-activates the plugin.
    I am referring to sites that are deleted in a multisite network. WordPress creates a set of database tables when a new site is created in a WordPress multisite network and so does All In One WP Security & Firewall.
    Unfortunately, upon deletion of the site, the tables I mentioned in my first post remain in the database. Given that sites cannot be restored after deletion, I do not see any use case for why the plugin tables should remain in the database. In a large multisite network, these “ghost” tables can contribute to the database size significantly.
    It would be great if you can delete the tables after site deletion. You can find more info here: https://developer.wordpress.org/reference/hooks/wpmu_drop_tables/

    I hope this helps.

    Best regards

    Jan

    Plugin Contributor mbrsolution

    (@mbrsolution)

    3 years, 1 month ago

    Thank you Jan for providing more information.

    I have submitted a message to the developers to investigate further your request.

    Kind regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Multisite – Ghost Tables remain after site deletion’ is closed to new replies.