BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 14 of 50
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Dec 19, 2024 · Databases

Data Consistency Verification Practices and Implementation at Xiaohongshu

Xiaohongshu built a lock‑free, non‑disruptive data‑consistency verification tool that automatically selects optimal methods, handles heterogeneous sources and dynamic changes, performs full and incremental checks via chunked checksums or row‑by‑row comparison, quickly isolates mismatches, and supports automatic remediation, ensuring reliable migrations and sharding.

Data ValidationMySQLdata consistency
0 likes · 16 min read
Data Consistency Verification Practices and Implementation at Xiaohongshu
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 18, 2024 · Databases

How MySQL InnoDB Allocates Undo Segments

This article explains the internal process MySQL 8.0.32 InnoDB uses to allocate, create, and manage Undo segments—including cached segment retrieval, new segment creation, insertion into rollback segment lists, conflict avoidance through mutexes, and a concise step‑by‑step summary of the entire workflow.

InnoDBMySQLdatabase
0 likes · 9 min read
How MySQL InnoDB Allocates Undo Segments
Top Architect
Top Architect
Dec 16, 2024 · Backend Development

Replacing MyBatis with MyBatis‑Plus: Version Compatibility, Debugging, and Lessons Learned

This article walks through the process of swapping MyBatis for MyBatis‑Plus in a legacy Java project, explains why upgrading MyBatis to 3.5.1 triggers a LocalDateTime conversion error, shows how updating mysql‑connector‑java resolves the issue, and shares the broader pitfalls of component upgrades and bug fixes.

JavaMyBatis-PlusMySQL
0 likes · 10 min read
Replacing MyBatis with MyBatis‑Plus: Version Compatibility, Debugging, and Lessons Learned
Architect
Architect
Dec 15, 2024 · Databases

Efficient MySQL Queries for Millions of Rows: Regular, Stream, and Cursor

When processing massive MySQL result sets, loading all rows into JVM memory can cause OOM and slow performance, so this guide compares three approaches—regular pagination, streaming queries using server-side cursors, and cursor‑based fetchSize control—detailing their implementations, MyBatis configurations, and trade‑offs.

CursorLarge DataMySQL
0 likes · 10 min read
Efficient MySQL Queries for Millions of Rows: Regular, Stream, and Cursor
Architecture Digest
Architecture Digest
Dec 15, 2024 · Databases

Impact of VARCHAR Length on MySQL Storage and Query Performance

This article investigates whether the declared length of VARCHAR columns (e.g., VARCHAR(50) vs VARCHAR(500)) affects MySQL storage size and query performance by creating two tables, inserting one million rows, measuring disk usage, and benchmarking various SELECT and ORDER BY operations.

MySQLPerformanceStorage
0 likes · 10 min read
Impact of VARCHAR Length on MySQL Storage and Query Performance
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 13, 2024 · Databases

Understanding MySQL Architecture and Log Mechanisms for ACID Transactions

This article provides a comprehensive overview of MySQL's layered architecture, the functions and core components of the server layer, and detailed explanations of Undo Log, Redo Log, and Binlog mechanisms that together ensure the ACID properties of transactions, including practical execution flows for queries and updates.

ACIDBinlogMySQL
0 likes · 29 min read
Understanding MySQL Architecture and Log Mechanisms for ACID Transactions
Java Tech Enthusiast
Java Tech Enthusiast
Dec 13, 2024 · Databases

Impact of VARCHAR Length on MySQL Storage and Query Performance

Testing shows that VARCHAR(50) and VARCHAR(500) occupy identical storage, yet while simple lookups perform similarly, sorting on the longer column triggers disk‑based mergesort and can be several times slower, demonstrating that excessive VARCHAR length harms query performance without saving space.

MySQLPerformanceSQL
0 likes · 10 min read
Impact of VARCHAR Length on MySQL Storage and Query Performance
Architect
Architect
Dec 12, 2024 · Databases

Design and Implementation of MySQL SQL Flow‑Control (Throttling) Feature

This document details the purpose, requirements, architecture, detailed design, performance impact, and limitations of a MySQL kernel extension that throttles SQL statements based on configurable flow‑control rules to protect core services from CPU overload caused by heavy or slow queries.

Database flow controlMySQLSQL throttling
0 likes · 13 min read
Design and Implementation of MySQL SQL Flow‑Control (Throttling) Feature
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 12, 2024 · Databases

Using EXPLAIN to Analyze and Optimize a Simple MySQL Query

This article demonstrates how to use MySQL's EXPLAIN statement to examine execution plans, interpret key fields such as possible_keys, key, rows, and Extra, and apply index adjustments—including adding and forcing indexes—to improve query performance while weighing sorting costs.

EXPLAINIndex OptimizationMySQL
0 likes · 11 min read
Using EXPLAIN to Analyze and Optimize a Simple MySQL Query
Programmer1970
Programmer1970
Dec 11, 2024 · Databases

How MySQL 8’s Transactional Data Dictionary Transforms Metadata Management

The article explains why MySQL 8 replaces fragmented, non‑transactional metadata files with a unified, InnoDB‑backed transactional data dictionary, details the information_schema views that expose it, and enumerates the resulting benefits such as atomicity, consistency, crash recovery, performance gains, simplified administration, reduced lock contention, smoother upgrades, improved DDL handling, and enhanced security.

InnoDBMySQLTransactional Data Dictionary
0 likes · 13 min read
How MySQL 8’s Transactional Data Dictionary Transforms Metadata Management
Architect's Guide
Architect's Guide
Dec 11, 2024 · Databases

Challenges and Limitations of Database Sharding in Large‑Scale E‑commerce Systems

The article examines why MySQL sharding (分库分表) is adopted for high‑traffic e‑commerce, outlines its inherent problems such as distributed transaction handling, index and global key constraints, operational overhead, and argues that distributed databases like OceanBase offer a more robust alternative.

Database ScalingDistributed TransactionsMySQL
0 likes · 10 min read
Challenges and Limitations of Database Sharding in Large‑Scale E‑commerce Systems
Architect
Architect
Dec 10, 2024 · Backend Development

Splitting Large Transactions to Ensure Distributed Consistency in Backend Systems

This article analyzes the challenges of distributed transaction consistency when combining MySQL writes with third‑party system calls, presents a concrete financial reimbursement case, and proposes a solution that splits a big transaction into small, retryable units using a task table, scheduled jobs, and Spring's after‑commit hook to achieve reliable consistency without excessive latency.

Distributed TransactionsMySQLtransaction splitting
0 likes · 9 min read
Splitting Large Transactions to Ensure Distributed Consistency in Backend Systems
Top Architect
Top Architect
Dec 10, 2024 · Databases

Why Docker Is Not Suitable for Running MySQL: Data Safety, Performance, and Resource Isolation Issues

The article explains that while Docker is convenient for learning environments, deploying MySQL in containers poses serious data‑safety, performance, and resource‑isolation problems, and it outlines scenarios where containerizing MySQL may still be viable before shifting to promotional content about AI communities.

Data SafetyDockerMySQL
0 likes · 10 min read
Why Docker Is Not Suitable for Running MySQL: Data Safety, Performance, and Resource Isolation Issues
Su San Talks Tech
Su San Talks Tech
Dec 10, 2024 · Databases

Master MySQL: 13 Essential Functions & Commands Every Developer Should Know

This article walks through 13 practical MySQL techniques—including group_concat, char_length, locate, replace, now, various INSERT variations, SELECT FOR UPDATE, on duplicate key update, SHOW CREATE TABLE, CREATE TABLE … SELECT, EXPLAIN, SHOW PROCESSLIST, and mysqldump—providing clear examples, SQL snippets, and screenshots to help developers write more efficient and reliable queries.

FunctionsMySQLPerformance
0 likes · 14 min read
Master MySQL: 13 Essential Functions & Commands Every Developer Should Know
Top Architect
Top Architect
Dec 9, 2024 · Databases

Database Monitoring and Slow Query Log Management Guide

This article provides a practical guide on monitoring database system resources using Linux commands, configuring MySQL slow query logging, analyzing performance issues, and outlines best practices, while also promoting a ChatGPT community and related services.

DevOpsMySQLdatabases
0 likes · 7 min read
Database Monitoring and Slow Query Log Management Guide
JD Tech Talk
JD Tech Talk
Dec 9, 2024 · Databases

Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins

This article explores MySQL's join processing methods—Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop joins—demonstrates how to create test tables, analyze execution plans, and apply practical optimizations such as indexing and query rewriting to dramatically improve multi‑table query performance.

Join AlgorithmsMySQLSQL optimization
0 likes · 21 min read
Mastering MySQL Join Algorithms: From Simple Loops to Hash Joins
dbaplus Community
dbaplus Community
Dec 8, 2024 · Databases

Why Do JDBC Queries Hang? Understanding Timeout Mechanisms and Fixes

The article explains how JDBC’s setQueryTimeout and Spring’s transaction timeout work, reveals why SQL statements can become indefinitely blocked in the socket read phase, and provides practical configuration steps—including driver URL parameters—to prevent such blocking in MySQL, SQL Server, and Oracle environments.

JDBCMySQLSpring
0 likes · 11 min read
Why Do JDBC Queries Hang? Understanding Timeout Mechanisms and Fixes
Java Tech Enthusiast
Java Tech Enthusiast
Dec 6, 2024 · Backend Development

Migrating MyBatis to MyBatis-Plus: Debugging LocalDateTime Conversion Issues

When migrating an old Java project from MyBatis 3.5.0 to MyBatis‑Plus 3.1.1, a test failed with “Conversion not supported for type java.time.LocalDateTime” because MyBatis 3.5.1 stopped handling Java 8 time types and the existing mysql‑connector‑java 5.1.26 driver lacked support, which was resolved by upgrading the connector to version 5.1.37 or later, highlighting the need for thorough compatibility testing during framework upgrades.

JavaLocalDateTimeMyBatis-Plus
0 likes · 7 min read
Migrating MyBatis to MyBatis-Plus: Debugging LocalDateTime Conversion Issues
Senior Tony
Senior Tony
Dec 6, 2024 · Databases

Why MySQL COUNT(*) Can Be Milliseconds Fast: Engine Tricks & Optimization Strategies

This article explains why COUNT(*) on a large InnoDB table can take seconds while MyISAM returns instantly, explores the underlying storage‑engine differences, and presents six practical techniques—including Redis counters, counting tables with transactions or triggers, parallel read threads, secondary indexes, and SHOW TABLE STATUS—to dramatically speed up row counting in MySQL.

COUNTInnoDBMySQL
0 likes · 9 min read
Why MySQL COUNT(*) Can Be Milliseconds Fast: Engine Tricks & Optimization Strategies
Top Architect
Top Architect
Dec 5, 2024 · Databases

Database Monitoring and Slow Query Log Management Guide

This article explains how database administrators can monitor system resource usage with commands like top, iostat, and vmstat, and configure MySQL slow query logging, including enabling the log, setting thresholds, viewing logs, and applying best‑practice recommendations for analysis and issue resolution.

Linux CommandsMySQLdatabase administration
0 likes · 8 min read
Database Monitoring and Slow Query Log Management Guide
Top Architecture Tech Stack
Top Architecture Tech Stack
Dec 5, 2024 · Databases

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Predicate Pushdown, Early Range Reduction, and CTEs

This article explains common MySQL performance pitfalls such as large‑offset LIMIT queries, implicit type conversion, sub‑query updates, mixed sorting, inefficient EXISTS clauses, predicate push‑down limitations, and demonstrates how rewriting with proper indexes, JOINs, early range reduction, and WITH (CTE) statements can reduce execution time from seconds to milliseconds.

CTEMySQLPredicate Pushdown
0 likes · 12 min read
Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Predicate Pushdown, Early Range Reduction, and CTEs
Efficient Ops
Efficient Ops
Dec 4, 2024 · Operations

Top 35 Linux Ops Interview Questions and Expert Answers

This article compiles thirty‑five essential Linux operations interview questions covering server management, RAID configurations, load‑balancing choices, middleware concepts, MySQL troubleshooting, networking tools, security practices, scripting examples, and system‑level optimizations, providing concise expert answers for each topic.

LinuxMySQLOperations
0 likes · 34 min read
Top 35 Linux Ops Interview Questions and Expert Answers
vivo Internet Technology
vivo Internet Technology
Dec 4, 2024 · Databases

OceanBase Implementation and Migration Practices at vivo

vivo migrated five 20‑TB MySQL clusters to OceanBase using OCP, oblogproxy, and OMS, eliminating sharding costs, achieving over 70% storage savings, improving consistency and performance, and leveraging native distributed architecture, tenant isolation, and strong compression to support scalable, reliable operations.

MySQLOceanBasedata compression
0 likes · 16 min read
OceanBase Implementation and Migration Practices at vivo
MaGe Linux Operations
MaGe Linux Operations
Dec 3, 2024 · Databases

Master MySQL Backups: Commands, Scripts, and Best Practices

This guide explains how to back up single or multiple MySQL databases, entire server instances, specific tables, or only schema, using mysqldump with options like -B, gzip compression, add‑drop flags, and provides restore procedures and an automated backup script.

GZIPMySQLRestore
0 likes · 10 min read
Master MySQL Backups: Commands, Scripts, and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 2, 2024 · Databases

MySQL Replication Filter Expansion: Adding New Databases with Efficient Backup and Restore

This article explains how to extend an existing MySQL master‑slave replication filter to include additional databases by using a low‑cost backup‑restore workflow, detailing two solution options, the chosen approach, and step‑by‑step commands for stopping replication, backing up, setting GTID points, restoring, and updating filter rules.

GTIDMySQLReplication
0 likes · 9 min read
MySQL Replication Filter Expansion: Adding New Databases with Efficient Backup and Restore
Lobster Programming
Lobster Programming
Dec 2, 2024 · Backend Development

Designing Scalable E‑Commerce Shopping Carts: From Cookies to Redis

This article explores the core functions of e‑commerce shopping carts and compares client‑side storage methods such as Cookies and LocalStorage with server‑side solutions like Redis and MySQL, offering guidance on choosing the appropriate approach based on business scale and reliability requirements.

BackendMySQLRedis
0 likes · 7 min read
Designing Scalable E‑Commerce Shopping Carts: From Cookies to Redis
Efficient Ops
Efficient Ops
Dec 1, 2024 · Operations

How I Rescued a Production MySQL Database After a Fatal rm -rf Accident

After a junior engineer mistakenly ran an unguarded rm -rf command that wiped an entire production server—including MySQL and Tomcat—I documented the step‑by‑step recovery using ext3grep, extundelete, and MySQL binlog, highlighting the lessons learned for future operations.

LinuxMySQLOperations
0 likes · 9 min read
How I Rescued a Production MySQL Database After a Fatal rm -rf Accident
Programmer1970
Programmer1970
Nov 29, 2024 · Databases

40 Essential MySQL Interview Questions and Answers

This article compiles 40 core MySQL interview questions covering ACID properties, lock types, views, stored procedures, JOINs, storage engines, query optimization, buffer pools, write buffers, transaction mechanisms, MVCC, isolation levels, gap locks, metadata locks, thread model, row formats, and more, providing concise answers for each.

MVCCMySQLQuery Optimization
0 likes · 57 min read
40 Essential MySQL Interview Questions and Answers
Top Architect
Top Architect
Nov 29, 2024 · Databases

Data Synchronization Strategies between MySQL and Elasticsearch

The article explains why MySQL alone struggles with large‑scale, complex queries, introduces Elasticsearch as a complementary search engine, and details multiple synchronization approaches—including synchronous and asynchronous double‑write, Logstash, Binlog, Canal, and Alibaba DTS—along with their advantages, disadvantages, and typical use cases.

CanalDTSElasticsearch
0 likes · 16 min read
Data Synchronization Strategies between MySQL and Elasticsearch
IT Services Circle
IT Services Circle
Nov 27, 2024 · Databases

15 Common MySQL Pitfalls and How to Avoid Them

This article outlines fifteen typical MySQL pitfalls—including missing WHERE clauses, lack of indexes, improper NULL handling, wrong data types, deep pagination, missing EXPLAIN analysis, charset misconfiguration, SQL injection risks, transaction misuse, collation issues, overusing SELECT *, index loss, frequent schema changes, missing backups, and unarchived historical data—and provides concrete examples and best‑practice solutions to improve performance, reliability, and security.

MySQLSQLTransactions
0 likes · 13 min read
15 Common MySQL Pitfalls and How to Avoid Them
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 27, 2024 · Databases

Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels

This article explains the concept and importance of MySQL database transactions, describes the ACID properties, shows how to use transaction control statements and savepoints, and demonstrates each isolation level (read uncommitted, read committed, repeatable read, serializable) with practical SQL examples.

ACIDDatabase TransactionsMySQL
0 likes · 10 min read
Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels
Programmer XiaoFu
Programmer XiaoFu
Nov 27, 2024 · Databases

Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes

The article explains how to troubleshoot extreme CPU usage in MySQL and Java processes, detailing step‑by‑step diagnostics with top, show processlist, jstack, and practical fixes such as adding missing indexes, disabling slow logs, using caches, and correcting busy‑loop code to bring CPU consumption back to normal levels.

CPUJavaLinux
0 likes · 11 min read
Why Does MySQL CPU Spike to 900%? Diagnosis and Fixes
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 27, 2024 · Databases

Summary of InnoDB Lock Module Articles

This article provides a concise English recap of the 27 previously published InnoDB lock module articles, covering theoretical concepts such as table and row locks, lock waiting, deadlock handling, and practical scenarios like lock behavior during inserts and duplicate key operations.

Database InternalsInnoDBLocks
0 likes · 6 min read
Summary of InnoDB Lock Module Articles
Su San Talks Tech
Su San Talks Tech
Nov 26, 2024 · Databases

15 Common MySQL Pitfalls and How to Avoid Them

This article outlines fifteen frequent MySQL mistakes—from missing WHERE clauses and absent indexes to improper data types, deep pagination, SQL injection risks, and inadequate backups—providing clear examples and practical solutions to improve query performance, data integrity, and overall database reliability.

MySQLSQLdatabase optimization
0 likes · 15 min read
15 Common MySQL Pitfalls and How to Avoid Them
php Courses
php Courses
Nov 25, 2024 · Databases

MySQL 8 New Features and Network Communication Course Overview

This course introduces MySQL 8's latest features, deep dives into its network communication mechanisms, and teaches advanced optimization techniques such as connection pooling, compression, and SSL encryption, enabling students to build efficient, secure, and high‑performance database applications.

MySQLOptimizationPerformance
0 likes · 2 min read
MySQL 8 New Features and Network Communication Course Overview
dbaplus Community
dbaplus Community
Nov 24, 2024 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

This article walks through practical MySQL performance tuning methods—including pagination, join, subquery, ORDER BY, GROUP BY, and COUNT optimizations—illustrated with real‑world data volumes, step‑by‑step SQL examples, EXPLAIN analyses, index creation, and measurable query‑time improvements.

JOINMySQLORDER BY
0 likes · 14 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
Efficient Ops
Efficient Ops
Nov 24, 2024 · Databases

Why Slow Queries Are the Silent Killers of Your App Performance

This article explains how slow MySQL queries degrade user experience, impact business operations, and consume resources, then details how to enable and interpret the slow query log, use EXPLAIN for query analysis, avoid common testing misconceptions, and apply four practical optimization strategies.

EXPLAINMySQLslow query
0 likes · 11 min read
Why Slow Queries Are the Silent Killers of Your App Performance
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Nov 22, 2024 · Backend Development

How to Sync MySQL to Redis in Real-Time with Spring Boot 3 and mysql-binlog-connector-java

This article demonstrates how to achieve real‑time synchronization of MySQL data to Redis using Spring Boot 3, the open‑source mysql‑binlog‑connector‑java library, and optional JMX exposure, providing step‑by‑step setup, code examples for parsing binlog events, listening to changes, and configuring Maven dependencies.

BinlogMySQLRedis
0 likes · 10 min read
How to Sync MySQL to Redis in Real-Time with Spring Boot 3 and mysql-binlog-connector-java
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 21, 2024 · Databases

Common MySQL Data Types and Selection Guidelines

This article explains MySQL's various numeric, date/time, and string data types, discusses their characteristics such as signed/unsigned integers, floating‑point precision, fixed‑point accuracy, and provides practical best‑practice recommendations for choosing optimal types in database design.

Data TypesMySQLSQL
0 likes · 6 min read
Common MySQL Data Types and Selection Guidelines
php Courses
php Courses
Nov 19, 2024 · 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, including a complete example that creates a connection, runs a query, processes results, and closes the connection.

MySQLPHPdatabase
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Top Architect
Top Architect
Nov 17, 2024 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article explains why MySQL alone may struggle with large‑scale, complex queries, introduces Elasticsearch as a high‑performance search engine, and compares several synchronization approaches—including synchronous and asynchronous dual‑write, Logstash, Binlog, Canal, and Alibaba Cloud DTS—detailing their advantages, disadvantages, and suitable scenarios.

BinlogCanalDTS
0 likes · 14 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
Su San Talks Tech
Su San Talks Tech
Nov 16, 2024 · Databases

Why MySQL Pagination Slows Down on Large Tables and How to Fix It

This article examines how pagination queries on massive MySQL tables become dramatically slower as the offset grows, defines what constitutes a slow SQL, and presents three practical optimization techniques—including returning only primary keys, range filtering, and using Elasticsearch—to dramatically improve query performance.

ElasticsearchMySQLPerformance
0 likes · 10 min read
Why MySQL Pagination Slows Down on Large Tables and How to Fix It
Java Backend Technology
Java Backend Technology
Nov 15, 2024 · Databases

How a MySQL Connection Takes 200ms+ and Why You Need a Pool

This article dissects the MySQL connection process using Java and Wireshark, revealing that establishing a single connection can consume over 200 ms, which scales to hours of latency for high‑traffic sites, highlighting the necessity of connection pooling and related optimizations.

Database ConnectionMySQLWireshark
0 likes · 7 min read
How a MySQL Connection Takes 200ms+ and Why You Need a Pool
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 15, 2024 · Backend Development

Implementing a View‑Once Image Feature with Spring Boot and MySQL

This guide explains how to design and build a privacy‑focused, view‑once image sharing system using Spring Boot, MySQL, Thymeleaf, and optional cloud storage, covering requirements analysis, architecture, environment setup, code implementation, security considerations, performance optimizations, testing, and deployment.

BackendImage BurnMySQL
0 likes · 15 min read
Implementing a View‑Once Image Feature with Spring Boot and MySQL
ITPUB
ITPUB
Nov 14, 2024 · Operations

How to Tame 900% CPU Spikes in MySQL and Java Processes

This guide explains why MySQL and Java processes can suddenly consume 900% CPU, walks through systematic diagnosis using Linux tools, and provides concrete remediation steps such as indexing, caching, thread analysis, and code adjustments to bring CPU usage back to normal levels.

CPUJavaLinux
0 likes · 12 min read
How to Tame 900% CPU Spikes in MySQL and Java Processes
php Courses
php Courses
Nov 14, 2024 · 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 connection, runs a SELECT query, processes results, and closes the database connection.

MySQLPHPdatabase
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Java Tech Enthusiast
Java Tech Enthusiast
Nov 13, 2024 · Backend Development

Implementing Image Self‑Destruct Feature with Spring Boot and MySQL

This guide walks through building a Spring Boot and MySQL‑backed “burn after viewing” image sharing service, covering architecture, environment setup, entity and repository design, upload and automatic deletion logic, Thymeleaf UI with burn animation, error handling, optimization, and Docker deployment.

Image BurnMySQLSelf-Destruct
0 likes · 15 min read
Implementing Image Self‑Destruct Feature with Spring Boot and MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 13, 2024 · Databases

InnoDB Locking Analysis for INSERT … ON DUPLICATE KEY under REPEATABLE‑READ and READ‑COMMITTED

This article examines how InnoDB acquires row‑level locks during INSERT … ON DUPLICATE KEY operations under REPEATABLE‑READ and READ‑COMMITTED isolation levels, explains the lock types on primary and unique indexes, and shows the rollback and lock‑conversion process with concrete SQL examples.

Duplicate KeyInnoDBMySQL
0 likes · 11 min read
InnoDB Locking Analysis for INSERT … ON DUPLICATE KEY under REPEATABLE‑READ and READ‑COMMITTED
Top Architect
Top Architect
Nov 12, 2024 · Databases

Design and Implementation of Table Sharding for Loan Repayment Applications Using ShardingSphere and Spring Boot

This article describes how a senior architect designed, configured, and implemented a 50‑table sharding solution for loan and repayment request data using ShardingSphere, Spring Boot 3, MySQL, and custom synchronization scripts, while also addressing historical data migration, backend query changes, and operational safeguards.

MySQLShardingSphereSpringBoot
0 likes · 23 min read
Design and Implementation of Table Sharding for Loan Repayment Applications Using ShardingSphere and Spring Boot
Lobster Programming
Lobster Programming
Nov 12, 2024 · Databases

Why Deploying MySQL in Docker Can Be Problematic: Scaling & Memory Pitfalls

This article explains why using Docker to host MySQL is generally discouraged, highlighting challenges in database scaling due to container‑exclusive storage, difficulties sharing data files, and memory contention among containers, while also outlining possible synchronization solutions and scenarios where containerized MySQL may still be viable.

DockerMySQLcontainerization
0 likes · 4 min read
Why Deploying MySQL in Docker Can Be Problematic: Scaling & Memory Pitfalls
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 11, 2024 · Databases

New JSON Format for EXPLAIN and EXPLAIN ANALYZE in MySQL 8.3+

MySQL 8.3 introduces a new iterator‑aware JSON output for EXPLAIN and EXPLAIN ANALYZE, selectable via the explain_json_format_version variable, which aligns JSON with the tree format, provides richer execution statistics, and can be accessed programmatically through EXPLAIN INTO across all recent MySQL releases.

EXPLAINJSONMySQL
0 likes · 11 min read
New JSON Format for EXPLAIN and EXPLAIN ANALYZE in MySQL 8.3+
ITPUB
ITPUB
Nov 11, 2024 · Databases

When Does MySQL Actually Update Index Blocks? A Deep Dive into InnoDB Update Mechanics

This article examines how MySQL InnoDB decides whether to modify index blocks during UPDATE statements, walks through the internal mysql_update workflow, shows debugging with GDB, explains three test scenarios, and validates the behavior by inspecting block LSNs with the innblock tool.

Database InternalsIndex UpdateInnoDB
0 likes · 18 min read
When Does MySQL Actually Update Index Blocks? A Deep Dive into InnoDB Update Mechanics
IT Services Circle
IT Services Circle
Nov 11, 2024 · Databases

Handling Case Sensitivity in MySQL Brand Table to Prevent Duplicate Entries

This article examines why a MySQL table with a case‑insensitive collation returns uppercase brand names when searching for lowercase input, analyzes the underlying charset and collation settings, and proposes backend pagination with a case‑insensitive fuzzy search and a unique index to reliably prevent duplicate brand records.

Brand ManagementCase InsensitivityMySQL
0 likes · 8 min read
Handling Case Sensitivity in MySQL Brand Table to Prevent Duplicate Entries
MaGe Linux Operations
MaGe Linux Operations
Nov 10, 2024 · Databases

Step‑by‑Step Guide to Deploy Multiple MySQL Instances on Linux

This tutorial walks you through downloading MySQL binaries, creating a dedicated mysql user, extracting files to /usr/local, setting up separate data directories, initializing each instance, configuring my.cnf, managing the services with systemd, setting root passwords, and troubleshooting common errors, enabling you to run three isolated MySQL servers on a single host.

Database deploymentLinuxMySQL
0 likes · 23 min read
Step‑by‑Step Guide to Deploy Multiple MySQL Instances on Linux
Java Tech Enthusiast
Java Tech Enthusiast
Nov 10, 2024 · Databases

Database Monitoring and Logging Practices

Effective database administration relies on continuous monitoring of system resources—CPU, memory, disk I/O, and network—using tools like top, iostat, and vmstat, alongside logging slow MySQL queries, analyzing performance bottlenecks, and following best practices such as automated monitoring, centralized log management, regular audits, and log backups.

LinuxMySQLPerformance
0 likes · 5 min read
Database Monitoring and Logging Practices
Architecture Digest
Architecture Digest
Nov 9, 2024 · Databases

MySQL Query Optimization Techniques and Common Pitfalls

This article examines frequent MySQL performance problems such as inefficient LIMIT pagination, implicit type conversion, sub‑query updates, mixed sorting, misuse of EXISTS, condition push‑down limitations, early result narrowing, intermediate result push‑down, and demonstrates how rewriting queries with JOINs, derived tables, and WITH clauses can dramatically improve execution speed.

JOINLIMITMySQL
0 likes · 11 min read
MySQL Query Optimization Techniques and Common Pitfalls
ITPUB
ITPUB
Nov 9, 2024 · Databases

Why MySQL Unique Indexes Still Allow Duplicates and How to Fix Them

This article explains why a MySQL 8 InnoDB table with a unique index can still store duplicate rows—especially when indexed columns contain NULL or when logical deletion is used—and presents several practical strategies, including status counters, timestamps, extra IDs, hash fields, and batch‑insert techniques, to enforce true uniqueness.

Batch InsertHash FieldInnoDB
0 likes · 14 min read
Why MySQL Unique Indexes Still Allow Duplicates and How to Fix Them
Top Architect
Top Architect
Nov 7, 2024 · Databases

Database Sharding Design and Implementation for Loan & Repayment Tables Using ShardingSphere and Spring Boot

This article describes how a senior architect designed and implemented a sharding solution for loan and repayment tables, covering database design, table naming, sharding algorithms, historical data migration, three‑write synchronization, dynamic switches, and the necessary Spring Boot, MyBatis‑Plus, and ShardingSphere configurations with code examples.

DataMigrationMySQLShardingSphere
0 likes · 22 min read
Database Sharding Design and Implementation for Loan & Repayment Tables Using ShardingSphere and Spring Boot
macrozheng
macrozheng
Nov 7, 2024 · Backend Development

9 Proven Techniques to Supercharge Pagination Query Performance

This article presents nine practical strategies—including adding default filters, limiting page size, reducing joins, optimizing indexes, using straight_join, archiving data, leveraging count(*), querying ClickHouse, and implementing read‑write splitting—to dramatically improve the speed and scalability of pagination APIs in MySQL‑based back‑ends.

ClickHouseMySQLSQL optimization
0 likes · 11 min read
9 Proven Techniques to Supercharge Pagination Query Performance
Tencent Cloud Developer
Tencent Cloud Developer
Nov 7, 2024 · Backend Development

Cache Consistency Strategies and Best Practices for the Cache‑Aside Pattern

The article explains cache‑aside consistency challenges and compares four update strategies—DB‑then‑cache, cache‑then‑DB, DB‑then‑delete, and delete‑then‑DB—showing that deleting the cache after a successful DB write offers the smallest inconsistency window, while recommending TTLs, message‑queue invalidation, and multi‑key coordination for robust eventual consistency.

MySQLcache consistencycache-aside
0 likes · 20 min read
Cache Consistency Strategies and Best Practices for the Cache‑Aside Pattern
Architect
Architect
Nov 6, 2024 · Databases

Storing IPv4 as Unsigned Int in MySQL: Benefits, Drawbacks & Code

Using an unsigned INT to store IPv4 addresses in MySQL saves space and enables efficient range queries, while strings are larger and slower; the article explains these advantages, outlines conversion functions INET_ATON/INET_NTOA, shows equivalent handling for IPv6, and provides Java utilities for bidirectional conversion.

Data StorageIPv4Java
0 likes · 6 min read
Storing IPv4 as Unsigned Int in MySQL: Benefits, Drawbacks & Code
Lobster Programming
Lobster Programming
Nov 6, 2024 · Cloud Native

Master Docker: From Basics to Running MySQL in Containers

This guide introduces Docker fundamentals, explains how containers differ from virtual machines, walks through installing Docker on Linux, and demonstrates practical steps to pull and run a MySQL container, while also providing a handy reference of common Docker commands for managing containers and images.

DevOpsDockerLinux
0 likes · 6 min read
Master Docker: From Basics to Running MySQL in Containers
Java Tech Enthusiast
Java Tech Enthusiast
Nov 6, 2024 · Backend Development

Java Interview Insights: Spring Boot Startup, Spring MVC Flow, MySQL Indexes, and Redis Performance

The article recounts a recent Hikvision interview, outlining campus salary ranges and providing a technical Q&A that explains Spring Boot’s startup sequence, Spring MVC request handling, MySQL index structures, creation rules, and performance diagnostics, as well as Redis’s in‑memory, single‑threaded architecture and optional I/O threading.

BackendJavaMySQL
0 likes · 20 min read
Java Interview Insights: Spring Boot Startup, Spring MVC Flow, MySQL Indexes, and Redis Performance
Code Ape Tech Column
Code Ape Tech Column
Nov 6, 2024 · Backend Development

Implementing a Snapchat-like Self-Destructing Image Feature with Spring Boot and MySQL

This article presents a step‑by‑step guide on building a Snapchat‑style “burn after reading” image sharing system using Spring Boot, MySQL, Thymeleaf, and optional cloud storage, covering background analysis, architecture design, environment setup, code implementation, optimization, testing, and deployment.

JavaMySQLSelf-Destructing Images
0 likes · 19 min read
Implementing a Snapchat-like Self-Destructing Image Feature with Spring Boot and MySQL
php Courses
php Courses
Nov 5, 2024 · Backend Development

Generating Visual Statistical Charts with PHP and ECharts

This article demonstrates how to use a PHP interface to retrieve data from a MySQL database and employ the ECharts library to create dynamic visual statistical charts, guiding developers through preparation, data extraction, and chart generation steps, including code examples for a bar chart.

Data VisualizationEChartsMySQL
0 likes · 7 min read
Generating Visual Statistical Charts with PHP and ECharts
macrozheng
macrozheng
Nov 5, 2024 · Backend Development

Mastering Global Unique ID Generation: 7 Proven Strategies for Distributed Systems

This article explores seven practical approaches to generating globally unique identifiers in distributed environments, covering database‑level configurations, MySQL auto‑increment tweaks, MyCat + Zookeeper integration, UUID limitations, Snowflake algorithm implementation, Meituan's Leaf service, Redis counters, and Zookeeper sequential nodes, providing code snippets and configuration guidance.

MySQLSnowflakeZooKeeper
0 likes · 18 min read
Mastering Global Unique ID Generation: 7 Proven Strategies for Distributed Systems