Innodb — Entidade

kedar.nitty-witty.com·há cerca de 1 mês

InnoDB Flushing is simple – explained

As a junior once I asked a seasoned MySQL DBA (Abuelo) “How do you stay so calm in critical situations?”Abuelo DBA then uttered golden words: “Son, I keep my dirty… The post InnoDB Flushing is simple

smalldatum.blogspot.com·há 2 meses

The insert benchmark on a small server, IO-bound workload : Postgres 19 beta1

This has results for Postgres versions 19 beta1, 18.4 and 17.10 with the Insert Benchmark on a small server using a cached and CPU-bound workload. I also used MySQL 8.4.8 to see where performance was

smalldatum.blogspot.com·há 2 meses

Write-heavy sysbench tests, a large server, modern Postgres and MySQL

This has results for modern Postgres and MySQL using write-heavy tests from sysbench and a large server. I think there are regressions in Postgres that arrive in some of versions 16, 17, 18 and 19 bet

smalldatum.blogspot.com·há 4 meses

MySQL 9.7.0 vs sysbench on a small server

This has results from sysbench on a small server with MySQL 9.7.0 and 8.4.8. Sysbench is run with low concurrency (1 thread) and a cached database. The purpose is to search for changes in performance,

smalldatum.blogspot.com·há 4 meses

Sysbench vs MySQL on a small server: another way to view the regressions

This post provides another way to see the performance regressions in MySQL from versions 5.6 to 9.7. It complements what I shared in a recent post. The workload here is cached by InnoDB and my focus i

smalldatum.blogspot.com·há 5 meses

Sysbench vs MySQL on a small server: no new regressions, many old ones

This has performance results for InnoDB from MySQL 5.6.51, 5.7.44, 8.0.X, 8.4.8 and 9.7.0 on a small server with sysbench microbenchmarks. The workload here is cached by InnoDB and my focus is on regr

smalldatum.blogspot.com·há 6 meses

HammerDB tproc-c on a large server, Postgres and MySQL

This has results for HammerDB tproc-c on a small server using MySQL and Postgres. I am new to HammerDB and still figuring out how to expla...

smalldatum.blogspot.com·há 7 meses

IO-bound Insert Benchmark vs MySQL on 24-core and 32-core servers

This has results for MySQL versions 5.6 through 9.5 with an IO-bound Insert Benchmark on 24-core and 32-core servers. The workload uses IO...