BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 11 of 50
Top Architect
Top Architect
May 19, 2025 · Databases

MySQL to Elasticsearch Data Synchronization Strategies and Solutions

This article explains why MySQL alone struggles with large‑scale queries, introduces Elasticsearch as a complementary search store, and compares several synchronization approaches—including synchronous write, asynchronous write, Logstash, binlog real‑time sync, Canal, and Alibaba Cloud DTS—detailing their implementation methods, advantages, disadvantages, and typical application scenarios.

CanalDTSElasticsearch
0 likes · 16 min read
MySQL to Elasticsearch Data Synchronization Strategies and Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
May 19, 2025 · Databases

Can MySQL Group Replication Power Dual‑Active Data Centers? A Practical Test Script

This article presents a detailed design, implementation, and automated testing script that evaluates whether MySQL Group Replication can support dual‑data‑center active‑active deployments, covering deployment steps, replication modes, fault simulation, data consistency checks, and key conclusions.

Active-ActiveDatabase High AvailabilityGroup Replication
0 likes · 16 min read
Can MySQL Group Replication Power Dual‑Active Data Centers? A Practical Test Script
MaGe Linux Operations
MaGe Linux Operations
May 17, 2025 · Databases

Master MySQL: Full Guide to Theory, Commands & Real-World Practices

This comprehensive MySQL tutorial covers everything from core concepts and architecture to practical CRUD operations, advanced queries, indexing, transaction control, stored procedures, triggers, replication, performance tuning, backup strategies, and real-world use cases, providing a complete roadmap for developers and DBAs.

MySQLReplicationSQL
0 likes · 25 min read
Master MySQL: Full Guide to Theory, Commands & Real-World Practices
IT Services Circle
IT Services Circle
May 16, 2025 · Databases

Internship Guidance, ByteDance Three‑Round Interview Experience, MySQL Replication Mechanics, and I/O Model Overview

The article combines practical advice for fresh graduates seeking internships and interview tips, shares a detailed ByteDance three‑round backend interview experience, explains MySQL master‑slave replication stages, binlog formats, and compares blocking, non‑blocking, multiplexed, and asynchronous I/O models.

I/OMySQLReplication
0 likes · 15 min read
Internship Guidance, ByteDance Three‑Round Interview Experience, MySQL Replication Mechanics, and I/O Model Overview
Architect's Must-Have
Architect's Must-Have
May 16, 2025 · Databases

Understanding Database Indexes: Structures, Types, and Trade‑offs

This article explains the fundamentals of database indexes, covering their purpose, underlying structures such as hash tables, B‑Tree and B+‑Tree, the advantages and drawbacks, and the various index types in MySQL including clustered, non‑clustered, primary, secondary, unique, prefix, and full‑text indexes.

B-treeMySQLhash
0 likes · 9 min read
Understanding Database Indexes: Structures, Types, and Trade‑offs
Java Backend Technology
Java Backend Technology
May 16, 2025 · Databases

How to Prevent MySQL Auto‑Increment ID Exhaustion: 6 Proven Strategies

When MySQL auto‑increment IDs approach their limit, this guide explains six practical solutions—including expanding column types, using UUIDs, segmenting ID generation, composite keys, adjusting increment steps, and sharding databases—to ensure scalable, unique identifiers for large‑scale applications.

Database ScalingID ExhaustionMySQL
0 likes · 7 min read
How to Prevent MySQL Auto‑Increment ID Exhaustion: 6 Proven Strategies
Zhuanzhuan Tech
Zhuanzhuan Tech
May 15, 2025 · Databases

Dynamic Extension of Fields in Billion‑Row Tables: Challenges and Practical Solutions

This article examines the difficulties of adding new fields to a core billion‑row MySQL table—including locking, page splitting, and index degradation—and presents a configuration‑driven, three‑layer architecture that uses JSON extension fields, extension tables, and Elasticsearch to achieve safe, scalable dynamic schema evolution.

Dynamic SchemaJSON fieldMySQL
0 likes · 8 min read
Dynamic Extension of Fields in Billion‑Row Tables: Challenges and Practical Solutions
Selected Java Interview Questions
Selected Java Interview Questions
May 15, 2025 · Backend Development

Six Common Approaches to Synchronize MySQL Data to Elasticsearch

This article reviews six mainstream solutions for keeping MySQL and Elasticsearch in sync—including synchronous double‑write, asynchronous MQ‑based double‑write, Logstash polling, Canal binlog listening, DataX batch migration, and Flink stream processing—detailing their scenarios, advantages, drawbacks, and practical code examples to guide optimal technical selection.

CanalElasticsearchFlink
0 likes · 8 min read
Six Common Approaches to Synchronize MySQL Data to Elasticsearch
Cognitive Technology Team
Cognitive Technology Team
May 15, 2025 · Databases

How to Solve MySQL Deep Pagination Performance Issues

This article analyzes why large OFFSET values cause severe MySQL performance degradation and presents multiple optimization techniques—including range queries, subqueries, delayed joins, covering indexes, sharding, caching, and search engine integration—along with their advantages, limitations, and practical recommendations.

CachingMySQLPerformance
0 likes · 11 min read
How to Solve MySQL Deep Pagination Performance Issues
Sohu Tech Products
Sohu Tech Products
May 14, 2025 · Databases

How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps

This guide walks you through locating the deadlock log, analyzing its contents to determine the time, order, and involved SQL statements, and pinpointing the root cause of MySQL InnoDB deadlocks, including special locking scenarios and how to interpret lock structures.

Database TroubleshootingInnoDBLock Analysis
0 likes · 16 min read
How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps
Java Captain
Java Captain
May 14, 2025 · Databases

Guide to Setting Up ShardingSphere with Docker for Database Sharding, Read‑Write Splitting, and SpringBoot Integration

This guide demonstrates how to set up Docker‑based MySQL instances, configure ShardingSphere‑Proxy for database sharding and read‑write splitting, and integrate ShardingSphere‑JDBC with SpringBoot 2.x using YAML configurations and Maven dependencies, providing complete code snippets and default connection details.

DockerMySQLRead-Write Splitting
0 likes · 11 min read
Guide to Setting Up ShardingSphere with Docker for Database Sharding, Read‑Write Splitting, and SpringBoot Integration
Senior Brother's Insights
Senior Brother's Insights
May 13, 2025 · Databases

Debunking MySQL VARCHAR Myths: Why 255 Isn’t the Magic Number

This article examines common misconceptions about MySQL VARCHAR—why 255 was historically used, the real maximum length, performance differences between short and long definitions, character‑set impacts on storage, and why aligning sizes to powers of two offers no real benefit.

Character EncodingMySQLPerformance
0 likes · 13 min read
Debunking MySQL VARCHAR Myths: Why 255 Isn’t the Magic Number
Aikesheng Open Source Community
Aikesheng Open Source Community
May 13, 2025 · Databases

Visualizing MySQL Execution Plans with Flame Graphs

This article explains how to use Flame Graphs to visualize MySQL execution plans, discusses the limitations of traditional EXPLAIN output, introduces the EXPLAIN ANALYZE feature in MySQL 8.0, provides sample SQL and command‑line usage, and shows how the visual tool helps quickly identify performance bottlenecks.

EXPLAIN ANALYZEMySQLSQL Performance
0 likes · 11 min read
Visualizing MySQL Execution Plans with Flame Graphs
php Courses
php Courses
May 13, 2025 · Backend Development

Implementing Logistics Tracking and Delivery Management in PHP for E-commerce

This article provides a step‑by‑step PHP tutorial for building logistics tracking and delivery management features in an e‑commerce system, covering database schema design, code for inserting, updating, and querying tracking and delivery records, and explaining how these functions improve operational efficiency.

Delivery ManagementLogistics TrackingMySQL
0 likes · 5 min read
Implementing Logistics Tracking and Delivery Management in PHP for E-commerce
Java Tech Enthusiast
Java Tech Enthusiast
May 13, 2025 · Big Data

Using Alibaba DataX 3.0 for MySQL Data Synchronization: Installation, Configuration, and Incremental Sync

This article introduces Alibaba DataX 3.0, explains its architecture and role‑based design, walks through Linux installation, JDK setup, MySQL preparation, and provides step‑by‑step examples of full‑load and incremental data synchronization between two MySQL instances using JSON job configurations and command‑line execution.

DataXETLLinux
0 likes · 14 min read
Using Alibaba DataX 3.0 for MySQL Data Synchronization: Installation, Configuration, and Incremental Sync
macrozheng
macrozheng
May 12, 2025 · Big Data

Master DataX: Efficient Data Synchronization for Massive MySQL Datasets

Learn how to overcome inaccurate reporting and cross-database challenges by using Alibaba’s open-source DataX tool to efficiently synchronize massive MySQL datasets, covering its architecture, job scheduling, installation, configuration, full- and incremental sync, and practical command-line examples.

DataXETLMySQL
0 likes · 15 min read
Master DataX: Efficient Data Synchronization for Massive MySQL Datasets
Java Captain
Java Captain
May 12, 2025 · Databases

Comprehensive Guide to Installing, Configuring, and Managing MySQL on CentOS Linux

This tutorial walks through preparing the environment, installing and uninstalling MySQL on CentOS 7, configuring firewalls, setting up remote access, handling character sets, adjusting security policies, managing SQL modes, and best practices for case sensitivity and version‑specific password policies.

ConfigurationInstallationLinux
0 likes · 30 min read
Comprehensive Guide to Installing, Configuring, and Managing MySQL on CentOS Linux
Su San Talks Tech
Su San Talks Tech
May 12, 2025 · Databases

How to Diagnose and Fix Slow MySQL Queries: A Surgeon’s Guide

This article walks you through diagnosing slow MySQL queries using EXPLAIN, fixing index issues, reordering joins, forcing optimal indexes, monitoring index usage, and applying systematic governance such as SQL sanitization and sharding to dramatically improve performance.

EXPLAINMySQLSQL optimization
0 likes · 9 min read
How to Diagnose and Fix Slow MySQL Queries: A Surgeon’s Guide
Pan Zhi's Tech Notes
Pan Zhi's Tech Notes
May 12, 2025 · Backend Development

How to Use SpringBoot, Dubbo, and Seata to Solve Distributed Transaction Data Inconsistency

This article walks through integrating SpringBoot, Dubbo, and Seata to implement reliable distributed transactions, covering project setup, Maven dependencies, service definitions, Nacos registration, configuration files, testing normal commits and rollbacks, and troubleshooting version incompatibilities.

Distributed TransactionsDubboJava
0 likes · 17 min read
How to Use SpringBoot, Dubbo, and Seata to Solve Distributed Transaction Data Inconsistency
Top Architecture Tech Stack
Top Architecture Tech Stack
May 10, 2025 · Databases

MySQL Query Optimization Guidelines and Best Practices

This article presents a comprehensive set of MySQL optimization techniques, covering the avoidance of SELECT *, proper use of specific fields, index-friendly query patterns, join strategies, handling of NULL and default values, efficient use of UNION, batch inserts, and numerous other performance‑enhancing tips for database developers.

MySQLSQL optimizationdatabase tuning
0 likes · 17 min read
MySQL Query Optimization Guidelines and Best Practices
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 10, 2025 · Databases

10 Powerful SQL Optimization Techniques to Boost Query Performance

This article presents ten practical SQL optimization techniques—including replacing DISTINCT with GROUP BY, using UNION ALL instead of OR, avoiding functions on indexed columns, leveraging EXISTS over IN, creating covering indexes, partitioning large tables, and more—each illustrated with before-and-after code examples to dramatically improve query speed and reduce server load.

MySQLPerformance OptimizationQuery Tuning
0 likes · 10 min read
10 Powerful SQL Optimization Techniques to Boost Query Performance
Code Ape Tech Column
Code Ape Tech Column
May 9, 2025 · Databases

Efficient Strategies for Importing One Billion Records into MySQL

This article explains how to import 1 billion 1 KB log records stored in HDFS or S3 into MySQL by analyzing single‑table limits, using batch inserts, choosing storage engines, sharding, optimizing file‑reading methods, and coordinating distributed tasks with Redis, Redisson, and Zookeeper to ensure ordered, reliable, and high‑throughput data loading.

Batch InsertKafkaMySQL
0 likes · 19 min read
Efficient Strategies for Importing One Billion Records into MySQL
php Courses
php Courses
May 8, 2025 · Backend Development

Using mysqli_fetch_assoc to Retrieve Query Results in PHP

This tutorial demonstrates how to connect to a MySQL database in PHP using mysqli_connect, execute queries with mysqli_query, and retrieve each row as an associative array using mysqli_fetch_assoc, providing complete code examples and a full script for efficient backend data handling.

MySQLMySQLiPHP
0 likes · 4 min read
Using mysqli_fetch_assoc to Retrieve Query Results in PHP
Top Architect
Top Architect
May 7, 2025 · Big Data

Using DataX for Efficient MySQL Data Synchronization

This article provides a comprehensive guide on using Alibaba's open‑source DataX tool for efficient offline synchronization between heterogeneous databases such as MySQL, covering its architecture, installation on Linux, job configuration, full‑ and incremental data transfer, and practical code examples.

DataXETLMySQL
0 likes · 18 min read
Using DataX for Efficient MySQL Data Synchronization
Pan Zhi's Tech Notes
Pan Zhi's Tech Notes
May 7, 2025 · Backend Development

How Seata Guarantees Zero-Error Cross-Database Transactions: Theory and Full Demo

This article explains Seata's distributed transaction architecture, details the AT transaction mode, walks through single‑node and cluster deployments, and provides complete code examples for stock and order services that demonstrate both successful commits and automatic rollbacks in a microservice environment.

AT ModeDistributed TransactionsMicroservices
0 likes · 25 min read
How Seata Guarantees Zero-Error Cross-Database Transactions: Theory and Full Demo
Liangxu Linux
Liangxu Linux
May 6, 2025 · Information Security

How to Mitigate MySQL Vulnerabilities with iptables Rules

This guide explains how to use Linux iptables to block or allow traffic to MySQL's port 3306, providing a practical workaround for several high‑severity CVE‑listed MySQL vulnerabilities that cannot be patched by upgrading in production environments.

CVEMySQLiptables
0 likes · 6 min read
How to Mitigate MySQL Vulnerabilities with iptables Rules
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2025 · Databases

Using GDB to Adjust MySQL max_connections Without Restart

This article explains how to troubleshoot and resolve the MySQL "Too many connections" error by using GDB to modify the max_connections parameter on a running MySQL 5.7 instance without restarting, including step‑by‑step commands, sysbench load testing, and two practical methods.

MySQLTroubleshootingdatabase tuning
0 likes · 9 min read
Using GDB to Adjust MySQL max_connections Without Restart
Su San Talks Tech
Su San Talks Tech
May 5, 2025 · Big Data

6 Proven Ways to Sync MySQL Data to Elasticsearch – Choose the Right Strategy

This article compares six mainstream MySQL‑to‑Elasticsearch synchronization methods—synchronous double‑write, asynchronous MQ, Logstash polling, Canal binlog listening, DataX batch sync, and Flink streaming—detailing scenarios, code samples, advantages, drawbacks, and practical selection guidance for developers.

CanalElasticsearchFlink
0 likes · 9 min read
6 Proven Ways to Sync MySQL Data to Elasticsearch – Choose the Right Strategy
Java Captain
Java Captain
May 4, 2025 · Databases

Evolution of MySQL, Rise of NoSQL, and In‑Depth Redis Data Types and Usage

This article traces MySQL’s architectural evolution from single‑node to sharded clusters, explains the fundamentals and classifications of NoSQL databases, and provides a comprehensive guide to Redis—including installation, memory management, and detailed usage of its five core data types with best‑practice considerations.

Data StructuresMySQLNoSQL
0 likes · 26 min read
Evolution of MySQL, Rise of NoSQL, and In‑Depth Redis Data Types and Usage
Java Captain
Java Captain
May 2, 2025 · Databases

Implementing Dynamic MySQL Master‑Slave Switching in SpringBoot Using AOP and Custom Annotations

This article demonstrates how to use SpringBoot 3.0.4 with AOP and a custom @DataSource annotation to dynamically switch between MySQL master and slave databases, ensuring high availability by automatically falling back to the master when a slave fails, and provides configuration and code examples for multiple data sources.

AOPDatabase SwitchingMySQL
0 likes · 14 min read
Implementing Dynamic MySQL Master‑Slave Switching in SpringBoot Using AOP and Custom Annotations
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 2, 2025 · Databases

Demonstrating MySQL Deadlock with a Practical Example

This article explains MySQL deadlocks by creating a test table, running two concurrent transactions—one using SLEEP to hold a lock and another attempting the same resource—to reproduce a deadlock error, and discusses how this approach aids debugging and understanding of transaction conflicts.

MySQLSQLdatabase
0 likes · 4 min read
Demonstrating MySQL Deadlock with a Practical Example
Java Backend Full-Stack
Java Backend Full-Stack
May 1, 2025 · Databases

Common Interview Question: When Does a MySQL Index Fail? Hands‑On Demo

This article walks through a mini‑project that creates a student table, adds indexes, populates it with 100 k rows, and then demonstrates six concrete scenarios—such as leading wildcards, arithmetic on indexed columns, functions, type mismatches, composite‑index misuse, and encoding differences—that cause MySQL indexes to become ineffective, showing the EXPLAIN output for each case.

EXPLAINMySQLSQL
0 likes · 8 min read
Common Interview Question: When Does a MySQL Index Fail? Hands‑On Demo
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 1, 2025 · Databases

Common Scenarios Where MySQL Indexes Fail

This article explains various situations that cause MySQL indexes to become ineffective—such as leading wildcard LIKE queries, calculations on indexed columns, use of functions, data type mismatches, improper use of composite indexes, and character set differences—providing example SQL, execution plans, and practical testing steps.

MySQLSQLdatabase optimization
0 likes · 7 min read
Common Scenarios Where MySQL Indexes Fail
Cognitive Technology Team
Cognitive Technology Team
May 1, 2025 · Databases

MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios

This article systematically examines MySQL optimization techniques for both read‑many/write‑few and write‑many/read‑few business scenarios, covering architecture design, caching, sharding, asynchronous processing, monitoring, and emerging NewSQL/HTAP solutions to achieve high performance, consistency, and scalability.

CachingMySQLRead-Write Splitting
0 likes · 9 min read
MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios
dbaplus Community
dbaplus Community
Apr 30, 2025 · Databases

Top 10 MySQL Errors and How to Fix Them: Practical Solutions for DBAs

This article compiles the ten most common MySQL error scenarios—from connection limits and replication conflicts to installation failures, password resets, truncate side‑effects, configuration pitfalls, charset issues, binlog formats, timeout problems, and file‑handle limits—offering clear diagnostic steps and concrete commands to resolve each case.

Database ErrorsMySQLReplication
0 likes · 16 min read
Top 10 MySQL Errors and How to Fix Them: Practical Solutions for DBAs
Architect
Architect
Apr 29, 2025 · Databases

Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration

A real‑world MySQL data‑migration case study shows how using INSERT INTO SELECT without proper indexing caused a full table scan, OOM errors, and data loss, and explains how to avoid the pitfall by adding appropriate indexes and understanding transaction locking.

INSERT INTO SELECTMySQLdata migration
0 likes · 8 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration
Top Architect
Top Architect
Apr 28, 2025 · Backend Development

Replacing MyBatis with MyBatis-Plus: Debugging LocalDateTime Conversion Errors and MySQL Connector Upgrades

The article walks through migrating an old MySQL‑5.7 project from MyBatis 3.5.0 to MyBatis‑Plus 3.1.1, diagnosing a LocalDateTime conversion exception caused by an outdated mysql‑connector‑java driver, and resolves it by upgrading the driver version, highlighting the need for careful component compatibility checks.

Backend DevelopmentJavaLocalDateTime
0 likes · 10 min read
Replacing MyBatis with MyBatis-Plus: Debugging LocalDateTime Conversion Errors and MySQL Connector Upgrades
php Courses
php Courses
Apr 28, 2025 · Databases

Python Database Programming: SQLite and MySQL Basics

This tutorial explains how to use Python's sqlite3 module and MySQL connectors to perform essential database operations such as connecting, creating tables, inserting, querying, updating, deleting records, and managing transactions for both SQLite and MySQL.

MySQLSQLSQLite
0 likes · 7 min read
Python Database Programming: SQLite and MySQL Basics
Wukong Talks Architecture
Wukong Talks Architecture
Apr 28, 2025 · Databases

Comprehensive Guide to Popular Database Management Tools

This article provides an extensive overview of widely used database management tools across various platforms—including DBeaver, Navicat, PL/SQL Developer, Toad for Oracle, SQLyog, MySQL Workbench, HeidiSQL, Percona Toolkit, pgAdmin, SQLite Expert, and SSMS—detailing their supported databases, core features, licensing, download links, and related learning resources.

DBeaverDatabase ToolsMySQL
0 likes · 19 min read
Comprehensive Guide to Popular Database Management Tools
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 27, 2025 · Databases

Why MySQL Memory Stays High and How to Optimize It

This article explains MySQL's memory architecture, why memory usage often stays high after spikes, and provides practical steps—including connection checks, slow query analysis, workload scaling, and switching to jemalloc—to diagnose and reduce memory consumption on 360's internal cloud platform.

Memory OptimizationMySQLconnection management
0 likes · 7 min read
Why MySQL Memory Stays High and How to Optimize It
转转QA
转转QA
Apr 27, 2025 · Databases

Design and Implementation of a General Data Synchronization Solution for Online and Offline Databases

This article analyzes the pain points of inconsistent online‑offline configurations, proposes three synchronization schemes—including timed batch sync, automatic real‑time binlog‑MQ sync, and manual selective sync—compares their applicability, risks and performance, and presents practical deployment results across multiple projects using MySQL and TiDB.

BinlogMySQLTiDB
0 likes · 14 min read
Design and Implementation of a General Data Synchronization Solution for Online and Offline Databases
Architect's Guide
Architect's Guide
Apr 25, 2025 · Databases

Solutions for MySQL Auto Increment ID Exhaustion

This article discusses the problem of MySQL auto‑increment ID exhaustion and presents six practical solutions—including changing column type to BIGINT, using UUIDs, segmenting ID generation, composite keys, adjusting auto‑increment steps, and database sharding—to ensure scalability and uniqueness.

ID ExhaustionMySQLUUID
0 likes · 6 min read
Solutions for MySQL Auto Increment ID Exhaustion
21CTO
21CTO
Apr 24, 2025 · Databases

What’s New in MySQL 9.3? Backup, JavaScript Support, and Group Replication Explained

MySQL 9.3 introduces powerful backup enhancements, JavaScript stored‑procedure support, advanced query optimization, and a new Group Replication primary‑election feature, all aimed at improving reliability, performance, and developer flexibility, making it a compelling upgrade for enterprises and developers alike.

Group ReplicationJavaScript stored proceduresMySQL
0 likes · 3 min read
What’s New in MySQL 9.3? Backup, JavaScript Support, and Group Replication Explained
Top Architect
Top Architect
Apr 24, 2025 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article examines why MySQL alone struggles with large‑scale, complex queries, introduces Elasticsearch as a complementary search engine, and compares several synchronization approaches—including synchronous double‑write, asynchronous double‑write, Logstash pipelines, binlog streaming, Canal, and Alibaba Cloud DTS—detailing their implementations, advantages, disadvantages, and typical use cases.

Backend DevelopmentElasticsearchMySQL
0 likes · 16 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
Senior Tony
Senior Tony
Apr 24, 2025 · Databases

How to Effectively Monitor and Optimize Slow SQL in Real Projects

The article explains a systematic interview‑ready approach to handling slow SQL: collect queries via Druid, MySQL slow‑query log or cloud exporters, prioritize by total execution time, analyze EXPLAIN output (type, key, rows, filtered, extra), and apply index, FORCE INDEX, join‑order, or off‑loading techniques for optimization.

MySQLOptimizationPerformance
0 likes · 9 min read
How to Effectively Monitor and Optimize Slow SQL in Real Projects
php Courses
php Courses
Apr 24, 2025 · Backend Development

Step-by-Step Guide to Generating Dynamic Web Pages with PHP

This article explains how to set up a PHP development environment, create .php files, embed PHP within HTML, handle form input, and interact with a MySQL database to produce dynamic web pages, providing clear code examples for each step.

Dynamic PagesMySQLTutorial
0 likes · 5 min read
Step-by-Step Guide to Generating Dynamic Web Pages with PHP
Java Tech Enthusiast
Java Tech Enthusiast
Apr 23, 2025 · Databases

Choosing the Right Date/Time Storage in MySQL and PostgreSQL

When storing dates in MySQL or PostgreSQL, avoid VARCHAR fields and select between DATETIME (no time‑zone, larger range) and TIMESTAMP (UTC conversion, smaller range) based on whether automatic time‑zone handling and the 2038 limit suit your application, with Unix timestamps as a high‑performance alternative.

MySQLdatabasedatetime
0 likes · 11 min read
Choosing the Right Date/Time Storage in MySQL and PostgreSQL
Zhuanzhuan Tech
Zhuanzhuan Tech
Apr 23, 2025 · Databases

Quick 3‑Step Guide to Locate and Analyze MySQL InnoDB Deadlocks

This article explains how to find the MySQL deadlock log, parse its contents to determine the time, order, and affected rows, identify the lock types and root cause, and provides extended examples of special locking scenarios, all illustrated with real‑world SQL and code snippets.

InnoDBMySQLTroubleshooting
0 likes · 15 min read
Quick 3‑Step Guide to Locate and Analyze MySQL InnoDB Deadlocks
Architect's Guide
Architect's Guide
Apr 23, 2025 · Databases

Understanding MySQL Indexes: Types, B+Tree Structure, and Clustered vs. Non‑Clustered Indexes

This article explains MySQL indexes, their purpose and working principle, compares primary, ordinary, composite and full‑text indexes, describes the B+Tree storage structure versus B‑Tree, and clarifies the differences between clustered and non‑clustered (auxiliary) indexes along with their advantages and drawbacks.

B+ TreeMySQLPerformance
0 likes · 10 min read
Understanding MySQL Indexes: Types, B+Tree Structure, and Clustered vs. Non‑Clustered Indexes
Architecture Digest
Architecture Digest
Apr 22, 2025 · Databases

Understanding MySQL INT Display Width and ZEROFILL

This article explains why the number in MySQL's int(N) definition does not limit the column's numeric range, demonstrates that int(1) can store the full 4‑byte unsigned range, and shows how the ZEROFILL attribute adds zero‑padding for display purposes.

MySQLZEROFILLdatabase
0 likes · 5 min read
Understanding MySQL INT Display Width and ZEROFILL
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 22, 2025 · Databases

Implementing a MySQL Configuration Comparison Script: Key Considerations and Common Pitfalls

This article explains how to build a MySQL configuration comparison script by retrieving runtime variable values, parsing my.cnf and mysqld-auto.cnf files, handling formatting and case issues, and accurately comparing values while addressing typical challenges such as unit conversion, boolean representation, and legacy variable names.

MySQLShellawk
0 likes · 8 min read
Implementing a MySQL Configuration Comparison Script: Key Considerations and Common Pitfalls
IT Xianyu
IT Xianyu
Apr 19, 2025 · Databases

Step-by-Step Guide to Setting Up MySQL 5.7 Master‑Slave Replication

This tutorial walks through preparing the Linux environment, installing MySQL 5.7, configuring master and slave servers, creating replication users, verifying synchronization, troubleshooting common issues, and applying advanced options such as GTID and semi‑synchronous replication, all with complete command examples.

ConfigurationGTIDLinux
0 likes · 10 min read
Step-by-Step Guide to Setting Up MySQL 5.7 Master‑Slave Replication
Top Architect
Top Architect
Apr 18, 2025 · Backend Development

Optimizing XML-to-MySQL Import: Reducing Execution Time from 300 s to 4 s with Batch Processing and Multithreading

This article details how to dramatically speed up importing over 60,000 XML records into MySQL by profiling the original 300‑second implementation, enabling JDBC batch writes, configuring MySQL rewriteBatchedStatements, and applying a Disruptor‑based multithreaded pipeline, ultimately achieving sub‑5‑second runtimes with modest memory usage.

BatchProcessingDisruptorJava
0 likes · 15 min read
Optimizing XML-to-MySQL Import: Reducing Execution Time from 300 s to 4 s with Batch Processing and Multithreading
Data Thinking Notes
Data Thinking Notes
Apr 17, 2025 · Artificial Intelligence

How Dify Accelerates Generative AI App Development with Low‑Code and Modular Design

Dify is an open‑source LLM application platform that blends BaaS and LLMOps, offering low‑code development, modular components, extensive model support, and advanced retrieval features, while also detailing its current limitations and recent enhancements such as MySQL integration and Elasticsearch‑based RAG capabilities.

AIElasticsearchLLM
0 likes · 7 min read
How Dify Accelerates Generative AI App Development with Low‑Code and Modular Design
IT Services Circle
IT Services Circle
Apr 17, 2025 · Backend Development

McDonald's Java Backend Interview Experience and Technical Q&A

This article shares a candidate's interview experience at McDonald's China Technology R&D Center, detailing salary expectations, work schedule, and an extensive technical Q&A covering IoC/DI, MyBatis, JVM memory and garbage‑collection algorithms, MySQL storage engines, concurrency, locking, RPC, HTTPS, Docker/Kubernetes commands, and Git workflows, while also including some promotional material.

BackendDockerJava
0 likes · 22 min read
McDonald's Java Backend Interview Experience and Technical Q&A
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 16, 2025 · Databases

Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution

This article explains how to reproduce a MySQL InnoDB lock‑wait scenario, use system tables such as information_schema.processlist, innodb_trx, sys.innodb_lock_waits and performance_schema to locate the blocking transaction, and finally resolve the issue by killing the offending session, while also providing quick‑check queries and parameter tuning advice.

Database TroubleshootingInnoDBLock Wait
0 likes · 9 min read
Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution
macrozheng
macrozheng
Apr 16, 2025 · Databases

Why Enterprises Shun Foreign Keys: Performance Risks and Alternatives

Although foreign keys enforce referential integrity, many enterprises avoid them because they can slow inserts, cause blocking cascade updates, trigger database update storms in high‑concurrency environments, and complicate sharding, leading developers to prefer redundant fields and handle relationships at the application layer.

Foreign KeyMySQLdatabase performance
0 likes · 6 min read
Why Enterprises Shun Foreign Keys: Performance Risks and Alternatives
Java Tech Enthusiast
Java Tech Enthusiast
Apr 14, 2025 · Databases

SQL Optimization Steps and Common Scenarios

To improve MySQL performance, first identify slow queries via logs, then examine their EXPLAIN plans and profiling data, understand optimizer traces, and apply fixes such as proper left‑most indexing, avoiding implicit conversions, large offsets, unsuitable IN/ORDER BY patterns, range‑blocking, NOT‑IN predicates, and consider alternative storage or pagination strategies for complex or massive datasets.

MySQLPerformanceSQL
0 likes · 10 min read
SQL Optimization Steps and Common Scenarios
MaGe Linux Operations
MaGe Linux Operations
Apr 12, 2025 · Databases

Master MySQL Remote Connections and Query Optimization: Tips & Tricks

This article explains how to create and grant MySQL users for remote access, describes client‑server communication methods such as TCP/IP, named pipes, shared memory, and Unix sockets, and provides detailed guidance on index usage, common pitfalls, and performance‑friendly techniques for query optimization and large OFFSET LIMIT handling.

MySQLRemote ConnectionUser Privileges
0 likes · 17 min read
Master MySQL Remote Connections and Query Optimization: Tips & Tricks
Architecture Digest
Architecture Digest
Apr 11, 2025 · Databases

Performance Issues of Using UUID as Primary Key in MySQL and Optimization Strategies

The article explains why using UUIDs as primary keys in MySQL large tables leads to poor index efficiency, slower inserts and queries, and costly index refreshes on updates, and then presents practical optimization techniques such as ordered UUIDs, binary storage, hybrid auto‑increment keys, and table partitioning.

Index PerformanceMySQLOptimization
0 likes · 7 min read
Performance Issues of Using UUID as Primary Key in MySQL and Optimization Strategies
macrozheng
macrozheng
Apr 11, 2025 · Databases

Why MySQL count() Slows Down on Large Tables and How to Speed It Up

This article explains how MySQL's count() works across storage engines, why InnoDB scans rows and can time out on massive tables, and presents practical alternatives such as using EXPLAIN rows, a dedicated count table, batch processing, or binlog‑to‑Hive for efficient row‑count estimation.

COUNTInnoDBMyISAM
0 likes · 14 min read
Why MySQL count() Slows Down on Large Tables and How to Speed It Up
Code Ape Tech Column
Code Ape Tech Column
Apr 10, 2025 · Databases

Comprehensive Guide to SQL Optimization Steps and Common Scenarios

This article explains why SQL statements become performance bottlenecks as data grows, outlines a systematic optimization workflow—including slow‑query identification, EXPLAIN analysis, profiling, and tracing—and discusses practical solutions for index usage, query rewriting, pagination, range queries, and large‑scale data handling in MySQL.

EXPLAINMySQLSQL
0 likes · 12 min read
Comprehensive Guide to SQL Optimization Steps and Common Scenarios
IT Services Circle
IT Services Circle
Apr 10, 2025 · Databases

Choosing the Right Date/Time Storage Type in MySQL: DATETIME vs TIMESTAMP vs Unix Timestamp

This article explains why storing dates as strings is problematic, compares MySQL's DATETIME and TIMESTAMP types—including their storage size, range, and timezone behavior—provides practical SQL examples, discusses numeric Unix timestamps, and offers guidance on selecting the most suitable type for different scenarios.

MySQLPerformancetimestamp
0 likes · 12 min read
Choosing the Right Date/Time Storage Type in MySQL: DATETIME vs TIMESTAMP vs Unix Timestamp
Sohu Tech Products
Sohu Tech Products
Apr 9, 2025 · Databases

Six Critical MySQL Index Pitfalls and How to Fix Them

This article analyzes six common MySQL query performance traps—type conversion, function usage, left‑most prefix, implicit charset conversion, left‑most match, and optimizer mis‑selection—illustrates each with real‑world SQL examples, explains why they degrade performance, and provides concrete remediation steps and verification tools.

MySQLPerformanceSQL
0 likes · 5 min read
Six Critical MySQL Index Pitfalls and How to Fix Them
Raymond Ops
Raymond Ops
Apr 9, 2025 · Databases

Step-by-Step Guide to Installing MySQL 5.7 on ARM (Aarch64) Linux

This tutorial walks you through checking the OS architecture, preparing the environment, downloading and extracting the MySQL 5.7 ARM package, configuring my.cnf, setting up auto‑start and environment variables, initializing the server, securing the root account, and configuring master‑slave replication on Linux.

ARMInstallationLinux
0 likes · 13 min read
Step-by-Step Guide to Installing MySQL 5.7 on ARM (Aarch64) Linux
Java Tech Enthusiast
Java Tech Enthusiast
Apr 9, 2025 · Databases

MySQL vs PostgreSQL Performance Benchmark: Latency, Throughput, and Saturation

The benchmark comparing MySQL 9.0 and PostgreSQL 17.0 shows PostgreSQL consistently achieving lower insertion latency, roughly double the throughput (≈19 k QPS vs 10 k QPS), using less CPU, memory and disk I/O, while both hit an 80‑connection pool limit and PostgreSQL maintains stable read latency as MySQL’s performance degrades beyond ~5.5 k QPS.

MySQLPostgreSQLThroughput
0 likes · 7 min read
MySQL vs PostgreSQL Performance Benchmark: Latency, Throughput, and Saturation
Java Captain
Java Captain
Apr 9, 2025 · Backend Development

Implementing Dynamic MySQL Master‑Slave Data Source Switching in SpringBoot with AOP and Custom Annotations

This tutorial explains how to use SpringBoot, AOP, and a custom @DataSource annotation to dynamically switch between MySQL master and slave databases—covering configuration, code implementation, multiple slave handling, and an Oracle example—to ensure high availability and flexible data source management.

AOPJavaMaster‑Slave
0 likes · 13 min read
Implementing Dynamic MySQL Master‑Slave Data Source Switching in SpringBoot with AOP and Custom Annotations
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 8, 2025 · Databases

Using MySQL Flashback Tools to Roll Back DML Mistakes

This article explains how to use MySQL flashback utilities such as binlog2sql, my2sql, and MyFlash to recover from accidental DML operations, covering supported SQL types, required binlog settings, tool features, command‑line usage examples, and best‑practice recommendations for preventing future data loss.

BinlogDMLFlashback
0 likes · 14 min read
Using MySQL Flashback Tools to Roll Back DML Mistakes
Java Tech Enthusiast
Java Tech Enthusiast
Apr 8, 2025 · Databases

Choosing the Right Date/Time Storage Type in MySQL and PostgreSQL

Choosing the proper MySQL or PostgreSQL date/time column—avoiding string types, understanding DATETIME’s literal storage versus TIMESTAMP’s automatic UTC conversion, considering PostgreSQL’s TIMESTAMP WITH/WITHOUT TIME ZONE equivalents, and weighing numeric Unix timestamps for speed—ensures correct time‑zone handling, storage efficiency, and future‑proof range.

MySQLPostgreSQLtimezones
0 likes · 12 min read
Choosing the Right Date/Time Storage Type in MySQL and PostgreSQL
Java Architect Essentials
Java Architect Essentials
Apr 7, 2025 · Databases

Practical MySQL Query Optimizations: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Predicate Push‑down, Early Row Limiting, and Intermediate Result Push‑down

This article presents a series of MySQL performance‑tuning techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting joins, handling mixed ordering, replacing EXISTS with joins, pushing predicates into subqueries, early row limiting, and using WITH clauses—to dramatically reduce query execution time across common scenarios.

JOINMySQLPredicate Pushdown
0 likes · 13 min read
Practical MySQL Query Optimizations: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Predicate Push‑down, Early Row Limiting, and Intermediate Result Push‑down
Architect's Guide
Architect's Guide
Apr 6, 2025 · Databases

Analyzing MySQL Connection Latency in Java Applications

This article investigates the time cost of establishing and closing MySQL connections in Java web applications, using Wireshark packet captures and code examples to demonstrate that a single connection can take over 200 ms, highlighting the importance of connection pooling and performance optimizations.

Database ConnectionJavaMySQL
0 likes · 7 min read
Analyzing MySQL Connection Latency in Java Applications
Java Tech Enthusiast
Java Tech Enthusiast
Apr 4, 2025 · Databases

MySQL Large Table Index Optimization and Batch Deletion Strategies

By dropping a low‑selectivity composite index, adding targeted indexes on product_id‑sequence‑station_no and receive_time, and using online DDL with pt‑osc, the team reduced row scans and replication lag, then implemented batch deletions by primary‑key ranges, cutting delete time from minutes to seconds on a 100‑million‑row table.

Batch DeletionIndex OptimizationMySQL
0 likes · 14 min read
MySQL Large Table Index Optimization and Batch Deletion Strategies