Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

In memory mysql table vs redis about insert and concurency 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?

like image 890
jess Avatar asked Jul 10 '16 14:07

jess


1 Answers

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.

like image 108
Bill Karwin Avatar answered Nov 01 '22 16:11

Bill Karwin