唔好傻啦prod咁樣做lock住晒啲table, 啲program run到一半run唔到仲死 一定係 dev 場試左冇問題先拎個sql上去直接run
含我呀2021-03-12 16:19:44
要去到 data recover 已經真係最嚴重既事故黎 好彩冇data lost都好啲,搞到人 data lost 既話應該都唔會再幫襯你
含我呀2021-03-12 16:20:16
仲可能要賠錢tim
含我呀2021-03-12 16:24:05
咁就要睇你個 db client / code library 點handle 啦, 但唔保證佢係會同你自動 end transaction, 咁既話會出現table lock, record lock既情況,要睇番lock record再 hard release有機會. 視乎lock type有機會連睇record都睇唔到