BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 18 of 50
Code Ape Tech Column
Code Ape Tech Column
Jun 14, 2024 · Databases

Designing an Efficient Import of 1 Billion Records into MySQL: Architecture, Batch Loading, Sharding, and Concurrency Control

This article analyzes how to import one billion 1 KB log records stored in HDFS or S3 into MySQL by evaluating single‑table limits, choosing storage engines, designing sharding, batch insertion, file‑reading strategies, task coordination, and distributed locking to achieve high‑throughput and ordered writes.

Batch InsertMySQLconcurrency
0 likes · 19 min read
Designing an Efficient Import of 1 Billion Records into MySQL: Architecture, Batch Loading, Sharding, and Concurrency Control
php Courses
php Courses
Jun 14, 2024 · Backend Development

How to Implement Taxi Trajectory Display with PHP and Baidu Maps API

This tutorial demonstrates step‑by‑step how to set up a MySQL database, write PHP scripts to retrieve taxi trajectory data, and use Baidu Maps JavaScript API to render interactive maps showing each vehicle’s path, including code examples for database creation, data insertion, and front‑end integration.

Baidu Maps APIMySQLPHP
0 likes · 6 min read
How to Implement Taxi Trajectory Display with PHP and Baidu Maps API
21CTO
21CTO
Jun 13, 2024 · Databases

Is Oracle Killing MySQL? A Deep Dive into MySQL’s Future Under Oracle

The article examines Peter Zaitsev’s critique of Oracle’s stewardship of MySQL, debunks long‑standing myths, evaluates recent MySQL Heatwave features and performance gaps, and compares MySQL’s trajectory with PostgreSQL and other open‑source databases.

MySQLOraclePerformance
0 likes · 8 min read
Is Oracle Killing MySQL? A Deep Dive into MySQL’s Future Under Oracle
New Oriental Technology
New Oriental Technology
Jun 13, 2024 · Databases

Understanding InnoDB Row-Level Locks and Locking Rules in MySQL

This article explains the types of InnoDB row‑level locks—record lock, gap lock, and next‑key lock—describes how MySQL determines lock ranges based on indexing, outlines the two fundamental locking principles with associated optimizations, and provides concrete examples for primary‑key and ordinary indexes.

Gap LockInnoDBMySQL
0 likes · 11 min read
Understanding InnoDB Row-Level Locks and Locking Rules in MySQL
Java Tech Enthusiast
Java Tech Enthusiast
Jun 13, 2024 · Databases

MySQL's Decline: Oracle's Strategy and the Rise of PostgreSQL

Oracle’s post‑acquisition strategy has left MySQL lagging behind modern developers, while PostgreSQL, praised for features like parallel queries and vector search, now dominates the open‑source database market, prompting calls for MySQL’s transfer to the Linux Foundation to avoid obsolescence.

DB-EnginesMySQLOracle
0 likes · 7 min read
MySQL's Decline: Oracle's Strategy and the Rise of PostgreSQL
Architect's Guide
Architect's Guide
Jun 13, 2024 · Databases

Cache Consistency Between MySQL and Redis: Design Patterns and Best Practices

This article explains the relationship between MySQL and Redis, discusses why cache consistency is challenging, and details four cache update design patterns—delete‑then‑update, update‑then‑invalidate (Cache‑Aside), read/write‑through, and write‑behind—illustrating each with flow diagrams and practical considerations.

Cache Design PatternsMySQLRedis
0 likes · 7 min read
Cache Consistency Between MySQL and Redis: Design Patterns and Best Practices
IT Services Circle
IT Services Circle
Jun 12, 2024 · Databases

MySQL to Elasticsearch Data Synchronization: Strategies and Tool Selection

This article reviews four common MySQL‑to‑Elasticsearch synchronization methods—synchronous dual‑write, asynchronous dual‑write via MQ, timer‑based SQL extraction, and real‑time Binlog replication—evaluates their pros and cons, and compares popular migration tools such as Canal, Alibaba DTS, Databus and others.

BinlogCDCData Migration Tools
0 likes · 11 min read
MySQL to Elasticsearch Data Synchronization: Strategies and Tool Selection
Liangxu Linux
Liangxu Linux
Jun 11, 2024 · Databases

Boost MySQL Performance: Master LIMIT, Implicit Conversion, JOIN Updates, and More

This article explains common MySQL performance pitfalls such as inefficient LIMIT pagination, implicit type conversion, sub‑query‑based updates, mixed ordering, misuse of EXISTS, and condition push‑down, and provides concrete rewrites and examples that reduce query times from seconds to milliseconds.

MySQLQuery TuningSQL optimization
0 likes · 13 min read
Boost MySQL Performance: Master LIMIT, Implicit Conversion, JOIN Updates, and More
Architecture Digest
Architecture Digest
Jun 11, 2024 · Databases

Multi‑Branch Product Sales Statistics Query Using Row Comparison in MySQL

This article explains how to design a MySQL table for product sales statistics, initialize massive test data, and compare several query strategies—including loop queries, OR‑concatenated dynamic SQL, mixed filtering, and the SQL‑92 row‑comparison technique—to efficiently retrieve sales figures for multiple business units and their products without violating development constraints.

BackendDynamic SQLMySQL
0 likes · 7 min read
Multi‑Branch Product Sales Statistics Query Using Row Comparison in MySQL
Programmer XiaoFu
Programmer XiaoFu
Jun 11, 2024 · Databases

10 Advanced MySQL Query Techniques Every Data Engineer Should Know

This article presents ten essential advanced MySQL concepts—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, running totals, and date‑time manipulation—each explained with clear examples and practical SQL snippets.

CASE WHENCTEMySQL
0 likes · 11 min read
10 Advanced MySQL Query Techniques Every Data Engineer Should Know
Java Tech Enthusiast
Java Tech Enthusiast
Jun 10, 2024 · Databases

Common MySQL String Functions

MySQL offers a comprehensive set of string functions—including lower, upper, concat, substring/substr, length, char_length, instr, lpad, rpad, trim (with leading, trailing, both options), replace, repeat, reverse, and format—that enable case conversion, concatenation, extraction, padding, trimming, substitution, repetition, reversal, and numeric formatting of textual data.

MySQLSQLString Functions
0 likes · 6 min read
Common MySQL String Functions
Su San Talks Tech
Su San Talks Tech
Jun 10, 2024 · Databases

Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools

This article compares four MySQL‑to‑Elasticsearch synchronization methods—synchronous dual‑write, asynchronous dual‑write, SQL extraction, and Binlog‑based real‑time sync—evaluates their pros and cons, and reviews popular migration tools such as Canal, Alibaba DTS, Databus, Flink, CloudCanal, Maxwell, and DRDS.

BinlogCDCElasticsearch
0 likes · 14 min read
Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools
ITPUB
ITPUB
Jun 8, 2024 · Operations

How to Prevent Catastrophic Data Loss with Automated MySQL and File Backups

This guide explains why accidental database deletion is a serious risk, outlines essential permission and logging measures, and provides step‑by‑step scripts and cron jobs to automatically back up MySQL databases and critical files using Docker, OpenSSL, rsync, and expect.

DockerLinuxMySQL
0 likes · 10 min read
How to Prevent Catastrophic Data Loss with Automated MySQL and File Backups
ITPUB
ITPUB
Jun 6, 2024 · Databases

Why MySQL CPU Spiked to 400%: A Real‑World SQL Optimization Case Study

A startup’s production MySQL server hit 400% CPU usage due to poorly written queries with temporary tables, filesorts, and join buffers, prompting a deep dive into execution plans, concrete optimization recommendations, and a rollback strategy to restore service.

CPU overloadMySQLproduction incident
0 likes · 8 min read
Why MySQL CPU Spiked to 400%: A Real‑World SQL Optimization Case Study
php Courses
php Courses
Jun 5, 2024 · Backend Development

Building and Displaying Nested Category Trees with PHP and MySQL

This guide explains how to design a MySQL categories table, retrieve records with PHP, construct a recursive tree based on parent_id, and render the hierarchical structure as nested HTML lists, providing a complete solution for managing product categories in e‑commerce applications.

MySQLPHPRecursive
0 likes · 5 min read
Building and Displaying Nested Category Trees with PHP and MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 5, 2024 · Databases

Understanding the InnoDB Lock Module Structure

This article explains the structure and components of InnoDB's lock module, including the global lock_sys object, its hash tables, latch mechanisms, waiting thread slots, and related attributes, with detailed code examples and diagrams to illustrate how row and table locks are managed.

Database InternalsInnoDBMySQL
0 likes · 15 min read
Understanding the InnoDB Lock Module Structure
Programmer XiaoFu
Programmer XiaoFu
Jun 4, 2024 · Operations

How to Tackle a 900% CPU Spike in MySQL and Java Processes

The article walks through real interview scenarios where MySQL or Java processes consume 900% CPU, detailing step‑by‑step diagnosis with top, processlist, jstack, and concrete remediation such as adding indexes, using caches, fixing busy loops, and tuning memory.

CPUGCJava
0 likes · 12 min read
How to Tackle a 900% CPU Spike in MySQL and Java Processes
Practical DevOps Architecture
Practical DevOps Architecture
Jun 4, 2024 · Databases

Causes and Solutions for MySQL Master‑Slave Replication Lag

This article explains why MySQL master‑slave replication can become delayed—including single‑threaded binlog processing, high load, network latency, and configuration issues—and provides detailed troubleshooting steps and practical solutions such as semi‑synchronous replication, hardware upgrades, and configuration tuning.

MySQLSemi‑synchronousdatabase architecture
0 likes · 8 min read
Causes and Solutions for MySQL Master‑Slave Replication Lag
Practical DevOps Architecture
Practical DevOps Architecture
Jun 4, 2024 · Databases

Understanding Large Transactions, Risks, and Mitigation Strategies in Databases

The article defines large database transactions, explains their performance and replication risks, offers practical guidelines to avoid them, demonstrates a MySQL example that creates and repeatedly inserts data to illustrate growing execution time, and discusses challenges and solutions for handling massive tables in high‑traffic environments.

Large TransactionsMySQLPerformance
0 likes · 5 min read
Understanding Large Transactions, Risks, and Mitigation Strategies in Databases
Efficient Ops
Efficient Ops
Jun 3, 2024 · Databases

How Does MySQL Execute a Query? Inside the Server Architecture

This article walks through how MySQL processes a SELECT query, detailing the server and storage engine layers, the roles of the connector, query cache, parser, optimizer, and executor, and provides practical command‑line examples to illustrate each step.

ConnectorExecutorMySQL
0 likes · 11 min read
How Does MySQL Execute a Query? Inside the Server Architecture
Java Backend Technology
Java Backend Technology
Jun 3, 2024 · Databases

How to Efficiently Query Multi‑Business Sales Data with Row‑Comparison in MySQL

This article explores how to retrieve sales statistics for multiple business units and their associated products in MySQL, compares loop‑based, OR‑concatenated, mixed‑filter, and SQL‑92 row‑comparison techniques, and explains why the row‑comparison method was ultimately chosen for its performance and compliance with development constraints.

Dynamic SQLMySQLRow Comparison
0 likes · 8 min read
How to Efficiently Query Multi‑Business Sales Data with Row‑Comparison in MySQL
dbaplus Community
dbaplus Community
Jun 2, 2024 · Databases

Why MySQL Emoji Inserts Fail and How utf8mb4 Fixes Them

This article explains why inserting emoji characters into a MySQL table defined with the default utf8 charset triggers a string‑value error, explores the underlying encoding and charset concepts, compares utf8mb3 and utf8mb4, and shows how to convert tables to avoid such failures.

MySQLcharacter setcollation
0 likes · 9 min read
Why MySQL Emoji Inserts Fail and How utf8mb4 Fixes Them
Architect's Guide
Architect's Guide
May 30, 2024 · Databases

MySQL vs PostgreSQL: Overview, Performance Comparison, and Use Cases

The article compares MySQL and PostgreSQL, covering their histories, architecture hierarchies, benchmark performance on SELECT/INSERT/UPDATE, suitable use cases, and summarizes PostgreSQL’s advantages and disadvantages relative to MySQL, providing guidance for choosing the appropriate database.

MySQLPostgreSQLSQL
0 likes · 9 min read
MySQL vs PostgreSQL: Overview, Performance Comparison, and Use Cases
Open Source Linux
Open Source Linux
May 30, 2024 · Databases

How to Automate MySQL Backups and Restores with Bash and Cron

Learn to create a Bash script that backs up a specific MySQL database using mysqldump, automatically deletes old backups, handles Windows line‑ending issues, schedules daily execution with cron, and restores compressed backups, complete with detailed command examples and explanations of find -mtime.

CronDatabase RestorationLinux
0 likes · 7 min read
How to Automate MySQL Backups and Restores with Bash and Cron
FunTester
FunTester
May 29, 2024 · Databases

How Fast Can MySQL Write? Comparing Single-Row, Batch, and Multi-Row Inserts

This article evaluates MySQL single‑thread write performance by testing three insertion methods—continuous while‑loop inserts, JDBC batch processing, and multi‑row INSERT statements—detailing setup, code examples, and measured rows per minute to reveal their relative throughput and stability.

Batch InsertJDBCMulti-Row Insert
0 likes · 10 min read
How Fast Can MySQL Write? Comparing Single-Row, Batch, and Multi-Row Inserts
Aikesheng Open Source Community
Aikesheng Open Source Community
May 29, 2024 · Databases

Analysis of InnoDB Table and Row Lock Structures in MySQL 8.0.32

This article examines the shared and distinct fields of InnoDB's table‑lock and row‑lock structures in MySQL 8.0.32, explains the layout of the lock_t, lock_table_t and lock_rec_t structs, decodes the type_mode bit‑field, and discusses how InnoDB merges compatible row‑locks using a bitmap memory area.

Database InternalsInnoDBMySQL
0 likes · 13 min read
Analysis of InnoDB Table and Row Lock Structures in MySQL 8.0.32
php Courses
php Courses
May 27, 2024 · Backend Development

How to Implement Taxi Trajectory Display with PHP and Baidu Maps API

This tutorial demonstrates how to build a taxi trajectory visualization by creating a MySQL table for track data, inserting sample records, writing a PHP script to serve the data as JSON, and using Baidu Maps JavaScript API in an HTML page to render the moving paths.

Baidu Maps APIMySQLPHP
0 likes · 6 min read
How to Implement Taxi Trajectory Display with PHP and Baidu Maps API
21CTO
21CTO
May 25, 2024 · Databases

How Pinterest Scaled Its Architecture: From Clusters to Sharding

This article examines Pinterest's evolution through four development phases, the core technologies it adopted, and how it transitioned from complex clustering to a simpler sharding architecture to achieve scalable, high‑availability data storage.

ArchitectureClusteringDatabase Scaling
0 likes · 11 min read
How Pinterest Scaled Its Architecture: From Clusters to Sharding
Architect
Architect
May 24, 2024 · Backend Development

How to Build a MySQL‑Based Fuzzy Company Name Matcher with Regex and IKAnalyzer

This article walks through a real‑world approval workflow where a business user adds a company, explains why MySQL REGEXP is chosen over Elasticsearch for fuzzy matching, and details the step‑by‑step implementation—including name preprocessing, tokenization with IKAnalyzer, and a custom SQL query that ranks results by match degree.

Backend DevelopmentIKAnalyzerJava
0 likes · 13 min read
How to Build a MySQL‑Based Fuzzy Company Name Matcher with Regex and IKAnalyzer
Laravel Tech Community
Laravel Tech Community
May 23, 2024 · Databases

MySQL Master‑Slave Replication: Theory, Installation, Configuration, and Laravel Read‑Write Separation

This article explains the concept of MySQL master‑slave replication, outlines its advantages and drawbacks, and provides a step‑by‑step guide—including downloading MySQL 8.0, configuring my.cnf on master and slave servers, creating replication users, setting up replication parameters, and using Laravel for read‑write splitting—complete with all necessary shell and SQL commands.

Database ConfigurationLaravelLinux
0 likes · 9 min read
MySQL Master‑Slave Replication: Theory, Installation, Configuration, and Laravel Read‑Write Separation
Selected Java Interview Questions
Selected Java Interview Questions
May 23, 2024 · Databases

MySQL Table Design Best Practices and Common Pitfalls

This article presents a comprehensive guide to MySQL table design, covering naming conventions, appropriate data types, primary key strategies, field length choices, logical deletion, common fields, indexing rules, normalization trade‑offs, storage engine selection, time type recommendations, and SQL optimization tips.

Data TypesMySQLSQL
0 likes · 17 min read
MySQL Table Design Best Practices and Common Pitfalls
php Courses
php Courses
May 21, 2024 · Backend Development

Implementing User Registration and Data Storage with PHP Functions

This article demonstrates how to use PHP functions to implement user registration and data storage, covering input validation, password hashing, MySQL database connection, SQL insertion, and returning operation results, while highlighting security considerations and practical code examples.

Backend DevelopmentData StorageMySQL
0 likes · 4 min read
Implementing User Registration and Data Storage with PHP Functions
Open Source Linux
Open Source Linux
May 21, 2024 · Operations

Set Up CentOS 7 VM, Configure IP, Install JDK, MySQL, Tomcat & Auto-Start

This guide walks through importing a CentOS 7 virtual machine in VMware, configuring network settings (dynamic or static IP), resolving common issues, then installing and configuring JDK 1.8, MySQL 5.7, and Tomcat 8.5, and finally creating systemd services for automatic startup of Java applications.

CentOSJDKMySQL
0 likes · 14 min read
Set Up CentOS 7 VM, Configure IP, Install JDK, MySQL, Tomcat & Auto-Start
Liangxu Linux
Liangxu Linux
May 20, 2024 · Operations

Mastering Linux Log Management with crontab and logrotate

This guide explains how to define log management goals, handle special logging scenarios for services like MySQL and nginx, and implement automated cleanup using crontab and logrotate, including detailed configuration options and practical examples for reliable log rotation and storage control.

LinuxLog ManagementMySQL
0 likes · 12 min read
Mastering Linux Log Management with crontab and logrotate
MaGe Linux Operations
MaGe Linux Operations
May 19, 2024 · Databases

How to Deploy Xenon: A Raft‑Based MySQL HA Solution with Semi‑Sync and Parallel Replication

This guide walks through deploying Xenon, an open‑source Raft‑based MySQL high‑availability solution, covering environment setup, installation of Go and Percona XtraBackup, configuring Xenon’s JSON, starting the cluster, monitoring status, and troubleshooting backup failures caused by misconfigured host settings.

Database ReplicationGoMySQL
0 likes · 8 min read
How to Deploy Xenon: A Raft‑Based MySQL HA Solution with Semi‑Sync and Parallel Replication
Liangxu Linux
Liangxu Linux
May 19, 2024 · Databases

Master MySQL Performance: Proven SQL, Index, and Hardware Optimization Techniques

This guide presents comprehensive MySQL performance‑tuning methods, covering SQL pagination tricks, proper index creation and usage, join and UNION optimizations, slow‑query logging, schema design choices, and hardware recommendations to dramatically improve query speed and resource efficiency.

MySQLdatabase designhardware optimization
0 likes · 16 min read
Master MySQL Performance: Proven SQL, Index, and Hardware Optimization Techniques
Programmer XiaoFu
Programmer XiaoFu
May 16, 2024 · Databases

MySQL Fuzzy Search Without LIKE%: Using Full‑Text Indexes

This article explains how InnoDB full‑text search can replace LIKE% fuzzy queries by using inverted indexes, covering index structures, creation syntax, MATCH() AGAINST() modes, practical demos, query expansion, and index removal, while noting when to prefer external search engines.

Boolean ModeMySQLQuery Expansion
0 likes · 12 min read
MySQL Fuzzy Search Without LIKE%: Using Full‑Text Indexes
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
May 16, 2024 · Databases

Why MySQL Dominates in Mainland China While PostgreSQL Remains Secondary, and Can PostgreSQL Replace MySQL?

The article analyses the historical, technical, and market reasons why MySQL became the mainstream database in mainland China, contrasts its simplicity and performance with PostgreSQL's advanced transaction and consistency features, and discusses whether PostgreSQL can realistically replace MySQL in enterprise scenarios.

ChinaMySQLPostgreSQL
0 likes · 6 min read
Why MySQL Dominates in Mainland China While PostgreSQL Remains Secondary, and Can PostgreSQL Replace MySQL?
Bilibili Tech
Bilibili Tech
May 14, 2024 · Backend Development

Design and Implementation of Bilibili Live Ranking System

The article details Bilibili’s live ranking system, explaining how configurable ranking lists—managed via a console, stored in MySQL and cached in Redis zsets—support diverse dimensions, scoring modes, and filters to boost streamer and viewer engagement, while addressing high traffic, reliability, and future scalability plans.

ConfigurationMySQLRedis
0 likes · 20 min read
Design and Implementation of Bilibili Live Ranking System
Su San Talks Tech
Su San Talks Tech
May 14, 2024 · Backend Development

How We Fixed Repeated Kafka Message Backlog in a High‑Traffic Restaurant System

This article details a series of Kafka message backlog incidents in a busy restaurant ordering system, analyzes root causes such as consumer speed, database indexing, and sudden traffic spikes, and presents step‑by‑step optimizations—including batch queries, index tuning, data archiving, and thread‑pool adjustments—to restore real‑time performance.

KafkaMySQLPerformance Optimization
0 likes · 11 min read
How We Fixed Repeated Kafka Message Backlog in a High‑Traffic Restaurant System
Liangxu Linux
Liangxu Linux
May 13, 2024 · Databases

Master MySQL Transaction Isolation: From Dirty Reads to Serializable

This article explains MySQL's transaction concepts, the four isolation levels defined by the SQL standard, how each level prevents dirty reads, non‑repeatable reads, and phantom reads, and provides practical commands and example experiments to configure and observe their behavior in InnoDB.

InnoDBMVCCMySQL
0 likes · 19 min read
Master MySQL Transaction Isolation: From Dirty Reads to Serializable
Go Programming World
Go Programming World
May 12, 2024 · Backend Development

Resolving MySQL Dependencies in Go Unit Tests with Fake and Mock Objects

This article explains how to write Go unit tests for HTTP handlers that depend on MySQL by using fake implementations and the gomock library to replace the store layer, demonstrating both fake object and mock approaches, code examples, and best practices for isolating external dependencies.

Dependency InjectionFakeGo
0 likes · 18 min read
Resolving MySQL Dependencies in Go Unit Tests with Fake and Mock Objects
Java Tech Enthusiast
Java Tech Enthusiast
May 9, 2024 · Databases

Risks of Using INSERT INTO SELECT in MySQL: A Postmortem

Using MySQL’s INSERT INTO SELECT on a large, unindexed table caused full‑table locks that timed out concurrent transactions, leading to lost payment rows; the post‑mortem shows that adding appropriate indexes to the WHERE clause and understanding locking behavior prevents such intermittent failures.

INSERT INTO SELECTMySQLdatabase migration
0 likes · 6 min read
Risks of Using INSERT INTO SELECT in MySQL: A Postmortem
Open Source Tech Hub
Open Source Tech Hub
May 8, 2024 · Databases

How Yearning Automates MySQL SQL Auditing and Rollback – A Complete Guide

Yearning is an open-source MySQL SQL audit platform built with Go and Vue.js that automates statement review, generates rollback scripts, provides audit logging, supports multi-channel notifications, and offers fine-grained permission control, with installation instructions and configuration details for rapid deployment.

Database SecurityGoMySQL
0 likes · 5 min read
How Yearning Automates MySQL SQL Auditing and Rollback – A Complete Guide
JD Retail Technology
JD Retail Technology
May 8, 2024 · Databases

Understanding MySQL Cost Model for Index Optimization and Conflict Resolution

This article explains MySQL's cost‑based optimizer, demonstrates how to calculate query costs for full‑table, covering, ref and range scans using actual source‑code constants, and applies the model to resolve index‑conflict cases in a store‑goods table, offering practical optimization guidelines and future tool ideas.

Cost ModelIndex OptimizationMySQL
0 likes · 22 min read
Understanding MySQL Cost Model for Index Optimization and Conflict Resolution
Cognitive Technology Team
Cognitive Technology Team
May 8, 2024 · Databases

Introduction to InnoDB Transaction Lock System in MySQL

This article provides a comprehensive overview of InnoDB's transaction lock subsystem in MySQL, explaining row‑level and table‑level lock types, their internal implementations, lock‑compatibility rules, practical SQL examples, and common deadlock scenarios with detailed code illustrations.

InnoDBMySQLRow-Level Locking
0 likes · 29 min read
Introduction to InnoDB Transaction Lock System in MySQL
JavaEdge
JavaEdge
May 7, 2024 · Backend Development

Mastering Product Management: Build SPU/SKU CRUD with Snowflake IDs in Java

This guide walks through implementing a complete product management module in a Java e‑commerce system, covering Snowflake distributed ID generation, database schema design for SPU and SKU tables, CRUD operations, category‑brand linking, audit workflow, status toggling, batch processing, and logical deletion, all with concrete code examples.

BackendCRUDJava
0 likes · 16 min read
Mastering Product Management: Build SPU/SKU CRUD with Snowflake IDs in Java
Aikesheng Open Source Community
Aikesheng Open Source Community
May 7, 2024 · Databases

Why Expanding a MySQL VARCHAR Column from 63 to 64 Characters Takes Much Longer

The article investigates why altering a MySQL VARCHAR column from a length that fits within 255 bytes to one that exceeds this limit (e.g., VARCHAR(63) to VARCHAR(64) in utf8mb4) triggers a costly copy operation, analyzes the storage mechanics, reproduces the issue, and provides practical recommendations to avoid performance penalties.

MySQLOnline DDLPerformance
0 likes · 13 min read
Why Expanding a MySQL VARCHAR Column from 63 to 64 Characters Takes Much Longer
Liangxu Linux
Liangxu Linux
May 6, 2024 · Databases

Why MySQL’s “utf8” Isn’t Real UTF‑8 and How utf8mb4 Fixes It

Discover why MySQL’s legacy ‘utf8’ charset only supports three‑byte characters, causing storage errors for true UTF‑8 data, and learn how the ‘utf8mb4’ charset resolves these issues, with historical context, technical details, and migration guidance.

MariaDBMySQLcharacter set
0 likes · 7 min read
Why MySQL’s “utf8” Isn’t Real UTF‑8 and How utf8mb4 Fixes It
ITPUB
ITPUB
May 6, 2024 · Databases

How MySQL’s Write‑Ahead Log Protects Data During Power Outages

This article explains MySQL InnoDB’s write‑ahead logging, detailing the roles of Buffer Pool, Redo and Undo logs, checkpoint mechanisms, and how they ensure data consistency and atomicity when a sudden power loss occurs.

CheckpointInnoDBMySQL
0 likes · 12 min read
How MySQL’s Write‑Ahead Log Protects Data During Power Outages
dbaplus Community
dbaplus Community
May 5, 2024 · Databases

Why MySQL’s utf8 Isn’t Real UTF‑8 and How utf8mb4 Solves Emoji Errors

The article explains why MySQL’s built‑in utf8 charset cannot store four‑byte characters such as emojis, demonstrates the resulting insert error, shows how switching the database, table and connection to utf8mb4 fixes the issue, and recounts the historical reasons behind MySQL’s limited utf8 implementation.

MySQLcharacter setemoji
0 likes · 8 min read
Why MySQL’s utf8 Isn’t Real UTF‑8 and How utf8mb4 Solves Emoji Errors
Su San Talks Tech
Su San Talks Tech
May 5, 2024 · Backend Development

Fixing MyBatis‑Plus Migration Errors: Why LocalDateTime Conversion Fails and How to Resolve It

This article walks through replacing MyBatis with MyBatis‑Plus in a legacy Java project, explains the “Conversion not supported for type java.time.LocalDateTime” error caused by MyBatis 3.5.1 and an outdated mysql‑connector‑java driver, and shows how upgrading the driver resolves the issue while offering debugging tips.

JavaMyBatisMyBatis-Plus
0 likes · 16 min read
Fixing MyBatis‑Plus Migration Errors: Why LocalDateTime Conversion Fails and How to Resolve It
Java Tech Enthusiast
Java Tech Enthusiast
May 3, 2024 · Databases

MySQL Data Recovery: Strategies for Handling Accidental Deletion

The article explains how to respond to accidental MySQL data deletion by analyzing loss causes, choosing recovery methods such as mysqldump backups, binary‑log point‑in‑time restores, or Percona’s InnoDB tool, provides step‑by‑step commands, and recommends preventive practices like regular backups, transactions, and strict permissions.

BinlogDatabase SecurityMySQL
0 likes · 3 min read
MySQL Data Recovery: Strategies for Handling Accidental Deletion
ITPUB
ITPUB
May 2, 2024 · Databases

Boost MySQL Performance 30‑50% with Profile‑Guided Optimization (PGO)

This article explains how Profile‑Guided Optimization (PGO) can increase MySQL throughput by 30‑50% without changing application code, detailing the required compilation steps, necessary CMake flags, and real‑world benchmark results that demonstrate the performance gains and their limitations.

C++MySQLPGO
0 likes · 10 min read
Boost MySQL Performance 30‑50% with Profile‑Guided Optimization (PGO)
21CTO
21CTO
Apr 30, 2024 · Databases

What’s New in MySQL 8.4? Key Feature Changes and Default Settings Explained

This article summarizes the major changes introduced in MySQL 8.4, including updated InnoDB parameters, revised default values, new cloning plugin rules, Windows SASL‑based LDAP authentication, and adjustments to replication settings, helping developers and DBAs optimize their database configurations.

8.4Database ConfigurationInnoDB
0 likes · 8 min read
What’s New in MySQL 8.4? Key Feature Changes and Default Settings Explained
Architect
Architect
Apr 29, 2024 · Databases

How to Slash MySQL Slow Queries on a 100M‑Row Table: Index Tuning and Batch Deletion

The article walks through a real‑world MySQL performance case where a 100‑million‑row table caused SLA alerts, analyzes slow‑query logs, demonstrates index redesign, compares online DDL with pt‑osc, and shows how batch deletions by primary key dramatically reduce delete time and replication lag.

Batch DeleteIndex OptimizationLarge Table
0 likes · 15 min read
How to Slash MySQL Slow Queries on a 100M‑Row Table: Index Tuning and Batch Deletion