AI Briefing#mysql
The latest AI and developer news about #mysql, with the original source and a short summary.
The latest AI and developer news about #mysql, with the original source and a short summary.
The fix resolved a rare empty-response bug caused by capability mismatches in shared CDN caches, achieving a 99.99% success rate.
The system enabled Airbnb to migrate its MySQL fleet from 5.7 to 8.0 without major production incidents by identifying latency regressions and compatibility issues offline.
This article outlines methods to maximize bulk data read and write performance using Querydsl-based cursor pagination and batch processing.
Appwrite 2.0 has been officially released, introducing Native PostgreSQL/MySQL support and the Hyperloop B engine to increase I/O throughput by 7x.
MEGA MGC Coffee migrated its DB to Amazon Aurora Serverless v2 to ensure stability and cost efficiency for its mobile ordering service, which experiences highly variable traffic.
An analysis of how Aurora MySQL's non-standard idle close behavior causes HikariCP connection validation errors.
NHN Cloud compared the same aggregation query and found ClickHouse up to 693 times faster.
Migrated 30 MySQL and 34 Nginx services to Hetzner with 0 minutes of downtime
Cloudflare Workers now lets you create PlanetScale Postgres and MySQL directly, bundling billing together.
The real cause of DB Connection Timeout was not a lack of connections, but the absence of JVM warm-up.
Starting from 0% test coverage, they safely improved 6 years of legacy by changing code, ERDs, and documentation.
Ilhaera Kim Bangsael maintained consistency with optimistic locking based on update_version.
This analyzes the differences and characteristics between MySQL's DATETIME and TIMESTAMP data types.
Kurly developed an AccessBlock system that blocks service maintenance access at the application level without nginx permissions, and improved performance with Redis caching.
Kakao has established an Orchestrator-based HA standard to replace MHA through R&D efforts since 2023.
When storing identical JSON data, the TEXT type uses 25 bytes, while the JSON type uses 35 bytes including metadata.
Confirmed average 50% to maximum over 100% productivity improvement in collaboration environments based on legacy code
There are conditions where it cannot be used, such as the maximum limit of 64 for ROW_VERSION and the presence of FTS indexes.
This document analyzes the lifecycle of MTR (Mini-Transaction) creation and commit within the InnoDB Redo Log of MySQL 5.7, as well as the concurrency control mechanism via Mutex when recording to the Redo Log Buffer.
Kakao shares its Spark job development case study, applying MySQL scan mode tuning, Iceberg maintenance, caching, and local mode optimization to handle large-scale consistency checks across hundreds of tables.
Support for mysql_native_password is discontinued in MySQL 9.0, making the transition to caching_sha2_password and preparation for SSL/RSA connections essential.
Under MySQL's REPEATABLE READ, the balance read before acquiring the lock stayed fixed until the end, causing payments to fail.
This analysis compares the operational principles of MySQL's Copy, In-Place, and Instant ALTER DDL algorithms and their Metadata Lock acquisition patterns.
Analyzes the internal implementation of how PreparedStatement operates across various layers such as Hibernate, HikariCP, and MySQL Connector/J.