non-InnoDB Tables warning, despite all tables are InnoDB based

[Piano Lesson With Warren]

I have double checked with my hosting & myself. My database doesn't have any non-InnoDB tables.  I have 3 views & one memory table. I have tried clicking on "check again" many times, but it is still showing this.

[Marc]

I'm a little confused as to what you say there. You say you have no non-INNODB tables, but also say you have one memory table. You do seem to have data from multiple applications in that same database too, which would not be advisable

[Piano Lesson With Warren]

Yes, you get it right, I have one database for both WordPress & invisioncommunity. Do you recommend to transfer the invisioncommunity to a separate database? I have same prefix for both applications. So is there a way to separate the invisioncommunity tables?

 

Also if I delete the Memory Table, will the warning disappear?

[Marc]

Yes, I would certainly recommend invision being in a separate database. Separating databases would be a manual task to see which are tables from invision, as you have the same prefixes, which would also not be recommended. 

In terms of the message, yes switching the memory table will likely correct the message. I would say though, if you are just trying to remove a message and know what is causing it, I would ask if its worth it to you to do?