BestHub
Sign in
Tagged articles
2671 articles
Page 13 of 27
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Jul 4, 2022 · Databases

RedKV: Xiaohongshu's Distributed NoSQL KV Storage System

RedKV, Xiaohongshu’s self‑developed distributed NoSQL key‑value store, combines a Redis‑compatible interface, RocksDB‑backed storage, and a shard‑managed multi‑cloud architecture that delivers three‑times higher write throughput, 1.5‑times read throughput, 40 % cost savings versus HBase, and sub‑5 ms P999 latency for petabyte‑scale workloads.

Distributed KVLZ4 compressionNoSQL
0 likes · 25 min read
RedKV: Xiaohongshu's Distributed NoSQL KV Storage System
Sanyou's Java Diary
Sanyou's Java Diary
Jun 30, 2022 · Databases

Mastering Redis High Availability: Sharding, Consistent Hashing, and Sentinel Explained

This article explains Redis high‑availability strategies, covering basic hash sharding, the advantages of consistent hashing, client‑side versus proxy‑based partitioning, master‑slave replication, and the Sentinel failover mechanism, with diagrams illustrating node addition, removal, and failover decision processes.

consistent hashingdatabasehigh availability
0 likes · 10 min read
Mastering Redis High Availability: Sharding, Consistent Hashing, and Sentinel Explained
Tencent Cloud Developer
Tencent Cloud Developer
Jun 30, 2022 · Databases

Redis Overview: Architecture, Persistence, Replication, Sentinel, and Cluster

Redis is a single‑threaded, in‑memory data store offering rich structures, configurable expiration, multiple eviction policies, asynchronous master‑slave replication with Sentinel failover, durable RDB snapshots plus AOF logging, and native clustering that shards data across many masters for horizontal scalability and high availability.

CacheClusterPersistence
0 likes · 18 min read
Redis Overview: Architecture, Persistence, Replication, Sentinel, and Cluster
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 30, 2022 · Databases

Handling Replication Anomalies in MySQL Slave IO Thread

This article analyzes MySQL replication anomalies caused by master failures or network interruptions that lead to incomplete transaction replay on slaves, demonstrates a reproducible experiment using network delay and iptables, and provides practical guidance for both recovering and permanently handling stalled slave IO threads.

GTIDMySQLReplication
0 likes · 6 min read
Handling Replication Anomalies in MySQL Slave IO Thread
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 29, 2022 · Databases

Understanding Multi-Column Partition Tables in MySQL: Implementation, Performance Comparison, and Best Practices

This article explains MySQL's support for multi‑column partition tables, provides a stored‑procedure to create them, compares performance against single‑column partitions under various query conditions, discusses partition column order impact, and offers practical guidance for when and how to use multi‑column partitions.

Multi-ColumnMySQLPartitioning
0 likes · 10 min read
Understanding Multi-Column Partition Tables in MySQL: Implementation, Performance Comparison, and Best Practices
Open Source Linux
Open Source Linux
Jun 29, 2022 · Databases

Top MySQL Interview Questions & Answers Every DBA Should Know

This article compiles essential MySQL interview questions covering primary and candidate keys, date functions, trigger limits, index column counts, data copying techniques, core MySQL concepts, feature highlights, transaction ACID properties, heap versus clustered tables, numeric type differences, and objects creatable with CREATE statements.

Heap TableMySQLTriggers
0 likes · 9 min read
Top MySQL Interview Questions & Answers Every DBA Should Know
MaGe Linux Operations
MaGe Linux Operations
Jun 28, 2022 · Databases

How Indexes Can Speed Up MySQL Queries by 50,000×: A Deep Dive

This article walks through a MySQL scenario with large tables, demonstrates why a sub‑query that took over eight hours runs in just a second after adding appropriate single‑column and composite indexes, and explains how to read and interpret execution plans for further tuning.

Index OptimizationMySQLQuery Performance
0 likes · 11 min read
How Indexes Can Speed Up MySQL Queries by 50,000×: A Deep Dive
ITPUB
ITPUB
Jun 28, 2022 · Backend Development

Mastering Distributed Locks: Database, Redis, and Zookeeper Strategies

This article explains the design and implementation of distributed locks, covering database pessimistic and optimistic locks, various Redis lock patterns, Redisson and RedLock, as well as Zookeeper's lock mechanism, and compares their advantages, drawbacks, and suitable use cases.

BackendZooKeeperconcurrency
0 likes · 20 min read
Mastering Distributed Locks: Database, Redis, and Zookeeper Strategies
php Courses
php Courses
Jun 24, 2022 · Databases

Comprehensive List of MySQL Interview Questions

This article compiles 66 MySQL interview questions covering fundamentals such as joins, data types, indexes, storage engines, transaction properties, locking mechanisms, replication, sharding, performance tuning, and high‑availability concepts for interview preparation.

MySQLPerformanceReplication
0 likes · 3 min read
Comprehensive List of MySQL Interview Questions
Baidu Geek Talk
Baidu Geek Talk
Jun 22, 2022 · Databases

Analyzing Go SQL Connection Pool Resource Release and Transaction Management

The article explains how Go's database/sql pool retains connections until Rows, Stmt, or Tx objects are explicitly closed or a timeout context is cancelled, demonstrates experiments showing blocked goroutines when resources aren't released, and offers practical guidelines—using QueryContext with timeouts, deferring Close/Cancel, and always committing or rolling back transactions—to prevent pool exhaustion and improve MySQL reliability.

Connection PoolGodatabase
0 likes · 19 min read
Analyzing Go SQL Connection Pool Resource Release and Transaction Management
Top Architect
Top Architect
Jun 22, 2022 · Databases

Understanding SELECT ... FOR UPDATE Locking in MySQL: Row vs. Table Locks

This article explains how the SELECT ... FOR UPDATE statement in MySQL adds a pessimistic lock, describes when it results in a row lock versus a table lock based on index usage, provides verification SQL, example scenarios, and practical tips for transaction handling.

MySQLSELECT FOR UPDATEdatabase
0 likes · 5 min read
Understanding SELECT ... FOR UPDATE Locking in MySQL: Row vs. Table Locks
Top Architect
Top Architect
Jun 14, 2022 · Databases

Understanding MySQL Execution Process: Connectors, Cache, Parser, Optimizer, and Executor

This article explains MySQL's internal execution process—including the connector, cache, parser, optimizer, and executor—describes privilege tables and verification, discusses query caching removal, outlines logical SQL execution order, and provides practical tips for ordering WHERE conditions to improve performance.

Database InternalsMySQLPerformance Tuning
0 likes · 12 min read
Understanding MySQL Execution Process: Connectors, Cache, Parser, Optimizer, and Executor
Top Architect
Top Architect
Jun 13, 2022 · Databases

Comprehensive MySQL Performance Optimization Guide

This article provides a detailed guide on optimizing MySQL performance, covering SQL statement tuning, index usage, table design normalization, system configuration, hardware choices, and the internal architecture of MySQL to help developers write faster and more efficient queries.

MySQLPerformance Tuningdatabase
0 likes · 19 min read
Comprehensive MySQL Performance Optimization Guide
Top Architect
Top Architect
Jun 12, 2022 · Databases

Best Practices for Using Alibaba Cloud Redis: Key Design, Command Usage, Client Configuration, and Tooling

This article outlines comprehensive guidelines for Alibaba Cloud Redis, covering readable and concise key naming, value size limits, appropriate data types, key lifecycle management, safe command usage, client connection pooling, encryption, eviction policies, and tools for synchronization, big‑key detection, and efficient deletion.

Alibaba CloudCommand OptimizationKey Design
0 likes · 8 min read
Best Practices for Using Alibaba Cloud Redis: Key Design, Command Usage, Client Configuration, and Tooling
Qunar Tech Salon
Qunar Tech Salon
Jun 8, 2022 · Backend Development

Design and Implementation of a Systematic Cache Architecture for High‑Performance Business Systems

This article describes how a multi‑layered cache system—including a DAO‑level Redis cache, shared cache components, and global cache planning—was designed, implemented, and deployed to reduce database QPS by over 80%, cut response latency, and improve overall system stability in a high‑traffic e‑commerce platform.

Performancecachingdatabase
0 likes · 30 min read
Design and Implementation of a Systematic Cache Architecture for High‑Performance Business Systems
Tencent Cloud Developer
Tencent Cloud Developer
Jun 7, 2022 · Databases

Mastering MongoDB: From Basics to Advanced Performance Tuning

This comprehensive guide explores MongoDB’s core features—including schema flexibility, high availability, sharding, storage engine internals, indexing, and performance tuning—while providing practical examples, configuration tips, and best‑practice recommendations for developers and architects seeking to efficiently deploy and operate MongoDB in production environments.

MongoDBPerformanceReplication
0 likes · 40 min read
Mastering MongoDB: From Basics to Advanced Performance Tuning
政采云技术
政采云技术
Jun 7, 2022 · Databases

Understanding MySQL Auto‑Increment Locks and Their Behaviors

This article explains the concept of MySQL auto‑increment locks, describes different insertion methods and lock modes, analyzes how InnoDB allocates and manages auto‑increment IDs—including simple, bulk, and mixed inserts—and provides source‑code insights, practical experiments, and mitigation strategies for ID continuity issues.

InnoDBMySQLauto_increment
0 likes · 21 min read
Understanding MySQL Auto‑Increment Locks and Their Behaviors
MaGe Linux Operations
MaGe Linux Operations
Jun 6, 2022 · Databases

What Is a Schema? From Databases to Kubernetes Explained

This article explains the concept of a schema—from its Greek origins and psychological meaning to its role as metadata in databases and Kubernetes—detailing different database schema models, Kubernetes resource definitions, and how to extend and register custom schemas in Go.

GolangYAMLdatabase
0 likes · 8 min read
What Is a Schema? From Databases to Kubernetes Explained
dbaplus Community
dbaplus Community
Jun 5, 2022 · Databases

Detecting and Resolving Redis Performance Bottlenecks

This guide explains how to identify when Redis is slow, measure baseline latency, monitor slow commands and latency, troubleshoot network, fork, huge pages, swap, AOF, expiration, and big keys, and provides a practical checklist of solutions.

databaseredistroubleshooting
0 likes · 18 min read
Detecting and Resolving Redis Performance Bottlenecks
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 2, 2022 · Operations

Common Operational, Data, and SQL Issues in Apache Doris – FAQs and Solutions

This article compiles frequently asked questions and detailed solutions covering Apache Doris operational problems, data handling errors, and SQL query issues, providing step‑by‑step guidance, configuration tips, and command examples to help administrators troubleshoot and maintain a stable Doris cluster.

Apache DorisOperationsconfiguration
0 likes · 28 min read
Common Operational, Data, and SQL Issues in Apache Doris – FAQs and Solutions
Architecture Digest
Architecture Digest
May 30, 2022 · Backend Development

Comprehensive Guide to Activiti 7 Workflow Engine: Concepts, Setup, Deployment, and Usage

This article provides an in‑depth tutorial on Activiti 7 workflow management, covering workflow concepts, system architecture, BPMN modeling, environment setup, Maven dependencies, database configuration, deployment methods, process execution, task handling, and historical data retrieval for Java backend development.

ActivitiBPMNWorkflow
0 likes · 43 min read
Comprehensive Guide to Activiti 7 Workflow Engine: Concepts, Setup, Deployment, and Usage
dbaplus Community
dbaplus Community
May 26, 2022 · Databases

How Meituan Built a Scalable Autonomous Database System to Slash MTTR

This article details Meituan's journey from rapid database growth and operational bottlenecks to a multi‑year roadmap that combines platform‑level monitoring, rule‑based and AI‑enhanced root‑cause analysis, and automated remediation, ultimately delivering measurable improvements in alert accuracy, recall rates, and overall database reliability.

AIAutomationPerformance
0 likes · 19 min read
How Meituan Built a Scalable Autonomous Database System to Slash MTTR
Top Architect
Top Architect
May 25, 2022 · Databases

Understanding MySQL Execution Process and SQL Execution Order

This article provides a comprehensive overview of MySQL's internal execution flow—from client connection handling, permission verification, caching, parsing, optimization, and execution—to the detailed SQL execution order, helping readers grasp how queries are processed and optimized within the database engine.

Execution ProcessMySQLQuery Execution
0 likes · 12 min read
Understanding MySQL Execution Process and SQL Execution Order
Code Ape Tech Column
Code Ape Tech Column
May 24, 2022 · Databases

Understanding MVCC (Multi-Version Concurrency Control) in MySQL InnoDB

This article provides a comprehensive, step‑by‑step explanation of MySQL InnoDB's MVCC mechanism, covering its fundamentals, the role of Undo Log and Read View, and how it enables repeatable‑read and read‑committed isolation levels while preventing dirty reads and other concurrency anomalies.

MVCCMySQLconcurrency
0 likes · 12 min read
Understanding MVCC (Multi-Version Concurrency Control) in MySQL InnoDB
Java Tech Enthusiast
Java Tech Enthusiast
May 23, 2022 · Backend Development

Implementing a Simple Java ORM Framework from Scratch

The article walks through building a lightweight Java ORM framework from scratch, showing JDBC drawbacks, defining XML configuration and mapper files, implementing core components like SqlSessionFactory, SimpleExecutor, and reflection‑based parameter and result mapping, and demonstrating a working test that returns POJOs.

FrameworkJDBCORM
0 likes · 12 min read
Implementing a Simple Java ORM Framework from Scratch
IT Architects Alliance
IT Architects Alliance
May 17, 2022 · Databases

Inside MySQL: How Queries Are Processed from Client to Execution

This article explains the complete MySQL query processing pipeline, covering the connector, authentication, privilege checks, caching, parser, optimizer, executor, and the detailed SQL execution order with examples of each stage, helping readers understand and optimize their SQL statements.

MySQLPerformanceQuery Execution
0 likes · 13 min read
Inside MySQL: How Queries Are Processed from Client to Execution
dbaplus Community
dbaplus Community
May 16, 2022 · Databases

Master MySQL 8.0.28: Install, Configure, and Connect via JDBC

This guide walks beginners through downloading, installing, and configuring MySQL 8.0.28 on Windows and Linux, covering environment variables, service management, password recovery, user and role creation, and JDBC connection setup with Maven, providing detailed commands, code snippets, and troubleshooting tips for a complete setup.

InstallationJDBCLinux
0 likes · 29 min read
Master MySQL 8.0.28: Install, Configure, and Connect via JDBC
Python Programming Learning Circle
Python Programming Learning Circle
May 16, 2022 · Backend Development

Using SQLAlchemy ORM in Python: Design, Initialization, Model Mapping, and Session Management

This article explains how to replace raw PyMySQL usage with SQLAlchemy ORM in Python, covering environment setup, database connection initialization, MVC‑style project structure, model class definitions, field attributes, session handling with context managers, and practical code examples for saving and querying data.

BackendMySQLORM
0 likes · 9 min read
Using SQLAlchemy ORM in Python: Design, Initialization, Model Mapping, and Session Management
Su San Talks Tech
Su San Talks Tech
May 12, 2022 · Databases

Why MySQL Indexes Matter: From Pages to B+ Trees Explained

This article walks through MySQL's InnoDB storage engine, explaining how pages, locality, skip‑list concepts and B+‑tree structures work together to make indexes efficient, and shows how clustered, non‑clustered and covering indexes affect query performance and I/O behavior.

B+TreeInnoDBMySQL
0 likes · 18 min read
Why MySQL Indexes Matter: From Pages to B+ Trees Explained
ITPUB
ITPUB
May 12, 2022 · Databases

Build a Tiny Shell‑Based Database in Two Commands – How It Works

This article demonstrates how a functional, persistent key‑value store can be created with just two shell commands—one to append data and another to retrieve the latest entry—while explaining the underlying grep and sed techniques, performance trade‑offs, and basic indexing concepts.

GrepPerformanceShell
0 likes · 5 min read
Build a Tiny Shell‑Based Database in Two Commands – How It Works
Code Ape Tech Column
Code Ape Tech Column
May 12, 2022 · Databases

Thirteen Rules for Optimizing Redis Performance

This article outlines thirteen practical Redis performance‑optimization rules, covering command complexity, key expiration, data‑structure selection, persistence settings, hardware choices, clustering, and memory‑fragmentation monitoring to help developers maximize throughput and reduce latency in production environments.

BackendMemory ManagementPerformance
0 likes · 12 min read
Thirteen Rules for Optimizing Redis Performance
Sohu Tech Products
Sohu Tech Products
May 11, 2022 · Backend Development

Optimizing Large-Scale Database Updates with Manual Transactions and Multithreading in Spring Boot MyBatis

This article demonstrates how to efficiently update up to 50,000 MySQL records in a Spring Boot‑MyBatis application by comparing simple loops, manual transaction control, multithreaded execution with CountDownLatch coordination, and union‑based batch updates, while analyzing performance and connection‑pool considerations.

databasemultithreadingmybatis
0 likes · 14 min read
Optimizing Large-Scale Database Updates with Manual Transactions and Multithreading in Spring Boot MyBatis
Code Ape Tech Column
Code Ape Tech Column
May 7, 2022 · Information Security

SQL Injection Attack Demonstration and Prevention in a Java Spring Application

This article explains how SQL injection can exploit a Java Spring course‑selection system by concatenating user input into SQL statements, demonstrates various injection techniques such as always‑true conditions and UNION queries, and provides multiple defensive measures including prepared statements, type checking, permission restrictions, and request‑parameter filtering.

SQL injectiondatabasejava
0 likes · 5 min read
SQL Injection Attack Demonstration and Prevention in a Java Spring Application
Code Ape Tech Column
Code Ape Tech Column
May 5, 2022 · Backend Development

Optimizing Bulk Database Updates with Manual Transactions and Multithreading in Spring/MyBatis

This article demonstrates how to dramatically speed up updating tens of thousands of records in a Spring‑MyBatis application by switching from automatic per‑operation commits to manual transaction control, applying multithreaded processing, tuning the Hikari connection pool, and using SQL UNION‑based batch updates.

databasemultithreadingmybatis
0 likes · 13 min read
Optimizing Bulk Database Updates with Manual Transactions and Multithreading in Spring/MyBatis
Top Architect
Top Architect
May 3, 2022 · Databases

ShardingSphere-JDBC Overview, MySQL Master‑Slave Replication Setup, Binlog & Redo Log Review, and Sharding‑JDBC Read/Write Splitting & Sharding Implementation

This article provides a comprehensive tutorial on using ShardingSphere‑JDBC, configuring MySQL master‑slave replication with Docker, explaining binlog and redo‑log mechanisms, demonstrating two‑phase commit, and detailing Sharding‑JDBC read/write splitting and sharding configurations with code examples.

JDBCMySQLShardingSphere
0 likes · 23 min read
ShardingSphere-JDBC Overview, MySQL Master‑Slave Replication Setup, Binlog & Redo Log Review, and Sharding‑JDBC Read/Write Splitting & Sharding Implementation
Architects' Tech Alliance
Architects' Tech Alliance
May 3, 2022 · Industry Insights

What Do China’s 2022 DB‑Engines Rankings Reveal About Database Trends?

The February 2022 DB‑Engines ranking shows Snowflake’s rapid rise, a sharp decline for Oracle, MySQL and Microsoft SQL Server, stable positions for Elasticsearch, and detailed score trends across relational, key‑value, document, time‑series and graph databases, highlighting five popularity metrics used for the assessment.

ChinaDB-EnginesDocument
0 likes · 4 min read
What Do China’s 2022 DB‑Engines Rankings Reveal About Database Trends?
Su San Talks Tech
Su San Talks Tech
Apr 28, 2022 · Databases

Why MySQL Chooses B+ Trees Over Skip Lists for Indexing

This article explains the structures of B+ trees and skip lists, compares their insertion and search behaviors, and shows why MySQL prefers B+ trees for disk‑based indexing while Redis adopts skip lists for in‑memory operations.

B+TreeMySQLdatabase
0 likes · 12 min read
Why MySQL Chooses B+ Trees Over Skip Lists for Indexing
IT Services Circle
IT Services Circle
Apr 26, 2022 · Databases

How to Install, Integrate, and Use Redis with Spring Boot

This article introduces Redis, explains how to install it on various platforms, demonstrates integrating Redis with Spring Boot using Spring Cache annotations, configures connection pools for Lettuce and Jedis, and provides custom Redis service implementations for flexible cache operations.

Spring Cachecachingdatabase
0 likes · 14 min read
How to Install, Integrate, and Use Redis with Spring Boot
政采云技术
政采云技术
Apr 26, 2022 · Databases

Analysis of Lock Wait Timeout and Gap Locks in InnoDB

This article analyzes a MySQL InnoDB lock wait timeout error, explains how gap locks cause blocked inserts and phantom reads under repeatable‑read isolation, and offers optimization strategies such as primary‑key deletions, while concluding with a recruitment invitation for the Zero technology team.

Gap LockInnoDBMySQL
0 likes · 7 min read
Analysis of Lock Wait Timeout and Gap Locks in InnoDB
Tencent Cloud Developer
Tencent Cloud Developer
Apr 25, 2022 · Databases

Implementing a Simple SQLite‑like Database in Go

The article walks through building a minimal SQLite‑style database in Go, covering memory‑disk page storage, B‑tree indexing, simple SQL parsing for INSERT and SELECT, row serialization, a pager that flushes pages, and a basic REPL, while highlighting current single‑page limits and future extensions.

B+TreeGoSQLite
0 likes · 12 min read
Implementing a Simple SQLite‑like Database in Go
Selected Java Interview Questions
Selected Java Interview Questions
Apr 25, 2022 · Databases

MySQL SQL and Index Optimization Techniques

This article provides a comprehensive guide to optimizing MySQL queries and indexes, covering best practices such as avoiding subqueries, using IN instead of OR, proper LIMIT usage, eliminating unnecessary ORDER BY, leveraging UNION ALL, batch inserts, selective column retrieval, distinguishing IN and EXISTS, improving GROUP BY, using numeric fields, optimizing JOINs, and applying index rules like left‑most prefix, avoiding functions on indexed columns, handling type conversions, covering indexes, and effective use of composite and prefix indexes.

SQL optimizationdatabaseindexing
0 likes · 19 min read
MySQL SQL and Index Optimization Techniques
YunZhu Net Technology Team
YunZhu Net Technology Team
Apr 21, 2022 · Databases

Common MySQL Query Pitfalls and How to Avoid Them

This article outlines several frequent MySQL query pitfalls—including missing table aliases in multi‑table operations, unsupported FULL JOIN syntax, unexpected REPLACE INTO side effects, auto‑increment edge cases, data‑type mismatches, nondeterministic functions, and warning‑driven query behavior—providing examples and best‑practice recommendations to prevent data loss and performance issues.

BestPracticesDataIntegrityMySQL
0 likes · 14 min read
Common MySQL Query Pitfalls and How to Avoid Them
DataFunTalk
DataFunTalk
Apr 20, 2022 · Databases

Apache Doris 1.0 Release: New Vectorized Engine, Hive External Tables, Z‑Order Indexing and More

Apache Doris (incubating) announced its 1.0 release on April 18, 2022, featuring a new vectorized execution engine, Hive external tables, Lateral View syntax, Z‑Order indexing, SeaTunnel integration, numerous performance optimizations, new bitmap functions, security enhancements, and detailed upgrade instructions for users.

Apache DorisHive External TablePerformance
0 likes · 10 min read
Apache Doris 1.0 Release: New Vectorized Engine, Hive External Tables, Z‑Order Indexing and More
Java Backend Technology
Java Backend Technology
Apr 20, 2022 · Backend Development

How to Implement Efficient MyBatis Streaming Queries in Spring MVC

This article explains the concept of streaming queries, introduces MyBatis's Cursor interface with its key methods, and provides three practical solutions—using SqlSessionFactory, TransactionTemplate, or @Transactional—to keep database connections open and avoid cursor‑closed errors in Spring MVC applications.

CursorSpring MVCStreaming Query
0 likes · 7 min read
How to Implement Efficient MyBatis Streaming Queries in Spring MVC
IT Services Circle
IT Services Circle
Apr 19, 2022 · Databases

Why MySQL Uses B+ Trees for Indexes Instead of Skip Lists

This article explains the structures of B+ trees and skip lists, compares their read and write performance, and details why MySQL chooses B+ trees for indexing while Redis and RocksDB prefer skip lists, highlighting trade‑offs in disk I/O, fan‑out, and balancing overhead.

B+TreeMySQLdatabase
0 likes · 13 min read
Why MySQL Uses B+ Trees for Indexes Instead of Skip Lists
Open Source Linux
Open Source Linux
Apr 19, 2022 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Faster Queries

This article examines frequent SQL anti‑patterns—such as inefficient LIMIT usage, implicit type conversion, suboptimal UPDATE/DELETE joins, mixed ordering, unnecessary EXISTS clauses, condition push‑down failures, early limiting, and intermediate result handling—and provides rewritten queries that dramatically improve performance.

MySQLQuery Tuningdatabase
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Faster Queries
The Dominant Programmer
The Dominant Programmer
Apr 18, 2022 · Databases

How to Install PostgreSQL 14 on CentOS Using a Script

This guide walks through installing PostgreSQL 14 on a CentOS server via a shell script, covering repository setup, package installation, initialization, user and database creation, remote‑connection configuration, firewall adjustments, service verification, and connecting with Navicat.

CentOSInstallationRemote access
0 likes · 4 min read
How to Install PostgreSQL 14 on CentOS Using a Script
Java Backend Technology
Java Backend Technology
Apr 16, 2022 · Backend Development

Why @Transactional Sometimes Fails in Spring and How to Fix It

This article explains three common situations where Spring's @Transactional annotation becomes ineffective—non‑public methods, internal self‑calls, and swallowed exceptions—detailing the underlying proxy mechanism, code examples, test results, and practical workarounds to ensure proper transaction management.

Exception Handlingaopdatabase
0 likes · 12 min read
Why @Transactional Sometimes Fails in Spring and How to Fix It
Architect
Architect
Apr 14, 2022 · Backend Development

Understanding Idempotent Design: Concepts, Scenarios, and Eight Practical Implementation Strategies

This article explains the mathematical and computer‑science definition of idempotency, why it is essential for reliable distributed services, how to handle timeout scenarios, and presents eight concrete design patterns—including unique IDs, database constraints, token mechanisms, optimistic/pessimistic locks, and distributed locks—along with code examples and HTTP method analysis.

Distributed SystemsHTTPbackend-development
0 likes · 18 min read
Understanding Idempotent Design: Concepts, Scenarios, and Eight Practical Implementation Strategies
Cloud Native Technology Community
Cloud Native Technology Community
Apr 13, 2022 · Big Data

Introduction to ClickHouse: Features, Architecture, Installation, Data Types, and Cluster Deployment

This article provides a comprehensive overview of ClickHouse, an open‑source column‑oriented MPP analytical database, covering its advantages and drawbacks, key features, typical use cases, data access flow, installation steps, core directories, indexes, data types, database and table engines, as well as detailed cluster architecture and deployment patterns.

Big DataClickHouseCluster
0 likes · 29 min read
Introduction to ClickHouse: Features, Architecture, Installation, Data Types, and Cluster Deployment
Top Architect
Top Architect
Apr 11, 2022 · Databases

Why Using UUID as MySQL Primary Key Is Inefficient: A Performance Comparison with Auto‑Increment and Random Keys

This article investigates MySQL's recommendation against UUID primary keys by creating three tables—auto‑increment, UUID, and random (snowflake) keys—running insert and query benchmarks with SpringBoot/JdbcTemplate, analyzing index structures, and discussing the performance trade‑offs and security considerations of each key strategy.

MySQLPerformanceauto_increment
0 likes · 11 min read
Why Using UUID as MySQL Primary Key Is Inefficient: A Performance Comparison with Auto‑Increment and Random Keys
Selected Java Interview Questions
Selected Java Interview Questions
Apr 9, 2022 · Databases

Comprehensive SQL Basics, Interview Questions, and Advanced Query Techniques

This article provides a thorough guide to SQL fundamentals—including SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, aggregate functions, joins, set operations, and Oracle-specific objects—followed by a collection of common interview questions with detailed solutions, top‑N queries, and row‑to‑column transformations, while also containing promotional notes for related resources.

JoinsOracleaggregation
0 likes · 25 min read
Comprehensive SQL Basics, Interview Questions, and Advanced Query Techniques
Top Architect
Top Architect
Apr 9, 2022 · Databases

Applying the Nested Set Model for Hierarchical Department Queries in MySQL

This article explains how to use the nested set (left‑right) model to efficiently query, count, and manipulate hierarchical department data in MySQL, providing SQL examples for retrieving descendants, ancestors, leaf detection, as well as insert, delete, and JavaScript tree‑building techniques.

MySQLNested Set ModelTree Structure
0 likes · 11 min read
Applying the Nested Set Model for Hierarchical Department Queries in MySQL
Architect's Tech Stack
Architect's Tech Stack
Apr 8, 2022 · Databases

Comprehensive Guide to MySQL Query Optimization and Common Pitfalls

This article explains why SQL performance degrades as data grows, outlines a step‑by‑step optimization workflow—including slow‑query detection, EXPLAIN analysis, profiling, optimizer tracing, and corrective actions—while detailing type and extra fields, index usage, and practical scenarios such as large pagination, IN‑order‑by, range queries, and complex joins.

MySQLPerformancedatabase
0 likes · 10 min read
Comprehensive Guide to MySQL Query Optimization and Common Pitfalls
Laravel Tech Community
Laravel Tech Community
Apr 7, 2022 · Databases

Redis 7.0-rc3 Release Notes: New Features, Breaking Changes, Performance Improvements, CLI Updates, and Bug Fixes

Redis 7.0-rc3 introduces new cluster commands, configuration ordering changes, ACL restrictions, function load adjustments, performance optimizations, enhanced CLI behavior, expanded INFO fields, module API extensions, and a comprehensive set of bug fixes, providing developers with important updates and potential migration considerations.

BugFixesCLIPerformance
0 likes · 4 min read
Redis 7.0-rc3 Release Notes: New Features, Breaking Changes, Performance Improvements, CLI Updates, and Bug Fixes
HomeTech
HomeTech
Apr 6, 2022 · Databases

MySQL High Availability Architecture and Practices at AutoHome

This article explains MySQL high‑availability concepts, defines HA, RPO and RTO, outlines common HA architectures such as master‑slave+VIP, MHA and MGR+Proxy, and details AutoHome's evolution from simple master‑slave setups to a container‑based MGR solution with automated failover and monitoring platforms.

KubernetesMGRMHA
0 likes · 11 min read
MySQL High Availability Architecture and Practices at AutoHome
Architects' Tech Alliance
Architects' Tech Alliance
Apr 2, 2022 · Industry Insights

How Financial Institutions Secure Database Continuity: Disaster Recovery Strategies & Market Trends

This article examines the critical role of databases in finance, defines disaster recovery and backup concepts, outlines industry requirements and regulations, analyzes market growth, and compares distributed database disaster‑recovery architectures such as single‑center, city‑level mutual backup, active‑active, and two‑site three‑center solutions.

BackupDistributed SystemsFinancial Services
0 likes · 15 min read
How Financial Institutions Secure Database Continuity: Disaster Recovery Strategies & Market Trends
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 28, 2022 · Databases

Testing Safe vs. Forceful MySQL Shutdown in a Semi‑Synchronous Replication Setup

This article presents a detailed experiment comparing graceful and kill‑9 shutdown methods on a MySQL 5.7 semi‑synchronous master‑slave cluster, analyzes their impact on data consistency, and outlines the official shutdown sequence with practical observations and recommendations for production environments.

MySQLReplicationSemi‑Sync
0 likes · 12 min read
Testing Safe vs. Forceful MySQL Shutdown in a Semi‑Synchronous Replication Setup
Xiaolei Talks DB
Xiaolei Talks DB
Mar 26, 2022 · Databases

Why TiDB’s GC Stalled and How to Fix Disk Space Alarms

This article walks through a real‑world TiDB/TiKV disk‑space alarm case, diagnosing why the GC worker got stuck, how TiCDC’s lingering changefeed caused outdated MVCC versions, and the step‑by‑step commands and monitoring tricks used to restore normal GC and reclaim storage.

TiCDCTiDBTiKV
0 likes · 15 min read
Why TiDB’s GC Stalled and How to Fix Disk Space Alarms
Java Interview Crash Guide
Java Interview Crash Guide
Mar 25, 2022 · Databases

Master MySQL Performance: Proven Steps to Optimize Slow Queries

Learn how to identify and fix slow MySQL queries by analyzing slow‑query logs, using EXPLAIN, profiling, and optimizer trace, understanding index types and extra flags, and applying practical case‑by‑case optimizations such as index tuning, query rewriting, pagination strategies, and handling large data sets.

Index TuningMySQLdatabase
0 likes · 11 min read
Master MySQL Performance: Proven Steps to Optimize Slow Queries
NetEase LeiHuo UX Big Data Technology
NetEase LeiHuo UX Big Data Technology
Mar 23, 2022 · Databases

Overview of Database Architecture, Storage Engines, and Data Layouts

This article explains the core components of database systems, including their client‑server architecture, query processing, storage engine modules, classification by storage media (memory vs. disk), and the differences between row‑oriented and column‑oriented data layouts, concluding with future topics to explore.

Column LayoutRow LayoutStorage Engine
0 likes · 8 min read
Overview of Database Architecture, Storage Engines, and Data Layouts
DeWu Technology
DeWu Technology
Mar 23, 2022 · Databases

Introduction to ORM and Peewee Usage in Python

The article explains how ORM bridges Python objects and relational databases, compares options, and justifies choosing the lightweight Peewee library, then details its workflow—model generation, inserting, updating, deleting, and querying records—showcasing how this approach reduces manual data‑creation time from hours to seconds.

DjangoORMPeewee
0 likes · 9 min read
Introduction to ORM and Peewee Usage in Python
Architects' Tech Alliance
Architects' Tech Alliance
Mar 22, 2022 · Databases

Western Sanctions on Russia Accelerate China's Drive for Indigenous Core Software and Highlight the Challenges of Replacing Oracle

The article analyzes how comprehensive Western sanctions against Russia are prompting China to accelerate self‑reliance in foundational software, examines Oracle's pivotal role in Chinese enterprises, and discusses the strategic, technical, and market obstacles to achieving a successful "de‑IOE" transition.

ChinaIOEOracle
0 likes · 12 min read
Western Sanctions on Russia Accelerate China's Drive for Indigenous Core Software and Highlight the Challenges of Replacing Oracle
Architects' Tech Alliance
Architects' Tech Alliance
Mar 21, 2022 · Databases

Oracle Real Application Cluster (RAC) Architecture, Components, Storage Options and Management

The article provides a comprehensive overview of Oracle Real Application Cluster (RAC), detailing its two‑part architecture of Clusterware and RAC instances, shared storage configurations, key Clusterware processes, storage options, benefits such as load balancing and high availability, as well as its management and planning considerations.

ClusterwareOracleRAC
0 likes · 13 min read
Oracle Real Application Cluster (RAC) Architecture, Components, Storage Options and Management
Java Interview Crash Guide
Java Interview Crash Guide
Mar 18, 2022 · Databases

Mastering MyBatis Streaming Queries: Keep Connections Open and Avoid Cursor Errors

Streaming queries return an iterator instead of a full result set, reducing memory usage, but require the database connection to stay open; this guide explains MyBatis’s Cursor interface, its methods, common pitfalls like premature closure, and three practical solutions using SqlSessionFactory, TransactionTemplate, or @Transactional to ensure reliable streaming.

CursorStreaming Queriesdatabase
0 likes · 6 min read
Mastering MyBatis Streaming Queries: Keep Connections Open and Avoid Cursor Errors
Code Ape Tech Column
Code Ape Tech Column
Mar 17, 2022 · Databases

Understanding the Druid Connection Pool Lifecycle and Management

This article provides a comprehensive walkthrough of Druid's connection pool lifecycle, detailing how getConnection initiates the process, the role of initialization, filter chains, connection validation, thread‑blocking strategies, and the various guardian threads that add, evict, and recycle connections to ensure performance and stability.

Connection PoolDruiddatabase
0 likes · 24 min read
Understanding the Druid Connection Pool Lifecycle and Management
Java High-Performance Architecture
Java High-Performance Architecture
Mar 17, 2022 · Backend Development

Mastering MyBatis Streaming Queries: Reduce Memory Usage and Avoid Cursor Closure Errors

This article explains what streaming queries are, why they save memory compared to pagination, details the MyBatis Cursor interface and its methods, demonstrates how to implement streaming queries with code examples, and presents three solutions—using SqlSessionFactory, TransactionTemplate, and @Transactional—to keep the database connection open and prevent cursor‑closed errors.

CursorStreaming Querydatabase
0 likes · 7 min read
Mastering MyBatis Streaming Queries: Reduce Memory Usage and Avoid Cursor Closure Errors
政采云技术
政采云技术
Mar 17, 2022 · Databases

InnoDB Lock System: Types, Modes, Structures, and Compatibility

This article explains InnoDB's lock system in MySQL, covering lock granularity, intent, shared, exclusive and auto‑increment locks, row‑lock types, the underlying C++ structures, lock mode and type encoding, and the compatibility and strength matrices that govern lock acquisition and waiting.

InnoDBMySQLc++
0 likes · 13 min read
InnoDB Lock System: Types, Modes, Structures, and Compatibility
Programmer DD
Programmer DD
Mar 16, 2022 · Backend Development

Implement Custom Annotation Logging with Spring AOP

This guide explains how to create a custom annotation and an Aspect in Spring to capture detailed operation logs—including description, table name, parameters, user info, and execution result—and persist them to a database, covering AOP terminology, configuration styles, and complete code examples.

Custom Annotationaspectjdatabase
0 likes · 15 min read
Implement Custom Annotation Logging with Spring AOP
Cloud Native Technology Community
Cloud Native Technology Community
Mar 15, 2022 · Databases

How to Build a High‑Availability MySQL PXC Cluster: Installation & Features

This guide explains the Percona XtraDB Cluster (PXC) architecture, its advantages and limitations, and provides step‑by‑step commands for removing MariaDB, opening firewall ports, disabling SELinux, downloading packages, configuring MySQL, bootstrapping the first node, adding additional nodes, and verifying the cluster status.

ClusterInstallationMySQL
0 likes · 8 min read
How to Build a High‑Availability MySQL PXC Cluster: Installation & Features