OhSeungJin/til

A collection of short articles about things I have learned

TIL (Today I Learned)

TIL is a collection of the things that I learned today. The contents can be anything.

---

Categories

• Benchmark
• DBMS
• Docker
• Git
• Go
• IPL
• Linux
• MariaDB
• MySQL
• NVRAM
• Oracle
• Percona
• PostgreSQL
• PMDK
• Predix
• RocksDB
• SSD
• Vim
• Zero

---

Benchmark

• How to install SysBench 0.5 on Ubuntu
• TPC-E vs. TPC-C 🇰🇷
• How to install BenchmarkSQL for Oracle
• How to install BenchmarkSQL for PostgreSQL
• How to install TPC-E on Ubuntu (for MySQL)
• How to install LinkBench on Ubuntu
• How to install TPC-H for Oracle

DBMS

• A comparison of buffer management algorithms between three DBMSs 🇰🇷
• Database Meets AI: A Survey 🇰🇷

Docker

• How to install MySQL and use a Docker volume on Docker
• How to use lb-mysql on IOD SSD
• Container networking 🇰🇷
• How to use Docker Hub 🇰🇷

Git

• Rename folders with git
• Modify previous commit messages
• Remove a file added in an older commit

Go

IPL

• Basic concept 🇰🇷
• Merge operation

Linux

• Direct I/O
• Synchronous I/O
• Extracts certain rows from a file
• AWK command
• How to control cores via bash command
• Copy and paste in tmux
• Extract multiple lines from a file
• How to add a kernel boot parameter
• perf and FlameGraph 🇰🇷
• How to create software RAID 0 with mdadm
• How to upgrade NVMe SSD firmware on Linux
• How to replace the string \n with an actual newline

MariaDB

• MariaDB S3 engine

MySQL

• Build and install the source code (5.6)
• Run MySQL
• The InnoDB recovery process
• Types of shutdown
• Crash recovery
• Redo
• Undo
• What happens when you UPDATE
• Change buffer
• MySQL connection error
• Log flush at commit
• innodb_flush_method
• Update root password in MySQL 5.7
• Build and install the source code (5.7)
• Build and install the source code (8.0)
• Useful MySQL performance tuning tips
• Curated contents about flushing mechanisms
• Monitoring InnoDB mutex and lock waits
• How InnoDB performs a checkpoint 🇰🇷
• InnoDB adaptive flushing 🇰🇷
• innodb_ruby 🇰🇷
• Punch hole 🇰🇷
• tpcc-mysql: Quick start guide
• Mid-point insertion strategy in MySQL/InnoDB
• All about InnoDB flushing 🇰🇷
• fallocate() and ftruncate() in MySQL/InnoDB
• Code related to log files
• InnoDB page splits
• MySQL/InnoDB page checksum

NVRAM

• Types of NVDIMM

Oracle

• Install Oracle 12c on Ubuntu
• How to clean UNDO tablespaces
• Solution to ORA-03113
• How to use Statspack
• How to resize the online redo log files
• Free buffer waits in Oracle
• Recovery after losing UNDO tablespace
• How to resize the SGA
• Understanding Oracle wait events 🇰🇷
• Oracle encoding error 🇰🇷
• How to add a datafile to a tablespace
• How to relocate files in Oracle

Percona

• Multi-threaded LRU flushing
• innodb_empty_free_list_algorithm
• Build and install the source code (5.6)
• Installing Percona Monitoring and Management (PMM) on Ubuntu

PMDK

• Building PMDK on Ubuntu

PostgreSQL

• PostgreSQL installation from source code
• Buffer management of PostgreSQL 🇰🇷
• PostgreSQL hit ratio

Predix

• Predix overview 🇰🇷

RocksDB

• How to use db_bench
• Write stalls 🇰🇷

SSD

• Basic operations
• FTL (Flash Translation Layer)
• Device initialization
• Logical block mapping
• Garbage collection
• TRIM
• Over-provisioning
• Writes
• Reads
• Concurrent reads and writes

Vim

• Search and replace

Zero

• Buffer Manager 🇰🇷

About

I borrowed this idea from thoughtbot/til and jbranchaud/til.