TIL is a collection of the things that I learned today. The contents can be anything.
- Arcus
- Benchmark
- CPU
- DBMS
- Docker
- Git
- Go
- GPU
- Hadoop
- IPL
- LightningDB
- Linux
- MariaDB
- MyRocks
- MySQL
- NVRAM
- Oracle
- Percona
- PostgreSQL
- PMDK
- Predix
- RocksDB
- Rockset
- Spark
- SSD
- TensorFlow
- Vim
- Zeppelin
- Zero
- How to install Arcus on Ubuntu 16.04
- How to install Arcus-memcached on Ubuntu 16.04
- Arcus persistence π°π·
- Separation of cmdlogbuf module into two modules π°π·
- tpcc-mysql: Quick start guide
- 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
- Summary of LinkBench for MySQL
- How to install YCSB for RocksDB
- How to install TPC-H for PostgreSQL
- AMD uProf π°π·
- A comparison of buffer management algorithms between three DBMSs π°π·
- Database Meets AI: A Survey π°π·
- 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 π°π·
- Rename folders with git
- Modify previous commit messages
- Remove a file added in an older commit
- Clone a single branch in Git
- 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
- How to replace the string
\nwith an actual newline - Redirect stderr to stdout
- How to use ftrace
- NVMe Device Driver
- Disk Readahead
- MariaDB S3 engine π°π·
- Build and install the source code (5.6)
- How to install SysBench 1.0 for MyRocks
- How to install tpcc-mysql for MyRocks
- How to monitor MyRocks
- 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 π°π·
- 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
- Doublewrite buffer
- Understanding InnoDB Lock Stats π°π·
- How to get the LBA of DWB
- InnoDB Flushing and Checkpoints π
- Secondary Index Search in InnoDB π
- MySQL Space Management π
- MySQL Buffer Management π
- Temporary Tablespaces π°π·
- Types of NVDIMM π°π·
- 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
- 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
- PostgreSQL installation from source code
- Buffer management of PostgreSQL π°π·
- PostgreSQL hit ratio
- Predix overview π°π·
- How to use db_bench
- Write stalls π°π·
- RocksDB detail π
- RocksDB compaction π
- Remote Compactions in RocksDB-Cloud π°π·
- How to install Spark 3 on Ubuntu
- How to install Spark RAPIDS
- How to run Spark Executor via command line
- Basic operations
- FTL (Flash Translation Layer)
- Device initialization
- Logical block mapping
- Garbage collection
- TRIM
- Over-provisioning
- Writes
- Reads
- Concurrent reads and writes
- How to get SMART information for NVMe
- Buffer Manager π°π·
I borrowed this idea from thoughtbot/til and jbranchaud/til.