BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 12 of 50
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.

JavaMySQLTCP
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 OptimizationMySQLSQL
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.

ElasticsearchMySQLdata modeling
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.

MySQLSQL optimizationdatabase performance
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‑SlaveMySQL
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.

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

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

DeepSeekMySQLdatabase optimization
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.

Index OptimizationMRRMySQL
0 likes · 5 min read
MySQL Multi-Range Read (MRR) Optimization: Advantages, Limitations, Use Cases, and Configuration
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 OptimizationMySQLcost 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.

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

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

Index structureMySQLUUID
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.

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

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

MySQLUUIDauto-increment
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.

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

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

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

EXPLAINMySQLSQL Performance
0 likes · 10 min read
How to Interpret the rows Value in MySQL EXPLAIN Output
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 MonitoringMySQLReplication
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+TreeInnoDBMySQL
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.

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

Backend DevelopmentDesign PatternsDistributed Transactions
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.

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

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

MySQLPerformance Optimizationcounting system
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.

MySQLPerformanceSQL optimization
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 1062MySQL
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.

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

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

MySQLSQLdatabase backup
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.

Covering IndexCursor PaginationDeep Pagination
0 likes · 9 min read
How to Fix MySQL Deep Pagination Bottlenecks with 6 Proven Techniques
Programmer XiaoFu
Programmer XiaoFu
Mar 5, 2025 · Databases

From 12 s to 200 ms: 6 MySQL Deep‑Pagination Tricks for 20 M Orders

When a MySQL order table with 20 million rows is paginated using a large OFFSET, query latency can explode from seconds to minutes, but applying six concrete techniques—cursor pagination, deferred join, covering index, table partitioning, precomputed pages, and Elasticsearch integration—can shrink response time to a few hundred milliseconds.

Covering IndexCursor PaginationElasticsearch
0 likes · 9 min read
From 12 s to 200 ms: 6 MySQL Deep‑Pagination Tricks for 20 M Orders
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.

BackendJavaMySQL
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 SecurityMySQL
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.

Backend DevelopmentMySQLMySQLi
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+TreeClusteringMySQL
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.

Backend DevelopmentDockerMySQL
0 likes · 9 min read
Why Docker May Not Be Ideal for Running MySQL: N Reasons and Practical Guidance
Bilibili Tech
Bilibili Tech
Feb 25, 2025 · Artificial Intelligence

Design and Implementation of a Live Streaming Highlight System with AI Optimization

The paper details a live‑streaming highlight system that integrates heterogeneous data sources, uses a three‑stage pipeline with MySQL/Redis storage, applies sliding‑window interval optimization and AI‑driven title generation, scoring, and segment selection, managed by a shared state‑machine, and outlines future stability and observability improvements.

Data ProcessingHighlight SystemMySQL
0 likes · 22 min read
Design and Implementation of a Live Streaming Highlight System with AI Optimization
Top Architecture Tech Stack
Top Architecture Tech Stack
Feb 25, 2025 · Backend Development

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

This tutorial explains how to implement dynamic master‑slave MySQL switching in a SpringBoot 3.0.4 project using AOP and a custom @DataSource annotation, covering configuration, enum definitions, utility classes, aspect handling, and usage examples for both single and multiple data sources, including Oracle integration.

AOPJavaMySQL
0 likes · 15 min read
Implementing Dynamic MySQL Master‑Slave Switching in SpringBoot Using AOP and Custom Annotations
Programmer1970
Programmer1970
Feb 24, 2025 · Databases

Deep Dive into MySQL Join Algorithms: Principles, Implementation, and Optimization

This article thoroughly examines MySQL join operations, detailing the fundamentals, inner workings, and performance characteristics of Nested‑Loop Join, Block Nested‑Loop Join, and Hash Join, while providing practical optimization techniques, parameter tuning, and decision‑making guidance for different data sizes and query patterns.

Block Nested Loop JoinHash JoinJoin Algorithms
0 likes · 11 min read
Deep Dive into MySQL Join Algorithms: Principles, Implementation, and Optimization
macrozheng
macrozheng
Feb 24, 2025 · Databases

Mastering MySQL to Elasticsearch Sync: 4 Strategies & Top Migration Tools

This article explores four practical methods for synchronizing MySQL data to Elasticsearch—including synchronous and asynchronous double writes, SQL extraction, and binlog real‑time replication—while reviewing popular migration tools such as Canal, Alibaba DTS, and Databus to help you choose the right solution.

CDCCanalDTS
0 likes · 13 min read
Mastering MySQL to Elasticsearch Sync: 4 Strategies & Top Migration Tools
MaGe Linux Operations
MaGe Linux Operations
Feb 23, 2025 · Databases

Understanding MySQL 8 Directory Structure and Table Storage

This guide explains MySQL 8's main directory layout, the locations of command binaries and configuration files, how databases and system schemas are represented on the file system, and the differences between InnoDB and MyISAM storage engines, including tablespace and file naming conventions.

Database FilesInnoDBMyISAM
0 likes · 13 min read
Understanding MySQL 8 Directory Structure and Table Storage
Raymond Ops
Raymond Ops
Feb 20, 2025 · Databases

Master MySQL Slow Query Optimization: EXPLAIN Tips & Practical SQL Tuning

This guide walks through identifying slow MySQL queries using EXPLAIN, explains each output field, and presents practical optimization techniques—including proper index usage, pagination tricks, join improvements, and ORDER/GROUP BY tuning—to dramatically boost query performance.

EXPLAINMySQLSQL optimization
0 likes · 8 min read
Master MySQL Slow Query Optimization: EXPLAIN Tips & Practical SQL Tuning
Pan Zhi's Tech Notes
Pan Zhi's Tech Notes
Feb 20, 2025 · Databases

Mastering Database Concurrency: Dirty Read, Non‑Repeatable Read, and Phantom Read

The article explains ACID properties, details how inadequate isolation levels cause dirty reads, non‑repeatable reads, and phantom reads, illustrates each with transaction scenarios and diagrams, and shows how MySQL’s lock types and isolation settings prevent these anomalies, noting the trade‑off between isolation and concurrency.

Dirty ReadMySQLPhantom Read
0 likes · 9 min read
Mastering Database Concurrency: Dirty Read, Non‑Repeatable Read, and Phantom Read
php Courses
php Courses
Feb 19, 2025 · Backend Development

Improving Development Practices in a Legacy PHP/MySQL Environment Without Version Control

The article recounts a developer’s experience modernizing a legacy PHP and MySQL codebase that lacked version control, detailing the challenges of disorganized code, security risks, and inefficient workflows, and describing the step‑by‑step solutions implemented to introduce backups, local Git, security hardening, and a structured development process.

MySQLPHPsecurity
0 likes · 10 min read
Improving Development Practices in a Legacy PHP/MySQL Environment Without Version Control
Java Backend Technology
Java Backend Technology
Feb 19, 2025 · Backend Development

Mastering Dynamic MySQL Master‑Slave Switching in SpringBoot with AOP

Learn how to implement dynamic MySQL master‑slave switching in a SpringBoot project using AOP and custom annotations, ensuring automatic failover to the master when a slave fails, with detailed configuration, code examples, and guidance for multiple data sources and Oracle integration.

AOPDatabase FailoverMaster‑Slave
0 likes · 15 min read
Mastering Dynamic MySQL Master‑Slave Switching in SpringBoot with AOP
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 18, 2025 · Databases

Parsing Delete Undo Log in MySQL 8.0.32 InnoDB

This article explains how to read and parse the Undo log generated by a DELETE operation in MySQL 8.0.32 InnoDB, covering preparation, log extraction, detailed field parsing, locating the primary index record, and the step‑by‑step rollback of secondary and primary index records.

Database InternalsInnoDBMySQL
0 likes · 10 min read
Parsing Delete Undo Log in MySQL 8.0.32 InnoDB
macrozheng
macrozheng
Feb 17, 2025 · Backend Development

Master Dynamic MySQL Master‑Slave Switching in Spring Boot with AOP

This guide explains how to use Spring Boot, AOP, and custom annotations to implement dynamic MySQL master‑slave data source switching, automatically falling back to the master when a slave fails, covering configuration, Maven dependencies, enum definitions, data source beans, routing logic, and usage examples.

AOPDynamic Data SourceMySQL
0 likes · 16 min read
Master Dynamic MySQL Master‑Slave Switching in Spring Boot with AOP
Liangxu Linux
Liangxu Linux
Feb 16, 2025 · Databases

Essential MySQL Tuning Tools: Diagnose and Optimize Your Database

This guide introduces four powerful MySQL performance‑tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run, and interpret their reports to identify configuration issues, memory overload, and slow‑query problems.

Database ToolsMySQLpercona-toolkit
0 likes · 9 min read
Essential MySQL Tuning Tools: Diagnose and Optimize Your Database
Java Tech Enthusiast
Java Tech Enthusiast
Feb 15, 2025 · Databases

Understanding MySQL table_open_cache and Its Impact on DTS Performance

table_open_cache limits the total simultaneously opened tables in MySQL, using a global cache complemented by per‑thread Table_cache instances to reduce lock contention; mis‑sizing this cache—especially when DTS forces many full‑table scans on key‑less tables—can cause latency, memory bloat, and LRU evictions, so monitor Opened_tables and adjust the setting judiciously.

DTSMySQLcaching
0 likes · 10 min read
Understanding MySQL table_open_cache and Its Impact on DTS Performance
Selected Java Interview Questions
Selected Java Interview Questions
Feb 14, 2025 · Databases

ShardingSphere Overview and Spring Boot Integration for Database Sharding, Proxy, and Sidecar

This article introduces ShardingSphere's three components—Sharding-JDBC, Sharding-Proxy, and the upcoming Sharding-Sidecar—explains why sharding is needed for relational databases, demonstrates horizontal data sharding concepts, and provides a complete Spring Boot example with configuration, code, and asynchronous batch insertion.

Distributed TransactionsMySQLShardingSphere
0 likes · 17 min read
ShardingSphere Overview and Spring Boot Integration for Database Sharding, Proxy, and Sidecar