MyBB Community Forums

This is partial suggestion and partial support thread.

I assume a benefit would exist if mybb_datacache was in memory instead of a myisam table. Of course that would mean anytime the server was reset the datacache would need to be rebuilt.

Does anyone on dev team see this as a benefit or a problem? I'm just looking into more solutions to optimize my mysql.

The datacache isn't exactly a "cache" of everything. For example, there is no fallback for the plugins "cache".
If you've set up a custom cache handler, eg xcache, reads won't hit the DB anyway (assuming xcache doesn't purge it), so this is unnecessary.

I see that now.

I run xcache but the tables is constantly hit anyways.

Huh...I just noticed something in my xcache admin page...the banned column isn't in the cached vars! WTF. Why would that be? I think I might have to give xcache more memory.