jess jess - 1 year ago 254
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download