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
• MySQL
• Oracle
• Percona
• PostgreSQL
• PMDK
• Predix
• RocksDB
• SSD
• Vim

---

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

DBMS

• A Comparison of Buffer Management Algorithms between Three DBMSs 🇰🇷

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

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

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 🇰🇷

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

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

About

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