---
# System prepended metadata

title: DB Experiments

---

# DB Experiments

### TODO
1. Statistics Manager

## Exp 1. Remote Read Time Analysis

The execution time of Remote Read = 
- Waiting for cocurrency lock
- Waiting for previous conflict Txn
- The stating time of Txn on master/slave node is too early/late.

### Exp 1.1: 

The total time and the time of reading cache/storage of Remote Read on Hot Counter/Google Workload

Number Of RTE | Total Time of Remote Read on Master | Total Time of Remote Read on Slave | CCLock Time of Remote Read on Master | CCLock Time of Remote Read on Slave | Waiting Time for previous conflict Txn on Master | Waiting Time for previous conflict Txn on Slave | Average Total Time of Read-Only Txn | Average Total Time of R/W Txn
--------------|:-----:|-----:| ----:|------------------------
1000 | 02:10 |  500 |    0 | Dark Age building x 2
2000    | 02:40 |  800 |  200 | Feudal Age building x 2
4000  | 03:30 | 1000 |  800 | Castle Age building x 2


## Exp 2. Local Storage Locks Time Analysis
- Waiting for conservative locking protocol
- Read/Write rate impact on Time
- Local Read Percentage of all Read in single Transaction


## Exp 3. Txn related Time Analysis  


