#innodb — Public Fediverse posts

[Перевод] 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

https://blog.gslin.org/archives/2026/02/21/12901/mariadb-12-3-%e5%b0%8d-innodb-%e7%9a%84%e5%a4%a7%e6%94%b9%e9%80%b2/

MariaDB 12.3 對 InnoDB 的大改進

#binlog #cpu #database #db #engine #fsync #i/o #innodb #latency #mariadb #mysql #performance #rdbms #speed #storage #write

I finally finished this upgrade this morning. There was a new check that I had to fiddle around with to get working and then of course #Nomad wanted to battle with me. And then that was all on top of #InnoDB being rude as well! :derpfuuu:

#GitHubEnterprise #GitHub #GHE #life #busy #Linux #git :github1: :linux: :mysql1:

I finally finished this upgrade this morning. There was a new check that I had to fiddle around with to get working and then of course #Nomad wanted to battle with me. And then that was all on top of #InnoDB being rude as well! :derpfuuu:

#GitHubEnterprise #GitHub #GHE #life #busy #Linux #git :github1: :linux: :mysql1:

I finally finished this upgrade this morning. There was a new check that I had to fiddle around with to get working and then of course #Nomad wanted to battle with me. And then that was all on top of #InnoDB being rude as well! :derpfuuu:

#GitHubEnterprise #GitHub #GHE #life #busy #Linux #git :github1: :linux: :mysql1:

I finally finished this upgrade this morning. There was a new check that I had to fiddle around with to get working and then of course #Nomad wanted to battle with me. And then that was all on top of #InnoDB being rude as well! :derpfuuu:

#GitHubEnterprise #GitHub #GHE #life #busy #Linux #git :github1: :linux: :mysql1:

Today I hate #InnoDB fragmentation, and incompatible #crontab files across different versions of #cron