Title: Wordfence Sql Table type Memory
Last modified: May 13, 2024

---

# Wordfence Sql Table type Memory

 *  Resolved [NAROLLES](https://wordpress.org/support/users/narolles/)
 * (@narolles)
 * [2 years ago](https://wordpress.org/support/topic/wordfence-sql-table-type-memory/)
 * 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 overloadsI noticed
   a “memory” type table even though my entire database is in innodb: wp_wfls_role_countsIn
   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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordfence-sql-table-type-memory%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [wfpeter](https://wordpress.org/support/users/wfpeter/)
 * (@wfpeter)
 * [2 years ago](https://wordpress.org/support/topic/wordfence-sql-table-type-memory/#post-17751901)
 * Hi [@narolles](https://wordpress.org/support/users/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](https://make.wordpress.org/core/2015/04/02/the-utf8mb4-upgrade/),
   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](https://wordpress.org/support/users/narolles/)
 * (@narolles)
 * [2 years ago](https://wordpress.org/support/topic/wordfence-sql-table-type-memory/#post-17755320)
 * Thanks a lot

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

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

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [NAROLLES](https://wordpress.org/support/users/narolles/)
 * Last activity: [2 years ago](https://wordpress.org/support/topic/wordfence-sql-table-type-memory/#post-17755320)
 * Status: resolved