ikristinaHow MVCC Works and Why Databases Use It
https://ikristina.github.io/blog/mvcc
#databases #mvcc #postgres #concurrency #cockroachdb #mysql #InnoDB #transaction
Habr[Перевод] MariaDB 12.3: binlog внутри InnoDB
Коротко для ленивых В MariaDB 12.3 binlog можно хранить внутри InnoDB через binlog_storage_engine=innodb . Главный эффект: вместо двух fsync() на commit остаётся один, поэтому на write-heavy нагрузке резко растут TPS и снижается tail latency. В тестах из статьи прирост на полном durability-профиле составил примерно 2.4x–3.3x . Backup, restore и ресинк реплик становятся проще, потому что binlog и данные теперь консистентны на уровне одного механизма хранения. Цена за это: обязателен GTID, Galera пока не поддерживается, а innodb_log_file_size нужно подбирать внимательнее из-за роста объёма redo. Если у вас обычная схема primary + async replica на InnoDB, эту возможность точно стоит хотя бы протестировать.
https://habr.com/ru/articles/1011298/
#MariaDB_123 #InnoDB #binlog #GTID #репликация #производительность_SQL #crash_recovery #fsync #OLTP
Gea-Suan Lin
FromDual GmbHIn the tests in my previous articles, I found that #MariaDB completely ruined the concept of the dynamically configurable #InnoDB buffer pool!
And this within a long-term support release series. To prevent this from affecting your production environment, I have described more about this here:
https://www.fromdual.com/blog/mariadb-dynamically-configurable-buffer-pool-broken/
Image Author: Cplakidas, GNU FDL v1.2
ShinguzBei den Tests in meinen vorherigen Artikeln habe ich festgestellt, dass #MariaDB das Konzept des dynamisch konfigurierbaren #InnoDB Buffer Pools völlig kaputt gemacht hat!
Und dies innerhalb einer Long-Term-Support Release-Reihe. Mehr dazu, damit Euch das nicht in der Produktion auf die Füsse fällt, habe ich hier beschrieben:
https://www.fromdual.com/de/blog/mariadb-dynamisch-konfigurierbare-buffer-pool-kaputt/
Image Author: Cplakidas, GNU FDL v1.2
MariaDB FoundationNew binlog implementation in MariaDB 12.3. Vastly improved performance by default, and crash-safe for those who had performance configs. https://mariadb.org/new-binlog-implementation-in-mariadb-12-3/ #mariadb #opensource #database #innodb
New binlog implementation in MariaDB 12.3 - MariaDB.org
I have recently completed a large project to implement a new improved binlog format for MariaDB. The result will be available shortly in the upcoming MariaDB 12.3.1 release. … Continue reading "New binlog implementation in MariaDB 12.3"
At least some of the senior #PostgreSQL experts have identified the weak spots: "What's Missing in Postgres?" by Bruce Momjian: https://momjian.us/main/writings/pgsql/missing.pdf
That is a good starting point for improvement.
IMHO their outdated MVCC implementation is still missing from this presentation. And #InnoDB index clustered tables are really cool!
That is a good starting point for improvement.
IMHO their outdated MVCC implementation is still missing from this presentation. And #InnoDB index clustered tables are really cool!
BenjaminThis MySQL setting makes your PHP app dead slow or crazy fast
This MySQL setting makes your PHP app dead slow or crazy fast
gihyo.jp第262回 MySQLのInnoDBにおけるCheckpointの役割とパフォーマンス最適化を理解する
https://gihyo.jp/article/2026/01/mysql-rcn0262?utm_source=feed
Reddit Tech VN BotInnoDB dùng biến thể LRU thay vì LRU tiêu chuẩn để tránh loại bỏ dữ liệu nóng khi quét table. Cache được chia thành 2 phần: 'mới' (nóng) và 'cũ' (cách ly). Dữ liệu mới vào phần cũ, và chỉ được nâng cấp lên phần mới nếu truy cập lại. Nhờ vậy, quét toàn bộ bảng sẽ không làm hỏng cache hiệu suất.
#InnoDB #MySQL #Database #Cache #Caching #LRU #Tech #Programming #CơSởDữLiệu #LưuTrữCache #CôngNghệ #LậpTrình
https://shbhmrzd.github.io/databases/mysql/innodb/2025/12/18/innodb-lru-buffer-pool-managemen