BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 35 of 50
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 25, 2022 · Databases

Custom MySQL Data Consistency Check Tool: Design, Implementation, and Usage

This article introduces a custom MySQL data consistency verification tool inspired by pt-table-checksum, explains the challenges of handling complex primary keys, details the implementation logic with shell scripts and SQL, and provides installation, configuration, and usage instructions including parallelism, network monitoring, and scheduling.

Data ConsistencyMySQLShell script
0 likes · 23 min read
Custom MySQL Data Consistency Check Tool: Design, Implementation, and Usage
Selected Java Interview Questions
Selected Java Interview Questions
Jan 22, 2022 · Databases

Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and Controlled foreach Values

This article analyzes why MyBatis foreach‑based batch inserts become extremely slow with thousands of rows, explains the underlying SQL and PreparedStatement overhead, and demonstrates how switching to ExecutorType.BATCH or limiting foreach values to 20‑50 rows dramatically improves MySQL insertion performance.

Batch InsertExecutorType.BATCHJava
0 likes · 9 min read
Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and Controlled foreach Values
Top Architect
Top Architect
Jan 22, 2022 · Databases

Optimizing MySQL Pagination Queries with Subqueries and Buffer‑Pool Analysis

The article explains why large‑offset LIMIT queries on a MySQL table with millions of rows are slow, demonstrates how rewriting the query to use a subquery that first selects primary‑key IDs dramatically reduces execution time, and validates the improvement by measuring buffer‑pool page usage.

Database PerformanceMySQLPagination
0 likes · 9 min read
Optimizing MySQL Pagination Queries with Subqueries and Buffer‑Pool Analysis
JavaEdge
JavaEdge
Jan 21, 2022 · Databases

Can MySQL Handle a 100 GB Full Table Scan Without Crashing?

This article explains why a MySQL query that scans a 100‑gigabyte table and returns millions of rows does not exhaust server memory, describing the net_buffer mechanism, socket send buffer behavior, InnoDB buffer‑pool management, and the improved LRU algorithm used to keep large scans from degrading overall performance.

InnoDBLRUMySQL
0 likes · 8 min read
Can MySQL Handle a 100 GB Full Table Scan Without Crashing?
Tencent Database Technology
Tencent Database Technology
Jan 19, 2022 · Databases

Deep Dive into Tencent's Self‑Developed MySQL Kernel TXSQL and Its Architecture

This article provides a comprehensive overview of Tencent's self‑developed MySQL kernel TXSQL, covering its evolution, overall architecture, columnar storage engine, instant DDL capabilities, enterprise‑grade features, high‑availability mechanisms, performance optimizations, and the rigorous development and testing processes behind the product.

Cloud DatabaseMySQLPerformance Optimization
0 likes · 11 min read
Deep Dive into Tencent's Self‑Developed MySQL Kernel TXSQL and Its Architecture
ITPUB
ITPUB
Jan 19, 2022 · Databases

How a Startup Solved Midnight MySQL Timeouts: Slow‑SQL Diagnosis & Caching

During nightly peaks, a social‑e‑commerce startup experienced hour‑long service outages due to MySQL timeouts; by analyzing traffic spikes, CPU usage, and slow‑SQL logs, the team identified un‑cached ranking queries and a 20‑minute cache refresh bottleneck, then implemented targeted caching, monitoring scripts, and fallback static pages to eliminate the issue.

MySQLPerformancecaching
0 likes · 14 min read
How a Startup Solved Midnight MySQL Timeouts: Slow‑SQL Diagnosis & Caching
Tencent Architect
Tencent Architect
Jan 18, 2022 · Databases

Inside Tencent’s TXSQL: Architecture, Evolution, and Enterprise‑Grade Features

This article reviews Tencent Cloud’s self‑developed MySQL kernel TXSQL, detailing its enterprise‑grade features, evolutionary roadmap, overall and cloud‑native TDSQL‑C architecture, columnar engine for OLAP, instant DDL capabilities, high‑availability mechanisms, performance optimizations, and the rigorous development and release process that underpins its stability.

Columnar EngineDatabase ArchitectureEnterprise Features
0 likes · 12 min read
Inside Tencent’s TXSQL: Architecture, Evolution, and Enterprise‑Grade Features
Java Backend Technology
Java Backend Technology
Jan 18, 2022 · Databases

Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization

This article explains how InnoDB implements full-text search using inverted indexes, shows how to create and use full-text indexes with various query modes—including natural language, boolean, and query expansion—covers relevance calculation, stopwords, token size limits, and demonstrates how to delete indexes, all illustrated with SQL examples and diagrams.

Boolean ModeFull-text SearchMySQL
0 likes · 13 min read
Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization
dbaplus Community
dbaplus Community
Jan 16, 2022 · Databases

Essential MySQL Query Optimization Tips to Avoid Full Table Scans

This guide compiles practical MySQL performance techniques—including proper indexing, avoiding costly operators, rewriting OR conditions, using EXISTS, limiting SELECT *, managing temporary tables, configuring threads, choosing storage engines, and optimizing data types—to dramatically reduce full‑table scans and improve query speed.

MySQLQuery OptimizationSQL Performance
0 likes · 21 min read
Essential MySQL Query Optimization Tips to Avoid Full Table Scans
Java Backend Technology
Java Backend Technology
Jan 15, 2022 · Databases

Why Large OFFSETs Slow MySQL Queries and How Subquery Optimization Fixes It

The article explains how using a large OFFSET in MySQL pagination forces the server to read and discard many rows, causing severe performance degradation, and demonstrates that rewriting the query to first fetch primary‑key IDs via a subquery dramatically reduces I/O and execution time, with buffer‑pool experiments confirming the improvement.

MySQLPaginationPerformance
0 likes · 9 min read
Why Large OFFSETs Slow MySQL Queries and How Subquery Optimization Fixes It
JavaEdge
JavaEdge
Jan 13, 2022 · Databases

Ensuring Redo Log and Binlog Consistency in InnoDB with Two‑Phase Commit

This article explains how InnoDB’s two‑phase commit mechanism keeps the redo log and binlog logically consistent, illustrating failure scenarios, the impact on data recovery, and how the prepare‑commit split prevents inconsistencies in MySQL’s storage engine.

InnoDBMySQLRedo Log
0 likes · 4 min read
Ensuring Redo Log and Binlog Consistency in InnoDB with Two‑Phase Commit
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.

DentryLinuxMemory Management
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+TreeInnoDBMySQL
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.

MySQLPerformance Schemainformation_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.

MySQLPerformanceauto_increment
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 ToolsMySQLPerformance Tuning
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.

DatabaseProxyFailoverHA
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)
Liangxu Linux
Liangxu Linux
Dec 30, 2021 · Databases

Why MySQL UPDATE Fails with AND and How to Use Comma‑Separated Assignments

A developer noticed an UPDATE statement that appeared to run without effect, discovered that using AND between column assignments is invalid in MySQL, learned the correct comma‑separated syntax, and saw how logical AND expressions can produce unexpected zero values.

Database TroubleshootingLogical expressionsMySQL
0 likes · 3 min read
Why MySQL UPDATE Fails with AND and How to Use Comma‑Separated Assignments
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.

Elastic ScalingMySQLTDSQL-C
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.

Multi-Valued IndexesMySQLindexes
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.

IndexingMulti-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.

IndexingMySQLNaming Convention
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.

MySQLSQLTransactions
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.

DBAMySQLautomation
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.

Database ComparisonDatabase MigrationMariaDB
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.

Database ScalingIndex OptimizationMySQL
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 PerformanceIndexingMVCC
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.

MySQLNetwork BottleneckPerformance Benchmark
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.

IndexMySQLPerformance
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.

InterviewMySQLindexes
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.

DELETEFunTesterINSERT
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.

HTAPMySQLTiDB
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.

DatabaseMySQLPagination
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.

DatabaseFacebookMyRocks
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.

ConfigurationDatabaseMySQL
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.

BugFixesMySQLOpenSource
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.

DELETEDMLINSERT
0 likes · 12 min read
Master MySQL DML: Insert, Update, Delete, and Truncate Explained