Understanding MySQL concurrency/isolation levels

I am working on the backend of an application that needs to protect an external API from too many requests per user per month. So I need to keep track of number of requests from each user. I have a lot of experience with concurrent programming but almost no experience with db management or MySQL,… Read More Understanding MySQL concurrency/isolation levels

Hekaton and Durability

Tech paper by Microsoft (Hekaton: SQL Server’s Memory-Optimized OLTP Engine) says Generating a log record only at transaction commit time is possible because Hekaton does not use write-ahead logging (WAL) to force log changes to durable storage before dirty data. Dirty data is never written to durable storage. Furthermore, Hekaton tries to group multiple log… Read More Hekaton and Durability