TIL is a collection of the things that I learned today. The contents can be anything.
- 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 MySQL and use a Docker volume on Docker
- How to use lb-mysql on IOD SSD
- Container networking ๐ฐ๐ท
- How to use Docker Hub ๐ฐ๐ท
- Basic concept ๐ฐ๐ท
- Merge operation
- 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
- 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
- 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 ๐ฐ๐ท
- 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
- Predix overview ๐ฐ๐ท
- How to use db_bench
- Write stalls ๐ฐ๐ท
- Basic operations
- FTL (Flash Translation Layer)
- Device initialization
- Logical block mapping
- Garbage collection
- TRIM
- Over-provisioning
- Writes
- Reads
- Concurrent reads and writes
I borrowed this idea from thoughtbot/til and jbranchaud/til.