Question : I have a financial transaction that looks something like this (pseudo): begin select record for update update record(same […]
Tag: acid
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, […]
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 […]
Scalability question
Question : There is a DB {MySql} with 5 tables A, BIG, C, D, E. Their grow factor is about […]
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 […]
- 1
- 2