Creating wp_wfwafconfig table makes troubles

  • Resolved Donghyeok kang

    (@wolfkang)


    4 months, 2 weeks ago

    Hi,

    I’m using 2 web servers and 1 mysql server. I set the storage engine as “mysqli”.

    define('WFWAF_STORAGE_ENGINE', 'mysqli');

    Wordfence tries to create the wp_wfwafconfig table on every requests and this makes lots of mysql bin log files.

    Please check this out.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support wfmargaret

    (@wfmargaret)

    Hi @wolfkang,

    Thanks for reaching out. If you’re not using database replication, we recommend disabling the MySQL binary log.

    The MySQL binary log logs each query that inserts, creates, modifies, deletes, etc., to the database. The CREATE statement is used to ensure the table exists, so even though the actual query isn’t doing anything, it’s still being logged to the binary log. Without the CREATE statement, the logs would still fill up over time.

    If you are replicating the database, we recommend reducing the binary log file age. You can find information on how to set the binary log expiration period here: https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_expire_logs_seconds

    Please let me know if you have any other questions or concerns.

    Thanks,
    Margaret

    Thread Starter Donghyeok kang

    (@wolfkang)

    Hi,

    Thanks for reply.

    What about creating tables during the plugin activation step?
    Do you have any reason to try to create tables on every request in the case of mysqli storage engine?

    Regards,
    Donghyeok

    Plugin Support wfmargaret

    (@wfmargaret)

    Hi @wolfkang,

    Thanks for following up and reporting this. I have linked this thread to our development team and they have created a case to review this in more depth and make any necessary changes to improve the MySQLi storage engine performance. Unfortunately, I can’t provide progress reports or potential release schedules here on the forums.

    Thanks again,
    Margaret

    We have recently encountered this and we use binary logging for db replication so cannot turn this off.
    This also logs an error to the PHP error log.

    • This reply was modified 2 months, 3 weeks ago by paulpixel.
Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.