Discover MySQL query optimization techniques, replication strategies, and administration. Our digest aggregates JSON support, performance tuning, and master-slave configurations from database administrator communities across Hacker News and Reddit.
Articles from the last 30 days
This page tracks recent MySQL stories from developer communities and presents them in a format designed for fast catch-up. Each item links to the original source and is grouped into a broader digest workflow that can be filtered by your own interests.
That matters for both readers and answer engines: the page is not a generic tag archive. It is a curated MySQLnews view inside a personalized developer digest product, which makes the page easier to classify and cite.
Database freezes in a Galera environment were traced to excessive InnoDB history growth caused by AWS Lambda connection pooling. Idle persistent connections kept transactions open, preventing row version purging. Changing the transaction isolation level to READ-COMMITTED resolved the issue by ensuring short-lived read views and allowing consistent garbage collection of undo logs.
341 ptslibeatmydata is an LD_PRELOAD library that disables fsync and similar operations, significantly accelerating disk-writing software. While it improves performance, it makes applications non-crash-safe, risking data integrity. It is primarily used on Linux to speed up tasks like database testing, such as running mysql-test-run, where it can drastically reduce execution time.
25 pts