jess jess - 9 months ago 116
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 ?


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.