Wordfence Sql Table type Memory

  • Resolved NAROLLES

    (@narolles)


    1 year, 10 months ago

    Good morning
    Some time ago I installed wordfence but I couldn’t keep it due to its known incompatibility with wp-rocket.
    I deleted it by checking to keep the parameters (mainly SQL tables)
    At times I notice some server overloads
    I noticed a “memory” type table even though my entire database is in innodb: wp_wfls_role_counts
    In addition, the wordfence tables have a different “interclassing”: “utf8mb3” instead of “mb4”
    What do you advise me….to reinstall to uninstall everything or another manipulation…..(the parameters kept are not as numerous and I don’t know when it will be compatible with rocket)
    THANKS

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support wfpeter

    (@wfpeter)

    1 year, 10 months ago

    Hi @narolles, thanks for your question.

    Wordfence doesn’t change database collations and observes the defaults currently set on your server when making changes or plugin updates. WordPress itself switched to using utf8mb4 quite a while ago, so seeing that there is another collation set might suggest a WordPress update didn’t finish changing your tables back then, or perhaps a migration or restore from backup used a different collation at some point. You can certainly convert any tables to another collation yourself and Wordfence won’t try to switch it back.

    Wordfence’s MEMORY table is primarily to improve speed when viewing the Login Security settings, but it can be changed without causing errors if you prefer. For our other tables, Wordfence should use the default your database is set up to use, even in the event of a reinstall. The plugin is also designed to create a permanent table if you’ve disabled temporary tables on your database.

    I hope that helps you out!
    Peter.

    Thread Starter NAROLLES

    (@narolles)

    1 year, 10 months ago

    Thanks a lot

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Wordfence Sql Table type Memory’ is closed to new replies.