jess jess - 4 months ago 53
SQL Question

In memory mysql table vs redis about insert and concurency performance

Since in both cases data stored in memory , is possible to have aproximative same insert/s and concurency performance for both ? if not , why ?

Answer

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.