Support » Plugin: WP Security Audit Log » Slow Queries with WSAL

  • Resolved Hyflex

    (@hyflex)


    Hi,

    I checked my slow queries log file and found two slow queries that happen twice a day (I think) every day from WSAL as you can see below:

    # Time: 170518 2:01:55
    # User@Host: root[root] @ localhost [] Id: 53282
    # Query_time: 4.112465 Lock_time: 0.000053 Rows_sent: 556467 Rows_examined: 556467
    SET timestamp=1495069315;
    SELECT /*!40001 SQL_NO_CACHE */ * FROM MYDATABASE_wsal_metadata;

    # Time: 170518 18:42:17
    # User@Host: root[root] @ localhost [] Id: 8818
    # Query_time: 4.468598 Lock_time: 0.000026 Rows_sent: 557289 Rows_examined: 557289
    SET timestamp=1495129337;
    SELECT /*!40001 SQL_NO_CACHE */ * FROM MYDATABASE_wsal_metadata;

    Anything I can do to help with this or is it an inefficient query in the code?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    Hello @hyflex,

    We are looking into this issue today and will get back to you with an update.

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    Hello @hyflex,

    We just checked our plugin and while I confirm that those tables in question are generated by our plugin, the plugin never issues a SELECT SQL query without a WHERE or LIMIT conditions, so these queries are not being generated by our plugin.

    Can you please check / confirm if you’ve got other plugins / maintenance scripts that are possibly running these queries?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Slow Queries with WSAL’ is closed to new replies.