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

InnoDBLock Waitdatabase troubleshooting
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.

Database PerformanceForeign Keymysql
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.

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

Remote ConnectionUser Privilegesindexing
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.

Database designindex performancemysql
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.

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

Database Optimizationexplainindexes
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.

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

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

Master‑SlaveMulti-DataSourceSpringBoot
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.

BinlogDMLData Recovery
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.

JOINPredicate PushdownSQL Optimization
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.

Connection PoolingDatabase ConnectionWireshark
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 OptimizationLarge Tables
0 likes · 14 min read
MySQL Large Table Index Optimization and Batch Deletion Strategies
Su San Talks Tech
Su San Talks Tech
Apr 4, 2025 · Backend Development

Master Ant Group Backend Interview: Java, MySQL, TCP, Zookeeper & Redis Secrets

This article walks through Ant Group's bonus structure, explains Java heap vs stack, String object creation, TCP packet issues, MySQL index types, B+‑tree advantages, database lock mechanisms, and shows how Zookeeper and Redis implement distributed coordination and locking, providing concrete code examples and best‑practice recommendations.

TCPZooKeeperjava
0 likes · 27 min read
Master Ant Group Backend Interview: Java, MySQL, TCP, Zookeeper & Redis Secrets
IT Services Circle
IT Services Circle
Apr 3, 2025 · Databases

Six Common MySQL Index Pitfalls and Their Remedies

This article examines six common MySQL indexing pitfalls—type mismatches, function usage, left‑prefix violations, implicit charset conversions, range query issues, and optimizer mis‑choices—and provides concrete SQL fixes and verification tools to improve query performance.

Index Optimizationdatabasemysql
0 likes · 5 min read
Six Common MySQL Index Pitfalls and Their Remedies
Top Architect
Top Architect
Apr 3, 2025 · Databases

MySQL to Elasticsearch Data Synchronization Strategies and Implementation

The article explains why MySQL alone struggles with large‑scale queries, introduces Elasticsearch as a high‑performance search engine, and details multiple synchronization approaches—including synchronous double‑write, asynchronous double‑write, Logstash pipelines, binlog real‑time sync, Canal, and Alibaba DTS—while also noting related promotional offers.

CanalDTSElasticsearch
0 likes · 16 min read
MySQL to Elasticsearch Data Synchronization Strategies and Implementation
macrozheng
macrozheng
Apr 3, 2025 · Databases

MySQL vs Elasticsearch: Which Data Store Wins for Your Use Case?

This article compares MySQL and Elasticsearch across data models, query languages, indexing, distributed architecture, performance, scalability, and typical use cases, helping developers choose the right system or combine them effectively for various application scenarios.

Elasticsearchdata modelingdatabase comparison
0 likes · 12 min read
MySQL vs Elasticsearch: Which Data Store Wins for Your Use Case?
vivo Internet Technology
vivo Internet Technology
Apr 2, 2025 · Databases

Case Study of Slow SQL Governance in an Activity Middleware System

The case study details how an activity‑middleware platform tackled slow SQL problems by cleaning historic data, introducing sharding and Elasticsearch off‑loading, optimizing queries with proper indexes and simplified joins, and automating nightly deletions, ultimately cutting daily slow queries from thousands to double‑digit levels and boosting system stability.

Database PerformanceSQL Optimizationindexing
0 likes · 17 min read
Case Study of Slow SQL Governance in an Activity Middleware System
Raymond Ops
Raymond Ops
Apr 2, 2025 · Databases

How to Set Up MySQL Master‑Slave Replication (Step‑by‑Step Guide)

This guide walks you through preparing multiple virtual machines, configuring MySQL server IDs, setting up both classic and GTID‑based master‑slave replication, and managing the replication with essential commands, complete with code examples and architecture diagrams.

GTIDMaster‑SlaveReplication
0 likes · 6 min read
How to Set Up MySQL Master‑Slave Replication (Step‑by‑Step Guide)
Architect's Tech Stack
Architect's Tech Stack
Mar 31, 2025 · Databases

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

This article investigates MySQL's recommendation to avoid UUIDs and non‑sequential keys by benchmarking insert performance of auto‑increment, UUID, and random (snowflake) primary keys, analyzing their index structures, drawbacks, and concluding that sequential auto‑increment keys provide the best overall efficiency.

auto_incrementindexingjava
0 likes · 9 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 31, 2025 · Databases

Smarter Query Routing with MySQL Routing Guidelines

The article explains how MySQL Shell and MySQL Router 9.2 introduce Routing Guidelines, a declarative, context‑aware query routing feature that lets administrators define fine‑grained rules based on server roles, session attributes, and network information to improve latency, load‑balancing, and fault‑tolerance in complex MySQL topologies.

AdminAPIDatabase ArchitectureMySQL Router
0 likes · 14 min read
Smarter Query Routing with MySQL Routing Guidelines
dbaplus Community
dbaplus Community
Mar 30, 2025 · Databases

Supercharge Your SQL Workflows with DeepSeek Prompt Templates

This guide presents a comprehensive collection of DeepSeek prompt templates for MySQL, covering SQL generation, optimization, data analysis, database administration, debugging, and advanced features, enabling beginners and seasoned developers alike to craft accurate queries, improve performance, and resolve errors efficiently.

Database OptimizationDeepSeekmysql
0 likes · 11 min read
Supercharge Your SQL Workflows with DeepSeek Prompt Templates
Cognitive Technology Team
Cognitive Technology Team
Mar 29, 2025 · Databases

MySQL Multi-Range Read (MRR) Optimization: Advantages, Limitations, Use Cases, and Configuration

MySQL's Multi-Range Read (MRR) optimization reduces random disk I/O by scanning indexes, sorting keys, and retrieving rows sequentially, offering advantages like sequential data access and batch key processing, while outlining its limitations, applicable scenarios, usage conditions, and configuration via optimizer_switch variables and buffer settings.

Disk I/OIndex OptimizationMRR
0 likes · 5 min read
MySQL Multi-Range Read (MRR) Optimization: Advantages, Limitations, Use Cases, and Configuration
Cognitive Technology Team
Cognitive Technology Team
Mar 28, 2025 · Databases

Index Condition Pushdown (ICP) Optimization in MySQL

Index Condition Pushdown (ICP) is a MySQL query‑optimization technique that pushes eligible WHERE predicates to the storage engine so that index entries can filter rows early, reducing row fetches and server‑engine communication.

databasesindex condition pushdownmysql
0 likes · 5 min read
Index Condition Pushdown (ICP) Optimization in MySQL
Linux Cloud Computing Practice
Linux Cloud Computing Practice
Mar 28, 2025 · Backend Development

200+ Essential Interview Questions for Linux, Nginx, MySQL, Kafka & Security

This article compiles a comprehensive collection of over two hundred interview questions covering Linux system administration, Nginx web server, MySQL databases, Redis caching, Kafka messaging, and core network security topics, providing a one‑stop resource for candidates preparing for major tech company interviews.

KafkaNginxinterview-questions
0 likes · 11 min read
200+ Essential Interview Questions for Linux, Nginx, MySQL, Kafka & Security
Sanyou's Java Diary
Sanyou's Java Diary
Mar 27, 2025 · Databases

Why Your MySQL Indexes Fail: Cost Estimation, Fragmentation, and Slow Query Secrets

This article examines MySQL slow‑query troubleshooting, explaining how the optimizer estimates costs, why indexes may be ineffective even when present, the impact of memory fragmentation, pitfalls of prefix indexes, index merging techniques, and additional resource‑related factors that can cause seemingly healthy SQL statements to become slow.

Index OptimizationMemory Fragmentationcost estimation
0 likes · 11 min read
Why Your MySQL Indexes Fail: Cost Estimation, Fragmentation, and Slow Query Secrets
Java Backend Full-Stack
Java Backend Full-Stack
Mar 27, 2025 · Databases

Hands‑On Sharding: Implementing Database and Table Partitioning with Spring Boot and Sharding‑JDBC

This article walks through a complete sharding implementation that splits a user table across four MySQL databases and sixteen tables, discusses challenges such as distributed IDs, transactions, data migration and pagination, and provides full Spring Boot, Sharding‑JDBC, Elasticsearch and Redis configurations with code examples.

ElasticsearchSharding-JDBCSpring Boot
0 likes · 10 min read
Hands‑On Sharding: Implementing Database and Table Partitioning with Spring Boot and Sharding‑JDBC
Java Backend Technology
Java Backend Technology
Mar 26, 2025 · Databases

Why UUID Primary Keys Slow Down MySQL Inserts: A Performance Deep Dive

This article investigates why MySQL discourages UUID or non‑sequential Snowflake IDs as primary keys, compares auto_increment, UUID, and random‑key tables through SpringBoot‑JdbcTemplate benchmarks, analyzes their index structures, and explains the performance trade‑offs and security considerations.

SpringBootauto_incrementindexing
0 likes · 10 min read
Why UUID Primary Keys Slow Down MySQL Inserts: A Performance Deep Dive
macrozheng
macrozheng
Mar 25, 2025 · Databases

Why Auto‑Increment Beats UUID in MySQL: Performance & Index Insights

This article investigates MySQL’s recommendation against UUIDs, comparing auto‑increment, UUID, and random snowflake keys through insertion speed tests and index structure analysis, revealing why auto‑increment keys outperform others, while also discussing the drawbacks of each approach.

Database designIndex structurePerformance Testing
0 likes · 10 min read
Why Auto‑Increment Beats UUID in MySQL: Performance & Index Insights
Top Architect
Top Architect
Mar 24, 2025 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article explains why MySQL alone struggles with large‑scale queries, introduces Elasticsearch for read‑write separation, and compares several synchronization methods—including synchronous and asynchronous dual‑write, Logstash, binlog, Canal, and Alibaba DTS—detailing their advantages, drawbacks, and typical use cases, followed by promotional offers.

CanalDTSElasticsearch
0 likes · 15 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
Cognitive Technology Team
Cognitive Technology Team
Mar 24, 2025 · Databases

Understanding MySQL Replication: Architecture, Binlog Formats, Use Cases, and Best Practices

This article explains MySQL's replication mechanism, detailing master‑slave architecture, key threads, binlog formats (statement, row, mixed), common application scenarios such as backup, read/write splitting, and data migration, and highlights important considerations like network latency, consistency, delay, and security.

ReplicationScalabilitydatabase
0 likes · 7 min read
Understanding MySQL Replication: Architecture, Binlog Formats, Use Cases, and Best Practices
IT Xianyu
IT Xianyu
Mar 24, 2025 · Databases

Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations

This article compares Oracle, PostgreSQL, and MySQL across core features, typical use cases, transaction support, storage engines, licensing, provides simplified installation steps, demonstrates basic SQL operations such as creating tables, inserting and querying data, and highlights key differences like auto‑increment handling and string‑matching functions.

InstallationOracledatabase comparison
0 likes · 7 min read
Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations
Java Architect Essentials
Java Architect Essentials
Mar 24, 2025 · Databases

Why MySQL Discourages UUID as Primary Key: Performance Comparison with Auto‑Increment and Random Keys

This article investigates MySQL's recommendation against using UUIDs or non‑sequential keys as primary keys by creating three tables, benchmarking insert and query speeds with Spring Boot/JdbcTemplate, analyzing index structures, and discussing the trade‑offs of auto‑increment, UUID, and random long keys.

Database designauto_incrementindexing
0 likes · 11 min read
Why MySQL Discourages UUID as Primary Key: Performance Comparison with Auto‑Increment and Random Keys
Java Tech Enthusiast
Java Tech Enthusiast
Mar 23, 2025 · Databases

MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Joins and More

The article shows how common MySQL performance pitfalls—such as large LIMIT offsets, implicit type conversions, sub‑query‑based updates or deletes, mixed ORDER BY, EXISTS clauses, and misplaced predicates—can be rewritten into index‑friendly forms using filters, joins, early limits, UNION ALL, and CTEs to achieve execution times that drop from seconds to milliseconds.

JOINLIMITSQL Optimization
0 likes · 14 min read
MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Joins and More
Java Captain
Java Captain
Mar 22, 2025 · Databases

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

This article investigates MySQL's recommendation against using UUID or random Snowflake IDs as primary keys by creating three tables with different key strategies, running Spring Boot/JDBC performance tests, analyzing index structures, and concluding that auto‑increment keys offer superior insertion efficiency and fewer drawbacks.

Database IndexJDBCSpring Boot
0 likes · 10 min read
Performance Comparison of UUID, Auto‑Increment, and Random Keys in MySQL
Java Backend Full-Stack
Java Backend Full-Stack
Mar 21, 2025 · Interview Experience

Only Four Interviews After a Layoff: My Takeaways

After being laid off, the author interviewed only four companies, detailing each interview’s technical questions—from Spring Cloud and MySQL to concurrency and design patterns—and reflecting on the interviewers’ professionalism, the relevance of his skill set, and the importance of matching resumes to job requirements.

SpringCloudconcurrencyinterview
0 likes · 6 min read
Only Four Interviews After a Layoff: My Takeaways
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 20, 2025 · Databases

How to Interpret the rows Value in MySQL EXPLAIN Output

This article explains what the rows column in MySQL EXPLAIN means, demonstrates three situations—when a small rows value indicates good performance, when it does not, and when rows is misleading—using concrete SQL examples, force‑index tricks, and multi‑table join analyses to show why rows alone cannot reliably judge query efficiency.

SQL Performanceexplainmysql
0 likes · 10 min read
How to Interpret the rows Value in MySQL EXPLAIN Output
Java Web Project
Java Web Project
Mar 19, 2025 · Databases

Why MySQL Auto‑Increment Beats UUID: A Deep Dive into Insertion Performance and Index Structure

This article experimentally compares MySQL auto_increment, UUID, and random Snowflake keys by measuring insert and query speeds, analyzing InnoDB index behavior, and discussing the trade‑offs of each primary‑key strategy, ultimately showing why auto_increment generally outperforms UUID in large‑scale workloads.

InnoDBauto_incrementbenchmark
0 likes · 11 min read
Why MySQL Auto‑Increment Beats UUID: A Deep Dive into Insertion Performance and Index Structure
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 19, 2025 · Databases

Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement

The article explains why the built‑in MySQL 5.7 Seconds_Behind_Master metric often misrepresents replication delay, analyzes its design flaws, and demonstrates how the Percona Toolkit's pt‑heartbeat tool can reliably measure master‑slave lag with real‑time precision.

Database MonitoringReplicationSeconds_Behind_Master
0 likes · 10 min read
Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement
Top Architect
Top Architect
Mar 18, 2025 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

The article outlines multiple approaches for synchronizing MySQL data to Elasticsearch—including synchronous and asynchronous dual‑write, Logstash pipelines, binlog real‑time sync, Canal, and Alibaba Cloud DTS—while also promoting related AI products and community services.

Alibaba CloudCanalElasticsearch
0 likes · 16 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
Architect's Must-Have
Architect's Must-Have
Mar 18, 2025 · Databases

Master MySQL Indexes: From Basics to B+Tree Optimization

This article explains what MySQL indexes are, how they work, their advantages and drawbacks, the different index types—including primary, ordinary, composite, full‑text, clustered and non‑clustered—and compares B‑Tree with B+Tree structures to help you design faster, more efficient queries.

B+TreeClustered IndexInnoDB
0 likes · 12 min read
Master MySQL Indexes: From Basics to B+Tree Optimization
php Courses
php Courses
Mar 17, 2025 · Backend Development

Using PHP mysqli_query to Execute MySQL Queries

This article explains how to use PHP's mysqli_query function to perform MySQL operations such as SELECT, INSERT, UPDATE, and DELETE, providing a step‑by‑step example that creates a database connection, executes a SELECT query, processes results, and closes the connection.

MySQLimysqlsql
0 likes · 5 min read
Using PHP mysqli_query to Execute MySQL Queries
macrozheng
macrozheng
Mar 14, 2025 · Backend Development

Inside Xiaomi Car Interviews: SpringBoot, MySQL Tuning & Distributed Transactions

This article shares Xiaomi car interview salary data, explains SpringBoot's startup process, discusses Spring IOC/AOP benefits, offers MySQL table creation and indexing tips, compares lock types, reviews common design patterns, outlines network device differences, and summarizes distributed transaction solutions including Seata.

Design PatternsDistributed Transactionsbackend-development
0 likes · 20 min read
Inside Xiaomi Car Interviews: SpringBoot, MySQL Tuning & Distributed Transactions
Java Tech Enthusiast
Java Tech Enthusiast
Mar 13, 2025 · Databases

Performance Comparison of UUID vs Auto-Increment IDs in MySQL

Benchmarking three MySQL tables—auto_increment, UUID, and random long keys—shows that sequential auto_increment inserts are fastest, random keys are slower, and UUIDs dramatically lag due to random I/O and fragmentation, so use auto_increment for most workloads and reserve UUIDs only for required global uniqueness.

JDBCSpringBootauto_increment
0 likes · 10 min read
Performance Comparison of UUID vs Auto-Increment IDs in MySQL
dbaplus Community
dbaplus Community
Mar 12, 2025 · Databases

Why Does LIMIT Pagination Slow Down? Deep Dive and Optimizations

This article reproduces a slow‑query scenario caused by deep pagination with LIMIT, explains the underlying index mechanics, and presents several practical SQL techniques—subquery, INNER JOIN, and anchor‑record methods—to dramatically reduce execution time.

Back-tableINNER JOINIndex Optimization
0 likes · 11 min read
Why Does LIMIT Pagination Slow Down? Deep Dive and Optimizations
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Mar 12, 2025 · Databases

Comprehensive MySQL Core Commands Tutorial

This article provides a step‑by‑step guide to essential MySQL operations, covering connection methods, database creation and deletion, user management, password changes, data manipulation, query techniques, indexing strategies, performance tips, and backup procedures, all illustrated with complete command examples.

Backupcommandsdatabase
0 likes · 7 min read
Comprehensive MySQL Core Commands Tutorial
Architecture Digest
Architecture Digest
Mar 12, 2025 · Backend Development

Designing and Optimizing a High‑Concurrency Counting System for Large‑Scale Social Media

This article explains the challenges of storing and serving trillion‑level count data for a massive micro‑blogging platform and presents a step‑by‑step backend design that evolves from simple MySQL tables to sharded databases, Redis caching, message‑queue write‑sharding, and memory‑efficient custom data structures to achieve high performance, low cost, and strong consistency.

counting systemhigh concurrencymysql
0 likes · 12 min read
Designing and Optimizing a High‑Concurrency Counting System for Large‑Scale Social Media
Java Tech Enthusiast
Java Tech Enthusiast
Mar 11, 2025 · Databases

Performance Analysis of MySQL 5.7 to 8.0 Upgrade and ORDER BY Optimization

After upgrading from MySQL 5.7 to 8.0, a client observed that ORDER BY queries on wide SELECTs became dramatically slower because MySQL 8.0 deprecated the max_length_for_sort_data setting, causing the optimizer to perform full‑field sorting instead of index‑based sorting; adding an index on the ordered column restores performance.

SQL OptimizationVersion Upgradedatabase
0 likes · 6 min read
Performance Analysis of MySQL 5.7 to 8.0 Upgrade and ORDER BY Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 10, 2025 · Databases

Using pt‑slave‑repair to Automatically Fix MySQL Master‑Slave Replication Errors 1032 and 1062

This article introduces the pt‑slave‑repair tool, explains the root causes of MySQL master‑slave replication errors 1032 and 1062, details its working principle, preparation steps, and provides concrete command‑line examples for automatically repairing these errors with minimal manual effort.

Error 1032Error 1062Replication
0 likes · 15 min read
Using pt‑slave‑repair to Automatically Fix MySQL Master‑Slave Replication Errors 1032 and 1062
macrozheng
macrozheng
Mar 10, 2025 · Backend Development

Build a Spring Boot + Flowable Leave Approval System: Step‑by‑Step Guide

This tutorial walks through setting up a Spring Boot 2.7.5 project with Flowable 6.6.0 and MySQL8, covering environment setup, Maven dependencies, application properties, core Java classes, REST endpoints, process diagram generation, BPMN definition, database tables, and demo screenshots for a complete leave‑approval workflow.

BPMNFlowableREST API
0 likes · 20 min read
Build a Spring Boot + Flowable Leave Approval System: Step‑by‑Step Guide
Top Architecture Tech Stack
Top Architecture Tech Stack
Mar 10, 2025 · Databases

13 Popular MySQL Graphical Management Tools

This article presents a curated list of thirteen MySQL graphical management tools, describing their main features, platform support, and official download links, to help developers and administrators choose the most suitable GUI for database administration tasks.

DBeaverDataGripDatabase Management
0 likes · 8 min read
13 Popular MySQL Graphical Management Tools
IT Services Circle
IT Services Circle
Mar 8, 2025 · Databases

PostgreSQL Overtaking MySQL: Cloud Adoption, Vector DB Advantage, and Future Database Landscape

The article analyzes recent industry data and expert observations showing PostgreSQL surpassing MySQL in cloud instance counts, CPU usage, and ecosystem support, especially in vector‑database and serverless contexts, while highlighting MySQL's strategic shortcomings and predicting PostgreSQL's dominance in the coming years.

Cloud DatabasesDatabase Trendsmysql
0 likes · 5 min read
PostgreSQL Overtaking MySQL: Cloud Adoption, Vector DB Advantage, and Future Database Landscape
Raymond Ops
Raymond Ops
Mar 7, 2025 · Databases

Master MySQL Backups: Commands for Single, Multiple, and All Databases

This guide explains how to use mysqldump to back up a single MySQL database, multiple databases, or all databases, includes options for specific tables, compression with gzip, adding drop statements, exporting only schema, and provides restore procedures and a sample automated backup script.

Database Backupmysqlmysqldump
0 likes · 11 min read
Master MySQL Backups: Commands for Single, Multiple, and All Databases
Su San Talks Tech
Su San Talks Tech
Mar 7, 2025 · Databases

How to Fix MySQL Deep Pagination Bottlenecks with 6 Proven Techniques

This article dissects the performance problems of MySQL deep pagination, explains why OFFSET‑based queries become increasingly costly, and presents six practical optimization strategies—including cursor pagination, deferred joins, covering indexes, partitioning, precomputed pages, and Elasticsearch integration—to dramatically speed up order‑lookup queries in large e‑commerce databases.

ElasticsearchTable Partitioningcovering index
0 likes · 9 min read
How to Fix MySQL Deep Pagination Bottlenecks with 6 Proven Techniques
IT Services Circle
IT Services Circle
Mar 3, 2025 · Backend Development

Meituan Spring Hiring Overview and Java Backend Interview Q&A

This article discusses Meituan's spring recruitment numbers, then provides detailed Java backend interview questions and answers covering Spring MVC vs Spring Boot, MySQL MVCC, Redis Zset implementation, message queue reliability, HashMap internals, and thread pool usage, offering practical insights for candidates.

BackendThreadPooljava
0 likes · 20 min read
Meituan Spring Hiring Overview and Java Backend Interview Q&A
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 27, 2025 · Information Security

Improving Data Export Workflows and Security: From 1.0 to 2.0 with Classification and Dynamic Approval

This article examines the security challenges of data export work orders in MySQL environments, outlines the shortcomings of the original 1.0 workflow, and presents a comprehensive 2.0 redesign that introduces dynamic approvals, data classification, execution‑plan analysis, and code‑level solutions to mitigate data leakage risks.

Data ExportDatabase SecuritySQL parsing
0 likes · 15 min read
Improving Data Export Workflows and Security: From 1.0 to 2.0 with Classification and Dynamic Approval
php Courses
php Courses
Feb 26, 2025 · Backend Development

Using mysqli_fetch_assoc to Retrieve Query Results in PHP

This article demonstrates how to connect to a MySQL database using mysqli, execute SELECT queries, and retrieve results row by row with the mysqli_fetch_assoc function in PHP, providing complete code examples for connection, querying, result iteration, and proper resource cleanup.

MySQLiPHPbackend-development
0 likes · 4 min read
Using mysqli_fetch_assoc to Retrieve Query Results in PHP
Architect's Must-Have
Architect's Must-Have
Feb 26, 2025 · Databases

Master MySQL Indexes: From Basics to B+Tree Optimization

This article explains what MySQL indexes are, how they work, their advantages and drawbacks, the different types of indexes—including primary, ordinary, composite, and full‑text—and dives deep into B‑Tree and B+Tree structures, clustering, page organization, and best practices for efficient query performance.

B+TreeDatabase Optimizationclustering
0 likes · 11 min read
Master MySQL Indexes: From Basics to B+Tree Optimization
Top Architect
Top Architect
Feb 25, 2025 · Backend Development

Why Docker May Not Be Ideal for Running MySQL: N Reasons and Practical Guidance

The article examines why deploying MySQL in Docker containers can lead to data‑security, performance, state‑management and resource‑isolation problems, outlines mitigation strategies, discusses scenarios where containerization is feasible, and concludes with a call for community discussion while also featuring promotional material for AI‑related services.

Dockerbackend-developmentcontainerization
0 likes · 9 min read
Why Docker May Not Be Ideal for Running MySQL: N Reasons and Practical Guidance