BestHub
Sign in
Tagged articles
5000 articles
Page 33 of 50
Qunar Tech Salon
Qunar Tech Salon
Jan 13, 2022 · Databases

Root Cause Analysis of MySQL Memory Spike Caused by Excessive dentry Allocation from Mis‑configured yum makecache Cron

The article details a MySQL memory‑usage incident at Qunar where abnormal slab memory, especially dentry allocation, caused a rapid increase in used memory after a mis‑configured yum makecache cron job, and explains the investigation steps, Linux memory concepts, diagnostic commands, and the corrective actions taken.

DentryLinuxMySQL
0 likes · 14 min read
Root Cause Analysis of MySQL Memory Spike Caused by Excessive dentry Allocation from Mis‑configured yum makecache Cron
Top Architect
Top Architect
Jan 11, 2022 · Databases

Understanding InnoDB Primary‑Key B+Tree Capacity and Height

This article explains how InnoDB stores data in 16 KB pages, calculates how many rows a B+Tree index can hold, shows how to determine the tree height from the page level, and answers why MySQL uses B+Tree rather than other tree structures.

B+TreeDatabase IndexInnoDB
0 likes · 10 min read
Understanding InnoDB Primary‑Key B+Tree Capacity and Height
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 10, 2022 · Databases

Analysis of MySQL 8.0.26 Crash Caused by the terminology_use_previous Parameter and INFORMATION_SCHEMA.PROCESSLIST Access

The article investigates a MySQL 8.0.26 crash triggered by setting the terminology_use_previous parameter to BEFORE_8_0_26, analyzes stack traces and core dumps, compares processlist access methods, references related bugs, and offers mitigation recommendations for monitoring tools.

Information SchemaMySQLPerformance Schema
0 likes · 12 min read
Analysis of MySQL 8.0.26 Crash Caused by the terminology_use_previous Parameter and INFORMATION_SCHEMA.PROCESSLIST Access
dbaplus Community
dbaplus Community
Jan 9, 2022 · Databases

How ICBC Tames MySQL: Real‑World Governance, Risk Mitigation, and SRE Practices

This article details Industrial and Commercial Bank of China's comprehensive MySQL governance framework, covering risk identification, prevention strategies, a four‑step methodology, automated quality gates, production‑level monitoring, SRE management, and future visions for rapid incident detection and self‑healing.

Database GovernanceMySQLPerformance Optimization
0 likes · 22 min read
How ICBC Tames MySQL: Real‑World Governance, Risk Mitigation, and SRE Practices
Java Captain
Java Captain
Jan 9, 2022 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article evaluates MySQL insertion performance of three primary key strategies—auto‑increment, UUID, and random Snowflake‑like keys—by building identical tables, running Spring‑Boot/JdbcTemplate benchmarks, analyzing index structures, and discussing the advantages and drawbacks of each approach.

MySQLauto_incrementperformance
0 likes · 9 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
Top Architect
Top Architect
Jan 7, 2022 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑diagnostic utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run them, and shows how to interpret their reports for optimizing database configuration and query performance.

Database ToolsMySQLMySQLTuner
0 likes · 8 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 5, 2022 · Databases

Understanding ProxySQL Configuration Tables for MySQL HA (Read/Write Splitting and Failover)

This article explains ProxySQL's built‑in databases, key configuration tables such as mysql_servers, mysql_users, mysql_replication_hostgroups, mysql_group_replication_hostgroups, and mysql_query_rules, and demonstrates how to set up read/write splitting and automatic failover for MySQL primary‑replica and group replication environments.

DatabaseProxyHAMySQL
0 likes · 14 min read
Understanding ProxySQL Configuration Tables for MySQL HA (Read/Write Splitting and Failover)
Qunar Tech Salon
Qunar Tech Salon
Jan 5, 2022 · Databases

Understanding MySQL Backup Tools and the Percona XtraBackup Backup Process

This article explains the importance of MySQL backups, compares common logical and physical backup tools such as mysqldump, Mydumper and Percona XtraBackup, details XtraBackup's step‑by‑step workflow, lock handling options, and provides practical Q&A for reliable database backup strategies.

InnoDBMySQLPercona XtraBackup
0 likes · 18 min read
Understanding MySQL Backup Tools and the Percona XtraBackup Backup Process
Code DAO
Code DAO
Jan 1, 2022 · Backend Development

Building a Clean Architecture GraphQL App with ent and gqlgen (Part 1)

This tutorial walks through creating a maintainable GraphQL application using Go, demonstrating how to set up a Docker‑based MySQL database, configure Viper and Echo, define ent schemas, run migrations, integrate gqlgen with ent, and implement queries and mutations following Clean Architecture principles.

Clean ArchitectureDockerEcho
0 likes · 22 min read
Building a Clean Architecture GraphQL App with ent and gqlgen (Part 1)
Tencent Database Technology
Tencent Database Technology
Dec 31, 2021 · Databases

Practices and Exploration of Disaster Recovery in Cloud‑Native Database TDSQL‑C (formerly CynosDB)

This article examines the architecture differences between traditional MySQL and the cloud‑native TDSQL‑C database, outlines MySQL disaster‑recovery deployment models, and details TDSQL‑C’s multi‑dimensional disaster‑recovery system, including its agent‑scheduler design, cross‑AZ switching challenges, and mitigation strategies.

MySQLTDSQL-Ccloud-native database
0 likes · 10 min read
Practices and Exploration of Disaster Recovery in Cloud‑Native Database TDSQL‑C (formerly CynosDB)
Tencent Architect
Tencent Architect
Dec 30, 2021 · Databases

Practices and Exploration of Disaster Recovery in Tencent Cloud‑Native Database TDSQL‑C (formerly CynosDB)

This article examines the architecture differences between cloud‑native TDSQL‑C and traditional MySQL, outlines TDSQL‑C’s elastic, serverless, low‑latency features, compares MySQL disaster‑recovery models, and details the multi‑dimensional disaster‑recovery system and its cross‑AZ/Region challenges and solutions.

MySQLTDSQL-Ccloud-native database
0 likes · 9 min read
Practices and Exploration of Disaster Recovery in Tencent Cloud‑Native Database TDSQL‑C (formerly CynosDB)
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 28, 2021 · Databases

MySQL 8.0.18 Crash When Importing Large BLOBs with Semi‑Sync Replication and slave_compressed_protocol Enabled

The article investigates a MySQL 8.0.18 crash that occurs when importing a large create.sql containing longblob data under semi‑synchronous replication, reveals that enabling slave_compressed_protocol together with high‑availability latency checks triggers the failure, and provides a concrete fix by disabling the compressed protocol.

CrashMySQLbug
0 likes · 10 min read
MySQL 8.0.18 Crash When Importing Large BLOBs with Semi‑Sync Replication and slave_compressed_protocol Enabled
Java Backend Technology
Java Backend Technology
Dec 28, 2021 · Databases

Unlock MySQL JSON: Design, Index, and Query Strategies for Dynamic Data

This article explains how MySQL's JSON data type bridges relational and non‑relational storage, shows practical table designs for user login and profiling, demonstrates querying with JSON functions and operators, and covers function and multi‑valued indexes to efficiently retrieve JSON‑based data.

IndexesMulti-Valued IndexesMySQL
0 likes · 12 min read
Unlock MySQL JSON: Design, Index, and Query Strategies for Dynamic Data
Architecture & Thinking
Architecture & Thinking
Dec 27, 2021 · Databases

Master MySQL GROUP BY: From Basics to Advanced Aggregations

This guide explains MySQL GROUP BY syntax, the role of aggregate functions such as AVG, COUNT, MAX, MIN, and SUM, and demonstrates practical queries with single‑field and multi‑field grouping, filtering with WHERE and HAVING, ordering, limiting results, and the correct execution order of keywords.

Database QueriesGROUP BYMySQL
0 likes · 12 min read
Master MySQL GROUP BY: From Basics to Advanced Aggregations
Tencent Cloud Developer
Tencent Cloud Developer
Dec 27, 2021 · Databases

Design and Implementation of a Simple Go ORM for MySQL

The article introduces a lightweight Go ORM for MySQL, explains native connection setup, details the SmallormEngine design with chainable methods for Table, Where, Insert, Update, Delete, and BatchInsert, and demonstrates how reflection builds SQL fragments while handling errors and supporting fluent query composition.

CRUDDatabaseGo
0 likes · 32 min read
Design and Implementation of a Simple Go ORM for MySQL
Top Architect
Top Architect
Dec 25, 2021 · Databases

Using MySQL JSON Data Type for Flexible Schema Design and Efficient Indexing

This article explains the MySQL JSON data type, demonstrates how to store structured and semi‑structured data with JSON objects and arrays, shows practical table designs for user login and profiling, and details virtual columns, function indexes, and multi‑valued indexes for fast querying.

JSONMulti-Valued IndexMySQL
0 likes · 13 min read
Using MySQL JSON Data Type for Flexible Schema Design and Efficient Indexing
Laravel Tech Community
Laravel Tech Community
Dec 23, 2021 · Databases

Database Object Naming and Design Standards

This guide details comprehensive naming conventions and design best‑practices for MySQL database objects—including schemas, tables, indexes, views, stored procedures, functions, triggers, constraints, and users—along with recommended storage engine, character set, field types, index strategies, and SQL usage rules to ensure consistency, performance, and maintainability.

MySQLNaming Conventionindexing
0 likes · 20 min read
Database Object Naming and Design Standards
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 23, 2021 · Databases

Common MySQL binlog Commands and Usage Tips

This article provides a practical guide to using mysqlbinlog for parsing and replaying MySQL binlog files, covering options for time, position, and GTID ranges, as well as important parameters such as --no-defaults, -v, --base64-output, and --skip-gtids.

GTIDMySQLbinlog
0 likes · 7 min read
Common MySQL binlog Commands and Usage Tips
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 22, 2021 · Big Data

Using Flink CDC to Capture MySQL Changes and Sink Them into ClickHouse

This article explains Change Data Capture (CDC), compares query‑based and log‑based approaches, introduces Debezium and ClickHouse, and provides step‑by‑step Flink CDC and Flink SQL CDC examples—including Java source, deserialization, sink code and required Maven dependencies—to stream MySQL binlog changes into ClickHouse for real‑time analytics.

Big DataCDCClickHouse
0 likes · 14 min read
Using Flink CDC to Capture MySQL Changes and Sink Them into ClickHouse
Senior Brother's Insights
Senior Brother's Insights
Dec 21, 2021 · Databases

9 Essential MySQL Optimization Techniques to Boost Performance

This article presents practical MySQL optimization methods—including proper column definitions, NOT NULL usage, JOIN over sub‑queries, UNION, transaction handling, foreign keys, table locking, indexing strategies, and a collection of query‑tuning tips—each illustrated with clear examples and code snippets to improve database speed and reliability.

Database OptimizationMySQLTransactions
0 likes · 18 min read
9 Essential MySQL Optimization Techniques to Boost Performance
ITPUB
ITPUB
Dec 20, 2021 · Databases

From Database Developer to New DBA: Boosting MySQL Efficiency and Automation

The article shares a senior DBA's journey from early database engine development to modern MySQL operations, outlining practical methods for improving efficiency, automating monitoring, building data‑driven processes, and redefining the DBA role for proactive, high‑impact service delivery.

DBADatabase operationsEfficiency
0 likes · 33 min read
From Database Developer to New DBA: Boosting MySQL Efficiency and Automation
Qunar Tech Salon
Qunar Tech Salon
Dec 20, 2021 · Databases

From Database Development to the New DBA: Strategies for Efficiency, Automation, and Career Growth

The article shares the author’s journey from early database development at DM6/DM7 through MySQL operations at Qunar, offering practical advice on demand‑driven implementation, data‑driven management, intelligent alerting, full‑log analysis, slow‑query risk modeling, high‑availability, and automation to transform traditional DBA work into a proactive, efficient New DBA role.

Database AdministrationMySQLautomation
0 likes · 31 min read
From Database Development to the New DBA: Strategies for Efficiency, Automation, and Career Growth
ITPUB
ITPUB
Dec 16, 2021 · Databases

How Alibaba Cloud RDS MySQL Three‑Node Enterprise Uses X‑Paxos for High Availability

This article explains the architecture of Alibaba Cloud RDS MySQL three‑node enterprise edition, detailing the X‑Paxos consensus protocol, node roles, election mechanisms, weight‑based leader selection, state‑machine diagnostics, disk health probing, and reverse‑heartbeat design that together provide a robust high‑availability database solution.

Database ArchitectureMySQLRDS
0 likes · 11 min read
How Alibaba Cloud RDS MySQL Three‑Node Enterprise Uses X‑Paxos for High Availability
Programmer DD
Programmer DD
Dec 16, 2021 · Databases

Why a Former MySQL Engineer Recommends PostgreSQL Over MySQL

A former Oracle MySQL lead engineer explains why, after five years of work, he finds PostgreSQL a superior open‑source RDBMS, criticizing MySQL’s design flaws, comparing MariaDB, and highlighting real‑world migration experiences and industry perspectives.

MariaDBMySQLPostgreSQL
0 likes · 9 min read
Why a Former MySQL Engineer Recommends PostgreSQL Over MySQL
NiuNiu MaTe
NiuNiu MaTe
Dec 15, 2021 · Databases

Master MySQL Performance: Practical Tuning, Indexes, and Scaling Strategies

This comprehensive guide walks through MySQL performance fundamentals, real‑world testing results, slow‑query detection, index impact, pagination pitfalls, count optimizations, sharding techniques, and step‑by‑step migration plans for large tables, equipping engineers with actionable tuning insights.

Index OptimizationMySQLSharding
0 likes · 13 min read
Master MySQL Performance: Practical Tuning, Indexes, and Scaling Strategies
Java Architect Essentials
Java Architect Essentials
Dec 14, 2021 · Databases

Why LIMIT Can Slow Down MySQL Queries and How to Fix It

Using LIMIT with a large offset in MySQL can cause severe performance degradation due to excessive random I/O, but by rewriting the query to first fetch primary keys in a subquery and then joining, execution time can drop from seconds to milliseconds, as demonstrated with real data.

InnoDBLIMITMySQL
0 likes · 10 min read
Why LIMIT Can Slow Down MySQL Queries and How to Fix It
21CTO
21CTO
Dec 14, 2021 · Databases

PostgreSQL vs MySQL: Which Database Wins in JSON, Indexing, and Concurrency?

This article examines workload analysis and query performance differences between PostgreSQL and MySQL, focusing on JSON handling, indexing strategies, concurrency control, benchmark results, and replication features, while offering configuration tips to improve each database’s speed and efficiency.

Database PerformanceJSONMVCC
0 likes · 10 min read
PostgreSQL vs MySQL: Which Database Wins in JSON, Indexing, and Concurrency?
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 13, 2021 · Databases

Why MySQL Performance Benchmark Shows Low TPS on High-End Hardware

This article examines why MySQL benchmark results often show low transactions per second on seemingly powerful servers, exploring hidden factors such as network bottlenecks, SSL overhead, and inappropriate sort_buffer_size settings, and provides practical troubleshooting steps and configuration tweaks to achieve optimal performance.

Database TuningMySQLNetwork Bottleneck
0 likes · 10 min read
Why MySQL Performance Benchmark Shows Low TPS on High-End Hardware
dbaplus Community
dbaplus Community
Dec 12, 2021 · Databases

7 Common MySQL Index Pitfalls That Can Kill Query Performance

This article examines seven typical scenarios where MySQL indexes unexpectedly fail—such as OR conditions, leading wildcards in LIKE, missing quotes, functions on indexed columns, NULL checks, arithmetic operations, and composite index ordering—providing SQL examples, execution plans, and practical tips to avoid costly full‑table scans.

Database OptimizationMySQLQuery Tuning
0 likes · 9 min read
7 Common MySQL Index Pitfalls That Can Kill Query Performance
JavaEdge
JavaEdge
Dec 10, 2021 · Databases

Master MySQL Interview Questions: ACID, Indexes, Transactions, and More

This comprehensive guide covers MySQL fundamentals such as ACID transaction properties, isolation levels, index types and design principles, storage engines, MVCC mechanics, query execution flow, replication, locking strategies, and performance‑tuning techniques for large tables and complex queries.

IndexesInterviewMySQL
0 likes · 39 min read
Master MySQL Interview Questions: ACID, Indexes, Transactions, and More
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 10, 2021 · Databases

DTLE 3.21.11.0 Release Notes – New Features and Fixes

The DTLE 3.21.11.0 release introduces MySQL‑specific enhancements such as partitioned table creation, geometry type support, multi‑threaded replay with unique columns, and large‑transaction handling, while also fixing an alter‑table rename issue, and provides download links and related reading resources.

DTLEData TransferDatabase Tools
0 likes · 3 min read
DTLE 3.21.11.0 Release Notes – New Features and Fixes
360 Tech Engineering
360 Tech Engineering
Dec 9, 2021 · Databases

Understanding MySQL Slow Query Analysis with EXPLAIN

This article explains why SQL queries can become slow, outlines MySQL's internal architecture, demonstrates how to use the EXPLAIN statement to view execution plans, and interprets key fields such as type, key, and Extra to help developers identify and optimize performance bottlenecks.

EXPLAINMySQLperformance
0 likes · 5 min read
Understanding MySQL Slow Query Analysis with EXPLAIN
FunTester
FunTester
Dec 8, 2021 · Databases

How Fast Can MySQL Insert and Delete? FunTester Performance Benchmarks

This article walks through using the FunTester framework to benchmark MySQL insert and delete operations, showing Java code examples, test configurations, and JSON results that reveal a high QPS for inserts and a noticeable slowdown when deletions are performed.

BenchmarkDeleteFunTester
0 likes · 7 min read
How Fast Can MySQL Insert and Delete? FunTester Performance Benchmarks
High Availability Architecture
High Availability Architecture
Dec 7, 2021 · Databases

Efficiency Choice: NetEase Internal Evaluation of Distributed Database TiDB

NetEase’s DBA team presents a comprehensive analysis comparing TiDB‑based innovative architecture with the traditional MySQL + DDB stack, detailing business fit, cost reduction, technical innovation, scalability, high availability, HTAP capabilities, migration strategies, and practical deployment experiences to justify adopting TiDB as a next‑generation distributed database solution.

HTAPMigrationMySQL
0 likes · 35 min read
Efficiency Choice: NetEase Internal Evaluation of Distributed Database TiDB
政采云技术
政采云技术
Dec 7, 2021 · Databases

Analysis of MySQL Connector/J Character Set Handling and UTF8MB4 Support

This article examines how MySQL Connector/J determines the character set during connection initialization, explains the transition from UTF8MB3 to UTF8MB4, analyzes source code of versions 5.1.46 and 5.1.47, and provides practical methods to enable UTF8MB4 without upgrading the driver.

Character SetConnector/JDatabase
0 likes · 10 min read
Analysis of MySQL Connector/J Character Set Handling and UTF8MB4 Support
Java Interview Crash Guide
Java Interview Crash Guide
Dec 7, 2021 · Databases

Why Traditional Pagination Fails After Sharding and How to Solve It

When a table grows beyond ten million rows, sharding it across multiple databases improves performance, but the usual LIMIT offset, pagesize pagination breaks, leading to missing or incorrect records; this article examines why simple merge approaches fail and evaluates global, secondary query, and no‑skip paging strategies, highlighting their trade‑offs.

DatabaseMySQLSharding
0 likes · 12 min read
Why Traditional Pagination Fails After Sharding and How to Solve It
Java Architect Essentials
Java Architect Essentials
Dec 6, 2021 · Databases

Facebook’s MySQL 5.6‑to‑8.0 Migration: Challenges, Process, and Lessons Learned

The article details Facebook’s multi‑year effort to migrate its heavily customized MySQL 5.6 deployment—including the MyRocks storage engine—to MySQL 8.0, describing the technical challenges, patch‑porting strategy, replication changes, automated verification, and application validation performed during the upgrade.

DatabaseFacebookMigration
0 likes · 17 min read
Facebook’s MySQL 5.6‑to‑8.0 Migration: Challenges, Process, and Lessons Learned
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 6, 2021 · Databases

MySQL Time Zone Configuration: Installation Standards, Session Variables, and Their Impact on Data

This article explains how to set the correct time zone for MySQL during installation, describes the relevant startup parameters and system variables, demonstrates their effect on functions like NOW() and TIMESTAMP columns, and provides practical solutions for Java applications, data migration, and dump utilities.

DatabaseMySQLTimezone
0 likes · 11 min read
MySQL Time Zone Configuration: Installation Standards, Session Variables, and Their Impact on Data
Practical DevOps Architecture
Practical DevOps Architecture
Dec 5, 2021 · Databases

Deploying MHA for MySQL High Availability – Part 1

This guide walks through the step‑by‑step deployment of MHA on a MySQL cluster, covering package installation on all nodes, copying and installing the MHA RPMs, creating the required MySQL user, configuring MHA, testing SSH connectivity, and reviewing the failover script.

DatabaseLinuxMHA
0 likes · 6 min read
Deploying MHA for MySQL High Availability – Part 1
Top Architect
Top Architect
Dec 5, 2021 · Databases

Why MySQL Table Size Does Not Decrease After DELETE and How to Reduce It

This article explains why deleting rows in MySQL does not shrink the underlying table file, describes the InnoDB storage mechanics that cause this behavior, and provides practical solutions such as OPTIMIZE TABLE, ALTER TABLE, and Online DDL to reclaim space and avoid table‑locking issues.

ALTER TABLEDeleteInnoDB
0 likes · 8 min read
Why MySQL Table Size Does Not Decrease After DELETE and How to Reduce It
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 4, 2021 · Databases

Weekly Community Newsletter: MySQL Index Cases, Password Policy, Backup Issues, and Open‑Source Middleware Updates

This weekly community newsletter curates technical articles and updates, covering MySQL index length limitations, new password policies, backup‑induced replication issues, open‑source middleware progress, bug fixes, and upcoming development plans, while inviting reader feedback for further improvements.

BugFixesDatabasesMySQL
0 likes · 4 min read
Weekly Community Newsletter: MySQL Index Cases, Password Policy, Backup Issues, and Open‑Source Middleware Updates
360 Quality & Efficiency
360 Quality & Efficiency
Dec 3, 2021 · Databases

Understanding MySQL Slow Query Analysis with EXPLAIN

This article explains why SQL queries become slow in MySQL, describes the server architecture, details how to use the EXPLAIN statement to interpret execution plans, and outlines how to read and optimize key fields such as type, key, and extra for better performance.

Database PerformanceEXPLAINIndex Optimization
0 likes · 5 min read
Understanding MySQL Slow Query Analysis with EXPLAIN
Architecture & Thinking
Architecture & Thinking
Dec 1, 2021 · Databases

Master MySQL DML: Insert, Update, Delete, and Truncate Explained

Learn the essential MySQL Data Manipulation Language commands—INSERT, UPDATE, DELETE, and TRUNCATE—including syntax variations, best practices, and step‑by‑step command‑line examples that illustrate single‑row, batch, and conditional operations, plus key differences between delete and truncate.

DMLDeleteInsert
0 likes · 12 min read
Master MySQL DML: Insert, Update, Delete, and Truncate Explained
政采云技术
政采云技术
Nov 30, 2021 · Databases

Overview of MySQL and InnoDB Storage Engine Architecture

This article provides a comprehensive overview of MySQL, detailing its configuration file search order, component architecture, various storage engines such as MyISAM, NDB, Memory, and an in‑depth examination of InnoDB’s internal structures, memory management, background threads, LRU handling, redo log buffering, and checkpoint mechanisms.

CheckpointDatabase ArchitectureInnoDB
0 likes · 26 min read
Overview of MySQL and InnoDB Storage Engine Architecture
High Availability Architecture
High Availability Architecture
Nov 29, 2021 · Databases

Analysis of DBCP Connection‑Pool Bug Causing Database Connection Saturation and Recommended Mitigations

The article investigates a DBCP 1.4 connection‑pool bug that allows the pool to exceed its configured limits, explains how removeAbandoned and socketTimeout interact to produce excess MySQL connections, reproduces the issue with a multithreaded test, and proposes configuration changes to avoid it.

AbandonedConnectionPoolDBCP
0 likes · 10 min read
Analysis of DBCP Connection‑Pool Bug Causing Database Connection Saturation and Recommended Mitigations
Java Interview Crash Guide
Java Interview Crash Guide
Nov 29, 2021 · Databases

How Many Rows Can a MySQL InnoDB B+ Tree Store?

This article explains the storage units of InnoDB, calculates how many rows a B+ tree can hold at different heights, shows how to determine the tree height from the page level, and answers why MySQL uses B+ trees for indexing.

B+TreeDatabase IndexInnoDB
0 likes · 9 min read
How Many Rows Can a MySQL InnoDB B+ Tree Store?
dbaplus Community
dbaplus Community
Nov 28, 2021 · Databases

Mastering MySQL Indexes: When to Use, Combine, and Optimize Them

This article explains why indexes are vital for MySQL performance, how to decide when to add ordinary, composite, prefix, or unique indexes, the pitfalls of using non‑sequential primary keys, and advanced optimizations such as change buffer, index condition pushdown, and MRR to reduce I/O.

B+TreeDatabase OptimizationMySQL
0 likes · 18 min read
Mastering MySQL Indexes: When to Use, Combine, and Optimize Them
Qingyun Technology Community
Qingyun Technology Community
Nov 26, 2021 · Cloud Native

How RadonDB MySQL Operator Simplifies MySQL Deployment on Kubernetes

This article introduces the RadonDB MySQL Operator, explaining its design goals, deployment topology on Kubernetes, detailed architecture—including RBAC, manager, custom resources, and services—and provides a visual overview to help engineers simplify MySQL high‑availability deployments in cloud‑native environments.

DatabaseMySQLOperator
0 likes · 4 min read
How RadonDB MySQL Operator Simplifies MySQL Deployment on Kubernetes
macrozheng
macrozheng
Nov 26, 2021 · Databases

7 Common MySQL Index Pitfalls and How to Avoid Them

This article examines seven typical scenarios where MySQL indexes fail—such as OR conditions, leading wildcards, missing quotes, functions, NULL checks, arithmetic on indexed columns, and composite index order—explaining why they happen and offering practical solutions to maintain query performance.

Database OptimizationMySQLindex
0 likes · 12 min read
7 Common MySQL Index Pitfalls and How to Avoid Them
ITPUB
ITPUB
Nov 25, 2021 · Databases

Essential MySQL Configuration Tuning for Production Environments

MySQL’s default settings target a 512 MB virtual machine and work for development or testing, but production deployments require a series of performance optimizations, including understanding why database tuning matters, how to optimize MySQL instances, and which parameters to adjust.

MySQLproduction
0 likes · 2 min read
Essential MySQL Configuration Tuning for Production Environments
macrozheng
macrozheng
Nov 23, 2021 · Databases

15 Essential SQL Optimization Tips to Boost Query Performance

This article presents fifteen practical SQL optimization techniques—including avoiding SELECT *, using UNION ALL, leveraging IN/EXISTS, batching inserts, applying LIMIT, controlling IN list size, incremental queries, efficient pagination, preferring JOINs, limiting join tables, managing indexes, choosing proper column types, improving GROUP BY, and using EXPLAIN—to help developers dramatically improve query speed and resource usage.

DatabaseMySQLQuery Tuning
0 likes · 20 min read
15 Essential SQL Optimization Tips to Boost Query Performance
Big Data Technology Architecture
Big Data Technology Architecture
Nov 23, 2021 · Big Data

Step-by-Step Guide to Setting Up Flink CDC with MySQL, Hudi, and Hive Integration on a Hadoop Cluster

This comprehensive tutorial walks through configuring a Hadoop‑based environment (Flink 1.13.1, Scala 2.11, CDH 6.2.0, Hive 2.1.1, Hudi 0.10), compiling Hudi, setting up Flink and MySQL binlog, creating CDC source and Hudi sink tables, running Flink jobs, and synchronizing the results to Hive partitions for query via Hive and Presto.

CDCFlinkHive
0 likes · 15 min read
Step-by-Step Guide to Setting Up Flink CDC with MySQL, Hudi, and Hive Integration on a Hadoop Cluster
Programmer DD
Programmer DD
Nov 23, 2021 · Databases

Why MySQL INSERT Fails with Incorrect String Value and How to Fix It

A colleague encountered an "Incorrect string value" error when inserting UTF‑8 text into a GBK‑encoded MySQL table, and the article explains how charset mismatches and the use of the CHAR() function cause the failure, then provides reproducible tests and concrete solutions.

CharsetGBKINSERT error
0 likes · 6 min read
Why MySQL INSERT Fails with Incorrect String Value and How to Fix It
dbaplus Community
dbaplus Community
Nov 22, 2021 · Databases

Transforming MySQL Monitoring: From Nagios to Kafka‑Powered Alerts

Qunar’s DBA team overhauled their MySQL monitoring and alert system—originally built on Nagios and NRPE—by integrating a Kafka‑based pipeline, a custom alarm service, and MySQL‑stored alert templates, achieving flexible thresholds, granular silencing, high‑availability processing, and early‑stage intelligent management of alerts, slow queries, and disk space.

DBAKafkaMySQL
0 likes · 14 min read
Transforming MySQL Monitoring: From Nagios to Kafka‑Powered Alerts
dbaplus Community
dbaplus Community
Nov 21, 2021 · Databases

15 Proven SQL Optimization Techniques to Boost Query Performance

This article presents fifteen practical SQL optimization tips—including avoiding SELECT *, preferring UNION ALL, leveraging small‑table‑driven queries, batching inserts, applying LIMIT, handling large IN lists, incremental fetching, efficient pagination, join strategies, index management, field‑type choices, and using EXPLAIN—to dramatically improve MySQL query speed and resource usage.

DatabaseMySQLperformance
0 likes · 18 min read
15 Proven SQL Optimization Techniques to Boost Query Performance