small datum - Robuta Search

https://smalldatum.blogspot.com/2019/01/ Small Datum: January 2019 small datum january https://smalldatum.blogspot.com/2018/12/lsm-math-how-many-levels-minimizes.html Small Datum: LSM math - how many levels minimizes write amplification? How do you configure an LSM tree with leveled compaction to minimize write amplification? For a given number of levels write-amp is minimal ... small datum how many lsm math levels https://smalldatum.blogspot.com/2022/ Small Datum: 2022 small datum https://smalldatum.blogspot.com/2015/04/big-numbers-for-web-scale-mysql.html Small Datum: Big numbers for web scale MySQL It is conference time. I haven't been at the MySQL UC as I am at another conference (ICDE) so I missed the talks but tweets make strong clai... small datum big numbers for web scale mysql https://smalldatum.blogspot.com/2023/07/fun-with-innodbpagecleaners.html Small Datum: Fun with innodb_page_cleaners I have been running the insert+delete benchmark for Postgres, InnoDB and MyRocks and then trying to improve the configurations I use for ea... small datum fun with innodb cleaners https://smalldatum.blogspot.com/2017/05/short-guide-on-using-performanceschema.html Small Datum: Short guide on using performance_schema for user & table stats It took me too long to figure this out while reading the chapter on PS in the MySQL manual. Hopefully this saves me time the next time I nee... small datum short guide https://smalldatum.blogspot.com/2024/10/ Small Datum: October 2024 small datum october https://smalldatum.blogspot.com/2025/01/evaluating-vector-indexes-in-mariadb.html?m=1 Small Datum: Evaluating vector indexes in MariaDB and pgvector: part 1 This post has results for vector index support in MariaDB and Postgres. I am new to vector indexes so I will start small and over time add m... small datum evaluating vector indexes https://smalldatum.blogspot.com/2014/02/ Small Datum: February 2014 small datum february https://smalldatum.blogspot.com/2017/07/i-overstated-cpu-regression-in-mysql-57.html Small Datum: I overstated the CPU regression in MySQL 5.7 My series of posts on the low-concurrency CPU regression greatly overstated the regression from MySQL 5.6 to 5.7. Most of the regression wa... small datum overstated https://smalldatum.blogspot.com/2024/05/ Small Datum: May 2024 small datum may https://smalldatum.blogspot.com/2014/04/types-of-writes.html Small Datum: Types of writes What does it mean to make writes fast? It helps to distinguish between the different types of writes. The slowest is a write that must be i... small datum types of writes https://smalldatum.blogspot.com/2015/11/read-write-space-amplification-b-tree.html Small Datum: Read, write & space amplification - B-Tree vs LSM This post compares a B-Tree and LSM for read, write and space amplification . The comparison is done in theory and practice so expect some ... small datum read write space amplification https://smalldatum.blogspot.com/2014/07/ Small Datum: July 2014 small datum july https://smalldatum.blogspot.com/2023/09/hello-world.html Small Datum: Hello world! Small Datum LLC is a thing. small datum hello world https://smalldatum.blogspot.com/2024/02/ Small Datum: February 2024 small datum february https://smalldatum.blogspot.com/2017/05/small-servers-for-database-performance.html Small Datum: Small servers for database performance tests I use Intel NUC servers at home to test open source databases. I like them because they are small, quiet and don't use much power. For abou... small datum database performance servers tests https://smalldatum.blogspot.com/2021/11/insert-benchmark-postgresql-12-13-and.html Small Datum: Insert benchmark: PostgreSQL 12, 13 and 14 on a small server I have another performance report for the insert benchmark using PostgreSQL 12.4, 13.4 and 14.0 on a small server . As normal, I had to rep... small datum https://smalldatum.blogspot.com/2024/08/ Small Datum: August 2024 small datum august https://smalldatum.blogspot.com/2022/05/rocksdb-internals-lru.html?ref=highscalability.com Small Datum: RocksDB internals: LRU RocksDB uses LRU to manage the size of the block cache. The LRU can suffer from mutex contention so I describe the implementation in detail ... small datum rocksdb internals lru https://smalldatum.blogspot.com/2014/10/sysbench-cached-updates-mysql-57-vs.html Small Datum: Sysbench cached updates: MySQL 5.7 vs previous releases I used MySQL 5.7.5 to repeat tests I did for MySQL 5.7.2 and 5.6.10 with the sysbench client and a cached database to compare performance ... small datum sysbench cached updates https://smalldatum.blogspot.com/2016/05/smartctl-and-samsung-850-evo.html Small Datum: smartctl and Samsung 850 EVO I have 3 small servers at home for performance testing. Each is an Intel NUC with 8G of RAM and a core i3 via 5i3RYH . These work quietly u... small datum smartctl samsung evo https://smalldatum.blogspot.com/2023/01/ Small Datum: January 2023 small datum january https://smalldatum.blogspot.com/2017/07/ Small Datum: July 2017 small datum july https://smalldatum.blogspot.com/2017/10/wearing-out-ssd.html Small Datum: Wearing out an SSD I use Intel NUC servers at home to test open-source databases for performance and efficiency. The servers have an SSD for the database and ... small datum wearing ssd https://smalldatum.blogspot.com/2016/08/web-scale-mysql-back-in-day.html Small Datum: Web-scale MySQL back in the day I spent a few years at Facebook where I was extremely busy helping to make MySQL better at web-scale. I worked a lot with Domas . He found s... small datum back in web scale mysql https://smalldatum.blogspot.com/2025/09/ Small Datum: September 2025 small datum september https://smalldatum.blogspot.com/2024/01/explaining-changes-in-rocksdb.html Small Datum: Explaining changes in RocksDB performance for IO-bound workloads I have two recent posts for RocksDB benchmarks ( here and here ) that mention there might be a regression in IO-bound workloads starting in... small datum explaining changes https://smalldatum.blogspot.com/2015/04/ Small Datum: April 2015 small datum april https://smalldatum.blogspot.com/2021/10/the-other-way-to-compress-innodb.html Small Datum: The other way to compress InnoDB: outsource it There are at least three ways to do compression for InnoDB - classic, holepunch and outsource. The classic approach ( table compression ) w... the other way small datum compress innodb outsource https://smalldatum.blogspot.com/2023/03/ Small Datum: March 2023 small datum march https://smalldatum.blogspot.com/2025/02/ Small Datum: February 2025 small datum february https://smalldatum.blogspot.com/2016/08/ Small Datum: August 2016 small datum august https://smalldatum.blogspot.com/2017/10/ Small Datum: October 2017 small datum october https://smalldatum.blogspot.com/2016/09/peak-benchmarketing-season-for-mysql.html Small Datum: Peak benchmarketing season for MySQL Maybe this is my XKCD week . With Oracle Open World and Percona Live Amsterdam we are approaching peak benchmarketing season for MySQL. I s... small datum peak season mysql https://smalldatum.blogspot.com/2023/02/ Small Datum: February 2023 small datum february https://smalldatum.blogspot.com/2017/ Small Datum: 2017 small datum https://smalldatum.blogspot.com/2021/01/sysbench-postgres-vs-mysql-and-impact.html Small Datum: Sysbench: Postgres vs MySQL and the impact of regressions I compare Postgres and MySQL using an in-memory and low-concurrency workload via sysbench. This reuses the data from my previous posts ( her... small datum and the sysbench postgres vs https://smalldatum.blogspot.com/2019/10/a-review-of-udepot-keeping-up-with-fast.html?ref=highscalability.com Small Datum: A review of uDepot - keeping up with fast storage This is a review of Reaping the performance of fast NVM storagewith uDepot which was published in FAST 2019. The paper is worth reading. u... small datum keeping up review https://smalldatum.blogspot.com/2017/12/ Small Datum: December 2017 small datum december https://smalldatum.blogspot.com/2023/07/keeping-up-with-sql-dbms-market.html Small Datum: Keeping up with the SQL DBMS market Sometimes it is easier to talk about tech when you can name things. There is much innovation in progress in the SQL DBMS market. The same is... small datum keeping up sql dbms market https://smalldatum.blogspot.com/2015/10/myrocks-versus-allocators-glibc.html Small Datum: MyRocks versus allocators: glibc, tcmalloc, jemalloc I used a host with Fedora 19 and Linkbench to determine the ability of memory allocators to avoid fragmentation with MyRocks (MySQL+RocksDB)... small datum myrocks versus allocators glibc https://smalldatum.blogspot.com/2014/10/page-read-performance-mysql-57-vs.html Small Datum: Page read performance: MySQL 5.7 vs previous releases For this test I used sysbench to determine the peak rate for disk reads per second from InnoDB with fast storage. Fast storage in this case ... small datum read performance https://smalldatum.blogspot.com/2017/02/ Small Datum: February 2017 small datum february https://smalldatum.blogspot.com/2017/05/benchmarketing-with-innodb-redo-log-size.html Small Datum: Benchmark(et)ing with InnoDB redo log size What is a typical InnoDB redo log size? By size I mean the product of innodb_log_file_size and innodb_log_files_in_group . A typical setup ... small datum benchmark et ing innodb https://smalldatum.blogspot.com/2018/ Small Datum: 2018 small datum https://smalldatum.blogspot.com/2016/06/rocksdb-innodb-and-insert-benchmark.html Small Datum: RocksDB, InnoDB and the insert benchmark Today I share results for RocksDB and InnoDB using MySQL 5.6 and the insert benchmark. I have many more results that I am currently sharing... small datum and the rocksdb innodb insert https://smalldatum.blogspot.com/2024/07/postgres-17beta2-vs-sysbench-looking.html Small Datum: Postgres 17beta2 vs sysbench: looking good small datum postgres vs sysbench looking https://smalldatum.blogspot.com/2023/07/ Small Datum: July 2023 small datum july https://smalldatum.blogspot.com/2017/06/linkbench-io-bound-intel-nuc-for-mysql.html Small Datum: Linkbench, IO-bound & Intel NUC for MySQL 5.6, 5.7 & 8 Update - the regression isn't as bad as I have been reporting. Read this post to understand why. Next up in my series on low-concurre... https://smalldatum.blogspot.com/2024/01/updated-insert-benchmark-myrocks-56-and_12.html Small Datum: Updated Insert benchmark: MyRocks 5.6 and 8.0, small server, cached database, v2 This has results for the Insert Benchmark using MyRocks 5.6 and 8.0, a small server and a cached workload. I have two versions of small se... https://smalldatum.blogspot.com/2024/02/perf-regressions-in-mysql-from-5621-to.html Small Datum: Perf regressions in MySQL from 5.6.21 to 8.0.36 using sysbench and a small server This has results for sysbench vs upstream MySQL on a small server. I have results for some 5.6, 5.7 and 8.0 releases up to 8.0.36. My last r...