#binlog — 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

Pushed a small update to the MSBuild Log Viewer VS Code extension. It should now be able to open .NET 8 binlogs

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

#vscode #vscodeExtension #dotnet #msbuild #msbuldLogViewer #msbuildStructuredLogViewer #binlog

Pushed a big update to the MSBuild Log Viewer VS Code extension (still experimental!)

- no more emoji - use VS Code icons
- better display of search results in side view (and you can have multiple searches per binlog)
- bookmarks! pin log items in the side view
- long log entires open in real VS Code editor windows instead of in a div inside the binlog document

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

#vscode #vscodeExtension #dotnet #msbuild #msbuildLogViewer #msbuildStructuredLogViewer #binlog

So I made a thing...

It's a VS Code extension based on Kirill Osenkov's @KirillOsenkov MS Build structured log viewer.

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

The desktop version runs on CoreCLR, the https://insiders.vscode.dev version runs using the new (and still very experimental!) .NET 8 WASI workload on top of VS Code's WASI extension host (https://code.visualstudio.com/blogs/2023/06/05/vscode-wasm-wasi)

#vscode #dotnet #dotnet8 #net8 #wasi #coreclr #vscodeExtension #mono #msbuild #msbuildLogViewer #msbuildStructuredLogViewer #binlog

So I made a thing...

It's a VS Code extension based on Kirill Osenkov's @KirillOsenkov MS Build structured log viewer.

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

The desktop version runs on CoreCLR, the https://insiders.vscode.dev version runs using the new (and still very experimental!) .NET 8 WASI workload on top of VS Code's WASI extension host (https://code.visualstudio.com/blogs/2023/06/05/vscode-wasm-wasi)

#vscode #dotnet #dotnet8 #net8 #wasi #coreclr #vscodeExtension #mono #msbuild #msbuildLogViewer #msbuildStructuredLogViewer #binlog

So I made a thing...

It's a VS Code extension based on Kirill Osenkov's @KirillOsenkov MS Build structured log viewer.

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

The desktop version runs on CoreCLR, the https://insiders.vscode.dev version runs using the new (and still very experimental!) .NET 8 WASI workload on top of VS Code's WASI extension host (https://code.visualstudio.com/blogs/2023/06/05/vscode-wasm-wasi)

#vscode #dotnet #dotnet8 #net8 #wasi #coreclr #vscodeExtension #mono #msbuild #msbuildLogViewer #msbuildStructuredLogViewer #binlog

So I made a thing...

It's a VS Code extension based on Kirill Osenkov's @KirillOsenkov MS Build structured log viewer.

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

The desktop version runs on CoreCLR, the https://insiders.vscode.dev version runs using the new (and still very experimental!) .NET 8 WASI workload on top of VS Code's WASI extension host (https://code.visualstudio.com/blogs/2023/06/05/vscode-wasm-wasi)

#vscode #dotnet #dotnet8 #net8 #wasi #coreclr #vscodeExtension #mono #msbuild #msbuildLogViewer #msbuildStructuredLogViewer #binlog

So I made a thing...

It's a VS Code extension based on Kirill Osenkov's @KirillOsenkov MS Build structured log viewer.

https://marketplace.visualstudio.com/items?itemName=lambdageek.msbuild-structured-log-viewer

The desktop version runs on CoreCLR, the https://insiders.vscode.dev version runs using the new (and still very experimental!) .NET 8 WASI workload on top of VS Code's WASI extension host (https://code.visualstudio.com/blogs/2023/06/05/vscode-wasm-wasi)

#vscode #dotnet #dotnet8 #net8 #wasi #coreclr #vscodeExtension #mono #msbuild #msbuildLogViewer #msbuildStructuredLogViewer #binlog