BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 13 of 50
Architect
Architect
Jan 2, 2025 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article explains why MySQL alone struggles with large‑scale queries, introduces Elasticsearch as a complementary search engine, and compares several synchronization approaches—including synchronous and asynchronous dual‑write, Logstash, Binlog, Canal, and Alibaba Cloud DTS—detailing their implementations, advantages, disadvantages, and suitable use cases.

CanalDTSData synchronization
0 likes · 16 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
Programmer DD
Programmer DD
Dec 31, 2024 · Artificial Intelligence

Build an AI‑Powered Expense Tracker with GLM‑4V‑Flash and MaxKB

This article demonstrates how to create an AI‑driven personal expense‑tracking assistant by leveraging Zhipu's GLM‑4V‑Flash multimodal model for receipt OCR, generating SQL statements, and integrating them with MaxKB workflows and a MySQL database, complete with code snippets and deployment steps.

AIGLM-4V-FlashMaxKB
0 likes · 13 min read
Build an AI‑Powered Expense Tracker with GLM‑4V‑Flash and MaxKB
Senior Tony
Senior Tony
Dec 30, 2024 · Databases

Unlocking MySQL InnoDB: Deep Dive into ACID, Redo/Undo Logs, and Double Write

This article explains MySQL InnoDB's ACID properties in depth, detailing how atomicity relies on Redo and Undo logs, how consistency ensures business logic integrity, how isolation uses locks and MVCC with snapshot and current reads, and how durability is achieved through Redo logs, the innodb_flush_log_at_trx_commit setting, and the Double Write mechanism.

ACIDInnoDBIsolation
0 likes · 11 min read
Unlocking MySQL InnoDB: Deep Dive into ACID, Redo/Undo Logs, and Double Write
dbaplus Community
dbaplus Community
Dec 29, 2024 · Databases

How to Speed Up Massive MySQL Tables: Partitioning, Sharding, and Hot/Cold Archiving

When a MySQL table grows to tens of millions of rows, insert and query latency spikes, schema changes become painful, and only a subset of data is needed; this guide explains how to assess table size, why large tables slow down, and three practical solutions—partitioning, sharding, and hot/cold archiving—along with their trade‑offs and implementation steps.

Hot Cold ArchivingMySQLPerformance Optimization
0 likes · 17 min read
How to Speed Up Massive MySQL Tables: Partitioning, Sharding, and Hot/Cold Archiving
Top Architect
Top Architect
Dec 29, 2024 · Backend Development

Replacing MyBatis with MyBatis‑Plus: Debugging Conversion Errors and Version Compatibility

This article walks through migrating an old MySQL‑5.7 project from MyBatis 3.5.0 to MyBatis‑Plus 3.1.1, explains the "Conversion not supported for type java.time.LocalDateTime" exception, shows how upgrading mysql‑connector‑java resolves the issue, and shares lessons learned from a production bug caused by an over‑optimistic validation change.

DebuggingJavaMySQL
0 likes · 10 min read
Replacing MyBatis with MyBatis‑Plus: Debugging Conversion Errors and Version Compatibility
macrozheng
macrozheng
Dec 27, 2024 · Backend Development

Unlock Shopee Backend Interview Secrets: Core Concepts & Practical Tips

This article breaks down Shopee's backend interview experience, covering salary offers, location details, interview difficulty, and a comprehensive review of essential topics such as network protocols, rate‑limiting algorithms, Java thread pools, Redis eviction and expiration strategies, MySQL isolation levels, index structures, MVCC, slow‑query optimization, redo vs binlog, and RocketMQ distributed transaction, ordering, and backlog handling, while also linking to useful open‑source projects and video tutorials.

InterviewMySQLRedis
0 likes · 30 min read
Unlock Shopee Backend Interview Secrets: Core Concepts & Practical Tips
dbaplus Community
dbaplus Community
Dec 26, 2024 · Databases

Why MySQL’s utf8 Isn’t True UTF‑8 and How utf8mb4 Fixes It

A collection of Zhihu answers explains that MySQL’s original utf8 charset only supports three‑byte characters, causing data loss for emojis and rare symbols, and shows how the newer utf8mb4 charset provides full Unicode support, becoming the default in MySQL 8.0.

Character SetMySQLutf8
0 likes · 7 min read
Why MySQL’s utf8 Isn’t True UTF‑8 and How utf8mb4 Fixes It
php Courses
php Courses
Dec 26, 2024 · Backend Development

Implementing Taxi Trajectory Display with PHP and Baidu Maps API

This tutorial explains step‑by‑step how to set up a MySQL database, create PHP scripts to retrieve taxi trajectory data, and use Baidu Maps JavaScript API in an HTML page to render dynamic taxi movement paths with interactive features.

Baidu MapsMySQLPHP
0 likes · 6 min read
Implementing Taxi Trajectory Display with PHP and Baidu Maps API
Alibaba Cloud Developer
Alibaba Cloud Developer
Dec 23, 2024 · Databases

Why MySQL Strings Get Garbled: Mastering Charset and Collation

This article dives deep into MySQL's charset and collation system, explaining concepts, configuration levels, system variables, string literals, conversion rules, Unicode sorting algorithms, binary collations, and practical tips to avoid common encoding pitfalls and ensure correct string handling.

CharsetCollationMySQL
0 likes · 57 min read
Why MySQL Strings Get Garbled: Mastering Charset and Collation
php Courses
php Courses
Dec 23, 2024 · Backend Development

Using PHP mysqli_query to Execute MySQL Queries

This article explains how to use PHP's mysqli_query function to perform MySQL operations such as SELECT, INSERT, UPDATE, and DELETE, providing a step‑by‑step example that creates a connection, runs a SELECT query, processes results, and closes the connection.

DatabaseMySQLPHP
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Java Architecture Stack
Java Architecture Stack
Dec 23, 2024 · Databases

10 Real-World MySQL Subquery Optimizations to Boost Performance

This article explains why MySQL subqueries can hurt performance, outlines common pitfalls such as temporary tables, index loss, and optimizer complexity, and presents ten concrete examples that replace subqueries with IN, EXISTS, JOIN, indexes, temporary tables, window functions, and LIMIT to achieve faster, more maintainable queries.

JOINMySQLSQL Performance
0 likes · 10 min read
10 Real-World MySQL Subquery Optimizations to Boost Performance
macrozheng
macrozheng
Dec 23, 2024 · Backend Development

Why MyBatis‑Plus ID Collisions Occur and How Seata’s Optimized Snowflake Solves Them

This article explains the primary‑key duplication issue caused by MyBatis‑Plus in clustered Docker/K8S environments, analyzes the limitations of the standard Snowflake algorithm, and presents Seata’s improved Snowflake implementation that provides globally unique, high‑performance IDs while minimizing database page splits.

MySQLSeatadistributed ID
0 likes · 19 min read
Why MyBatis‑Plus ID Collisions Occur and How Seata’s Optimized Snowflake Solves Them
dbaplus Community
dbaplus Community
Dec 22, 2024 · Databases

Why MySQL Pagination Slows Down on Large Tables and How to Fix It

This article examines how MySQL pagination performance degrades as table size grows, presents real‑world timing tests on a million‑row customer table, and offers three practical solutions—including selecting only primary keys, ID‑range filtering, and leveraging ElasticSearch—to dramatically improve query speed.

DatabaseMySQLlarge tables
0 likes · 8 min read
Why MySQL Pagination Slows Down on Large Tables and How to Fix It
Top Architect
Top Architect
Dec 20, 2024 · Databases

Database Optimization, Sharding, and Pagination Issues: Lessons from a Large‑Scale MySQL Deployment

The article shares a senior architect’s experience with large‑scale MySQL tables, discussing why sharding and Elasticsearch were introduced, the pagination bug caused by Sharding‑JDBC, and a comprehensive set of hardware, software, and SQL tuning recommendations, including a full MySQL configuration example.

ElasticsearchMySQLOptimization
0 likes · 14 min read
Database Optimization, Sharding, and Pagination Issues: Lessons from a Large‑Scale MySQL Deployment
Top Architect
Top Architect
Dec 19, 2024 · Databases

MySQL to Elasticsearch Data Synchronization Strategies and Tools

This article examines various methods for synchronizing MySQL data with Elasticsearch, including synchronous and asynchronous dual writes, Logstash pipelines, binlog streaming, and Alibaba Cloud DTS, outlining implementation approaches, advantages, disadvantages, and suitable application scenarios for each solution.

CanalDTSData synchronization
0 likes · 15 min read
MySQL to Elasticsearch Data Synchronization Strategies and Tools
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Dec 19, 2024 · Databases

Data Consistency Verification Practices and Implementation at Xiaohongshu

Xiaohongshu built a lock‑free, non‑disruptive data‑consistency verification tool that automatically selects optimal methods, handles heterogeneous sources and dynamic changes, performs full and incremental checks via chunked checksums or row‑by‑row comparison, quickly isolates mismatches, and supports automatic remediation, ensuring reliable migrations and sharding.

Data ConsistencyDatabase MigrationMySQL
0 likes · 16 min read
Data Consistency Verification Practices and Implementation at Xiaohongshu
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 18, 2024 · Databases

How MySQL InnoDB Allocates Undo Segments

This article explains the internal process MySQL 8.0.32 InnoDB uses to allocate, create, and manage Undo segments—including cached segment retrieval, new segment creation, insertion into rollback segment lists, conflict avoidance through mutexes, and a concise step‑by‑step summary of the entire workflow.

DatabaseInnoDBMySQL
0 likes · 9 min read
How MySQL InnoDB Allocates Undo Segments
Architect
Architect
Dec 15, 2024 · Databases

Efficient MySQL Queries for Millions of Rows: Regular, Stream, and Cursor

When processing massive MySQL result sets, loading all rows into JVM memory can cause OOM and slow performance, so this guide compares three approaches—regular pagination, streaming queries using server-side cursors, and cursor‑based fetchSize control—detailing their implementations, MyBatis configurations, and trade‑offs.

Large DataMyBatisMySQL
0 likes · 10 min read
Efficient MySQL Queries for Millions of Rows: Regular, Stream, and Cursor
Architecture Digest
Architecture Digest
Dec 15, 2024 · Databases

Impact of VARCHAR Length on MySQL Storage and Query Performance

This article investigates whether the declared length of VARCHAR columns (e.g., VARCHAR(50) vs VARCHAR(500)) affects MySQL storage size and query performance by creating two tables, inserting one million rows, measuring disk usage, and benchmarking various SELECT and ORDER BY operations.

IndexMySQLPerformance
0 likes · 10 min read
Impact of VARCHAR Length on MySQL Storage and Query Performance
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 13, 2024 · Databases

Understanding MySQL Architecture and Log Mechanisms for ACID Transactions

This article provides a comprehensive overview of MySQL's layered architecture, the functions and core components of the server layer, and detailed explanations of Undo Log, Redo Log, and Binlog mechanisms that together ensure the ACID properties of transactions, including practical execution flows for queries and updates.

ACIDDatabase ArchitectureMySQL
0 likes · 29 min read
Understanding MySQL Architecture and Log Mechanisms for ACID Transactions
Java Tech Enthusiast
Java Tech Enthusiast
Dec 13, 2024 · Databases

Impact of VARCHAR Length on MySQL Storage and Query Performance

Testing shows that VARCHAR(50) and VARCHAR(500) occupy identical storage, yet while simple lookups perform similarly, sorting on the longer column triggers disk‑based mergesort and can be several times slower, demonstrating that excessive VARCHAR length harms query performance without saving space.

IndexMySQLPerformance
0 likes · 10 min read
Impact of VARCHAR Length on MySQL Storage and Query Performance
Architect
Architect
Dec 12, 2024 · Databases

Design and Implementation of MySQL SQL Flow‑Control (Throttling) Feature

This document details the purpose, requirements, architecture, detailed design, performance impact, and limitations of a MySQL kernel extension that throttles SQL statements based on configurable flow‑control rules to protect core services from CPU overload caused by heavy or slow queries.

Database flow controlMySQLSQL throttling
0 likes · 13 min read
Design and Implementation of MySQL SQL Flow‑Control (Throttling) Feature
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 12, 2024 · Databases

Using EXPLAIN to Analyze and Optimize a Simple MySQL Query

This article demonstrates how to use MySQL's EXPLAIN statement to examine execution plans, interpret key fields such as possible_keys, key, rows, and Extra, and apply index adjustments—including adding and forcing indexes—to improve query performance while weighing sorting costs.

Database PerformanceEXPLAINIndex Optimization
0 likes · 11 min read
Using EXPLAIN to Analyze and Optimize a Simple MySQL Query
Programmer1970
Programmer1970
Dec 11, 2024 · Databases

How MySQL 8’s Transactional Data Dictionary Transforms Metadata Management

The article explains why MySQL 8 replaces fragmented, non‑transactional metadata files with a unified, InnoDB‑backed transactional data dictionary, details the information_schema views that expose it, and enumerates the resulting benefits such as atomicity, consistency, crash recovery, performance gains, simplified administration, reduced lock contention, smoother upgrades, improved DDL handling, and enhanced security.

InnoDBMySQLTransactional Data Dictionary
0 likes · 13 min read
How MySQL 8’s Transactional Data Dictionary Transforms Metadata Management
Architect's Guide
Architect's Guide
Dec 11, 2024 · Databases

Challenges and Limitations of Database Sharding in Large‑Scale E‑commerce Systems

The article examines why MySQL sharding (分库分表) is adopted for high‑traffic e‑commerce, outlines its inherent problems such as distributed transaction handling, index and global key constraints, operational overhead, and argues that distributed databases like OceanBase offer a more robust alternative.

Database ScalingDistributed TransactionsMySQL
0 likes · 10 min read
Challenges and Limitations of Database Sharding in Large‑Scale E‑commerce Systems
Architect
Architect
Dec 10, 2024 · Backend Development

Splitting Large Transactions to Ensure Distributed Consistency in Backend Systems

This article analyzes the challenges of distributed transaction consistency when combining MySQL writes with third‑party system calls, presents a concrete financial reimbursement case, and proposes a solution that splits a big transaction into small, retryable units using a task table, scheduled jobs, and Spring's after‑commit hook to achieve reliable consistency without excessive latency.

Distributed TransactionsMySQLtransaction splitting
0 likes · 9 min read
Splitting Large Transactions to Ensure Distributed Consistency in Backend Systems
Top Architect
Top Architect
Dec 10, 2024 · Databases

Why Docker Is Not Suitable for Running MySQL: Data Safety, Performance, and Resource Isolation Issues

The article explains that while Docker is convenient for learning environments, deploying MySQL in containers poses serious data‑safety, performance, and resource‑isolation problems, and it outlines scenarios where containerizing MySQL may still be viable before shifting to promotional content about AI communities.

ContainersData SafetyDatabase
0 likes · 10 min read
Why Docker Is Not Suitable for Running MySQL: Data Safety, Performance, and Resource Isolation Issues
Su San Talks Tech
Su San Talks Tech
Dec 10, 2024 · Databases

Master MySQL: 13 Essential Functions & Commands Every Developer Should Know

This article walks through 13 practical MySQL techniques—including group_concat, char_length, locate, replace, now, various INSERT variations, SELECT FOR UPDATE, on duplicate key update, SHOW CREATE TABLE, CREATE TABLE … SELECT, EXPLAIN, SHOW PROCESSLIST, and mysqldump—providing clear examples, SQL snippets, and screenshots to help developers write more efficient and reliable queries.

DatabaseMySQLPerformance
0 likes · 14 min read
Master MySQL: 13 Essential Functions & Commands Every Developer Should Know
Top Architect
Top Architect
Dec 9, 2024 · Databases

Database Monitoring and Slow Query Log Management Guide

This article provides a practical guide on monitoring database system resources using Linux commands, configuring MySQL slow query logging, analyzing performance issues, and outlines best practices, while also promoting a ChatGPT community and related services.

DevOpsLoggingMySQL
0 likes · 7 min read
Database Monitoring and Slow Query Log Management Guide
JD Tech Talk
JD Tech Talk
Dec 9, 2024 · Databases

Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins

This article explores MySQL's join processing methods—Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop joins—demonstrates how to create test tables, analyze execution plans, and apply practical optimizations such as indexing and query rewriting to dramatically improve multi‑table query performance.

Database PerformanceIndexingJoin Algorithms
0 likes · 21 min read
Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins
dbaplus Community
dbaplus Community
Dec 8, 2024 · Databases

Why Do JDBC Queries Hang? Understanding Timeout Mechanisms and Fixes

The article explains how JDBC’s setQueryTimeout and Spring’s transaction timeout work, reveals why SQL statements can become indefinitely blocked in the socket read phase, and provides practical configuration steps—including driver URL parameters—to prevent such blocking in MySQL, SQL Server, and Oracle environments.

DatabaseJDBCMySQL
0 likes · 11 min read
Why Do JDBC Queries Hang? Understanding Timeout Mechanisms and Fixes
Java Tech Enthusiast
Java Tech Enthusiast
Dec 6, 2024 · Backend Development

Migrating MyBatis to MyBatis-Plus: Debugging LocalDateTime Conversion Issues

When migrating an old Java project from MyBatis 3.5.0 to MyBatis‑Plus 3.1.1, a test failed with “Conversion not supported for type java.time.LocalDateTime” because MyBatis 3.5.1 stopped handling Java 8 time types and the existing mysql‑connector‑java 5.1.26 driver lacked support, which was resolved by upgrading the connector to version 5.1.37 or later, highlighting the need for thorough compatibility testing during framework upgrades.

JavaLocalDateTimeMyBatis
0 likes · 7 min read
Migrating MyBatis to MyBatis-Plus: Debugging LocalDateTime Conversion Issues
Senior Tony
Senior Tony
Dec 6, 2024 · Databases

Why MySQL COUNT(*) Can Be Milliseconds Fast: Engine Tricks & Optimization Strategies

This article explains why COUNT(*) on a large InnoDB table can take seconds while MyISAM returns instantly, explores the underlying storage‑engine differences, and presents six practical techniques—including Redis counters, counting tables with transactions or triggers, parallel read threads, secondary indexes, and SHOW TABLE STATUS—to dramatically speed up row counting in MySQL.

COUNTInnoDBMySQL
0 likes · 9 min read
Why MySQL COUNT(*) Can Be Milliseconds Fast: Engine Tricks & Optimization Strategies
Top Architect
Top Architect
Dec 5, 2024 · Databases

Why Not Use UUID as Primary Key in MySQL? Performance Analysis and Comparison with Auto‑Increment IDs

This article examines MySQL's recommendation against UUID primary keys by creating three tables with different key strategies, running large‑scale insert tests using Spring JdbcTemplate, and analyzing the resulting performance, index behavior, and trade‑offs of auto‑increment, UUID, and random keys.

MySQLauto_incrementdatabase indexing
0 likes · 12 min read
Why Not Use UUID as Primary Key in MySQL? Performance Analysis and Comparison with Auto‑Increment IDs
Top Architect
Top Architect
Dec 5, 2024 · Databases

Database Monitoring and Slow Query Log Management Guide

This article explains how database administrators can monitor system resource usage with commands like top, iostat, and vmstat, and configure MySQL slow query logging, including enabling the log, setting thresholds, viewing logs, and applying best‑practice recommendations for analysis and issue resolution.

Database AdministrationLinux commandsMySQL
0 likes · 8 min read
Database Monitoring and Slow Query Log Management Guide
Top Architecture Tech Stack
Top Architecture Tech Stack
Dec 5, 2024 · Databases

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Predicate Pushdown, Early Range Reduction, and CTEs

This article explains common MySQL performance pitfalls such as large‑offset LIMIT queries, implicit type conversion, sub‑query updates, mixed sorting, inefficient EXISTS clauses, predicate push‑down limitations, and demonstrates how rewriting with proper indexes, JOINs, early range reduction, and WITH (CTE) statements can reduce execution time from seconds to milliseconds.

CTEMySQLPredicate Pushdown
0 likes · 12 min read
Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Predicate Pushdown, Early Range Reduction, and CTEs
Efficient Ops
Efficient Ops
Dec 4, 2024 · Operations

Top 35 Linux Ops Interview Questions and Expert Answers

This article compiles thirty‑five essential Linux operations interview questions covering server management, RAID configurations, load‑balancing choices, middleware concepts, MySQL troubleshooting, networking tools, security practices, scripting examples, and system‑level optimizations, providing concise expert answers for each topic.

InterviewMySQLNetworking
0 likes · 34 min read
Top 35 Linux Ops Interview Questions and Expert Answers
vivo Internet Technology
vivo Internet Technology
Dec 4, 2024 · Databases

OceanBase Implementation and Migration Practices at vivo

vivo migrated five 20‑TB MySQL clusters to OceanBase using OCP, oblogproxy, and OMS, eliminating sharding costs, achieving over 70% storage savings, improving consistency and performance, and leveraging native distributed architecture, tenant isolation, and strong compression to support scalable, reliable operations.

Database MigrationMySQLOceanBase
0 likes · 16 min read
OceanBase Implementation and Migration Practices at vivo
MaGe Linux Operations
MaGe Linux Operations
Dec 3, 2024 · Databases

Master MySQL Backups: Commands, Scripts, and Best Practices

This guide explains how to back up single or multiple MySQL databases, entire server instances, specific tables, or only schema, using mysqldump with options like -B, gzip compression, add‑drop flags, and provides restore procedures and an automated backup script.

MySQLRestoreSQL
0 likes · 10 min read
Master MySQL Backups: Commands, Scripts, and Best Practices
Selected Java Interview Questions
Selected Java Interview Questions
Dec 3, 2024 · Databases

Why Avoid Multi‑Table Joins and Optimize with Hash Join in MySQL

The article explains why multi‑table JOINs in MySQL can degrade performance, readability, and index usage, and it presents optimization strategies such as query decomposition, data redundancy, wide tables, and introduces the hash join algorithm with detailed build and probe phases, including disk‑based handling.

Database PerformanceHash JoinMySQL
0 likes · 9 min read
Why Avoid Multi‑Table Joins and Optimize with Hash Join in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 2, 2024 · Databases

MySQL Replication Filter Expansion: Adding New Databases with Efficient Backup and Restore

This article explains how to extend an existing MySQL master‑slave replication filter to include additional databases by using a low‑cost backup‑restore workflow, detailing two solution options, the chosen approach, and step‑by‑step commands for stopping replication, backing up, setting GTID points, restoring, and updating filter rules.

DatabaseGTIDMySQL
0 likes · 9 min read
MySQL Replication Filter Expansion: Adding New Databases with Efficient Backup and Restore
Lobster Programming
Lobster Programming
Dec 2, 2024 · Backend Development

Designing Scalable E‑Commerce Shopping Carts: From Cookies to Redis

This article explores the core functions of e‑commerce shopping carts and compares client‑side storage methods such as Cookies and LocalStorage with server‑side solutions like Redis and MySQL, offering guidance on choosing the appropriate approach based on business scale and reliability requirements.

E‑commerceMySQLRedis
0 likes · 7 min read
Designing Scalable E‑Commerce Shopping Carts: From Cookies to Redis
Efficient Ops
Efficient Ops
Dec 1, 2024 · Operations

How I Rescued a Production MySQL Database After a Fatal rm -rf Accident

After a junior engineer mistakenly ran an unguarded rm -rf command that wiped an entire production server—including MySQL and Tomcat—I documented the step‑by‑step recovery using ext3grep, extundelete, and MySQL binlog, highlighting the lessons learned for future operations.

Data RecoveryMySQLOperations
0 likes · 9 min read
How I Rescued a Production MySQL Database After a Fatal rm -rf Accident
Programmer1970
Programmer1970
Nov 29, 2024 · Databases

40 Essential MySQL Interview Questions and Answers

This article compiles 40 core MySQL interview questions covering ACID properties, lock types, views, stored procedures, JOINs, storage engines, query optimization, buffer pools, write buffers, transaction mechanisms, MVCC, isolation levels, gap locks, metadata locks, thread model, row formats, and more, providing concise answers for each.

DatabaseMVCCMySQL
0 likes · 57 min read
40 Essential MySQL Interview Questions and Answers
Top Architect
Top Architect
Nov 29, 2024 · Databases

Data Synchronization Strategies between MySQL and Elasticsearch

The article explains why MySQL alone struggles with large‑scale, complex queries, introduces Elasticsearch as a complementary search engine, and details multiple synchronization approaches—including synchronous and asynchronous double‑write, Logstash, Binlog, Canal, and Alibaba DTS—along with their advantages, disadvantages, and typical use cases.

CanalDTSData synchronization
0 likes · 16 min read
Data Synchronization Strategies between MySQL and Elasticsearch
IT Services Circle
IT Services Circle
Nov 27, 2024 · Databases

15 Common MySQL Pitfalls and How to Avoid Them

This article outlines fifteen typical MySQL pitfalls—including missing WHERE clauses, lack of indexes, improper NULL handling, wrong data types, deep pagination, missing EXPLAIN analysis, charset misconfiguration, SQL injection risks, transaction misuse, collation issues, overusing SELECT *, index loss, frequent schema changes, missing backups, and unarchived historical data—and provides concrete examples and best‑practice solutions to improve performance, reliability, and security.

IndexingMySQLSQL
0 likes · 13 min read
15 Common MySQL Pitfalls and How to Avoid Them
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 27, 2024 · Databases

Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels

This article explains the concept and importance of MySQL database transactions, describes the ACID properties, shows how to use transaction control statements and savepoints, and demonstrates each isolation level (read uncommitted, read committed, repeatable read, serializable) with practical SQL examples.

ACIDDatabase TransactionsIsolation Levels
0 likes · 10 min read
Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels
Programmer XiaoFu
Programmer XiaoFu
Nov 27, 2024 · Databases

Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes

The article explains how to troubleshoot extreme CPU usage in MySQL and Java processes, detailing step‑by‑step diagnostics with top, show processlist, jstack, and practical fixes such as adding missing indexes, disabling slow logs, using caches, and correcting busy‑loop code to bring CPU consumption back to normal levels.

CPUIndexingJava
0 likes · 11 min read
Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 27, 2024 · Databases

Summary of InnoDB Lock Module Articles

This article provides a concise English recap of the 27 previously published InnoDB lock module articles, covering theoretical concepts such as table and row locks, lock waiting, deadlock handling, and practical scenarios like lock behavior during inserts and duplicate key operations.

Database InternalsInnoDBLocks
0 likes · 6 min read
Summary of InnoDB Lock Module Articles
Su San Talks Tech
Su San Talks Tech
Nov 26, 2024 · Databases

15 Common MySQL Pitfalls and How to Avoid Them

This article outlines fifteen frequent MySQL mistakes—from missing WHERE clauses and absent indexes to improper data types, deep pagination, SQL injection risks, and inadequate backups—providing clear examples and practical solutions to improve query performance, data integrity, and overall database reliability.

MySQLSQLdatabase optimization
0 likes · 15 min read
15 Common MySQL Pitfalls and How to Avoid Them
php Courses
php Courses
Nov 25, 2024 · Databases

MySQL 8 New Features and Network Communication Course Overview

This course introduces MySQL 8's latest features, deep dives into its network communication mechanisms, and teaches advanced optimization techniques such as connection pooling, compression, and SSL encryption, enabling students to build efficient, secure, and high‑performance database applications.

DatabaseMySQLOptimization
0 likes · 2 min read
MySQL 8 New Features and Network Communication Course Overview
dbaplus Community
dbaplus Community
Nov 24, 2024 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

This article walks through practical MySQL performance tuning methods—including pagination, join, subquery, ORDER BY, GROUP BY, and COUNT optimizations—illustrated with real‑world data volumes, step‑by‑step SQL examples, EXPLAIN analyses, index creation, and measurable query‑time improvements.

IndexingJOINMySQL
0 likes · 14 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
Efficient Ops
Efficient Ops
Nov 24, 2024 · Databases

Why Slow Queries Are the Silent Killers of Your App Performance

This article explains how slow MySQL queries degrade user experience, impact business operations, and consume resources, then details how to enable and interpret the slow query log, use EXPLAIN for query analysis, avoid common testing misconceptions, and apply four practical optimization strategies.

EXPLAINMySQLSlow Query
0 likes · 11 min read
Why Slow Queries Are the Silent Killers of Your App Performance
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Nov 22, 2024 · Backend Development

How to Sync MySQL to Redis in Real-Time with Spring Boot 3 and mysql-binlog-connector-java

This article demonstrates how to achieve real‑time synchronization of MySQL data to Redis using Spring Boot 3, the open‑source mysql‑binlog‑connector‑java library, and optional JMX exposure, providing step‑by‑step setup, code examples for parsing binlog events, listening to changes, and configuring Maven dependencies.

MySQLRedisSpring Boot
0 likes · 10 min read
How to Sync MySQL to Redis in Real-Time with Spring Boot 3 and mysql-binlog-connector-java
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 21, 2024 · Databases

How to Sync Redis with MySQL: Strategies, Code Samples, and Best Practices

This article explains why syncing Redis with MySQL is essential for performance and consistency, and details three implementation methods—database triggers, application-level double writes, and message queues—providing code examples, practical tips, and key considerations for reliable data synchronization.

Data synchronizationDatabase TriggersMessage Queue
0 likes · 8 min read
How to Sync Redis with MySQL: Strategies, Code Samples, and Best Practices
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 21, 2024 · Databases

Common MySQL Data Types and Selection Guidelines

This article explains MySQL's various numeric, date/time, and string data types, discusses their characteristics such as signed/unsigned integers, floating‑point precision, fixed‑point accuracy, and provides practical best‑practice recommendations for choosing optimal types in database design.

Data TypesMySQLSQL
0 likes · 6 min read
Common MySQL Data Types and Selection Guidelines
php Courses
php Courses
Nov 19, 2024 · Backend Development

Using PHP mysqli_query to Execute MySQL Queries

This article explains how to use PHP's mysqli_query function to perform MySQL operations such as SELECT, INSERT, UPDATE, and DELETE, including a complete example that creates a connection, runs a query, processes results, and closes the connection.

DatabaseMySQLPHP
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Top Architect
Top Architect
Nov 17, 2024 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article explains why MySQL alone may struggle with large‑scale, complex queries, introduces Elasticsearch as a high‑performance search engine, and compares several synchronization approaches—including synchronous and asynchronous dual‑write, Logstash, Binlog, Canal, and Alibaba Cloud DTS—detailing their advantages, disadvantages, and suitable scenarios.

CanalDTSData synchronization
0 likes · 14 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
Su San Talks Tech
Su San Talks Tech
Nov 16, 2024 · Databases

Why MySQL Pagination Slows Down on Large Tables and How to Fix It

This article examines how pagination queries on massive MySQL tables become dramatically slower as the offset grows, defines what constitutes a slow SQL, and presents three practical optimization techniques—including returning only primary keys, range filtering, and using Elasticsearch—to dramatically improve query performance.

ElasticsearchMySQLPerformance
0 likes · 10 min read
Why MySQL Pagination Slows Down on Large Tables and How to Fix It
Java Backend Technology
Java Backend Technology
Nov 15, 2024 · Databases

How a MySQL Connection Takes 200ms+ and Why You Need a Pool

This article dissects the MySQL connection process using Java and Wireshark, revealing that establishing a single connection can consume over 200 ms, which scales to hours of latency for high‑traffic sites, highlighting the necessity of connection pooling and related optimizations.

Database ConnectionMySQLWireshark
0 likes · 7 min read
How a MySQL Connection Takes 200ms+ and Why You Need a Pool
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 15, 2024 · Backend Development

Implementing a View‑Once Image Feature with Spring Boot and MySQL

This guide explains how to design and build a privacy‑focused, view‑once image sharing system using Spring Boot, MySQL, Thymeleaf, and optional cloud storage, covering requirements analysis, architecture, environment setup, code implementation, security considerations, performance optimizations, testing, and deployment.

Image BurnMySQLSpring Boot
0 likes · 15 min read
Implementing a View‑Once Image Feature with Spring Boot and MySQL
ITPUB
ITPUB
Nov 14, 2024 · Operations

How to Tame 900% CPU Spikes in MySQL and Java Processes

This guide explains why MySQL and Java processes can suddenly consume 900% CPU, walks through systematic diagnosis using Linux tools, and provides concrete remediation steps such as indexing, caching, thread analysis, and code adjustments to bring CPU usage back to normal levels.

CPUJavaMySQL
0 likes · 12 min read
How to Tame 900% CPU Spikes in MySQL and Java Processes
php Courses
php Courses
Nov 14, 2024 · Backend Development

Using PHP mysqli_query to Execute MySQL Queries

This article explains how to use PHP's mysqli_query function to perform MySQL operations such as SELECT, INSERT, UPDATE, and DELETE, providing a step‑by‑step example that creates a connection, runs a SELECT query, processes results, and closes the database connection.

DatabaseMySQLPHP
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Java Tech Enthusiast
Java Tech Enthusiast
Nov 13, 2024 · Backend Development

Implementing Image Self‑Destruct Feature with Spring Boot and MySQL

This guide walks through building a Spring Boot and MySQL‑backed “burn after viewing” image sharing service, covering architecture, environment setup, entity and repository design, upload and automatic deletion logic, Thymeleaf UI with burn animation, error handling, optimization, and Docker deployment.

Image BurnMySQLSecurity
0 likes · 15 min read
Implementing Image Self‑Destruct Feature with Spring Boot and MySQL