BestHub
Sign in
Tagged articles
5000 articles
Page 16 of 50
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.

Character SetDatabase AdministrationMySQL
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.

Character SetEncodingMariaDB
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.

CheckpointDatabase RecoveryInnoDB
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.

Character SetEmojiEncoding
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.

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

Data RecoveryDatabase BackupMySQL
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++Compiler OptimizationMySQL
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
Architect's Tech Stack
Architect's Tech Stack
Apr 29, 2024 · Databases

Performance Evaluation of Inserting Billion-Scale Data into MySQL Using MyBatis, JDBC, and Batch Processing

This article presents a comprehensive performance test of inserting massive amounts of randomly generated person records into MySQL, comparing three strategies—MyBatis lightweight insertion, direct JDBC handling, and JDBC batch processing—both with and without transactions, and concludes that combining batch processing with transactions yields the fastest insertion speed for large‑scale data loads.

Batch processingJDBCLarge Data Insertion
0 likes · 13 min read
Performance Evaluation of Inserting Billion-Scale Data into MySQL Using MyBatis, JDBC, and Batch Processing
Lobster Programming
Lobster Programming
Apr 28, 2024 · Databases

How to Solve MySQL Deep Pagination: Causes and 6 Effective Optimization Strategies

Deep pagination in MySQL becomes a performance bottleneck when tables reach millions of rows, causing excessive row scans and costly index lookups; this article explains its root causes and presents six practical optimization techniques—including keyset pagination, delayed joins, covering indexes, data partitioning, and external search engines—to dramatically improve query speed.

Keyset PaginationMySQLcovering index
0 likes · 7 min read
How to Solve MySQL Deep Pagination: Causes and 6 Effective Optimization Strategies
Lobster Programming
Lobster Programming
Apr 27, 2024 · Databases

Essential MySQL Optimization: SQL Tricks and Parameter Tuning

This guide covers practical MySQL performance improvements, detailing SQL-level optimizations such as limit pagination, proper LIKE usage, UNION ALL, EXISTS vs IN, TRUNCATE, batch inserts, early filtering, function placement, data type minimization, CHAR/VARCHAR choices, indexing strategies, force index, as well as server parameter tuning for buffer pool and redo log settings.

Database TuningMySQLSQL optimization
0 likes · 10 min read
Essential MySQL Optimization: SQL Tricks and Parameter Tuning
Liangxu Linux
Liangxu Linux
Apr 25, 2024 · Databases

How MySQL’s B+ Tree Indexes Supercharge Query Speed and Reliability

MySQL, born in the 1990s as a free open‑source database, became a core component of the LAMP stack and remains widely used; the article explains why indexes are needed, compares binary trees, B‑trees and B+‑trees, and describes how modern cloud‑based MySQL services improve performance and reliability.

B+TreeData StructuresMySQL
0 likes · 9 min read
How MySQL’s B+ Tree Indexes Supercharge Query Speed and Reliability
php Courses
php Courses
Apr 24, 2024 · Backend Development

How to Connect to a Database Using PHP

This tutorial explains how to connect PHP to databases using both mysqli and PDO, covering connection setup, error handling, executing queries, and properly closing the connection, with complete code examples for each method.

Database ConnectionMySQLMySQLi
0 likes · 4 min read
How to Connect to a Database Using PHP
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 24, 2024 · Databases

Summary of the MySQL Transaction Module Series

This article reviews the 14-part series on MySQL's transaction module, covering initialization, transaction types, two‑phase commit, binlog handling, savepoints, and full rollback, and provides links to each detailed post, including discussions on BEGIN statements, read‑only transactions, and the internal mechanisms of InnoDB.

DatabaseInnoDBMySQL
0 likes · 5 min read
Summary of the MySQL Transaction Module Series
The Dominant Programmer
The Dominant Programmer
Apr 23, 2024 · Fundamentals

How to Write, Convert, and Read WKB Data with JTS in Java

This article explains the WKB binary format, its storage advantages in MySQL and PostgreSQL, and provides step‑by‑step Java code using JTS's GeometryFactory, WKBWriter, and WKBReader to write a Point to WKB, convert it to a hex string, and read it back into a geometry object.

GeometryJTSJava
0 likes · 3 min read
How to Write, Convert, and Read WKB Data with JTS in Java
Inke Technology
Inke Technology
Apr 23, 2024 · Databases

How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB

This article details the migration of a popular social app's private‑message service from a saturated MySQL cluster to PolarDB, covering business challenges, evaluation of storage‑optimization, vertical and horizontal scaling, the chosen distributed database solution, step‑by‑step offline and online migration procedures, and the resulting performance and cost benefits.

MySQLPolardbScalability
0 likes · 12 min read
How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB
MaGe Linux Operations
MaGe Linux Operations
Apr 22, 2024 · Databases

How to Reset MySQL Root Password and Manage User Grants Safely

This guide walks through three MySQL administration scenarios—resetting the root password using the --skip-grant-tables option, adding user accounts with proper grants, and changing passwords via UPDATE, SET PASSWORD, ALTER USER, GRANT, and mysqladmin—providing step‑by‑step commands and precautions.

Database AdministrationMySQLRoot Password
0 likes · 7 min read
How to Reset MySQL Root Password and Manage User Grants Safely
Architecture Digest
Architecture Digest
Apr 22, 2024 · Backend Development

Migrating from MyBatis to MyBatis-Plus: Resolving LocalDateTime Conversion Errors and Lessons Learned

This article walks through replacing MyBatis with MyBatis‑Plus in a legacy Java project, demonstrates the LocalDateTime conversion error caused by MySQL‑connector‑java version incompatibility, shows how upgrading the driver resolves the issue, and shares a cautionary tale about unintended bugs after component upgrades.

DatabaseJavaLocalDateTime
0 likes · 15 min read
Migrating from MyBatis to MyBatis-Plus: Resolving LocalDateTime Conversion Errors and Lessons Learned
dbaplus Community
dbaplus Community
Apr 18, 2024 · Databases

How I Rescued a MySQL Table After a Massive Bad‑Group Insertion

A Java developer recounts a production MySQL outage caused by a faulty batch insert, walks through failed delete and lock‑free attempts, then details a series of table‑recreation, truncate, and index‑rebuilding steps that finally restored data integrity and performance.

DDLDatabase AdministrationIndex Recovery
0 likes · 13 min read
How I Rescued a MySQL Table After a Massive Bad‑Group Insertion
IT Services Circle
IT Services Circle
Apr 18, 2024 · Databases

Improving MySQL Insert Performance with Batch Operations and MyBatis Flex

This article explains how to boost MySQL insertion speed by adjusting server hardware, tuning database parameters, choosing the MyISAM engine, and especially applying three batch‑insert techniques—SQL concatenation, MyBatis‑Flex saveBatch, and manual transaction batching—while showing test results and configuration tips.

Batch InsertDatabase OptimizationMyBatis
0 likes · 8 min read
Improving MySQL Insert Performance with Batch Operations and MyBatis Flex
dbaplus Community
dbaplus Community
Apr 17, 2024 · Backend Development

How We Scaled a Volunteer Registration System to 20k QPS with Redis, RocketMQ, and MySQL

This article recounts how a volunteer registration platform was redesigned to meet extreme concurrency demands—handling up to 40k QPS and 20k TPS—by evaluating MySQL limits, adding Redis caching, integrating RocketMQ, applying fault‑recovery mechanisms, and iteratively optimizing through multiple load‑testing rounds.

MySQLRedisRocketMQ
0 likes · 16 min read
How We Scaled a Volunteer Registration System to 20k QPS with Redis, RocketMQ, and MySQL
Architect
Architect
Apr 17, 2024 · Databases

How We Split a 500‑Million‑Row MySQL Table: Process, Pitfalls, and Lessons

Facing a 50‑million‑row financial transaction table that grew 6 million rows per month, the team analyzed the problem, set clear split goals, evaluated sharding middleware, designed a custom pagination algorithm, built a hybrid data‑migration plan, and executed a three‑stage rollout to safely replace the monolithic table with multiple 10‑million‑row shards.

BackendLarge TablesMySQL
0 likes · 13 min read
How We Split a 500‑Million‑Row MySQL Table: Process, Pitfalls, and Lessons
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 17, 2024 · Databases

Why MySQL’s TDDL Optimizer Picks the Wrong Index and How to Fix It

This article investigates a slow‑SQL incident caused by the TDDL optimizer reordering a MySQL query, analyzes why the optimizer chose an inefficient index, demonstrates how to verify and force the correct index, and proposes better index and partition‑key designs for optimal performance.

Index OptimizationMySQLPartitioning
0 likes · 11 min read
Why MySQL’s TDDL Optimizer Picks the Wrong Index and How to Fix It
Liangxu Linux
Liangxu Linux
Apr 16, 2024 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

Learn how to assess and optimize your MySQL database using four powerful open‑source tools—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—complete with download links, command‑line usage examples, and guidance on interpreting their diagnostic reports to improve performance and security.

Database ToolsMySQLPerformance tuning
0 likes · 9 min read
Boost MySQL Performance: Essential Tools and How to Use Them
Architecture & Thinking
Architecture & Thinking
Apr 16, 2024 · Databases

Master MySQL InnoDB Locks: How SELECT…FOR UPDATE Behaves

This article explains the default repeatable‑read isolation level in InnoDB, details the three main lock types—record, gap, and next‑key—and shows how SELECT … FOR UPDATE applies different locking rules depending on primary key, unique, ordinary, range, or table‑scan queries, with practical SQL examples.

Database ConcurrencyInnoDBMySQL
0 likes · 10 min read
Master MySQL InnoDB Locks: How SELECT…FOR UPDATE Behaves
Su San Talks Tech
Su San Talks Tech
Apr 15, 2024 · Databases

Mastering MySQL ORDER BY: Full-Field vs RowID Sorting and Optimizations

This article explains how MySQL executes ORDER BY queries, the role of sort_buffer, the difference between full-field and rowid sorting, how parameters like sort_buffer_size and max_length_for_sort_data affect performance, and how proper indexing can eliminate the need for sorting altogether.

Index OptimizationMySQLOrder By
0 likes · 12 min read
Mastering MySQL ORDER BY: Full-Field vs RowID Sorting and Optimizations
Liangxu Linux
Liangxu Linux
Apr 14, 2024 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article presents eight practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting joins, handling mixed ordering, replacing EXISTS with joins, pushing down conditions, pre‑filtering data, and using WITH clauses—to dramatically reduce query execution time.

IndexesMySQLPerformance tuning
0 likes · 13 min read
Boost MySQL Performance: 8 Proven SQL Optimization Techniques
Selected Java Interview Questions
Selected Java Interview Questions
Apr 13, 2024 · Backend Development

Recovering MySQL Data from a Deleted Docker Container

This guide walks through locating the Docker volume of a removed MySQL container, creating a new container with the same image, and swapping the volumes to restore the original database, providing step‑by‑step commands and screenshots for successful data recovery.

Data RecoveryMySQLVolumes
0 likes · 4 min read
Recovering MySQL Data from a Deleted Docker Container
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Apr 13, 2024 · Databases

Comprehensive Guide to MySQL String Functions

This article provides an in‑depth overview of MySQL string functions, covering concatenation, length, position, replacement, conversion, encryption, comparison, generation, and their syntax and usage examples, helping developers manipulate textual data efficiently in database operations.

DatabaseMySQLString Functions
0 likes · 18 min read
Comprehensive Guide to MySQL String Functions
21CTO
21CTO
Apr 12, 2024 · Databases

PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?

This article compares PostgreSQL and MySQL across history, ACID compliance, performance, scalability, advanced features, tooling, security, backup strategies, and Linux installation steps, helping full‑stack developers choose the most suitable open‑source relational database for their projects.

ACIDLinux InstallationMySQL
0 likes · 12 min read
PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?
Architecture Digest
Architecture Digest
Apr 12, 2024 · Databases

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

This article analyzes why MySQL recommends auto‑increment primary keys over UUIDs or random snowflake IDs by designing three tables, running insert‑select benchmarks with Spring Boot's JdbcTemplate, presenting the test results, and discussing the underlying index‑structure impacts and trade‑offs.

Database IndexMySQLauto_increment
0 likes · 10 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
Code Ape Tech Column
Code Ape Tech Column
Apr 12, 2024 · Databases

Understanding Full-Text Search and Inverted Indexes in MySQL InnoDB

This article explains MySQL InnoDB full-text search, covering inverted index structures, creation and usage of full-text indexes, query modes such as natural language, boolean, and query expansion, and provides practical SQL examples and considerations for effective text searching.

DatabaseFull-Text SearchMySQL
0 likes · 11 min read
Understanding Full-Text Search and Inverted Indexes in MySQL InnoDB
Top Architect
Top Architect
Apr 11, 2024 · Databases

MySQL Slow Query Analysis and Index Optimization for Large Tables

This article presents a detailed investigation of a MySQL master‑slave instance suffering from nightly SLA alerts due to slow‑query latency, analyzes the root causes with pt‑query‑digest and execution plans, proposes index redesign, demonstrates backup and restore with mydumper, compares online DDL and pt‑osc, and finally shows batch‑delete techniques to reduce load on large tables.

Database PerformanceIndex OptimizationLarge Tables
0 likes · 16 min read
MySQL Slow Query Analysis and Index Optimization for Large Tables
dbaplus Community
dbaplus Community
Apr 10, 2024 · Databases

How MySQL Chooses the Cheapest Index for COUNT(*) and When It Gets It Wrong

This article examines whether SELECT COUNT(*) causes full‑table scans, explains MySQL’s optimizer cost‑based index selection (including IO and CPU costs), demonstrates with a 100k‑row table how auxiliary indexes are chosen, and shows cases where the optimizer’s estimates mislead performance.

COUNTIndex CostMySQL
0 likes · 9 min read
How MySQL Chooses the Cheapest Index for COUNT(*) and When It Gets It Wrong
IT Services Circle
IT Services Circle
Apr 9, 2024 · Backend Development

ByteDance Backend Interview Experience: Key Topics and Knowledge Points

This article shares a detailed ByteDance backend interview experience covering three rounds, summarizing essential topics such as Java HashMap internals, Spring circular dependencies, MySQL indexing, OS process/thread concepts, networking protocols, TLS handshake, HTTP/2 features, and common design patterns, providing concise explanations and practical tips.

BackendDesign PatternsInterview
0 likes · 25 min read
ByteDance Backend Interview Experience: Key Topics and Knowledge Points
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Apr 8, 2024 · Databases

9 Essential MySQL Index Optimization Techniques You Must Know

This article presents nine practical MySQL index optimization techniques—from selecting high‑selectivity columns and avoiding functions on indexed fields to applying the leftmost‑prefix rule, handling NULLs, using proper LIKE patterns, and leveraging EXPLAIN and LIMIT 1 for faster queries.

Database PerformanceIndex OptimizationMySQL
0 likes · 6 min read
9 Essential MySQL Index Optimization Techniques You Must Know
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 8, 2024 · Databases

How I Rescued a MySQL Table After Massive Bad Data Insertion

When a user reported errors, I discovered a MySQL table flooded with millions of bad rows from a new group, causing slow queries and crashes; I detail the step‑by‑step investigation, failed attempts with DELETE and lock‑free changes, and the final successful rebuild using temporary tables, DROP, TRUNCATE, and index reconstruction.

DDLDatabaseMySQL
0 likes · 13 min read
How I Rescued a MySQL Table After Massive Bad Data Insertion
Liangxu Linux
Liangxu Linux
Apr 7, 2024 · Databases

8 Proven MySQL Query Optimizations to Slash Execution Time

This article explains common MySQL performance pitfalls such as large‑offset pagination, implicit type conversion, inefficient UPDATE/DELETE joins, mixed ordering, EXISTS subqueries, predicate push‑down, early data reduction, and intermediate result set push‑down, and provides concrete rewrites that turn multi‑second queries into millisecond‑level executions.

CTEJoinsMySQL
0 likes · 13 min read
8 Proven MySQL Query Optimizations to Slash Execution Time
dbaplus Community
dbaplus Community
Apr 6, 2024 · Databases

Unlocking InnoDB: Page Size, Row Formats, and Varchar Limits Explained

This article explains what InnoDB does, how its page‑based I/O causes the first query to be slower, the default Dynamic row format, how varchar length is stored, the practical limits of varchar(M) under utf8mb4, and the impact of metadata and internal fragmentation on row space.

Database StorageMySQLPage Size
0 likes · 22 min read
Unlocking InnoDB: Page Size, Row Formats, and Varchar Limits Explained
Efficient Ops
Efficient Ops
Apr 6, 2024 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article explores eight common MySQL performance pitfalls—from inefficient LIMIT usage and implicit type conversion to subquery joins, mixed ordering, EXISTS clauses, condition pushdown, early result limiting, and intermediate result set optimization—offering concrete rewrites and execution plan analyses to dramatically speed up queries.

DatabaseMySQLPerformance tuning
0 likes · 14 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
Liangxu Linux
Liangxu Linux
Apr 4, 2024 · Databases

Why MySQL Tables Stall After 20 Million Rows and How B‑Link Trees Fix It

The article examines why MySQL performance drops sharply when a single table exceeds tens of millions of rows, debunks the index‑depth myth, explains SMO concurrency limits in InnoDB, and shows how B‑Link Tree indexes and heap‑organized tables can overcome these bottlenecks.

B-Link TreeB-TreeDatabase Performance
0 likes · 10 min read
Why MySQL Tables Stall After 20 Million Rows and How B‑Link Trees Fix It
Java Architect Essentials
Java Architect Essentials
Apr 3, 2024 · Databases

MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Condition Pushdown, Early Limiting, and Intermediate Result Pushdown

This article presents a series of MySQL performance‑enhancing techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting UPDATE/DELETE with JOINs, mixed‑order sorting tricks, replacing EXISTS with JOINs, condition push‑down, early result limiting, and intermediate result push‑down—to dramatically reduce query execution time.

DatabaseIndexesMySQL
0 likes · 13 min read
MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Condition Pushdown, Early Limiting, and Intermediate Result Pushdown
Su San Talks Tech
Su San Talks Tech
Apr 2, 2024 · Databases

18 Essential Tips for Designing Robust Database Tables

This article presents 18 practical guidelines for backend developers on naming conventions, field types, lengths, primary keys, indexes, storage engines, null constraints, foreign keys, character sets, collations, large fields, redundant fields, and comments to help create efficient, maintainable MySQL tables.

Database DesignMySQLSQL Best Practices
0 likes · 22 min read
18 Essential Tips for Designing Robust Database Tables
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 1, 2024 · Databases

Understanding MySQL Instant DDL: What DBAs Should Know

The article explains MySQL 8.0's INSTANT DDL algorithm, its default behavior, limitations such as the 64‑change cap, and provides practical recommendations for always specifying the algorithm, monitoring instant changes via INFORMATION_SCHEMA, and safely rebuilding tables when needed.

Database AdministrationInnoDBInstant DDL
0 likes · 7 min read
Understanding MySQL Instant DDL: What DBAs Should Know
dbaplus Community
dbaplus Community
Mar 31, 2024 · Databases

How to Seamlessly Upgrade MySQL 5.7 to 8.0: Step‑by‑Step Guide and Common Pitfalls

This article walks through the complete process of upgrading MySQL 5.7.43 to 8.0.34 on CentOS 7, covering lifecycle background, new 8.0 features, pre‑upgrade checks, data backup, configuration changes, installation, upgrade execution, post‑upgrade verification, and troubleshooting of typical SSL and host‑blocking issues.

MySQLconfigurationdatabase migration
0 likes · 21 min read
How to Seamlessly Upgrade MySQL 5.7 to 8.0: Step‑by‑Step Guide and Common Pitfalls
Top Architect
Top Architect
Mar 31, 2024 · Databases

Inserting 300,000 Records with MyBatis and JDBC: Batch vs Loop Approaches and Performance Optimization

This article demonstrates how to insert 300,000 rows into a MySQL table using MyBatis and JDBC, compares bulk batch insertion with per‑row looping, discusses packet size limits, transaction handling, performance metrics, and provides practical code snippets and optimization tips for efficient large‑scale data loading.

Batch InsertJDBCMyBatis
0 likes · 16 min read
Inserting 300,000 Records with MyBatis and JDBC: Batch vs Loop Approaches and Performance Optimization
Top Architect
Top Architect
Mar 31, 2024 · Databases

Understanding MySQL Auto‑Increment IDs, Their Limits, and Alternative Strategies

This article explains how MySQL auto‑increment primary keys work, the practical limits of various internal IDs such as auto‑increment, InnoDB row_id, Xid, trx_id, and thread_id, and compares them with external solutions like Redis‑based auto‑increment keys, providing guidance on choosing the right approach for different scenarios.

InnoDBMySQLRedis
0 likes · 10 min read
Understanding MySQL Auto‑Increment IDs, Their Limits, and Alternative Strategies
DevOps Operations Practice
DevOps Operations Practice
Mar 30, 2024 · Cloud Native

How to Deploy MySQL with Docker: A Step-by-Step Guide

This guide explains how to install Docker, pull the official MySQL image, run a MySQL container with persistent storage, connect to it, perform basic SQL operations, and finally stop and remove the container, demonstrating a complete end‑to‑end deployment using Docker.

ContainerizationDatabaseDevOps
0 likes · 5 min read
How to Deploy MySQL with Docker: A Step-by-Step Guide
Architect
Architect
Mar 29, 2024 · Databases

Understanding Database Sharding and Partitioning with ShardingSphere

This article explains the fundamentals of database sharding and partitioning, why they are needed for massive data volumes, various vertical and horizontal splitting strategies, routing algorithms, client vs. proxy deployment models, and the practical challenges and solutions when using ShardingSphere 5.x.

MySQLPartitioningShardingSphere
0 likes · 17 min read
Understanding Database Sharding and Partitioning with ShardingSphere
ITPUB
ITPUB
Mar 29, 2024 · Databases

How to Import 1 Billion Records into MySQL at Lightning Speed

This guide explains how to efficiently load one billion 1‑KB log entries from HDFS or S3 into MySQL by analyzing B‑tree limits, using batch inserts, choosing the right storage engine, sharding tables, optimizing file reading, and coordinating tasks with Redis, Redisson, and Zookeeper.

Batch InsertBig DataDistributed Tasks
0 likes · 19 min read
How to Import 1 Billion Records into MySQL at Lightning Speed
Java Architect Essentials
Java Architect Essentials
Mar 28, 2024 · Backend Development

Why Switching MyBatis to MyBatis‑Plus Triggers LocalDateTime Errors—and How to Resolve Them

This article walks through replacing MyBatis with MyBatis‑Plus in a legacy Java project, uncovers the root cause of a LocalDateTime conversion error caused by MyBatis 3.5.1 and an outdated MySQL connector, demonstrates version upgrades and code fixes, and shares a related production bug and its remediation.

BackendJavaLocalDateTime
0 likes · 15 min read
Why Switching MyBatis to MyBatis‑Plus Triggers LocalDateTime Errors—and How to Resolve Them
Java Captain
Java Captain
Mar 28, 2024 · Databases

Analyzing the Cost of Establishing MySQL Database Connections in Java Applications

This article investigates the time overhead of establishing MySQL database connections in Java web applications, detailing the TCP handshake, authentication steps, and measured latency using Wireshark, and demonstrates why connection pooling is essential to avoid hundreds of milliseconds per request.

Connection PoolingDatabase ConnectionJava
0 likes · 7 min read
Analyzing the Cost of Establishing MySQL Database Connections in Java Applications
Refining Core Development Skills
Refining Core Development Skills
Mar 27, 2024 · Backend Development

How I Built My Personal Technical Blog Site Using Typecho on a Lightweight Cloud Server

This article details the motivations, technology choices, step‑by‑step deployment of Typecho on a Tencent lightweight cloud server, domain registration, site theming, custom image‑processing plugins, HTTPS setup, content migration, and a concise checklist for building a dynamic personal technical website.

LNMPMySQLTypecho
0 likes · 11 min read
How I Built My Personal Technical Blog Site Using Typecho on a Lightweight Cloud Server
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 26, 2024 · Databases

MySQL 8.0.22 READ ONLY Database Feature: Overview, Usage, Query Methods, Limitations and Exceptions

This article explains the MySQL 8.0.22 READ ONLY option for individual databases, demonstrates how to enable and verify the read‑only state with ALTER DATABASE and SHOW CREATE DATABASE commands, shows the impact on DDL/DML operations, lists usage restrictions, and notes exceptional cases and backup considerations.

ALTER DATABASEDatabaseInformation Schema
0 likes · 11 min read
MySQL 8.0.22 READ ONLY Database Feature: Overview, Usage, Query Methods, Limitations and Exceptions
DevOps Operations Practice
DevOps Operations Practice
Mar 25, 2024 · Operations

How to Monitor MySQL with Prometheus and Grafana

This tutorial explains how to install the MySQL Exporter, configure Prometheus to scrape MySQL metrics, set up Grafana dashboards for visualization, and define alerting rules for common MySQL performance indicators, providing a complete end‑to‑end monitoring solution.

ExporterGrafanaMetrics
0 likes · 5 min read
How to Monitor MySQL with Prometheus and Grafana
Java Architect Essentials
Java Architect Essentials
Mar 25, 2024 · Databases

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

This article introduces MySQL and PostgreSQL, compares their architectures and benchmark results, highlights performance differences in SELECT, INSERT, and UPDATE operations, and discusses suitable scenarios and trade‑offs to help developers choose the appropriate database for their applications.

MySQLPerformance BenchmarkPostgreSQL
0 likes · 9 min read
MySQL vs PostgreSQL: Overview, Performance Comparison, and Use Cases
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Mar 25, 2024 · Backend Development

Design and Performance Optimization of a High‑Concurrency Volunteer Registration System

This article recounts the end‑to‑end design, bottleneck analysis, and iterative performance tuning—including MySQL, Redis, RocketMQ, compression, sharding, and connection‑pool adjustments—that enabled a volunteer registration platform to meet demanding high‑concurrency and data‑accuracy requirements under limited resources.

JavaMySQLRocketMQ
0 likes · 16 min read
Design and Performance Optimization of a High‑Concurrency Volunteer Registration System
Python Programming Learning Circle
Python Programming Learning Circle
Mar 21, 2024 · Databases

Comprehensive Guide to Using PyMySQL for MySQL Interaction in Python

This article provides a detailed tutorial on the PyMySQL library, covering installation, connection setup, cursor operations, executing queries, transaction handling, advanced features like batch processing and connection pooling, as well as best practices for error handling and performance optimization in Python‑MySQL applications.

DatabaseMySQLPython
0 likes · 9 min read
Comprehensive Guide to Using PyMySQL for MySQL Interaction in Python
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 19, 2024 · Information Security

Risks of Granting MySQL Authentication Table Permissions and How to Mitigate Them

The article explains how granting ordinary MySQL users full access to authentication tables can lead to severe privilege‑escalation risks, demonstrates the issue with concrete scenarios, and provides mitigation strategies including the use of MySQL 8.0 partial revokes and the principle of least privilege.

Information SecurityMySQLPartial Revokes
0 likes · 9 min read
Risks of Granting MySQL Authentication Table Permissions and How to Mitigate Them
Architecture & Thinking
Architecture & Thinking
Mar 19, 2024 · Databases

Why MySQL Indexes Fail: 9 Common Pitfalls and How to Fix Them

This article enumerates the most frequent situations that cause MySQL indexes to become ineffective—such as violating the left‑most rule, using functions or expressions on indexed columns, type conversions, improper LIKE patterns, OR/IN/NOT IN usage, and inequality operators—and demonstrates how to reproduce and verify each case with sample data and SQL scripts.

Database OptimizationMySQLindexing
0 likes · 21 min read
Why MySQL Indexes Fail: 9 Common Pitfalls and How to Fix Them
Architect
Architect
Mar 18, 2024 · Databases

MySQL vs PostgreSQL: Overview, Performance Benchmark, and Use‑Case Guidance

The article introduces MySQL and PostgreSQL, compares their performance through a benchmark on identical hardware, discusses each system’s strengths, weaknesses, and suitable application scenarios, and provides guidance on choosing the appropriate database for different workloads.

MySQLPerformance BenchmarkPostgreSQL
0 likes · 8 min read
MySQL vs PostgreSQL: Overview, Performance Benchmark, and Use‑Case Guidance