BestHub
Sign in
Tagged articles
5000 articles
Page 5 of 50
Top Architect
Top Architect
Oct 13, 2025 · Backend Development

Why Replacing MyBatis with MyBatis‑Plus Can Break Your App—and How to Fix It

The article walks through swapping MyBatis for MyBatis‑Plus in a legacy Java project, explains the LocalDateTime conversion error caused by MyBatis 3.5.1 and an outdated MySQL driver, shows how upgrading mysql‑connector‑java resolves the issue, and warns that component upgrades can trigger cascading bugs that require thorough testing.

ORMbackend-developmentjava
0 likes · 11 min read
Why Replacing MyBatis with MyBatis‑Plus Can Break Your App—and How to Fix It
Senior Brother's Insights
Senior Brother's Insights
Oct 13, 2025 · Databases

Why Setting MySQL Columns to NOT NULL Boosts Performance and Saves Space

This article explains why defining MySQL table columns as NOT NULL—unless business logic demands NULL—improves query speed, reduces storage overhead, enhances index efficiency, prevents aggregation distortion, simplifies application code, and strengthens data consistency, while also noting scenarios where NULL is appropriate.

Database OptimizationNOT NULLStorage Efficiency
0 likes · 9 min read
Why Setting MySQL Columns to NOT NULL Boosts Performance and Saves Space
Java Tech Enthusiast
Java Tech Enthusiast
Oct 13, 2025 · Databases

Why OR Queries Break MySQL Indexes and How to Fix Them

This article explains how MySQL OR conditions can cause index loss, demonstrates typical scenarios with multi‑field, range, and dynamic filters, and provides practical solutions such as using UNION/UNION ALL or adding appropriate indexes to restore efficient query performance.

Index OptimizationOR queryUNION
0 likes · 7 min read
Why OR Queries Break MySQL Indexes and How to Fix Them
Architect
Architect
Oct 12, 2025 · Databases

How to Safely Add a Column to a Billion‑Row Order Table Without Downtime

Adding a new field to a core order table with tens of millions of rows can lock the table and disrupt services, so this article explores various strategies—including master‑slave switching, online DDL tools, extension tables, JSON fields, and repurposing redundant columns—to achieve schema changes safely and efficiently.

JSON fieldOnline DDLSchema Change
0 likes · 8 min read
How to Safely Add a Column to a Billion‑Row Order Table Without Downtime
DevOps Coach
DevOps Coach
Oct 11, 2025 · Databases

Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification

Uber migrated its core database from PostgreSQL to MySQL because PostgreSQL suffered from index bloat, write amplification, high replication overhead, and limited MVCC support, prompting a detailed analysis of each issue, the improvements in newer PostgreSQL releases, and how MySQL’s architecture addresses these challenges.

Index BloatReplicationWrite Amplification
0 likes · 12 min read
Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification
IT Services Circle
IT Services Circle
Oct 11, 2025 · Databases

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article compares PostgreSQL and MySQL across architecture, indexing, query optimization, data types, concurrency control, and real‑world benchmarks, showing why PostgreSQL generally outperforms MySQL in high‑throughput, complex‑query, and data‑intensive applications.

Data TypesDatabase Performanceindexing
0 likes · 12 min read
Why PostgreSQL Beats MySQL in High‑Performance Scenarios
IT Services Circle
IT Services Circle
Oct 11, 2025 · Databases

Crack Backend Interviews: Redis, MySQL Locks, MQs & XiaoHongShu Salary Secrets

The article combines a surprising look at XiaoHongShu's record‑breaking graduate salaries with a comprehensive backend interview guide covering Redis advantages and drawbacks, common data structures, persistence and high‑availability, MySQL lock types, optimistic vs. pessimistic locking, message‑queue fundamentals, RabbitMQ vs. Kafka differences, deadlock avoidance, and a sample algorithm question.

Database LocksSalary Insightsbackend interview
0 likes · 19 min read
Crack Backend Interviews: Redis, MySQL Locks, MQs & XiaoHongShu Salary Secrets
IT Services Circle
IT Services Circle
Oct 10, 2025 · Databases

Why PostgreSQL Is Overtaking MySQL in the AI Era – A Feature Comparison

While MySQL remains a reliable, widely-used relational database for simple applications, PostgreSQL’s extensibility, AI-friendly extensions, and growing developer preference—highlighted by recent Stack Overflow surveys—make it the stronger choice for modern, complex workloads, especially those involving vector search, time‑series, and geospatial data.

AIdatabase comparisondeveloper survey
0 likes · 6 min read
Why PostgreSQL Is Overtaking MySQL in the AI Era – A Feature Comparison
php Courses
php Courses
Oct 10, 2025 · Backend Development

Master PHP Database Connections: MySQL with mysqli and PDO

This tutorial walks you through establishing MySQL connections in PHP using both the mysqli extension and PDO, covering procedural and object‑oriented code, prepared statements, error handling, and proper connection closure for robust backend development.

BackendMySQLiPDO
0 likes · 4 min read
Master PHP Database Connections: MySQL with mysqli and PDO
Sohu Tech Products
Sohu Tech Products
Oct 9, 2025 · Databases

When to Use SELECT DISTINCT vs GROUP BY in MySQL: Performance & Use Cases

This article compares MySQL’s SELECT DISTINCT and GROUP BY clauses, explaining their syntax, functional differences, performance implications, and ideal scenarios through detailed examples, index usage analysis, and a feature comparison table, helping developers choose the right approach for deduplication or aggregation tasks.

GROUP BYSELECT DISTINCTSQL Performance
0 likes · 10 min read
When to Use SELECT DISTINCT vs GROUP BY in MySQL: Performance & Use Cases
Raymond Ops
Raymond Ops
Oct 9, 2025 · Databases

Step‑by‑Step: Install MySQL 8.0/8.4 on Ubuntu 24.04 and Debian 11/12

This guide walks you through adding the MySQL APT repository, selecting the desired MySQL version, installing required dependencies, configuring the package source, installing MySQL on Ubuntu 24.04 and Debian 11/12, enabling the service, and verifying the installation with status checks and database listings.

DebianLinuxUbuntu
0 likes · 15 min read
Step‑by‑Step: Install MySQL 8.0/8.4 on Ubuntu 24.04 and Debian 11/12
Su San Talks Tech
Su San Talks Tech
Oct 9, 2025 · Databases

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article compares PostgreSQL and MySQL across architecture, indexing, complex query optimization, data‑type support, transaction handling, and real‑world benchmark results, showing why PostgreSQL is generally the better choice for high‑concurrency, data‑intensive applications.

Database Performanceconcurrencyindexing
0 likes · 13 min read
Why PostgreSQL Beats MySQL in High‑Performance Scenarios
Raymond Ops
Raymond Ops
Oct 8, 2025 · Databases

Step-by-Step Guide: Installing MySQL via RPM on Rocky, AlmaLinux, CentOS and More

This article provides a comprehensive, cross‑platform tutorial for downloading MySQL RPM bundles, installing required dependencies, using rpm or yum to install MySQL on various RHEL‑compatible distributions, starting the service, retrieving the temporary root password, and securely changing it to a permanent one.

LinuxRPMRPM installation
0 likes · 39 min read
Step-by-Step Guide: Installing MySQL via RPM on Rocky, AlmaLinux, CentOS and More
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Oct 8, 2025 · Databases

Master MySQL Replication: Async, Semi‑Sync, and Full‑Sync Architectures Explained

This article outlines MySQL’s three primary replication architectures—async, semi‑sync, and full‑sync—detailing their mechanisms, typical topologies, performance trade‑offs, and suitable scenarios such as read‑heavy web services, high‑availability setups, and strict consistency requirements like financial transactions.

AsynchronousDatabase ArchitectureFull Sync
0 likes · 4 min read
Master MySQL Replication: Async, Semi‑Sync, and Full‑Sync Architectures Explained
JavaGuide
JavaGuide
Oct 8, 2025 · Databases

Is MySQL Now the Runner‑Up to PostgreSQL in the AI Era?

While MySQL has long dominated relational databases with its open‑source stability and massive user base, the rise of AI and PostgreSQL’s extensible ecosystem—highlighted by extensions like pgvector, pg_bm25, TimescaleDB and PostGIS—are shifting developer preference, as shown by the 2025 Stack Overflow survey.

AIDatabase ExtensibilityTimescaleDB
0 likes · 6 min read
Is MySQL Now the Runner‑Up to PostgreSQL in the AI Era?
Senior Brother's Insights
Senior Brother's Insights
Oct 8, 2025 · Databases

Choosing the Right MySQL Date and Time Type: A Complete Guide

This article explains the five MySQL temporal column types—DATE, DATETIME, TIMESTAMP, YEAR, and TIME—detailing their storage size, valid ranges, typical use‑cases, timezone behavior, and the 2038 problem, helping developers pick the most suitable type for any scenario.

Temporal Typesdatetimemysql
0 likes · 9 min read
Choosing the Right MySQL Date and Time Type: A Complete Guide
Architect
Architect
Oct 7, 2025 · Backend Development

How to Combine SpringBoot, Canal, and RabbitMQ for Real‑Time MySQL Change Capture

This guide walks through setting up a Docker‑Compose environment, configuring Canal to capture MySQL binlog changes, integrating it with a SpringBoot client, and forwarding change events to RabbitMQ, providing complete code snippets and step‑by‑step instructions for real‑time data change tracking.

CanalChange Data CaptureDocker
0 likes · 22 min read
How to Combine SpringBoot, Canal, and RabbitMQ for Real‑Time MySQL Change Capture
Java Tech Enthusiast
Java Tech Enthusiast
Oct 7, 2025 · Databases

When MySQL Auto‑Increment Hits INT Limit: Diagnosis & Fixes

The article recounts a real‑world incident where a massive MySQL table exceeded the INT auto‑increment limit, causing insert failures, and walks through analysis, three remediation strategies—including converting to BIGINT, using distributed IDs, and sharding—plus practical SQL scripts and performance insights for handling billions of rows.

BIGINTINT overflowauto_increment
0 likes · 9 min read
When MySQL Auto‑Increment Hits INT Limit: Diagnosis & Fixes
Senior Brother's Insights
Senior Brother's Insights
Oct 7, 2025 · Databases

Why MySQL OR Queries Often Skip Indexes—and How to Fix Them

This article explains how MySQL's OR conditions can cause index loss, provides concrete query examples, analyzes why the optimizer falls back to full table scans, and offers practical solutions such as rewriting with UNION or adding missing indexes to restore efficient index usage.

Index OptimizationOR queryUNION
0 likes · 7 min read
Why MySQL OR Queries Often Skip Indexes—and How to Fix Them
Raymond Ops
Raymond Ops
Oct 6, 2025 · Databases

Beyond CRUD: Unlock Hidden MySQL Features and Optimization Tricks

This article dives deep into MySQL beyond basic CRUD, covering remote user creation, permission grants, communication protocols like TCP/IP, named pipes, shared memory, Unix sockets, and advanced query optimization techniques including index usage, ORDER BY, and LIMIT offset strategies.

Database OptimizationRemote ConnectionSQL Indexes
0 likes · 16 min read
Beyond CRUD: Unlock Hidden MySQL Features and Optimization Tricks
Senior Brother's Insights
Senior Brother's Insights
Oct 5, 2025 · Databases

Master MySQL JSON: From Basics to Advanced CRUD Operations

This article explains MySQL’s native JSON data type introduced in 5.7, covering its binary storage format, built‑in functions, generated‑column indexing, performance advantages over string storage, and detailed CRUD examples with SQL syntax and practical code snippets.

CRUDJSONdatabase
0 likes · 14 min read
Master MySQL JSON: From Basics to Advanced CRUD Operations
Ops Community
Ops Community
Oct 5, 2025 · Databases

Master MySQL Slow Query Optimization: Proven Methods & Pitfall Guide

This comprehensive guide walks you through a systematic methodology for diagnosing and fixing MySQL slow queries, covering proper log configuration, EXPLAIN analysis, index design, query rewriting, table restructuring, and practical caching techniques, while highlighting common misconceptions and real‑world case studies.

Index Optimizationdatabasemysql
0 likes · 35 min read
Master MySQL Slow Query Optimization: Proven Methods & Pitfall Guide
Senior Brother's Insights
Senior Brother's Insights
Oct 4, 2025 · Databases

Master MySQL Composite Indexes: Unlock the Leftmost Prefix Principle

This article explains what MySQL composite (multi‑column) indexes are, how they are built and ordered, the leftmost‑prefix rule that governs their usage, factors such as cardinality and selectivity for optimal design, and common scenarios where the index may become ineffective.

Composite IndexDatabase OptimizationIndex Selectivity
0 likes · 11 min read
Master MySQL Composite Indexes: Unlock the Leftmost Prefix Principle
Ops Community
Ops Community
Oct 4, 2025 · Databases

How to Quickly Diagnose and Fix a Frozen MySQL in Production: 5 Proven Steps

Facing a MySQL that suddenly becomes unresponsive in production? This article walks through the exact five‑step investigative process—checking process status, examining connections, locating lock waits, analyzing slow queries and system bottlenecks, and applying emergency recovery—illustrated with real‑world examples and command‑line snippets.

OperationsProduction Incidentdatabase troubleshooting
0 likes · 19 min read
How to Quickly Diagnose and Fix a Frozen MySQL in Production: 5 Proven Steps
Raymond Ops
Raymond Ops
Oct 2, 2025 · Operations

Step‑by‑Step Guide: Deploy Zabbix 7.0 on Ubuntu 22.04 LTS

This tutorial walks you through preparing the environment, adding the Zabbix repository, installing required packages, configuring MySQL, setting up Zabbix server and agent, customizing the web interface, and adding monitored hosts on Ubuntu 22.04 LTS, complete with commands and screenshots.

LinuxOperationsUbuntu
0 likes · 7 min read
Step‑by‑Step Guide: Deploy Zabbix 7.0 on Ubuntu 22.04 LTS
MaGe Linux Operations
MaGe Linux Operations
Oct 1, 2025 · Operations

How a Single rm -rf Command Almost Wiped My Data—and the Backup Plan That Saved It

A disastrous rm -rf command erased 2.3 TB of production MySQL data, but a meticulously designed multi‑layer backup strategy—including logical, physical, real‑time, and cloud backups—enabled a 99.4% data recovery within 72 hours, highlighting essential lessons and best‑practice guidelines for reliable data protection.

BackupData ProtectionOperations
0 likes · 36 min read
How a Single rm -rf Command Almost Wiped My Data—and the Backup Plan That Saved It
Senior Brother's Insights
Senior Brother's Insights
Sep 29, 2025 · Databases

Why MySQL Uses B+ Trees: From BSTs to Efficient Indexing

This article walks through the evolution from binary search trees to balanced trees, B‑trees and finally B+ trees, explaining how MySQL's InnoDB and MyISAM storage engines implement these structures to reduce disk I/O and boost query performance.

B+TreeData StructuresDatabase Performance
0 likes · 12 min read
Why MySQL Uses B+ Trees: From BSTs to Efficient Indexing
Senior Brother's Insights
Senior Brother's Insights
Sep 28, 2025 · Databases

Understanding MySQL’s Three Index Processing Stages: Key, Filter, and Table

MySQL query optimization involves three distinct index processing stages—Index Key, Index Filter, and Table Filter—each handling different parts of condition matching and data retrieval, and mastering their roles and execution flow can dramatically improve query performance, especially with index condition pushdown.

databaseindex condition pushdownmysql
0 likes · 8 min read
Understanding MySQL’s Three Index Processing Stages: Key, Filter, and Table
Senior Brother's Insights
Senior Brother's Insights
Sep 27, 2025 · Databases

When to Use SELECT DISTINCT vs GROUP BY in MySQL: Features, Performance, and Examples

This article explains the functional differences, performance considerations, and practical use cases of MySQL's SELECT DISTINCT and GROUP BY clauses, providing syntax details, example tables, query results, and a comparison table to help developers choose the right approach for deduplication or aggregation tasks.

GROUP BYSELECT DISTINCTaggregation
0 likes · 8 min read
When to Use SELECT DISTINCT vs GROUP BY in MySQL: Features, Performance, and Examples
Architecture Digest
Architecture Digest
Sep 25, 2025 · Databases

How to Tackle MySQL Master‑Slave Replication Lag and Prevent Dirty Reads

This article explains why MySQL master‑slave replication lag causes dirty reads, breaks down the asynchronous replication pipeline, and presents three practical mitigation strategies—including semi‑synchronous replication, forcing reads from the master, and cache double‑delete techniques—so you can choose the right solution for your workload.

Replication LagSemi-synchronouscache invalidation
0 likes · 9 min read
How to Tackle MySQL Master‑Slave Replication Lag and Prevent Dirty Reads
Senior Brother's Insights
Senior Brother's Insights
Sep 25, 2025 · Databases

Offset/Limit vs Cursor Pagination in MySQL: When and How to Choose

This article explains why selecting only needed columns and ensuring deterministic ordering are essential for MySQL queries, then compares Offset/Limit pagination with cursor‑based pagination, detailing their syntax, advantages, drawbacks such as data drift and performance issues, and offers practical optimization tips.

OFFSET LIMITdeterministic orderingmysql
0 likes · 12 min read
Offset/Limit vs Cursor Pagination in MySQL: When and How to Choose
Su San Talks Tech
Su San Talks Tech
Sep 25, 2025 · Databases

Boost MySQL Query Speed: Indexing, Subqueries vs Joins Explained

This article walks through a MySQL 5.6 scenario where a sub‑query to find students scoring 100 runs for hours, demonstrates how adding single‑column indexes cuts execution time dramatically, explores join‑based rewrites, composite indexes, left‑most prefix rules, covering indexes and sorting optimizations, and provides practical performance‑tuning tips.

JOINSQL Optimizationindexing
0 likes · 12 min read
Boost MySQL Query Speed: Indexing, Subqueries vs Joins Explained
Architect
Architect
Sep 24, 2025 · Databases

How Indexes Can Speed Up MySQL Queries by 30,000×: A Practical Guide

This article walks through a MySQL 5.6 scenario with three tables, demonstrates why a sub‑query that scans millions of rows runs for hours, and shows step‑by‑step how adding single‑column, composite, and covering indexes, as well as rewriting the query as a join, reduces execution time from over eight hours to a few milliseconds.

SQL Optimizationdatabaseindexing
0 likes · 12 min read
How Indexes Can Speed Up MySQL Queries by 30,000×: A Practical Guide
Senior Brother's Insights
Senior Brother's Insights
Sep 24, 2025 · Databases

Why Your MySQL Index Isn’t Used and How to Fix It

This article explains how to verify whether MySQL uses an index with EXPLAIN, outlines eight common reasons why an index may be ignored—including better alternatives, low selectivity, stale statistics, full‑table scans, structural limitations, function usage, invisible indexes—and provides practical commands and hints to resolve each issue.

Database Performanceexplainmysql
0 likes · 9 min read
Why Your MySQL Index Isn’t Used and How to Fix It
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Sep 24, 2025 · Databases

Unlock MySQL Performance: How Optimistic Locking Works

This article explains MySQL's optimistic locking strategy, detailing how a version column enables conflict detection during updates, provides step‑by‑step SQL examples, compares it with pessimistic locking, and shows why it improves performance in read‑heavy, low‑conflict environments.

Concurrency ControlVersioningdatabase
0 likes · 3 min read
Unlock MySQL Performance: How Optimistic Locking Works
MaGe Linux Operations
MaGe Linux Operations
Sep 24, 2025 · Operations

How a 3 AM MySQL Crash Taught Me Essential Ops Lessons

This article recounts a 3 AM MySQL outage, analyzes its root causes, and shares comprehensive operational strategies—including index optimization, connection‑pool tuning, slow‑query fixing, replication lag handling, monitoring metrics, automation scripts, performance tuning, security hardening, and future trends—to help DBAs prevent and resolve similar incidents.

Database operationsautomationmonitoring
0 likes · 15 min read
How a 3 AM MySQL Crash Taught Me Essential Ops Lessons
Java Tech Enthusiast
Java Tech Enthusiast
Sep 24, 2025 · Backend Development

Essential Java Interview Questions Every Backend Engineer Must Master

This guide compiles high‑frequency Java interview questions—from core language concepts and collections to JVM tuning, MySQL indexing, Redis caching, Spring frameworks, micro‑services, and MQ reliability—providing a comprehensive reference for candidates targeting small‑to‑mid‑size companies.

JVMjavamysql
0 likes · 11 min read
Essential Java Interview Questions Every Backend Engineer Must Master
Senior Brother's Insights
Senior Brother's Insights
Sep 23, 2025 · Databases

How Index Condition Pushdown Supercharges MySQL Query Performance

Index Condition Pushdown (ICP) in MySQL pushes filter conditions to the storage engine, dramatically cutting data transferred to the server layer, speeding up queries especially when using composite indexes, and requiring no changes to the original SQL statements.

Database PerformanceInnoDBindex condition pushdown
0 likes · 6 min read
How Index Condition Pushdown Supercharges MySQL Query Performance
dbaplus Community
dbaplus Community
Sep 22, 2025 · Databases

Why MySQL Tables Shouldn’t Exceed 10 Million Rows – A Deep Dive into InnoDB Pages & B+Tree Limits

This article explains why the industry advises keeping MySQL single‑table row counts below ten million by examining InnoDB’s 16KB page structure, B+‑tree indexing mechanics, fan‑out calculations, and how page size and row size together determine the practical limits and performance cliffs of large tables.

B+TreeDatabaseDesignInnoDB
0 likes · 20 min read
Why MySQL Tables Shouldn’t Exceed 10 Million Rows – A Deep Dive into InnoDB Pages & B+Tree Limits
Selected Java Interview Questions
Selected Java Interview Questions
Sep 22, 2025 · Backend Development

Quickly Diagnose Spring Boot + Nacos + MySQL Microservice Failures

This guide provides a step‑by‑step troubleshooting workflow for Spring Boot microservices using Nacos as a config/registry and MySQL as the database, covering log inspection, process checks, port listening, network connectivity, configuration validation, database connectivity, system resources, startup commands, and an optional one‑click diagnostic script.

LinuxNacosSpring Boot
0 likes · 9 min read
Quickly Diagnose Spring Boot + Nacos + MySQL Microservice Failures
Architect's Tech Stack
Architect's Tech Stack
Sep 22, 2025 · Backend Development

How to Safely Split Distributed Transactions in Java: A Practical Guide

This article explains how to handle distributed consistency when a business operation writes to MySQL and calls external systems, using a financial reimbursement example to illustrate risks, analyzes the root cause, and presents a step‑by‑step solution that splits the large transaction into small, retryable units with code snippets and Spring optimization.

BPMdistributed-transactionmysql
0 likes · 8 min read
How to Safely Split Distributed Transactions in Java: A Practical Guide
Architect's Tech Stack
Architect's Tech Stack
Sep 22, 2025 · Databases

How to Safely Add a Column to a Billion-Row Order Table Without Downtime

When a core order table with tens of millions of rows needs a new business field, directly running ALTER TABLE can lock the table and disrupt services, so this article explores master‑slave switching, online DDL tools, extension tables, JSON fields, and clever reuse of existing redundant columns to achieve the change safely and efficiently.

JSON fieldLarge TablesOnline DDL
0 likes · 9 min read
How to Safely Add a Column to a Billion-Row Order Table Without Downtime
Java Tech Enthusiast
Java Tech Enthusiast
Sep 20, 2025 · Databases

Why Running MySQL in Docker Is a Bad Idea (And When It Might Work)

This article examines the fundamental mismatch between MySQL’s stateful nature and Docker’s container model, detailing performance penalties, data‑persistence risks, resource‑management challenges, security concerns, and operational complexity, while also outlining scenarios where Docker can be acceptable for development or limited production use.

Dockerdatabasemysql
0 likes · 12 min read
Why Running MySQL in Docker Is a Bad Idea (And When It Might Work)
Raymond Ops
Raymond Ops
Sep 19, 2025 · Cloud Native

Master MySQL Replication with Kubernetes StatefulSets: A Hands‑On Guide

This tutorial walks through building a MySQL master‑slave cluster on Kubernetes using StatefulSets, covering local persistent volumes, storage classes, ConfigMaps, Secrets, Services for read‑write splitting, and step‑by‑step YAML manifests with verification commands to ensure proper replication and scaling.

ReplicationStatefulSetlocal storage
0 likes · 18 min read
Master MySQL Replication with Kubernetes StatefulSets: A Hands‑On Guide
Raymond Ops
Raymond Ops
Sep 19, 2025 · Information Security

How to Mitigate MySQL CVEs with iptables: Practical Firewall Rules

As network security threats rise, unpatchable MySQL vulnerabilities can be mitigated by configuring iptables rules that whitelist trusted IPs for port 3306 and drop all other traffic, with clear guidance on rule ordering and the differences between DROP and REJECT actions.

CVELinuxfirewall
0 likes · 7 min read
How to Mitigate MySQL CVEs with iptables: Practical Firewall Rules
Senior Brother's Insights
Senior Brother's Insights
Sep 18, 2025 · Databases

Why MySQL Table Lookups Slow Queries and How to Eliminate Them

This article explains the concept of table lookups in MySQL, shows how they arise from using secondary indexes, provides concrete query examples, and offers practical optimization techniques such as creating covering indexes, reducing selected columns, and analyzing execution plans to improve performance.

InnoDBSQL PerformanceTable Lookup
0 likes · 9 min read
Why MySQL Table Lookups Slow Queries and How to Eliminate Them
Lobster Programming
Lobster Programming
Sep 18, 2025 · Databases

Master MySQL Ranking: row_number, rank, and dense_rank Explained

Learn how MySQL window functions—row_number, rank, and dense_rank—can efficiently rank and rank‑tie data such as class scores or sales amounts, with clear syntax examples, differences in handling duplicate values, and practical SQL queries illustrated with real‑world scenarios.

ROW_NUMBERdense_rankmysql
0 likes · 6 min read
Master MySQL Ranking: row_number, rank, and dense_rank Explained
NiuNiu MaTe
NiuNiu MaTe
Sep 17, 2025 · Databases

Why MySQL Indexes Fail and How to Fix Them: 12 Common Scenarios

This article explains the core purpose of MySQL indexes, enumerates twelve typical situations that cause index failure, provides concrete SQL examples and corrections, and shows how to use EXPLAIN to diagnose and verify index usage for better query performance.

Database PerformanceIndex Optimizationexplain
0 likes · 16 min read
Why MySQL Indexes Fail and How to Fix Them: 12 Common Scenarios
Architecture Digest
Architecture Digest
Sep 16, 2025 · Databases

How to Insert 300,000 Records Efficiently with MyBatis and JDBC

This article demonstrates how to insert 300,000 rows into a MySQL table using MyBatis and JDBC, compares naïve single‑batch and per‑row approaches, presents optimized batch‑processing code with configurable batch sizes and wait times, and shares practical performance‑tuning tips such as index handling and connection‑pool configuration.

Batch InsertJDBCMyBatis
0 likes · 14 min read
How to Insert 300,000 Records Efficiently with MyBatis and JDBC
Senior Brother's Insights
Senior Brother's Insights
Sep 15, 2025 · Databases

Understanding MySQL Clustered vs Non‑Clustered Indexes: When and How to Use Them

This article provides a comprehensive review of MySQL’s two primary index types—clustered (clustered index) and non‑clustered (non‑clustered index)—explaining their storage mechanisms, performance trade‑offs, typical use cases, and best‑practice guidelines for selecting the appropriate index in database design.

Clustered IndexDatabase Optimizationmysql
0 likes · 14 min read
Understanding MySQL Clustered vs Non‑Clustered Indexes: When and How to Use Them
DeWu Technology
DeWu Technology
Sep 15, 2025 · Databases

Why MySQL Single-Table Data Should Stay Under 20 Million Rows

This article explains how InnoDB stores data in 16 KB pages, how B+Tree indexes work, derives the formula for the maximum number of rows a single MySQL table can hold, and why the practical limit of about twenty million rows exists, along with performance implications and optimization tips.

B+TreeInnoDBPage Size
0 likes · 20 min read
Why MySQL Single-Table Data Should Stay Under 20 Million Rows
Su San Talks Tech
Su San Talks Tech
Sep 15, 2025 · Databases

5 Proven Ways to Sync MySQL Data to Elasticsearch

This article explains why synchronizing MySQL with Elasticsearch is beneficial and compares five practical solutions—dual‑write, scheduled tasks, binlog, Canal, and MQ asynchronous—detailing their implementation, advantages, disadvantages, and suitable scenarios for each.

Elasticsearchbackend-developmentdata synchronization
0 likes · 14 min read
5 Proven Ways to Sync MySQL Data to Elasticsearch
dbaplus Community
dbaplus Community
Sep 14, 2025 · Databases

Why MySQL Updates Sometimes Disappear: InnoDB Read View Explained

A nighttime incident revealed that a MySQL transaction updated a row but subsequent reads returned the old value, prompting a deep investigation that uncovered InnoDB’s repeatable‑read snapshot behavior, concurrent updates, and how MySQL may skip updates when data appears unchanged, along with reproducible steps and mitigation advice.

InnoDBRead ViewUpdate Anomaly
0 likes · 16 min read
Why MySQL Updates Sometimes Disappear: InnoDB Read View Explained
Raymond Ops
Raymond Ops
Sep 14, 2025 · Databases

Deploy MySQL 8.4 from Source with a Single Script Across Major Linux Distributions

This guide provides a comprehensive, step‑by‑step shell script that automates the installation, configuration, and service setup of MySQL 8.4 from source on a wide range of Linux distributions, including Rocky, AlmaLinux, CentOS, openEuler, Anolis, OpenCloudOS, Kylin, UOS, openSUSE, Ubuntu, and Debian.

Database InstallationLinuxautomation
0 likes · 25 min read
Deploy MySQL 8.4 from Source with a Single Script Across Major Linux Distributions
Su San Talks Tech
Su San Talks Tech
Sep 14, 2025 · Databases

Should You Run MySQL in Docker? Risks, Performance & Best Practices

This article examines why running MySQL in Docker is generally discouraged, covering container‑state mismatches, I/O and network performance penalties, data persistence challenges, resource limits, security concerns, monitoring difficulties, and finally outlines scenarios where Docker may be acceptable and recommended production alternatives.

ContainersData PersistenceDocker
0 likes · 12 min read
Should You Run MySQL in Docker? Risks, Performance & Best Practices
MaGe Linux Operations
MaGe Linux Operations
Sep 13, 2025 · Databases

Master MySQL Performance: From Slow Queries to Billion-Row Optimization

This comprehensive guide walks you through real-world MySQL performance tuning, covering slow query analysis, index design, query optimization, parameter tuning, hardware considerations, sharding, and fault handling, with practical scripts and case studies to help you transform sluggish databases into high‑throughput, scalable systems.

Index Optimizationdatabase scalingmysql
0 likes · 24 min read
Master MySQL Performance: From Slow Queries to Billion-Row Optimization
Senior Brother's Insights
Senior Brother's Insights
Sep 13, 2025 · Databases

When Do Database Indexes Hurt More Than Help?

This article explains how indexes boost query speed but also incur storage, write‑performance, and maintenance costs, offering practical SQL scripts and guidelines for auditing, testing, and safely removing unnecessary indexes.

Database IndexesIndex ManagementStorage Overhead
0 likes · 6 min read
When Do Database Indexes Hurt More Than Help?
21CTO
21CTO
Sep 12, 2025 · Databases

Oracle's Massive MySQL Layoffs: What It Means for Open‑Source Databases

Oracle's recent large‑scale layoffs in its MySQL division have sparked community worries about the future of the world’s most popular open‑source database, highlighting shifts toward AI‑focused services and the rise of MariaDB as an alternative.

Database CommunityLayoffsMariaDB
0 likes · 4 min read
Oracle's Massive MySQL Layoffs: What It Means for Open‑Source Databases
Raymond Ops
Raymond Ops
Sep 12, 2025 · Databases

Step-by-Step Guide to Installing MySQL 8.x Binary Packages on Linux

This comprehensive tutorial explains how to install MySQL 8.0 and 8.4 binary packages on various Linux distributions, covering user creation, package download, environment setup, configuration, initialization, dependency handling, service script creation, password setting, and verification of the installation.

BinaryInstallationLinux
0 likes · 72 min read
Step-by-Step Guide to Installing MySQL 8.x Binary Packages on Linux
ITPUB
ITPUB
Sep 12, 2025 · Cloud Native

Why Deploying MySQL in Production Containers Is a Bad Idea

Deploying MySQL in production containers introduces volatile storage, unstable networking, performance variability, and replication challenges that clash with the database's need for persistent, high‑availability, and consistent operation, making native VM or bare‑metal deployments far more reliable.

Cloud NativeContainersDatabase Deployment
0 likes · 7 min read
Why Deploying MySQL in Production Containers Is a Bad Idea
Raymond Ops
Raymond Ops
Sep 11, 2025 · Databases

Master MySQL: Installation Guide Across Linux Distros & Key Features

This comprehensive guide introduces MySQL’s core concepts, architecture, and features, then walks you through step‑by‑step installation and configuration on popular Linux distributions—including Rocky, AlmaLinux, CentOS, Ubuntu, Debian, and openSUSE—covering network setup, repository configuration, and post‑install security tweaks.

InstallationLinuxdatabase
0 likes · 69 min read
Master MySQL: Installation Guide Across Linux Distros & Key Features
IT Services Circle
IT Services Circle
Sep 11, 2025 · Databases

Understanding MySQL Redo Log vs Binlog: How They Ensure Data Safety

This article explains the distinct yet collaborative roles of MySQL's Redo Log and Binlog, covering two‑phase commit, write‑ahead logging, flushing mechanisms, performance trade‑offs, and their use cases in crash recovery, replication, and point‑in‑time restoration.

BinlogReplicationmysql
0 likes · 11 min read
Understanding MySQL Redo Log vs Binlog: How They Ensure Data Safety