BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 21 of 50
Top Architect
Top Architect
Jan 11, 2024 · Databases

Implementing Multi‑Tenant SaaS Architecture with MySQL Partitioning and MyBatis Interceptor

This article demonstrates how to convert a single‑tenant MySQL application into a multi‑tenant SaaS solution by adding a tenant_id column, using shared‑database partitioning, creating tenant tables, writing stored procedures for dynamic partition management, and implementing a MyBatis interceptor for hierarchical data permissions.

MyBatisMySQLSaaS
0 likes · 19 min read
Implementing Multi‑Tenant SaaS Architecture with MySQL Partitioning and MyBatis Interceptor
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 11, 2024 · Databases

Step-by-Step Guide to Managing SQL Releases with SQLE

This article provides a detailed walkthrough of using the SQLE platform to create users, configure data sources, submit SQL tickets, perform reviews, and execute releases, illustrating each step with screenshots and practical tips for effective database change management.

Database ManagementMySQLSQL
0 likes · 7 min read
Step-by-Step Guide to Managing SQL Releases with SQLE
php Courses
php Courses
Jan 10, 2024 · Backend Development

How to Query MySQL with PHP and Return Results as an Array

This tutorial demonstrates how to set up a PHP script that connects to a MySQL database, executes a SELECT query, stores the result rows in an array, and displays the data in an HTML table using loops such as while and foreach.

MySQLPHPSQL
0 likes · 5 min read
How to Query MySQL with PHP and Return Results as an Array
Efficient Ops
Efficient Ops
Jan 9, 2024 · Operations

35 Must‑Know Linux Operations Interview Questions & Answers

This comprehensive guide compiles 35 essential Linux operations interview questions covering server management, RAID configurations, load balancing with LVS/Nginx/HAProxy, proxy choices, middleware, MySQL troubleshooting, networking tools, security practices, and practical scripts, providing concise answers to help candidates ace DevOps and sysadmin roles.

LinuxMySQLOperations
0 likes · 34 min read
35 Must‑Know Linux Operations Interview Questions & Answers
Architect
Architect
Jan 9, 2024 · Databases

How to Build a Multi‑Tenant SaaS Architecture with MySQL Partitioning and MyBatis Interceptor

This article walks through converting a single‑tenant MySQL application into a SaaS solution by adding a tenant_id column, using shared‑database table partitioning, creating tenant metadata tables, writing stored procedures to add columns and partitions, and implementing a MyBatis interceptor for automatic data‑permission enforcement.

Data PermissionMyBatisMySQL
0 likes · 22 min read
How to Build a Multi‑Tenant SaaS Architecture with MySQL Partitioning and MyBatis Interceptor
php Courses
php Courses
Jan 9, 2024 · Databases

Efficiently Inserting 10 Million Records into MySQL with PHP

This tutorial explains how to use PHP and PDO to quickly insert ten million rows into a remote MySQL database by preparing the connection, employing batch inserts, managing transactions, tuning MySQL settings, and optionally using the LOAD DATA statement for optimal performance.

Bulk InsertMySQLPDO
0 likes · 6 min read
Efficiently Inserting 10 Million Records into MySQL with PHP
ITPUB
ITPUB
Jan 8, 2024 · Databases

How I Cut an 8‑Second SQL Query to 0.7 Seconds: Step‑by‑Step Optimization

This article walks through a real‑world case of a slow MySQL query that took 8 seconds, explains how the original use of EXISTS and NOT EXISTS caused performance bottlenecks, and details two successive rewrites—first using JOIN + GROUP BY, then replacing NOT EXISTS with NOT IN—bringing execution time down to 0.7 seconds while highlighting key indexing and testing lessons.

MySQLQuery OptimizationSQL
0 likes · 7 min read
How I Cut an 8‑Second SQL Query to 0.7 Seconds: Step‑by‑Step Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 8, 2024 · Databases

MySQL General Tablespaces: A Powerful Storage Option

This article explains what MySQL general tablespaces are, outlines their main features and benefits, provides step‑by‑step commands for creating, managing, and assigning tables to them, and shows monitoring queries and practical usage scenarios for improved storage efficiency and performance.

InnoDBMySQLPerformance
0 likes · 12 min read
MySQL General Tablespaces: A Powerful Storage Option
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 8, 2024 · Databases

AIKOS Open Source Community Weekly Newsletter – SQLE Release, Community Updates, and Selected Database Articles

This newsletter announces the SQLE 3.2401.0-pre1 release with automatic data masking, shares recent community development work, outlines upcoming plans, and curates several technical articles covering MySQL EXPLAIN enhancements, transaction fundamentals, hardware considerations for database stability, consistent backup techniques, and efficient JDBC connection testing.

MySQLSQLSQLE
0 likes · 6 min read
AIKOS Open Source Community Weekly Newsletter – SQLE Release, Community Updates, and Selected Database Articles
dbaplus Community
dbaplus Community
Jan 7, 2024 · Databases

How to Cut MySQL Storage Costs by Over 50%: A Practical Framework

This article presents a systematic, nine‑grid method for reducing MySQL storage expenses—including table compression, JSON field serialization, and hot‑cold data separation—while quantifying benefits, ensuring data safety, and validating system stability through staged testing and SRE metrics.

Database Cost ReductionMySQLdata compression
0 likes · 13 min read
How to Cut MySQL Storage Costs by Over 50%: A Practical Framework
MaGe Linux Operations
MaGe Linux Operations
Jan 7, 2024 · Backend Development

Mastering MySQL Connections in Go: From Raw SQL to GORM ORM

Learn how to connect Go applications to MySQL using the native driver and the GORM ORM, covering driver installation, basic connection code, database configuration, query execution, and best practices for model definition and handling common pitfalls.

Backend DevelopmentDatabase ConnectionGORM
0 likes · 9 min read
Mastering MySQL Connections in Go: From Raw SQL to GORM ORM
MaGe Linux Operations
MaGe Linux Operations
Jan 4, 2024 · Databases

Master MySQL Stored Procedures: Concepts, Syntax, and Real-World Examples

This guide explains MySQL stored procedures, covering their definition, benefits, parameter types, creation syntax, delimiter handling, multiple practical examples, calling conventions, debugging tips, and hands‑on exercises, enabling developers to efficiently write, test, and manage reusable SQL routines.

Code ExamplesMySQLSQL
0 likes · 17 min read
Master MySQL Stored Procedures: Concepts, Syntax, and Real-World Examples
ITPUB
ITPUB
Jan 3, 2024 · Databases

Why MySQL Queries Can Be 50,000× Faster with Proper Indexing

This article walks through a MySQL 5.6 scenario where a sub‑query that scans 700,000 rows takes over 30,000 seconds, then demonstrates how adding single‑column and composite indexes, rewriting the query as a join, and analyzing execution plans reduces the runtime to milliseconds, highlighting best‑practice indexing techniques.

Index OptimizationMySQLQuery Tuning
0 likes · 12 min read
Why MySQL Queries Can Be 50,000× Faster with Proper Indexing
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 2, 2024 · Databases

Using EXPLAIN INTO and EXPLAIN FOR SCHEMA in MySQL 8.1 and 8.2

This article explains the new EXPLAIN INTO clause introduced in MySQL 8.1 for storing JSON‑formatted EXPLAIN output in a user variable and the EXPLAIN FOR SCHEMA clause added in MySQL 8.2 for running EXPLAIN on other schemas, showing how to extract costs with JSON functions and automate collection with stored procedures.

EXPLAINJSONMySQL
0 likes · 7 min read
Using EXPLAIN INTO and EXPLAIN FOR SCHEMA in MySQL 8.1 and 8.2
政采云技术
政采云技术
Jan 2, 2024 · Databases

Understanding B‑Tree and B+Tree Indexes in MySQL

This article explains the fundamentals of B‑Tree and B+Tree data structures, their search algorithms, and how MySQL's MyISAM and InnoDB storage engines implement these indexes to achieve efficient disk‑based query performance.

AlgorithmsB+ TreeB-Tree
0 likes · 19 min read
Understanding B‑Tree and B+Tree Indexes in MySQL
IT Services Circle
IT Services Circle
Jan 1, 2024 · Backend Development

ByteDance Java Backend Internship Interview Questions and Answers

This article compiles a comprehensive set of ByteDance daily internship interview questions covering Java backend fundamentals, networking protocols, operating system concepts, Linux process management, Redis data structures and persistence, MySQL indexing and query optimization, as well as essential algorithms, providing detailed explanations and code examples for each topic.

BackendJavaMySQL
0 likes · 37 min read
ByteDance Java Backend Internship Interview Questions and Answers
ITPUB
ITPUB
Dec 31, 2023 · Databases

Master MySQL Index Optimization with EXPLAIN: A Step‑by‑Step Guide

This article explains why slow queries occur in high‑traffic MySQL databases, introduces the EXPLAIN statement, walks through its syntax and output columns, demonstrates how to interpret each field with concrete examples, and provides a practical workflow for optimizing indexes to eliminate performance bottlenecks.

EXPLAINIndex OptimizationMySQL
0 likes · 14 min read
Master MySQL Index Optimization with EXPLAIN: A Step‑by‑Step Guide
IT Niuke
IT Niuke
Dec 31, 2023 · Databases

How to Optimize MyBatis-Plus Batch Insert Performance

This article explains why MyBatis-Plus saveBatch does not perform true batch inserts, shows how to enable JDBC rewriteBatchedStatements, creates a custom SQL injector with InsertBatchSomeColumn, implements batch splitting in a service layer, and presents benchmark results that demonstrate a several‑second speedup for inserting tens of thousands of rows.

Batch InsertJavaMyBatis-Plus
0 likes · 11 min read
How to Optimize MyBatis-Plus Batch Insert Performance
ITPUB
ITPUB
Dec 30, 2023 · Databases

Why MySQL 5.6 → 5.7 Upgrades Fail and How to Prevent Rollbacks

The article recounts a legacy project that relied on MySQL 5.6, explains common pitfalls of that version such as replication lag, heavy performance_schema overhead, binlog issues, and memory limits, then details why an upgrade to 5.7 was rolled back due to syntax changes, case‑sensitivity differences, and unresolved configuration problems.

Case SensitivityMySQLReplication
0 likes · 9 min read
Why MySQL 5.6 → 5.7 Upgrades Fail and How to Prevent Rollbacks
dbaplus Community
dbaplus Community
Dec 30, 2023 · Databases

Essential MySQL Best Practices for High‑Performance, Scalable Architecture

This guide presents a comprehensive set of MySQL conventions—including engine choice, character set, naming, table and column design, indexing, and SQL usage—tailored for high‑concurrency, large‑scale internet services, explaining the rationale behind each rule to boost performance and maintainability.

MySQLPerformancebest practices
0 likes · 8 min read
Essential MySQL Best Practices for High‑Performance, Scalable Architecture
IT Services Circle
IT Services Circle
Dec 29, 2023 · Backend Development

Bank Software Development Interview Guide: Java, MySQL, Thread Pools, HTTP, TCP/UDP, and Database Indexes

This article compiles common technical interview questions for bank software positions, covering Java fundamentals, MySQL storage engines and indexes, thread‑pool parameters, HTTP GET/POST differences, TCP vs UDP characteristics, session and cookie handling, Redis data types, and C++ memory management, providing concise explanations and examples for each topic.

C++DatabaseIndexHTTP
0 likes · 32 min read
Bank Software Development Interview Guide: Java, MySQL, Thread Pools, HTTP, TCP/UDP, and Database Indexes
JD Retail Technology
JD Retail Technology
Dec 28, 2023 · Databases

Methods and Practices for Reducing MySQL Database Storage Costs

This article outlines the background, challenges, systematic methods, benefit calculations, data‑safety and stability checks, verification steps, rollback strategies, and gray‑deployment practices for lowering MySQL storage expenses in large‑scale billing systems while maintaining system reliability.

Data SafetyDatabase Cost ReductionGray Deployment
0 likes · 12 min read
Methods and Practices for Reducing MySQL Database Storage Costs
vivo Internet Technology
vivo Internet Technology
Dec 27, 2023 · Databases

Evolution of Vivo's Database Backup and Recovery System

Vivo replaced its fragile Python‑Celery backup system on GlusterFS—characterized by two‑day MySQL backups, single‑point failures, and weak security—with a Java‑based architecture using a Redis cluster and object storage, adding automated copying, verification, point‑in‑time recovery and migration, cutting backup windows to about ten hours and achieving near‑100 % success.

MongoDBMySQLTiDB
0 likes · 28 min read
Evolution of Vivo's Database Backup and Recovery System
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 26, 2023 · Databases

Understanding MySQL 8.0 immediate_commit_timestamp and original_commit_timestamp in Binlog Replication

This article explains the meaning, generation process, and operational impact of the new immediate_commit_timestamp and original_commit_timestamp fields in MySQL 8.0 binlog events, including how they affect replication delay calculations, warning handling, and precise monitoring of transaction commit times.

GTIDMySQLtimestamp
0 likes · 9 min read
Understanding MySQL 8.0 immediate_commit_timestamp and original_commit_timestamp in Binlog Replication
Architecture Digest
Architecture Digest
Dec 25, 2023 · Databases

Lessons Learned from Misusing INSERT INTO SELECT in MySQL: OOM, Full Table Scan, and Transaction Issues

This article recounts a real‑world MySQL data‑migration failure caused by an unguarded INSERT INTO SELECT that triggered OOM, full‑table scans, and row‑level locking, explains why testing missed the problem, and offers indexing and transaction‑level safeguards to prevent similar incidents.

INSERT INTO SELECTMySQLdatabase migration
0 likes · 6 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL: OOM, Full Table Scan, and Transaction Issues
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 25, 2023 · Databases

Can You Trust AI Chatbots When Seeking Help With Databases?

This article examines how generative AI chatbots such as Google Bard, Bing Chat, and ChatGPT respond to database downgrade queries for MongoDB and MySQL, highlighting inaccurate or fabricated answers, providing correct downgrade procedures, and stressing the need for careful verification when relying on AI assistance.

AIMongoDBMySQL
0 likes · 13 min read
Can You Trust AI Chatbots When Seeking Help With Databases?
dbaplus Community
dbaplus Community
Dec 24, 2023 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

When a system’s data grows, MySQL queries can become slow and cause latency; this article presents practical optimization strategies—including query tuning, pagination, join improvements, subquery replacement, order‑by and group‑by enhancements, and count() efficiency—illustrated with sample tables, code snippets, and performance screenshots.

GROUP BYJOINMySQL
0 likes · 13 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
Wukong Talks Architecture
Wukong Talks Architecture
Dec 24, 2023 · Databases

MySQL Indexes, Lock Types, Transaction Isolation Levels, and Deadlock Analysis

This article explains MySQL index structures, covers covered and back‑table queries, details InnoDB transaction isolation levels, classifies various lock types (table, row, gap, next‑key, intention, auto‑inc, metadata), analyzes lock behavior in multiple scenarios, discusses deadlock causes, and provides DDL and online schema‑change recommendations.

DDLMySQLdeadlock
0 likes · 61 min read
MySQL Indexes, Lock Types, Transaction Isolation Levels, and Deadlock Analysis
ITPUB
ITPUB
Dec 22, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers from 5.7 to 8.0 Without Downtime

GitHub upgraded over 1,200 MySQL hosts from 5.7 to 8.0 across more than 50 clusters, detailing the motivation, infrastructure, extensive preparation, a five‑step rolling upgrade process, rollback strategies, challenges like Vitess integration and replication lag, and key lessons for future database migrations.

GitHubMySQLdatabase migration
0 likes · 14 min read
How GitHub Upgraded 1,200 MySQL Servers from 5.7 to 8.0 Without Downtime
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Dec 22, 2023 · Databases

Understanding NULL Values in MySQL

This article explains the nature of NULL in MySQL, demonstrates why comparisons with = or != fail, shows the correct IS NULL/IS NOT NULL syntax, and discusses how NULL behaves with DISTINCT, GROUP BY, ORDER BY, and aggregate functions.

AggregationMySQLNULL
0 likes · 6 min read
Understanding NULL Values in MySQL
Sanyou's Java Diary
Sanyou's Java Diary
Dec 21, 2023 · Databases

What Happens Inside MySQL When You Run an UPDATE? A Deep Dive

This article explains the complete execution process of a MySQL UPDATE statement, covering InnoDB page structures, tablespaces, buffer pool caching, redo/undo logs, binlog, and the two‑phase commit mechanism, helping readers understand how MySQL ensures data consistency and durability.

Buffer PoolInnoDBMySQL
0 likes · 21 min read
What Happens Inside MySQL When You Run an UPDATE? A Deep Dive
IT Services Circle
IT Services Circle
Dec 21, 2023 · Backend Development

Comprehensive Backend Interview Guide: MySQL, Redis, Java Collections, Concurrency, and TCP

This article compiles essential backend interview questions and answers covering MySQL storage engines and indexes, Redis persistence modes, Java collection frameworks and HashMap internals, thread‑safe ConcurrentHashMap implementations, as well as HTTP message structure and TCP reliability mechanisms, providing a thorough review for candidates preparing for backend positions.

JavaMySQLRedis
0 likes · 26 min read
Comprehensive Backend Interview Guide: MySQL, Redis, Java Collections, Concurrency, and TCP
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 20, 2023 · Information Security

MySQL User Security Hardening: Password Policy, Connection Control, and Password Change Strategies

This article details how to strengthen MySQL user security by implementing comprehensive password complexity requirements, connection control policies, and password change strategies, including configuration of the validate_password component, connection_control plugin, and password expiration settings for MySQL 5.7 and 8.0, with practical examples and code snippets.

Connection ControlMySQLdatabase administration
0 likes · 21 min read
MySQL User Security Hardening: Password Policy, Connection Control, and Password Change Strategies
dbaplus Community
dbaplus Community
Dec 19, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers from 5.7 to 8.0 Without Downtime

GitHub detailed a year‑long, multi‑team effort to upgrade over 1,200 MySQL hosts from version 5.7 to 8.0, describing the motivations, infrastructure scale, preparation steps, a staged rollout plan, rollback strategies, challenges faced, and key lessons learned for large‑scale database migrations.

GitHubMySQLReplication
0 likes · 16 min read
How GitHub Upgraded 1,200 MySQL Servers from 5.7 to 8.0 Without Downtime
LouZai
LouZai
Dec 18, 2023 · Databases

How Many Rows Can a Single MySQL Table Actually Store? A Deep Dive

This article analyzes the theoretical and practical limits of a single MySQL InnoDB table by examining B+‑tree depth, page layout, row format, and index pointer size, then calculates minimum and maximum record counts for int and bigint primary keys and validates the results with real‑world table schemas.

B+ TreeIndex PointerInnoDB
0 likes · 13 min read
How Many Rows Can a Single MySQL Table Actually Store? A Deep Dive
Su San Talks Tech
Su San Talks Tech
Dec 18, 2023 · Databases

Master MySQL Transactions: ACID, Isolation Levels, and MVCC Explained

This comprehensive guide explores MySQL transaction fundamentals, the ACID properties, various isolation levels, concurrency issues like dirty, non‑repeatable, and phantom reads, and dives deep into MVCC implementation, hidden fields, undo logs, and read views to help developers write reliable, consistent database code.

ACIDIsolation LevelMVCC
0 likes · 24 min read
Master MySQL Transactions: ACID, Isolation Levels, and MVCC Explained
php Courses
php Courses
Dec 16, 2023 · Databases

Why EXISTS() Is More Efficient Than COUNT() in MySQL and Laravel

Using MySQL's EXISTS() function for existence checks is generally more efficient and readable than COUNT(), especially in large datasets, and Laravel provides convenient query builder methods to implement EXISTS() queries, offering performance gains over COUNT() in PHP applications.

COUNTLaravelMySQL
0 likes · 6 min read
Why EXISTS() Is More Efficient Than COUNT() in MySQL and Laravel
21CTO
21CTO
Dec 15, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime

GitHub’s engineering team detailed a year‑long, multi‑team effort to upgrade over 1,200 MySQL hosts from 5.7 to 8.0, preserving high availability, SLO compliance, and rollback capability while introducing new features and performance improvements.

GitHubMySQLReplication
0 likes · 17 min read
How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime
JD Tech
JD Tech
Dec 15, 2023 · Databases

Systematic Approach to Reducing MySQL Database Storage Costs

This article presents a comprehensive, step‑by‑step methodology for cutting MySQL storage expenses—including background analysis, challenge identification, a nine‑grid systematic framework, benefit calculation, safety and stability verification, rollout, gray‑release, and rollback—demonstrating over 50% disk space reduction while managing risk.

MySQLStorage Managementcost reduction
0 likes · 14 min read
Systematic Approach to Reducing MySQL Database Storage Costs
Programmer DD
Programmer DD
Dec 14, 2023 · Databases

How GitHub Upgraded Its 1200‑Node MySQL Cluster to 8.0 Without Downtime

GitHub detailed its year‑long, multi‑team effort to seamlessly upgrade over 1,200 MySQL servers—supporting more than 300 TB of data and 5.5 million queries per second—from 5.7 to 8.0, outlining the infrastructure, tools, and step‑by‑step migration strategy used to maintain service reliability.

GitHubMySQLdatabase migration
0 likes · 5 min read
How GitHub Upgraded Its 1200‑Node MySQL Cluster to 8.0 Without Downtime
政采云技术
政采云技术
Dec 14, 2023 · Databases

Understanding MySQL Locks: Types, Mechanisms, and Deadlock Resolution

This article explains the various lock types in MySQL—including global, table, row, metadata, and intent locks—how they work under InnoDB, demonstrates lock acquisition with SQL examples, and provides practical guidance for detecting and resolving deadlocks in production environments.

InnoDBLocksMySQL
0 likes · 17 min read
Understanding MySQL Locks: Types, Mechanisms, and Deadlock Resolution
FunTester
FunTester
Dec 12, 2023 · Backend Development

Understanding ResultSet Resource Release and Statement Concurrency in MySQL JDBC

This article examines how MySQL's JDBC driver manages ResultSet resource release, the internal close mechanisms, and the concurrency limitations of Statement objects, illustrated with code excerpts and a Groovy virtual‑thread demo that reveals runtime exceptions when ResultSets are accessed after implicit closure.

JDBCJavaMySQL
0 likes · 8 min read
Understanding ResultSet Resource Release and Statement Concurrency in MySQL JDBC
dbaplus Community
dbaplus Community
Dec 12, 2023 · Databases

Why Does MySQL Replication Lag? Causes and Practical Fixes

This article explains the fundamentals of MySQL master‑slave replication, identifies why replication lag occurs—including single‑threaded processing, lock contention, network issues, and outdated versions—and offers concrete strategies such as hardware upgrades, configuration tweaks, and architectural changes to minimize the delay.

LagMySQLOptimization
0 likes · 7 min read
Why Does MySQL Replication Lag? Causes and Practical Fixes
Efficient Ops
Efficient Ops
Dec 12, 2023 · Databases

How to Diagnose MySQL Lock Waits and Transaction Timeouts with MyAWR

This article explains how commercial banks can analyze MySQL lock‑wait events and transaction timeouts using MDL metadata lock monitoring, innodb_lock_wait_timeout, custom MyAWR collection, SQL de‑parameterization, and post‑mortem queries to pinpoint blocking SQL and its source.

Lock WaitMySQLSQL optimization
0 likes · 19 min read
How to Diagnose MySQL Lock Waits and Transaction Timeouts with MyAWR
JD Retail Technology
JD Retail Technology
Dec 12, 2023 · Databases

Common SQL Optimization Techniques for MySQL

This article reviews MySQL's execution process and presents a comprehensive list of practical SQL optimization strategies—including indexing, query rewriting, avoiding costly operators, using batch operations, and leveraging EXPLAIN—to improve database performance and maintainability.

MySQLSQL optimizationdatabase tuning
0 likes · 14 min read
Common SQL Optimization Techniques for MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 11, 2023 · Databases

Understanding utf8mb4 and Its Advantages in MySQL 8.0

This article explains the differences between utf8, utf8mb3 and utf8mb4 character sets in MySQL, demonstrates how utf8mb4 enables full Unicode support including emojis, and provides step‑by‑step SQL examples for creating tables, inserting data, and querying results with the proper character set.

MySQLUnicodeemoji
0 likes · 12 min read
Understanding utf8mb4 and Its Advantages in MySQL 8.0
Open Source Tech Hub
Open Source Tech Hub
Dec 11, 2023 · Databases

How MySQL 8.2 Router Enables Seamless Read/Write Splitting

Oracle’s MySQL 8.2 introduces built‑in read/write splitting via MySQL Router, allowing write traffic to target primary instances while reads are automatically routed to secondary replicas, with configuration examples, command‑line bootstrap, routing settings, and practical observations on transaction behavior.

InnoDB ClusterMySQLMySQL Router
0 likes · 6 min read
How MySQL 8.2 Router Enables Seamless Read/Write Splitting
FunTester
FunTester
Dec 10, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime

GitHub detailed a year‑long, multi‑team effort to upgrade over 1,200 MySQL hosts from 5.7 to 8.0 using phased rollouts, automated testing, compatibility checks, and rollback mechanisms while maintaining strict SLOs and high‑availability requirements.

GitHubMySQLOperations
0 likes · 16 min read
How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime
dbaplus Community
dbaplus Community
Dec 10, 2023 · Databases

How to Import 1 Billion Records into MySQL in Record Time

This article outlines a comprehensive strategy for rapidly loading one billion 1 KB log records stored in HDFS or S3 into MySQL, covering data partitioning, B‑tree limits, batch inserts, storage‑engine selection, sharding, concurrent write control, efficient file reading, task coordination, fault‑tolerant progress tracking with Redis, and distributed locking with Redisson.

Batch InsertFile ReadingMySQL
0 likes · 20 min read
How to Import 1 Billion Records into MySQL in Record Time
Open Source Tech Hub
Open Source Tech Hub
Dec 10, 2023 · Backend Development

How to Persist WebSocket Messages with MySQL in a PHP Webman App

This guide explains how to implement server‑side WebSocket message persistence using MySQL, covering requirement analysis, database schema design, Think‑ORM integration, event handling code, testing scripts, and performance considerations for high‑concurrency scenarios.

MySQLPHPWebSocket
0 likes · 10 min read
How to Persist WebSocket Messages with MySQL in a PHP Webman App
ITPUB
ITPUB
Dec 10, 2023 · Databases

Do 20‑Million‑Row MySQL Tables Still Slow Down on SSDs? Experimental Results

The article investigates whether the long‑standing rule of avoiding MySQL tables larger than 20 million rows still holds on modern SSD‑backed instances by creating tables of varying sizes, measuring query latency under different InnoDB buffer pool configurations, and analyzing the impact of caching and index usage.

Buffer PoolInnoDBMySQL
0 likes · 11 min read
Do 20‑Million‑Row MySQL Tables Still Slow Down on SSDs? Experimental Results
Test Development Learning Exchange
Test Development Learning Exchange
Dec 10, 2023 · Backend Development

Online Traffic Replay in Python Automated Testing: Log Parsing, MySQL Storage, and Local Request Data Management

This article explains how to implement online traffic replay for Python automated testing by parsing logs, storing request data in a local MySQL database, analyzing user information with data‑analysis libraries, and locally persisting URL, method, headers, and body details using JSON files, complete with sample code.

Data AnalysisMySQLPython
0 likes · 5 min read
Online Traffic Replay in Python Automated Testing: Log Parsing, MySQL Storage, and Local Request Data Management
dbaplus Community
dbaplus Community
Dec 9, 2023 · Databases

Why MySQL Still Beats PostgreSQL in China: A Deep Dive

An in‑depth analysis shows that MySQL’s early Windows support, lower entry barrier, strong LAMP ecosystem, backing from major Chinese tech firms, and a mature tooling landscape together explain why it remains far more popular than PostgreSQL across China despite global growth trends.

ChinaDatabase PopularityMySQL
0 likes · 9 min read
Why MySQL Still Beats PostgreSQL in China: A Deep Dive
Architect's Guide
Architect's Guide
Dec 8, 2023 · Databases

Why Transaction Isolation Is Needed and Understanding MySQL Isolation Levels

Transaction isolation prevents concurrency issues such as dirty writes, dirty reads, non‑repeatable reads, and phantom reads in MySQL, and the article explains these problems, the ACID properties of transactions, and the four isolation levels—read uncommitted, read committed, repeatable read, and serializable.

ACIDMySQLdatabases
0 likes · 9 min read
Why Transaction Isolation Is Needed and Understanding MySQL Isolation Levels
Efficient Ops
Efficient Ops
Dec 6, 2023 · Databases

When and How to Use MySQL Locks: A Deep Dive into Explicit and Implicit Locking

This article explains MySQL's explicit and implicit locking mechanisms, illustrates how transaction isolation levels affect lock scope, provides practical SQL examples for various scenarios, and offers guidelines on when to apply pessimistic locks versus optimistic approaches to maintain database performance.

MySQLSQLdatabase
0 likes · 13 min read
When and How to Use MySQL Locks: A Deep Dive into Explicit and Implicit Locking
Architecture Digest
Architecture Digest
Dec 6, 2023 · Databases

MySQL Query Optimization and Index Tuning: From Subqueries to Joins

This article analyzes a slow MySQL query that scans millions of rows to find students scoring 100 in Chinese, then demonstrates how adding appropriate single‑column and composite indexes, rewriting the query as a join, and using covering indexes can reduce execution time from hours to milliseconds.

MySQLQuery OptimizationSQL
0 likes · 10 min read
MySQL Query Optimization and Index Tuning: From Subqueries to Joins
dbaplus Community
dbaplus Community
Dec 5, 2023 · Databases

How I Cut an 8‑Second Slow Query to 0.7 Seconds with Two Optimizations

The article walks through a real‑world case of a slow MySQL query that took 8 seconds, explains why simple indexing wasn't enough, and demonstrates two successive rewrites using JOIN‑GROUP BY and NOT IN that reduced execution time to 0.7 seconds while detailing the EXPLAIN analysis.

EXPLAINMySQLQuery Optimization
0 likes · 6 min read
How I Cut an 8‑Second Slow Query to 0.7 Seconds with Two Optimizations
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 5, 2023 · Databases

Optimizing MySQL Join Queries: Algorithms, Execution Plans, and Practical Tips

This article explains the characteristics of various MySQL join algorithms—including Simple Nested‑Loop, Index Nested‑Loop, Block Nested‑Loop, Hash Join, and Batched Key Access—demonstrates how to examine execution plans, configure optimizer settings, and apply best‑practice optimizations such as indexing, choosing the small driver table, and upgrading MySQL versions.

BKAHash JoinJOIN optimization
0 likes · 12 min read
Optimizing MySQL Join Queries: Algorithms, Execution Plans, and Practical Tips
Sanyou's Java Diary
Sanyou's Java Diary
Dec 4, 2023 · Backend Development

When Pagination Breaks: Real‑World Bugs and Practical Fixes

This article recounts three production‑level pagination bugs encountered in a payment system, explains why they occurred—ranging from naive batch processing to MySQL's nondeterministic LIMIT behavior—and shows how proper pagination, ThreadLocal cleanup, and deterministic ordering resolve the issues.

BackendBug fixingMySQL
0 likes · 16 min read
When Pagination Breaks: Real‑World Bugs and Practical Fixes
php Courses
php Courses
Dec 2, 2023 · Databases

Index Optimization Techniques for PHP and MySQL Multi‑Table Queries

Effective index design, including single‑table, foreign‑key, composite, and covering indexes, along with optimizer hints, can dramatically improve the performance of multi‑table queries in PHP‑MySQL applications, and the article provides practical examples and SQL statements for each technique.

Index OptimizationMySQLPHP
0 likes · 4 min read
Index Optimization Techniques for PHP and MySQL Multi‑Table Queries
LouZai
LouZai
Dec 1, 2023 · Backend Development

Understanding All Major Distributed Lock Implementations in One Guide

This article explains what distributed locks are, outlines their key properties, classifies implementation approaches, and provides detailed walkthroughs of MySQL, Redis, Etcd, and ZooKeeper based locks—including code examples, trade‑offs, and best‑practice recommendations.

GoMySQLRedis
0 likes · 21 min read
Understanding All Major Distributed Lock Implementations in One Guide
Tencent Cloud Developer
Tencent Cloud Developer
Nov 30, 2023 · Backend Development

Tutorial: Building a Spring Boot CRUD Application with Tencent Hunyuan Large Model API and MySQL

This tutorial demonstrates how to prompt Tencent Hunyuan’s large‑model API to generate a Spring Boot project configured for MySQL, create a user table, and implement full JPA‑based CRUD layers—including entity, repository, service, and REST controller—while addressing common null‑field errors and testing the endpoints.

APICRUDJava
0 likes · 14 min read
Tutorial: Building a Spring Boot CRUD Application with Tencent Hunyuan Large Model API and MySQL
JavaEdge
JavaEdge
Nov 29, 2023 · Databases

How Quora Optimizes MySQL Reads, Writes, and Storage with Caching and MyRocks

This article explains how Quora reduces database load by optimizing read patterns, improving high‑QPS queries with smarter caching, shrinking table size using MyRocks, and boosting write throughput through parallel replication settings, providing concrete steps, code snippets, and real‑world results.

MyRocksMySQLRead/Write Performance
0 likes · 12 min read
How Quora Optimizes MySQL Reads, Writes, and Storage with Caching and MyRocks
Architect
Architect
Nov 28, 2023 · Databases

How to Import 1 Billion Records into MySQL Efficiently: Architecture & Performance Guide

This article walks through the full engineering process of importing a billion 1 KB log records into MySQL, covering data size calculations, B‑tree index limits, batch‑insert strategies, storage‑engine trade‑offs, fast file‑reading techniques, task coordination with Redis and Redisson, and distributed‑lock design using Zookeeper.

Batch InsertDistributed TasksMySQL
0 likes · 20 min read
How to Import 1 Billion Records into MySQL Efficiently: Architecture & Performance Guide
Top Architect
Top Architect
Nov 28, 2023 · Databases

Performance Comparison of JOIN vs IN in MySQL Queries

This article experimentally compares the performance of JOIN and IN approaches for retrieving order and user data in MySQL, showing that JOIN is faster on small datasets while IN may become costly with large data volumes, and discusses code implementations and practical conclusions.

JOINMySQLPHP
0 likes · 10 min read
Performance Comparison of JOIN vs IN in MySQL Queries
IT Services Circle
IT Services Circle
Nov 28, 2023 · Backend Development

Comprehensive Java Interview Guide: Basics, Collections, Concurrency, Spring Boot, MySQL, and Network Concepts

This article provides a thorough overview of Java interview topics, covering core language fundamentals, collection frameworks, concurrency mechanisms, Spring Boot transaction handling, database indexing strategies, and network protocol comparisons, all presented in clear English with code examples and diagrams.

JavaMySQLNetworking
0 likes · 19 min read
Comprehensive Java Interview Guide: Basics, Collections, Concurrency, Spring Boot, MySQL, and Network Concepts