Support » Plugin: WP Activity Log (formerly WP Security Audit Log) » Remove SHOW TABLES calls

  • Hello,

    On large multis-sites the “SHOW TABLES” call can be very long.
    Can you remove theses calls, or add a hook to disable it ?

    For example in my case I replace the logger in database by a connector for cloudwatch, so the database is not relevant to me :).

    Nicolas,

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor robertabela

    (@robert681)

    Thank you for using our plugin @rahe

    May I ask how many tables you have on your database? Just trying to understand how long the plugin is taking (we have some users with more than thousand sites on a multisite and have no issues).

    I will also look into why we are using the query and see how we can improve it.

    In regards to the logger, just to confirm, so you are writing directly to Cloudwatch and not on the WordPress database? If that’s the case, I’d like to learn more about your setup. Would appreciate if you can send me more details at robert@wpwhitesecurity.com

    Looking forward to hearing from you.

    Hello,

    I have 3101 tables for 59 sites, these calls can take 100ms of query displayed on query monitor.
    Maybe the SQL server have some issues.

    But these are useless calls in my case, maybe a filter or something else ?

    Nicolas,

    Plugin Contributor robertabela

    (@robert681)

    That´s a lot of tables! We will certainly look into this issue to see why the Show Tables is used and if we can do without it or replace it with something else @rahe

    Thank you for reporting this.

    Great to hear this 🙂

    Plugin Contributor robertabela

    (@robert681)

    Hello @rahe

    We have a positive update for you. Today we discussed this / looking into this and can confirm that in some cases we need show tables in some others it has been added as part of a “template”.

    We are going to remove it from where it is not needed. We will also see how we can optimize the queries where it is needed (this is basically needed for the plugin to detect table changes). However, there are many things we can do here, such as, move the database changes detection to the background etc.

    Anyway, just thought that you’d be happy to hear this update. Thank you again for using and supporting our plugin.

    Hello,

    This is great news, thank you very much 🙂
    I’m looking forward for the updates.

    BTW, do you have received my email about CloudWatch ?

    Nicolas,

    Plugin Contributor robertabela

    (@robert681)

    You’re welcome @rahe

    We have received your email about CloudWatch and just replied to it yesterday. Sorry for the delayed response Nicolas.

    Have a good day.

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.