Deep Dive
2 分鐘 閱讀文 (大約 290 個字)

Redo Logs in Database Systems

用 ChatGPT 查了下 redo log 是怎麼用在 database crash or power loss 後的 recovery 裡，這邊做個小筆記統整一下：

  • 進行交易時，會依序進行以下步驟：
    1. 寫 redo log, 裡面記錄準備要做的改變，並記錄這個 transaction 的狀態為 in progress
    2. 把 redo log 紀錄的那些改變實際寫入 database files
    3. 把 redo log 的 transaction 狀態改為 committed
    4. 回傳 OK
繼續閱讀
Development Note
1 分鐘 閱讀文 (大約 163 個字)

PostgreSQL/MySQL local docker 開發的初始 setup

container run 起來之後：
PostgreSQL:

  1. docker exec -it {db-container-name} psql -U postgres
    • 以預設 user postgres 連進 DB
  2. create user {username} with password '{password}';
  3. create database {database_name} with owner {username};
繼續閱讀

分類

標籤雲

android array authentication binary search binary search tree binary tree bit manipulation breadth-first search database depth-first search distributed system django docker dokku dynamic programming graph greedy hash table heap heroku java jwt linked list matrix mysql paas package management pipenv postgresql python recursion shortest path simulation sliding window sorting stack string tree two pointers

最新文章

彙整

標籤

android 2
array 5
authentication 1
binary search 1
binary search tree 1
binary tree 6
bit manipulation 2
breadth-first search 5
database 2
depth-first search 9
distributed system 1
django 1
docker 3
dokku 1
dynamic programming 4
graph 2
greedy 1
hash table 6
heap 1
heroku 1
java 1
jwt 1
linked list 5
matrix 1
mysql 1
paas 1
package management 1
pipenv 1
postgresql 1
python 9
recursion 11
shortest path 1
simulation 1
sliding window 1
sorting 1
stack 2
string 4
tree 7
two pointers 3

最新文章

彙整

標籤

android 2
array 5
authentication 1
binary search 1
binary search tree 1
binary tree 6
bit manipulation 2
breadth-first search 5
database 2
depth-first search 9
distributed system 1
django 1
docker 3
dokku 1
dynamic programming 4
graph 2
greedy 1
hash table 6
heap 1
heroku 1
java 1
jwt 1
linked list 5
matrix 1
mysql 1
paas 1
package management 1
pipenv 1
postgresql 1
python 9
recursion 11
shortest path 1
simulation 1
sliding window 1
sorting 1
stack 2
string 4
tree 7
two pointers 3
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×