RANDOMBLOGS (RSS)

smalldatum.blogspot.com


6. 11. 2024RocksDB on a big server: LRU vs hyperclock – smalldatum.blogspot.com
4. 11. 2024RocksDB benchmarks: small server, universal compaction – smalldatum.blogspot.com
1. 11. 2024Too many performance regressions for InnoDB in MySQL 8.0.29 and 8.0.30 – smalldatum.blogspot.com
29. 10. 2024Trying out Advanced MySQL – smalldatum.blogspot.com
24. 10. 2024RocksDB benchmarks: small server, leveled compaction – smalldatum.blogspot.com
23. 10. 2024InnoDB busy-wait loops changed in MySQL 8.0.30 – smalldatum.blogspot.com
21. 10. 2024The impact of PGO, LTO and more for MySQL on a small CPU: insert benchmark – smalldatum.blogspot.com
21. 10. 2024MySQL 8.0.40 does not fix the regressions I hoped it would fix – smalldatum.blogspot.com
17. 10. 2024The impact of PGO, LTO and more for MySQL on a small CPU – smalldatum.blogspot.com
16. 10. 2024Sysbench vs c-state on an AMD 4700u – smalldatum.blogspot.com
16. 10. 2024Code bloat vs memory system bloat : why is something getting slower – smalldatum.blogspot.com
13. 10. 2024Managing CPU frequency for AMD on Ubuntu 22.04 – smalldatum.blogspot.com
11. 10. 2024What does "perf stat" tell us about MySQL performance regressions on an AMD Threadripper CPU – smalldatum.blogspot.com
11. 10. 2024What does "perf stat" tell us about MySQL performance regressions on an Intel Xeon CPU – smalldatum.blogspot.com
9. 10. 2024What does "perf stat" tell us about MySQL performance regressions on a Ryzen 7 7735HS CPU – smalldatum.blogspot.com
7. 10. 2024What does "perf stat" tell us about MySQL performance regressions on a Ryzen 7 4700u CPU – smalldatum.blogspot.com
6. 10. 2024How to run MySQL with text in huge pages – smalldatum.blogspot.com
26. 9. 2024InnoDB code bloat in MySQL 8.0 makes me sad – smalldatum.blogspot.com
25. 9. 2024Configuration options that make writes faster or slower with MySQL and Postgres – smalldatum.blogspot.com
25. 9. 2024The size of the mysqld binary as a proxy for innovation – smalldatum.blogspot.com
23. 9. 2024Why do table scans get slower with MySQL from 5.6 to 8.0? – smalldatum.blogspot.com
20. 9. 2024Ubuntu 22.04, Linux kernels and me – smalldatum.blogspot.com
14. 9. 2024MySQL and Postgres vs the Insert Benchmark on a large server – smalldatum.blogspot.com
13. 9. 2024HTAP benchmarks: trying out HATrick with MySQL – smalldatum.blogspot.com
12. 9. 2024MySQL + InnoDB vs sysbench on a large server – smalldatum.blogspot.com
12. 9. 2024InnoDB, compiler options and sysbench – smalldatum.blogspot.com
9. 9. 2024Postgres 17rc1 vs sysbench on small & large servers: looking great – smalldatum.blogspot.com
5. 9. 2024RocksDB benchmarks: cached database – smalldatum.blogspot.com
4. 9. 2024Postgres 17beta3 vs sysbench on a large server: looking great – smalldatum.blogspot.com
3. 9. 2024Trying out a dedicated server from Hetzner – smalldatum.blogspot.com
28. 8. 2024Postgres 17beta3 vs the Insert Benchmark on a medium server:: looking good – smalldatum.blogspot.com
17. 8. 2024Postgres 17beta3 vs sysbench on a small server: looking good – smalldatum.blogspot.com
12. 8. 2024Postgres 17beta3 vs sysbench on a medium server: looking good – smalldatum.blogspot.com
8. 8. 2024MySQL regressions: delete vs InnoDB – smalldatum.blogspot.com
8. 8. 2024MySQL regressions: update-nonindex vs InnoDB – smalldatum.blogspot.com
8. 8. 2024MySQL regressions: skip_concurrency_ticket – smalldatum.blogspot.com
8. 8. 2024MySQL regressions: binlog_log_row – smalldatum.blogspot.com
26. 7. 2024Sysbench on a medium server: MariaDB is faster than MySQL – smalldatum.blogspot.com
22. 7. 2024Searching for regressions in RocksDB with db_bench: part 2 – smalldatum.blogspot.com
22. 7. 2024MyRocks vs InnoDB on cached sysbench: revised – smalldatum.blogspot.com
19. 7. 2024MySQL 8.0.38 vs cached Sysbench on a medium server – smalldatum.blogspot.com
18. 7. 2024Searching for regressions in RocksDB with db_bench – smalldatum.blogspot.com
17. 7. 2024Make MyRocks 2X faster by changing the CPU frequency governor – smalldatum.blogspot.com
15. 7. 2024MySQL 8.0.38 vs the Insert Benchmark on a medium server – smalldatum.blogspot.com
12. 7. 2024Postgres 17beta2 vs the Insert Benchmark on a medium server:: looking good – smalldatum.blogspot.com
8. 7. 2024MyRocks vs InnoDB on cached sysbench – smalldatum.blogspot.com
8. 7. 2024Postgres 17beta2 vs sysbench: looking good – smalldatum.blogspot.com
3. 7. 2024The journey to explain performance regressions in MySQL – smalldatum.blogspot.com
2. 7. 2024The impact of PGO for MySQL – smalldatum.blogspot.com
27. 6. 2024The impact of link time optimization for MySQL with sysbench – smalldatum.blogspot.com
26. 6. 2024A simple test to measure CPU per IO – smalldatum.blogspot.com
24. 6. 2024The Insert Benchmark: Postgres 17beta1, large server, IO-bound – smalldatum.blogspot.com
19. 6. 2024Stalls from TRIM after deleting a lot of data – smalldatum.blogspot.com
15. 6. 2024The Insert Benchmark vs MyRocks and InnoDB, small server, IO-bound database – smalldatum.blogspot.com
12. 6. 2024The Insert Benchmark vs MyRocks and InnoDB, small server, cached database – smalldatum.blogspot.com
11. 6. 2024MyRocks and InnoDB vs sysbench on a small server – smalldatum.blogspot.com
10. 6. 2024The Insert Benchmark, Postgres 17beta1, a large server and cached database – smalldatum.blogspot.com
8. 6. 2024Postgres 17beta1 vs sysbench on a large server – smalldatum.blogspot.com
6. 6. 2024Postgres 17beta1 vs sysbench on a small server – smalldatum.blogspot.com
3. 6. 2024Does disabling full_page_writes reduce variance for Postgres with a cached Insert Benchmark – smalldatum.blogspot.com
28. 5. 2024The Insert Benchmark, Postgres 17beta1, a small server and cached database – smalldatum.blogspot.com
24. 5. 2024Sysbench on a new small server: MariaDB vs MySQL – smalldatum.blogspot.com
24. 5. 2024Space vs CPU tradeoffs with universal compaction in RocksDB – smalldatum.blogspot.com
14. 5. 2024The Insert Benchmark: MariaDB, MySQL, new small server, cached workload, some concurrency – smalldatum.blogspot.com
21. 4. 2024The Insert Benchmark: MariaDB, MySQL, small server, cached workload, some concurrency – smalldatum.blogspot.com
18. 4. 2024Changes to managing turbo boost in Ubuntu 22.04 and Linux 6.5 – smalldatum.blogspot.com
13. 4. 2024The Insert Benchmark: MariaDB, MySQL, small server, cached workload – smalldatum.blogspot.com
12. 4. 2024Sysbench on a (less) small server: MariaDB and MySQL – smalldatum.blogspot.com
4. 4. 2024Sysbench on a small server: MariaDB and MySQL – smalldatum.blogspot.com
18. 3. 2024Comparing Postgres and MySQL on the insert benchmark with a small server – smalldatum.blogspot.com
18. 3. 2024Yet another Insert Benchmark result: MyRocks, MySQL and a small server – smalldatum.blogspot.com
18. 3. 2024Yet another Insert Benchmark result: MySQL, InnoDB and a small server – smalldatum.blogspot.com
17. 3. 2024Trying to tune Postgres for the Insert Benchmark: small server – smalldatum.blogspot.com
19. 2. 2024Perf regressions in Postgres from 9.0 to 16 with sysbench and a small server – smalldatum.blogspot.com
17. 2. 2024Perf regressions in MySQL from 5.6.21 to 8.0.36 using sysbench and a small server – smalldatum.blogspot.com
12. 2. 2024It wasn't a performance regression in Postgres 14 – smalldatum.blogspot.com
1. 2. 2024Updated Insert benchmark: InnoDB/MySQL 5.6, 5.7 and 8.0, small server, IO-bound database – smalldatum.blogspot.com
1. 2. 2024Updated Insert benchmark: Postgres 9.x to 16.x, large server, cached database – smalldatum.blogspot.com
28. 1. 2024Explaining a performance regression in Postgres 14 – smalldatum.blogspot.com
27. 1. 2024Updated Insert benchmark: Postgres 9.x to 16.x, small server, IO-bound database – smalldatum.blogspot.com
25. 1. 2024Updated Insert benchmark: InnoDB/MySQL 5.6, 5.7 and 8.0, small server, cached database – smalldatum.blogspot.com
24. 1. 2024Updated Insert benchmark: Postgres 9.x to 16.x, small server, cached database, v3 – smalldatum.blogspot.com
17. 1. 2024Updated Insert benchmark: MyRocks 5.6 and 8.0, medium server, IO-bound database, v2 – smalldatum.blogspot.com
12. 1. 2024Updated Insert benchmark: MyRocks 5.6 and 8.0, small(est) server, cached database, v2 – smalldatum.blogspot.com
12. 1. 2024Updated Insert benchmark: MyRocks 5.6 and 8.0, small server, cached database, v2 – smalldatum.blogspot.com
12. 1. 2024Updated Insert benchmark: MyRocks 5.6 and 8.0, medium server, cached database, v2 – smalldatum.blogspot.com
10. 1. 2024Updated Insert benchmark: Postgres 9.x to 16.x, small server, cached database, v2 – smalldatum.blogspot.com
8. 1. 2024Explaining changes in RocksDB performance for IO-bound workloads – smalldatum.blogspot.com
4. 1. 2024RocksDB 8.x benchmarks: large server, IO-bound – smalldatum.blogspot.com
4. 1. 2024innodb_log_writer_threads and the Insert Benchmark – smalldatum.blogspot.com
2. 1. 2024Updated Insert benchmark: MyRocks 5.6 and 8.0, small server, cached database – smalldatum.blogspot.com
2. 1. 2024Updated Insert benchmark: Postgres 9.x to 16.x, small server, cached database – smalldatum.blogspot.com
2. 1. 2024Updated Insert benchmark: MyRocks 5.6 and 8.0, medium/large server, cached database – smalldatum.blogspot.com
1. 1. 2024Updated Insert benchmark: MyRocks 5.6 and 8.0, medium server, cached database – smalldatum.blogspot.com
1. 1. 2024Updated Insert benchmark: InnoDB, MySQL 5.6 to 8.0, medium server, cached database – smalldatum.blogspot.com
1. 1. 2024Updated Insert benchmark: MyRocks 5.6 and 8.0, large server, cached database – smalldatum.blogspot.com
31. 12. 2023Updated Insert benchmark: InnoDB, MySQL 5.6 to 8.0, large server, cached database – smalldatum.blogspot.com
31. 12. 2023Updates for the Insert Benchmark, December 2023 – smalldatum.blogspot.com
29. 12. 2023RocksDB 8.x benchmarks: large server, cached database – smalldatum.blogspot.com
24. 12. 2023Create InnoDB indexes 2X faster with this simple trick – smalldatum.blogspot.com
19. 12. 2023What is the cost of the performance schema in MySQL 5.7 and 8.0: small server, cached database, simple queries – smalldatum.blogspot.com
18. 12. 2023Perf regressions in MySQL from 5.6 to 8.0 using the Insert Benchmark and a small server, Dec23: part 1 – smalldatum.blogspot.com
27. 11. 2023Explaining changes in MySQL performance via hardware perf counters: part 4 – smalldatum.blogspot.com
27. 11. 2023Explaining changes in MySQL performance via hardware perf counters: part 3 – smalldatum.blogspot.com
27. 11. 2023Explaining changes in MySQL performance via hardware perf counters: part 2 – smalldatum.blogspot.com
27. 11. 2023Explaining changes in MySQL performance via hardware perf counters: part 1 – smalldatum.blogspot.com
16. 11. 2023Checking RocksDB 8.x for performance regressions on a large server, part 2 – smalldatum.blogspot.com
15. 11. 2023Perf regressions in MySQL from 5.6.21 to 8.0.34 using the Insert Benchmark and a medium server, part 1 – smalldatum.blogspot.com
8. 11. 2023Fixing bug 109595 makes MySQL almost 4X faster on the Insert Benchmark – smalldatum.blogspot.com
7. 11. 2023Checking RocksDB 4.x thru 8.x for performance regressions on a small server: cached workload – smalldatum.blogspot.com
7. 11. 2023Checking RocksDB 4.x thru 8.x for performance regressions on a small server: IO-bound with buffered IO – smalldatum.blogspot.com
7. 11. 2023Checking RocksDB 4.x thru 8.x for performance regressions on a small server: IO-bound with O_DIRECT – smalldatum.blogspot.com
6. 11. 2023Debugging perf changes in RocksDB 8.6 on a small server – smalldatum.blogspot.com
31. 10. 2023Postgres vs MySQL: the impact of CPU overhead on performance – smalldatum.blogspot.com
31. 10. 2023Perf regressions in MySQL from 5.6.21 to 8.0.35 using sysbench and a medium server, part 5 – smalldatum.blogspot.com
31. 10. 2023Perf regressions in MySQL from 5.6.21 to 8.0.35 using sysbench and a medium server, part 4 – smalldatum.blogspot.com
31. 10. 2023Perf regressions in MySQL from 5.6.21 to 8.0.35 using sysbench and a medium server, part 3 – smalldatum.blogspot.com
31. 10. 2023Perf regressions in MySQL from 5.6.21 to 8.0.35 using sysbench and a medium server, part 2 – smalldatum.blogspot.com
30. 10. 2023Perf regressions in MySQL from 5.6.21 to 8.0.35 using sysbench and a medium server, part 1 – smalldatum.blogspot.com
23. 10. 2023Perf regressions for MySQL/InnoDB vs the Insert Benchmark: 8.0.28 to 8.0.30 – smalldatum.blogspot.com
20. 10. 2023Checking RocksDB 7.x and 8.x for performance regressions on a large server – smalldatum.blogspot.com
10. 10. 2023Variance in RocksDB benchmarks – smalldatum.blogspot.com
9. 10. 2023Perf regressions in MySQL from 5.6.21 to 8.0.34 using the Insert Benchmark and a small server, part 2 – smalldatum.blogspot.com
2. 10. 2023Variance in peak RSS with jemalloc 5.2.1, part 2 – smalldatum.blogspot.com
2. 10. 2023Postgres versions 11, 12, 13, 14, 15, and 16 vs sysbench with a medium server – smalldatum.blogspot.com
26. 9. 2023Trying out OrioleDB – smalldatum.blogspot.com
26. 9. 2023Checking MyRocks 5.6 for regressions with the Insert Benchmark and a large server, revisited – smalldatum.blogspot.com
25. 9. 2023Checking Postgres for perf regressions from 11.21 to 16.0 with sysbench and a small server – smalldatum.blogspot.com
25. 9. 2023Variance in peak RSS with jemalloc 5.2.1 – smalldatum.blogspot.com
23. 9. 2023Postgres 16.0, sysbench and a medium server – smalldatum.blogspot.com
23. 9. 2023Postgres 16.0, sysbench and a small server – smalldatum.blogspot.com
22. 9. 2023Hello world! – smalldatum.blogspot.com
19. 9. 2023Perf regressions in MySQL from 5.6.21 to 8.0.34 using the Insert Benchmark and a small server – smalldatum.blogspot.com
18. 9. 2023Postgres 16.0 vs the Insert Benchmark on a medium server – smalldatum.blogspot.com
18. 9. 2023Postgres 16.0 vs the Insert Benchmark on a small server – smalldatum.blogspot.com
12. 9. 2023Perf regressions in MySQL from 5.6.21 to 8.0.34 using sysbench and a small server – smalldatum.blogspot.com
11. 9. 2023Checking jemalloc versions for RSS regressions with MyRocks and the Insert Benchmark – smalldatum.blogspot.com
6. 9. 2023Chasing a performance regression in MyRocks vs the Insert Benchmark – smalldatum.blogspot.com
2. 9. 2023Postgres 16, sysbench and a small server – smalldatum.blogspot.com
27. 8. 2023RocksDB and glibc malloc don't play nice together – smalldatum.blogspot.com
26. 8. 2023Postgres 16 beta3 and the Insert Benchmark on a small server – smalldatum.blogspot.com
25. 8. 2023Checking MyRocks 5.6 for regressions with the Insert Benchmark and a large server – smalldatum.blogspot.com
23. 8. 2023Checking MyRocks 5.6 for regressions with sysbench and a small server, part 2 – smalldatum.blogspot.com
22. 8. 2023The impact from hyperthreading for RocksDB db_bench on a medium server – smalldatum.blogspot.com
22. 8. 2023Checking MyRocks 5.6 for regressions with sysbench and a medium server, part 3 – smalldatum.blogspot.com
17. 8. 2023Checking MyRocks 5.6 for regressions with the Insert Benchmark and a small server, part 2 – smalldatum.blogspot.com
17. 8. 2023Checking MyRocks 5.6 for regressions with the Insert Benchmark and a medium server, part 2 – smalldatum.blogspot.com
16. 8. 2023Tuning Postgres 15.2 and 15.3 for the Insert Benchmark on a small server – smalldatum.blogspot.com
16. 8. 2023Postgres 16 beta3 and the Insert Benchmark on a medium server – smalldatum.blogspot.com
15. 8. 2023Compiling all MySQL 5.7 versions on modern Ubuntu – smalldatum.blogspot.com
15. 8. 2023Tuning MyRocks to reduce MVCC GC debt – smalldatum.blogspot.com
14. 8. 2023InnoDB vs the Insert Benchmark on a medium server, includes Percona Server – smalldatum.blogspot.com
12. 8. 2023Tuning InnoDB for the Insert Benchmark on a small server – smalldatum.blogspot.com
12. 8. 2023One path for an open source database project – smalldatum.blogspot.com
10. 8. 2023Checking MyRocks 5.6 for regressions with the Insert Benchmark and a medium server – smalldatum.blogspot.com
10. 8. 2023Tuning Postgres and the Insert Benchmark, round 6 – smalldatum.blogspot.com
8. 8. 2023Checking MyRocks 5.6 for regressions with the Insert Benchmark and a small server – smalldatum.blogspot.com
4. 8. 2023Tuning InnoDB for the Insert Benchmark on a large server – smalldatum.blogspot.com
26. 7. 2023Tuning MyRocks for the Insert Benchmark on a large server – smalldatum.blogspot.com
26. 7. 2023Tuning MyRocks for the Insert Benchmark on a small server – smalldatum.blogspot.com
26. 7. 2023How do you limit MVCC GC debt? – smalldatum.blogspot.com
25. 7. 2023Insert benchmark perf over time for MyRocks 5.6 on a large server – smalldatum.blogspot.com
18. 7. 2023MyRocks, InnoDB and Postgres as a queue – smalldatum.blogspot.com
17. 7. 2023Tuning InnoDB for the insert benchmark on a medium server, part 2 – smalldatum.blogspot.com
17. 7. 2023my.cnf options that influence create index performance – smalldatum.blogspot.com
16. 7. 2023Keeping up with the SQL DBMS market – smalldatum.blogspot.com
14. 7. 2023Insert+delete benchmark, medium server and MyRocks, part 2 – smalldatum.blogspot.com
14. 7. 2023Tuning Postgres and the new insert benchmark on a small server, part 2 – smalldatum.blogspot.com
11. 7. 2023Tuning Postgres and the new insert benchmark, round 5 – smalldatum.blogspot.com
10. 7. 2023Write stalls with RocksDB from a too small block cache and/or too many block cache shards – smalldatum.blogspot.com
7. 7. 2023innodb_page_cleaners, part 2: big server, database not cached – smalldatum.blogspot.com
6. 7. 2023Fun with innodb_page_cleaners – smalldatum.blogspot.com
6. 7. 2023Dynamic leveled compaction in RocksDB – smalldatum.blogspot.com
27. 6. 2023Insert+delete benchmark, medium server and MyRocks – smalldatum.blogspot.com
22. 6. 2023Universal Compaction in RocksDB and me – smalldatum.blogspot.com
14. 6. 2023Tuning Postgres and the new insert benchmark, round 4 – smalldatum.blogspot.com
13. 6. 2023Tuning Postgres and the new insert benchmark on a small server – smalldatum.blogspot.com
13. 6. 2023Tuning InnoDB for the insert benchmark on a medium server – smalldatum.blogspot.com
12. 6. 2023Insert+delete benchmark: small server, MyRocks and IO-bound – smalldatum.blogspot.com
7. 6. 2023Create index, MyRocks and memory – smalldatum.blogspot.com
1. 6. 2023Tuning Postgres and the new insert benchmark, round 3 – smalldatum.blogspot.com
1. 6. 2023Tuning Postgres and the new insert benchmark, round 2 – smalldatum.blogspot.com
30. 5. 2023Insert+delete benchmark, small server and MyRocks – smalldatum.blogspot.com
30. 5. 2023Updates to the insert benchmark – smalldatum.blogspot.com
28. 5. 2023Postgres 16beta1 looks good vs sysbench – smalldatum.blogspot.com
23. 5. 2023Tuning Postgres and the new insert benchmark – smalldatum.blogspot.com
23. 5. 2023Compiling all releases of MySQL 8.0 – smalldatum.blogspot.com
18. 5. 2023Summary of another round of benchmarks – smalldatum.blogspot.com
18. 5. 2023The Insert Benchmark, MySQL 5.6, 5.7, 8.0 and a small server – smalldatum.blogspot.com
16. 5. 2023Understanding the insert benchmark results: variance and write stalls – smalldatum.blogspot.com
16. 5. 2023The Insert Benchmark, MySQL 5.6, 5.7, 8.0 and a big server – smalldatum.blogspot.com
4. 5. 2023The insert benchmark, Postgres versions 11 to 15, a big server – smalldatum.blogspot.com
4. 5. 2023The insert benchmark, Postgres versions 11 to 15, a small server – smalldatum.blogspot.com
26. 4. 2023Time to compile Postgres, MySQL and MyRocks – smalldatum.blogspot.com
26. 4. 2023Perf regressions in MySQL/InnoDB, a big server & sysbench, part 2 – smalldatum.blogspot.com
26. 4. 2023Perf regressions in MySQL/InnoDB, a big server & sysbench – smalldatum.blogspot.com
24. 4. 2023Revisiting perf regressions in Postgres, a larger server and sysbench, part 2 – smalldatum.blogspot.com
24. 4. 2023Revisiting perf regressions in Postgres, a larger server and sysbench – smalldatum.blogspot.com
17. 4. 2023Perf regressions in MyRocks with the insert benchmark – smalldatum.blogspot.com
13. 4. 2023The case of the missing NVMe device – smalldatum.blogspot.com
12. 4. 2023GC for MVCC - MyRocks, InnoDB and Postgres – smalldatum.blogspot.com
7. 4. 2023MyRocks vs InnoDB with sysbench – smalldatum.blogspot.com
3. 4. 2023Impact of writes on read performance – smalldatum.blogspot.com
29. 3. 2023Perf regressions in MyRocks, a larger server and sysbench – smalldatum.blogspot.com
29. 3. 2023Perf regressions in MyRocks, a small server & sysbench – smalldatum.blogspot.com
28. 3. 2023Perf regressions in MySQL/InnoDB, a small server & sysbench – smalldatum.blogspot.com
27. 3. 2023Perf regressions in Postgres, a larger server and sysbench – smalldatum.blogspot.com
27. 3. 2023Searching for performance regressions in Postgres – smalldatum.blogspot.com
27. 3. 2023How I run sysbench – smalldatum.blogspot.com
17. 3. 2023Huge pages with Postgres & InnoDB: better perf, but a bit more work – smalldatum.blogspot.com
15. 3. 2023Compiler optimizations, MyRocks and a small server – smalldatum.blogspot.com
1. 3. 2023Adventures in compiling MySQL: RelWithDebInfo vs Release – smalldatum.blogspot.com
22. 2. 2023Can RocksDB use all of the IOPs from fast storage? – smalldatum.blogspot.com
21. 2. 2023Sysbench, Arm & x86, public cloud – smalldatum.blogspot.com
19. 2. 2023I'd prefer not to update firmware for Samsung SSD on Linux – smalldatum.blogspot.com
16. 2. 2023CMAKE_BUILD_TYPE: RelWithDebInfo vs Release for MySQL – smalldatum.blogspot.com
15. 2. 2023Adventures in compiling MySQL – smalldatum.blogspot.com
13. 2. 2023Sysbench with huge pages for Postgres & InnoDB – smalldatum.blogspot.com
8. 2. 2023The value of the InnoDB change buffer – smalldatum.blogspot.com
2. 2. 2023RocksDB microbenchmarks: compilers, Arm and x86 – smalldatum.blogspot.com
1. 2. 2023Statistical rigor and database benchmarks – smalldatum.blogspot.com
23. 1. 2023The insert benchmark on ARM and x86 cloud servers – smalldatum.blogspot.com
17. 1. 2023clang, gcc & compiler flags vs the insert benchmark & ARM – smalldatum.blogspot.com
5. 1. 2023Insert benchmark on an 8-core AMD server – smalldatum.blogspot.com
3. 1. 2023RocksDB microbenchmarks: crc32c, xxh3 and lz4 uncompress – smalldatum.blogspot.com
2. 1. 2023Variance in RocksDB benchmarks on cloud HW – smalldatum.blogspot.com
2. 12. 2022Benchmark(et)ing RocksDB vs SplinterDB – smalldatum.blogspot.com
30. 11. 2022Compiling MySQL 5.6 & 5.7 on Ubuntu 22.04 – smalldatum.blogspot.com
29. 11. 2022Insert benchmark: Postgres, InnoDB and MyRocks with low concurrency – smalldatum.blogspot.com
19. 11. 2022SSD read response time: raw device vs a filesystem – smalldatum.blogspot.com
31. 10. 2022s/optimal/better/g - on reviewing conference papers – smalldatum.blogspot.com
26. 10. 2022Quantifying storage on Linux – smalldatum.blogspot.com
25. 10. 2022Small servers for performance testing, v4 – smalldatum.blogspot.com
24. 10. 2022Early lock release and InnoDB – smalldatum.blogspot.com
19. 10. 2022Hyping the hyper clock cache in RocksDB – smalldatum.blogspot.com
18. 10. 2022Reasons for writeback with an update-in-place B-Tree – smalldatum.blogspot.com
29. 9. 2022Magma, a new storage engine for Couchbase – smalldatum.blogspot.com
28. 9. 2022Storage engines, efficiency and large documents, rows, objects – smalldatum.blogspot.com
20. 9. 2022Understanding some jemalloc stats for RocksDB – smalldatum.blogspot.com
15. 9. 2022Configuring the RocksDB block cache – smalldatum.blogspot.com
15. 9. 2022How to ask questions – smalldatum.blogspot.com
14. 9. 2022Using SPIN to validate the InnoDB read-write lock – smalldatum.blogspot.com
23. 8. 2022How I do RocksDB performance tests, part 2 – smalldatum.blogspot.com
19. 8. 2022When is a secondary index-only query not index-only for InnoDB and Postgres? – smalldatum.blogspot.com
18. 8. 2022How I do performance tests for RocksDB – smalldatum.blogspot.com
22. 7. 2022The impact of max_background_threads, part 2 – smalldatum.blogspot.com
21. 7. 2022The impact of max_background_jobs on write throughput for RocksDB – smalldatum.blogspot.com
28. 6. 2022Setting up a server on GCP – smalldatum.blogspot.com
24. 6. 2022Fixing mmap performance for RocksDB – smalldatum.blogspot.com
16. 6. 2022Insert Benchmark for Postgres 12, 13, 14 and 15: part 2 – smalldatum.blogspot.com
16. 6. 2022Insert Benchmark for Postgres 12, 13, 14 and 15 – smalldatum.blogspot.com
26. 5. 2022The benefit of lz4 and zstd for Postgres WAL compression – smalldatum.blogspot.com
26. 5. 2022Defining "X has too many options" – smalldatum.blogspot.com
10. 5. 2022RocksDB internals: LRU – smalldatum.blogspot.com
10. 5. 2022Performance bugs: p50 vs p99 – smalldatum.blogspot.com
10. 5. 2022Using mmap with RocksDB – smalldatum.blogspot.com
5. 5. 2022To compress or not compress – smalldatum.blogspot.com
25. 4. 2022clang vs crc32c in RocksDB – smalldatum.blogspot.com
5. 4. 2022Becoming less confused about perf record – smalldatum.blogspot.com
3. 4. 2022Examples of the RocksDB trivial move optimization – smalldatum.blogspot.com
1. 4. 2022One problem with flamegraphs – smalldatum.blogspot.com
9. 3. 2022The db_bench mixgraph benchmark – smalldatum.blogspot.com
24. 2. 2022RocksDB externals: avoiding problems with db_bench --seed – smalldatum.blogspot.com
24. 2. 2022RocksDB externals: the series – smalldatum.blogspot.com
15. 2. 2022RocksDB internals: trivial move and benchmarks – smalldatum.blogspot.com
10. 2. 2022RocksDB internals: trivial move – smalldatum.blogspot.com
8. 2. 2022RocksDB internals: the series – smalldatum.blogspot.com
8. 2. 2022RocksDB internals: prefetch and/or readahead – smalldatum.blogspot.com
1. 2. 2022RocksDB internals: write rate limiter – smalldatum.blogspot.com
28. 1. 2022RocksDB internals: compaction stall counters – smalldatum.blogspot.com
27. 1. 2022RocksDB internals: intra-L0 compaction – smalldatum.blogspot.com
26. 1. 2022RocksDB internals: bytes pending compaction – smalldatum.blogspot.com
3. 12. 2021Summarizing the different implementations of tiered compaction – smalldatum.blogspot.com
1. 12. 2021Sysbench: MySQL 5.6, 5.7 & 8.0 on a small server – smalldatum.blogspot.com
1. 12. 2021Sysbench: PostgreSQL 12, 13 and 14 on a small server – smalldatum.blogspot.com
30. 11. 2021Insert benchmark: MySQL 5.6, 5.7 & 8.0 on a small server – smalldatum.blogspot.com
30. 11. 2021Insert benchmark: PostgreSQL 12, 13 and 14 on a small server – smalldatum.blogspot.com
21. 11. 2021Welll actually, LSM and B-tree – smalldatum.blogspot.com
13. 11. 2021DeWitt Clause vs the public cloud – smalldatum.blogspot.com
13. 10. 2021Compatible with MySQL or Postgres? – smalldatum.blogspot.com
1. 10. 2021The other way to compress InnoDB: outsource it – smalldatum.blogspot.com
29. 9. 2021Automating memory management in a DBMS – smalldatum.blogspot.com
28. 9. 2021Developer experience, what about the other stakeholders? – smalldatum.blogspot.com
21. 9. 2021Review of DiffKV – smalldatum.blogspot.com
14. 8. 2021Happy 15th to Percona – smalldatum.blogspot.com
11. 8. 2021On storage engines – smalldatum.blogspot.com
13. 3. 2021Sequential IO and an LSM tree – smalldatum.blogspot.com
7. 3. 2021How to submit a PR for RocksDB – smalldatum.blogspot.com
26. 2. 2021More on read-only benchmarks and an LSM – smalldatum.blogspot.com
24. 2. 2021Read-only benchmarks with an LSM are complicated – smalldatum.blogspot.com
18. 2. 2021Still not finding CPU regressions in RocksDB – smalldatum.blogspot.com
15. 2. 2021Not finding CPU regressions across RocksDB releases – smalldatum.blogspot.com
22. 1. 2021Summary of my search for regressions with MySQL & Postgres – smalldatum.blogspot.com
21. 1. 2021Sysbench: MySQL vs Postgres for an IO-bound workload – smalldatum.blogspot.com
20. 1. 2021Sysbench: IO-bound and Postgres – smalldatum.blogspot.com
20. 1. 2021Sysbench: IO-bound and InnoDB – smalldatum.blogspot.com
19. 1. 2021Sysbench: in-memory scans for MyRocks, InnoDB and Postgres – smalldatum.blogspot.com
19. 1. 2021Sysbench: IO-bound and MyRocks – smalldatum.blogspot.com
17. 1. 2021Insert Benchmark: InnoDB – smalldatum.blogspot.com
17. 1. 2021Insert Benchmark: Postgres is still boring – smalldatum.blogspot.com
16. 1. 2021Insert benchmark: MyRocks – smalldatum.blogspot.com
13. 1. 2021T is for Tuning amplification – smalldatum.blogspot.com
11. 1. 2021Sysbench: Postgres vs MySQL and the impact of regressions – smalldatum.blogspot.com
10. 1. 2021Sysbench: in-memory Postgres, Postgres is boring – smalldatum.blogspot.com
9. 1. 2021Sysbench: in-memory InnoDB, MySQL 5.6, 5.7 & 8.0, take 3 – smalldatum.blogspot.com
8. 1. 2021Sysbench: in-memory MyRocks, MySQL 5.6 & 8.0, take 3 – smalldatum.blogspot.com
5. 1. 2021Sysbench: in-memory MyRocks, MySQL 5.6 & 8.0, take 2 – smalldatum.blogspot.com
4. 1. 2021Sysbench: in-memory InnoDB, MySQL 5.6 & 8.0, take 2 – smalldatum.blogspot.com
30. 12. 2020Sysbench: IO-bound InnoDB in MySQL 5.6, 5.7 and 8.0 – smalldatum.blogspot.com
30. 12. 2020Sysbench: in-memory InnoDB in MySQL 5.6, 5.7 and 8.0 – smalldatum.blogspot.com
30. 12. 2020Sysbench: IO-bound MyRocks in 5.6 vs 8.0 – smalldatum.blogspot.com
30. 12. 2020Sysbench: MyRocks in MySQL 5.6 vs 8.0 – smalldatum.blogspot.com
4. 12. 2020Tuning for the Insert Benchmark: Postgres, InnoDB & MyRocks – smalldatum.blogspot.com
4. 12. 2020Tuning for the Insert Benchmark: Postgres – smalldatum.blogspot.com
4. 12. 2020Tuning for the Insert Benchmark: MyRocks – smalldatum.blogspot.com
4. 12. 2020Tuning for the Insert Benchmark: InnoDB – smalldatum.blogspot.com
30. 11. 2020Blind-writes and an LSM – smalldatum.blogspot.com
6. 11. 2020Max row per group, sad answers only – smalldatum.blogspot.com
26. 10. 2020InnoDB, fsync and fdatasync - reducing commit latency – smalldatum.blogspot.com
26. 10. 2020Overloading the meaning of "copy-on-write" for index structures – smalldatum.blogspot.com
23. 10. 2020LSM local secondary indexes (LSM LSI) – smalldatum.blogspot.com
21. 10. 2020Self-aware DBMS, RID-lists for LSM trees – smalldatum.blogspot.com
21. 10. 2020MyRocks in MySQL 5.6 and 8.0 – smalldatum.blogspot.com
15. 10. 2020Better vs optimal – smalldatum.blogspot.com
14. 10. 2020Comments on: The Unwritten Contract of Solid State Drives – smalldatum.blogspot.com
9. 10. 2020MySQL 8 is greater with MyRocks – smalldatum.blogspot.com
8. 10. 2020Comments on: Optimizing Databases by Learning Hidden Parameters of Solid State Drives – smalldatum.blogspot.com
17. 9. 2020Performance results and DBMS experts – smalldatum.blogspot.com
4. 9. 2020When is it OK to lose a commit? – smalldatum.blogspot.com
20. 8. 2020iostat output format changes again – smalldatum.blogspot.com
17. 8. 2020Review of PrismDB: Read-aware LSM Tree for Heterogeneous Storage – smalldatum.blogspot.com
6. 8. 2020Over fetching in a DBMS – smalldatum.blogspot.com
23. 7. 2020Sustaining high insert rates despite secondary indexes – smalldatum.blogspot.com
22. 7. 2020Postgres, vacuum and the insert benchmark – smalldatum.blogspot.com
18. 7. 2020Review of -- TimescaleDB: SQL made scalable for time-series data – smalldatum.blogspot.com
16. 7. 2020Indexing and write-heavy workloads – smalldatum.blogspot.com
15. 7. 2020Review: The Design of the Postgres Storage System – smalldatum.blogspot.com
13. 7. 2020Updates for the insert benchmark – smalldatum.blogspot.com
1. 7. 2020Something changed for the better in create index between MySQL 8.0.18 and 8.0.20 – smalldatum.blogspot.com
30. 6. 2020Java GC and Linkbench – smalldatum.blogspot.com
18. 5. 2020Avoiding reads in write-optimized index structures – smalldatum.blogspot.com
10. 4. 2020Reviving mstat – smalldatum.blogspot.com
7. 4. 2020Creating performance reports – smalldatum.blogspot.com
31. 3. 2020Compiling from source for Amazon Linux 2 – smalldatum.blogspot.com
27. 3. 2020kernel lockdown vs blktrace – smalldatum.blogspot.com
16. 3. 2020Insert Benchmark v3 – smalldatum.blogspot.com
13. 3. 2020Tuning space and write amplification to minimize cost – smalldatum.blogspot.com
12. 3. 2020Review of Benchmarking RocksDB Key-Value Workloads at Facebook – smalldatum.blogspot.com
11. 3. 2020Building MySQL 5.6 from source on Ubuntu 18.04 – smalldatum.blogspot.com
4. 3. 2020RDBMS != SQL DBMS – smalldatum.blogspot.com
18. 2. 2020New school vs old school DBMS – smalldatum.blogspot.com
15. 2. 2020Describing replication – smalldatum.blogspot.com
14. 2. 2020Benchmarks vs real workloads – smalldatum.blogspot.com
14. 2. 2020Short guide to MongoDB monitoring – smalldatum.blogspot.com
12. 2. 2020How long should you wait for a JVM JIT before attaching a CPU profiler? – smalldatum.blogspot.com
11. 2. 2020Websites that report your browsing to Facebook – smalldatum.blogspot.com
8. 2. 2020Podcasts I love – smalldatum.blogspot.com
31. 1. 2020Durability vs Availability – smalldatum.blogspot.com
31. 1. 2020Copyleft vs the DeWitt Clause – smalldatum.blogspot.com
29. 1. 2020Aggregate PMP call stacks for one thread – smalldatum.blogspot.com
27. 1. 2020Deletes are fast and slow in an LSM – smalldatum.blogspot.com
24. 1. 2020Comparative benchmarks and a question about describing data – smalldatum.blogspot.com
17. 1. 2020PMP for on-cpu profiling? – smalldatum.blogspot.com
16. 1. 2020The slow perf movement – smalldatum.blogspot.com
16. 1. 2020Setting up Ubuntu 18.04 server on an Intel NUC – smalldatum.blogspot.com
13. 1. 2020480p is my friend - video streaming when you don't have fiber – smalldatum.blogspot.com
7. 1. 2020It is all about the constant factors – smalldatum.blogspot.com
2. 1. 2020From disk to flashcache to flash – smalldatum.blogspot.com
21. 12. 2019What is the future of off-cpu analysis? – smalldatum.blogspot.com
20. 12. 2019Readahead – smalldatum.blogspot.com
11. 12. 2019Slides for talks I have given on MySQL, MongoDB and RocksDB – smalldatum.blogspot.com
11. 12. 2019Historical - summary of the Google MySQL effort – smalldatum.blogspot.com
11. 12. 2019Historical - InnoDB IO Performance – smalldatum.blogspot.com
11. 12. 2019Historical - Patch for MySQL 5.0 – smalldatum.blogspot.com
11. 12. 2019Historical - Make User Delayed – smalldatum.blogspot.com
11. 12. 2019Historical - Adding Roles to MySQL – smalldatum.blogspot.com
11. 12. 2019Historical - changes to my.cnf – smalldatum.blogspot.com
11. 12. 2019Historical - SHOW INNODB STATUS – smalldatum.blogspot.com
11. 12. 2019Historical - SHOW STATUS changes – smalldatum.blogspot.com
10. 12. 2019Historical - design doc for semisync replication – smalldatum.blogspot.com
10. 12. 2019Historical - SemiSync replication – smalldatum.blogspot.com
10. 12. 2019Historical - SQL changes for MySQL – smalldatum.blogspot.com
10. 12. 2019Historical - Transactional Replication – smalldatum.blogspot.com
10. 12. 2019Historical - UserTable Monitoring – smalldatum.blogspot.com
10. 12. 2019Historical - InnoDB SMP performance – smalldatum.blogspot.com
10. 12. 2019Fixing the InnoDB RW-lock – smalldatum.blogspot.com
9. 12. 2019Still web scale – smalldatum.blogspot.com
26. 11. 2019iostat output changes in Ubuntu 18.04 – smalldatum.blogspot.com
26. 11. 2019Throttling writes: LSM vs B-Tree – smalldatum.blogspot.com
20. 11. 2019The delta+main index structure – smalldatum.blogspot.com
18. 11. 2019Always be upgrading – smalldatum.blogspot.com
16. 11. 2019My theory on technical debt and OSS – smalldatum.blogspot.com
15. 11. 2019The joy of database configuration – smalldatum.blogspot.com
12. 11. 2019Using an LSM for analytics – smalldatum.blogspot.com
11. 11. 2019Linux syscall performance regressions explained – smalldatum.blogspot.com
9. 11. 2019Jungle - LSM plus copy-on-write B-Tree – smalldatum.blogspot.com
7. 11. 2019Revisiting Kudu – smalldatum.blogspot.com
1. 11. 2019Fun setting up Ubuntu on Win 10 Home – smalldatum.blogspot.com
30. 10. 2019USL, universal scalability law, is good to know – smalldatum.blogspot.com
29. 10. 2019Review of "5 Minute rule - thirty years later" – smalldatum.blogspot.com
25. 10. 2019Nitpicking papers in the LSM space – smalldatum.blogspot.com
24. 10. 2019Tuning space and write amplification to minimize cost – smalldatum.blogspot.com
23. 10. 2019Write vs space amplification for an LSM and index+log – smalldatum.blogspot.com
22. 10. 2019A review of uDepot - keeping up with fast storage – smalldatum.blogspot.com
22. 10. 2019How many storage devices does a workload require? – smalldatum.blogspot.com
18. 10. 2019Just put the cold data over there – smalldatum.blogspot.com
7. 10. 2019Learned indexes for an LSM? – smalldatum.blogspot.com
25. 9. 2019Reducing write and space amplification in a b-tree – smalldatum.blogspot.com
20. 9. 2019Review of Spanner: Becoming a SQL System – smalldatum.blogspot.com
12. 9. 2019Optimal Tuning for an LSM – smalldatum.blogspot.com
10. 9. 2019FoundationDB Record Layer – smalldatum.blogspot.com
9. 9. 2019Vinyl - the LSM in Tarantool – smalldatum.blogspot.com
5. 9. 2019Adapting TPC-C for MongoDB - reviewing a VLDB paper – smalldatum.blogspot.com
5. 9. 2019Tunable Consistency in MongoDB - reviewing a VLDB paper – smalldatum.blogspot.com
5. 9. 2019InnoDB repeatable read in a nutshell – smalldatum.blogspot.com
20. 6. 2019Open Core Summit and OSS glue code – smalldatum.blogspot.com
14. 6. 2019Interesting indexing in Rockset and MongoDB – smalldatum.blogspot.com
18. 5. 2019index+log: implementations – smalldatum.blogspot.com
16. 5. 2019index+log: open issues – smalldatum.blogspot.com
16. 5. 2019Index+log, v2 – smalldatum.blogspot.com
10. 5. 2019CRUM conjecture - read, write, space and cache amplification – smalldatum.blogspot.com
12. 4. 2019A research paper on Optane performance – smalldatum.blogspot.com
22. 1. 2019Less "mark" in MySQL benchmarking – smalldatum.blogspot.com
21. 1. 2019Optimal configurations for an LSM and more – smalldatum.blogspot.com
21. 1. 2019Bugs in Windows 10 parental controls – smalldatum.blogspot.com
16. 1. 2019Geek code for LSM trees – smalldatum.blogspot.com
10. 1. 2019LSM math: fixing mistakes in my last post – smalldatum.blogspot.com
10. 1. 2019LSM math: revisiting the number of levels that minimizes write amplification – smalldatum.blogspot.com
7. 1. 2019Define "better" – smalldatum.blogspot.com
3. 1. 2019Review of LSM-based Storage Techniques: A Survey – smalldatum.blogspot.com
17. 12. 2018New small servers for performance testing – smalldatum.blogspot.com
14. 12. 2018LSM math - size of search space for LSM tree configuration – smalldatum.blogspot.com
13. 12. 2018LSM math - how many levels minimizes write amplification? – smalldatum.blogspot.com
1. 12. 2018Pixelbook review – smalldatum.blogspot.com
19. 11. 2018Review of TRIAD: Creating Synergies Between Memory, Disk and Log in Log Structured Key-Value Stores – smalldatum.blogspot.com
2. 11. 2018Converting an LSM to a B-Tree and back again – smalldatum.blogspot.com
20. 10. 2018Combining tiered and leveled compaction – smalldatum.blogspot.com
3. 10. 2018Minimizing write amplification in an LSM – smalldatum.blogspot.com
3. 10. 2018Describing tiered and leveled compaction – smalldatum.blogspot.com
1. 10. 2018Transaction Processing in NewSQL – smalldatum.blogspot.com
20. 9. 2018Durability debt – smalldatum.blogspot.com
18. 9. 2018Bloom filter and cuckoo filter – smalldatum.blogspot.com
13. 9. 2018Review of SlimDB from VLDB 2018 – smalldatum.blogspot.com
5. 9. 20185 things to set when configuring RocksDB and MyRock – smalldatum.blogspot.com
30. 8. 2018Name that compaction algorithm – smalldatum.blogspot.com
27. 8. 2018Review of "Concurrent Log-Structured Memory" from VLDB 2018. – smalldatum.blogspot.com
@kaja47, 0xDEADBEEF funkcionálně.cz, k47.cz