search

tanelpoder / blog-comments

Comment repo for tanelpoder.com blog
3 stars 0 forks source link

Testing Oracle's Use of Optane Persistent Memory, Part 1 - Low Latency Commits | Tanel Poder Consulting #31

Open utterances-bot opened 2 years ago

utterances-bot commented 2 years ago

Testing Oracle's Use of Optane Persistent Memory, Part 1 - Low Latency Commits | Tanel Poder Consulting

Part 1 [this post], part 2. Introduction Introduction My home lab Optane setup Testing Oracle commit latency OS-level view Oracle metrics New log writing behavior internals Summary There will be multiple posts in this series. In this post I will focus on Oracle’s use of Optane Persistent Memory (PMEM) for fast transaction log data flushes (persisting data from redo log buffer to “disk”). There’s more than just the log buffer flush on the critical path of a transaction commit, like messaging and wakeups between the Log Writer and the database connection (foreground) process, I will cover this in the next part. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

https://tanelpoder.com/posts/testing-oracles-use-of-optane-persistent-memory/

MaksimIvanovPerm commented 2 years ago

wonderful article. thank you very much.