Đang tải bảng tin…
Planet MySQL0 Hot0 bình luận8 phút đọc
InnoDB Flushing is simple – explained
A beginner-friendly deep dive into InnoDB flushing mechanics, covering all four flushing types: background, adaptive, LRU, and sync flushing. Explains dirty pages, checkpoint age, and the redo log using everyday analogies. Includes three practical diagnostic commands to detect sync flush risk, LRU flushing problems, and whether background/adaptive flushing is keeping up with writes. Provides concrete fixes like increasing innodb_redo_log_capacity, tuning innodb_io_capacity, and sizing the buffer pool appropriately.
Nguồn: https://kedar.nitty-witty.com/blog/innodb-flushing-is-simple-explained. 8sync News chỉ tóm tắt và dẫn link; bản quyền nội dung thuộc tác giả và nguồn gốc.
Đề xuất cho bạn
Percona Blog0 Hot6 phút
Running DuckDB as a MySQL 9.7 storage engine
An experimental MySQL 9.7 build called ducksdb-mysql-engine integrates DuckDB as a pluggable storage engine, allowing tables marked ENGINE=DuckDB to offload analytical queries to DuckDB's columnar engine while keeping the same MySQL connection and data. A custom pushdown_select hook (handlerton::pushdown_select) translates qualifying SQL to DuckDB SQL transparently, falling back to the normal row path when needed. TPC-H benchmarks at scale factor 10 show InnoDB timing out on 6 of 22 queries and taking 1317 seconds on the rest, while the DuckDB engine completes all 22 in ~15 seconds. At SF100 (600M rows), the engine remains correct on all 22 queries and stays close to native DuckDB performance, outperforming MariaDB's DuckDB integration on several heavy joins and loading data ~4x faster. The project is open source under GPLv2 and explicitly experimental.
