innoDB and wp_wfls_role_counts

Hi @beyrone, thanks for your question.

Wordfence’s MEMORY table is primarily to improve speed when viewing the Login Security settings, but it can be changed if you prefer. We will also offer a configuration option to avoid the use of MEMORY tables in a future release. For our other tables, Wordfence should use the default your database is setup to use so should remain as InnoDB in your case.

In the mean time, the plugin is designed to create a permanent table if you disable temporary tables on your database. These can then be forced to use InnoDB . The command:
alter table wp_wfls_role_counts engine=innodb; worked for me, and it doesn’t get changed when the plugin updates.

I hope that helps you out,
Peter.

Hi Peter,

Thanks for getting back to me on this, that would indeed be handy configuration option. When that table is made permanent can I enable temporary tables again? I think certain migration plugins rely on temporary tables.

Hi @beyrone,

I believe so, as the table name should be found before it tries to create another MEMORY table with that name. Let us know if that’s not the case so I can speak with the team.

Thanks again,
Peter.