Question : Are non-unique indexes / indices covered under the Consistency clause in aCid? (same for other attributes of an […]
Tag: acid
How to configure read transactions to never cause other write serialization transactions to fail
Question : I am protecting critical transactions with application mutexes and SERIALIZABLE. I presume that this makes these operations as […]
Is Mysql ACID Compliant?
Question : Is Mysql not an ACID compliant according to Postgresql? In some blogs I see Mysql is not ACID […]
row locking within ACID transaction innodb
Question : I have a financial transaction that looks something like this (pseudo): begin select record for update update record(same […]
Can power failure rollback mysql innodb database of many days?
Question : I have an application running on a x86 system with MySQL InnoDB database. This application store many rows […]
Optimize queries that need to be 100% ACID compliant but can tolerate latency in persistence
Question : Introduction I’m writing a trading program in C++. The program involves having user balances and orderbooks. The orderbook […]
Postgres: Are secondary indexes included in ACID?
Question : Are non-unique indexes / indices covered under the Consistency clause in aCid? (same for other attributes of an […]
Can power failure rollback mysql innodb database of many days?
Question : I have an application running on a x86 system with MySQL InnoDB database. This application store many rows […]
Making sure balance field is always consistently updated with triggers
Question : This is my database schema, related to the problem. This is one of the triggers: CREATE OR REPLACE […]
Can Postgres timestamp be used to implement client side caching?
Question : If I have a pool of connections in a multi-threaded client sending out requests to the database server, […]
- 1
- 2