Search code examples
mysqlredisin-memory-database

In memory MySQL table vs Redis, about insert and concurrency performance


Since data is stored in memory in both cases, is it possible to have the same approximative insert/s and concurrency performance for both?

If not, why?


Solution

  • Concurrency for the MySQL MEMORY storage engine is not good. Like MyISAM, it can only do table-locks. So all concurrent threads doing inserts queue up against each other.