The storage engine for the table doesn’t support check

Hi @udarakalana, Thanks for reaching out.

The wp_wfls_role_counts temporary table was added to Wordfence to improve the performance of the user count calculation that drives the table at the top of the Wordfence>Login Security > Settings page.

Temporary tables should be dropped automatically when all connections disconnect from the database, so there should be cause for concern.

You can also safely change the storage engine on this table manually if needed — it may make performance slower only on the Login Security menu pages for admins where users are counted, but assuming you don’t have tens of thousands of users, the speed is usually tolerable. Wordfence only recreates this table if it is missing, but it does not change the storage engine if you manually change it.

Thanks,

Mark