Tagged articles
2671 articles
Page 11 of 27
Su San Talks Tech
Su San Talks Tech
Mar 10, 2023 · Backend Development

Why Did Our Java Service Crash with OOM? A Deep Dive into Root Causes and Fixes

An online service experienced severe latency due to massive GAP times, leading to repeated OutOfMemoryErrors; by analyzing monitoring data, JVM dumps, and SQL queries, the team uncovered a massive userId array causing a 1 GB count query, then implemented request limits and JVM flags to prevent recurrence.

BackendJVMOutOfMemoryError
0 likes · 8 min read
Why Did Our Java Service Crash with OOM? A Deep Dive into Root Causes and Fixes
Laravel Tech Community
Laravel Tech Community
Mar 9, 2023 · Databases

Understanding Redis Persistence: AOF and RDB Mechanisms

This article explains how Redis ensures data durability by using two persistence strategies—Append Only File (AOF) and Redis Database (RDB) snapshots—detailing their operation, configuration options, trade‑offs, rewrite processes, and how they handle expired keys and recovery.

AOFData RecoveryPersistence
0 likes · 13 min read
Understanding Redis Persistence: AOF and RDB Mechanisms
Java Architect Essentials
Java Architect Essentials
Mar 7, 2023 · Databases

16 Common Redis Application Scenarios with Code Examples

This article presents sixteen typical Redis use cases—including caching, distributed locks, global IDs, counters, rate limiting, bitmaps, shopping carts, timelines, message queues, lotteries, likes, product tags, filtering, follow relationships, and ranking—each explained with practical code snippets and command examples.

CacheDistributedLockcode
0 likes · 9 min read
16 Common Redis Application Scenarios with Code Examples
Laravel Tech Community
Laravel Tech Community
Mar 6, 2023 · Databases

SQL Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, and Other Performance Tips

This article presents a comprehensive set of MySQL performance guidelines, including avoiding SELECT *, preferring specific columns, eliminating OR in WHERE clauses, using numeric types, choosing VARCHAR over CHAR, applying proper JOINs, leveraging LIMIT, UNION ALL, composite indexes, and other practical tips to improve query efficiency and resource usage.

MySQLPerformancedatabase
0 likes · 17 min read
SQL Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, and Other Performance Tips
Sanyou's Java Diary
Sanyou's Java Diary
Mar 6, 2023 · Databases

15 Common MySQL Index Pitfalls and How to Avoid Them

This article compiles fifteen typical scenarios where MySQL indexes become ineffective—covering composite index left‑most matching, SELECT *, arithmetic on indexed columns, functions, LIKE patterns, type conversion, OR/AND logic, range queries, ORDER BY, and optimizer decisions—providing example SQL, EXPLAIN output, and practical tips to help developers prevent costly full‑table scans.

MySQLPerformancedatabase
0 likes · 24 min read
15 Common MySQL Index Pitfalls and How to Avoid Them
MaGe Linux Operations
MaGe Linux Operations
Mar 4, 2023 · Databases

Why Docker Struggles with MySQL: 7 Critical Reasons

This article examines why running MySQL in Docker containers often leads to data‑security risks, performance bottlenecks, state management issues, and resource‑isolation problems, while also outlining scenarios where containerization can still be viable and offering practical mitigation strategies.

ContainerizationDockerPerformance
0 likes · 7 min read
Why Docker Struggles with MySQL: 7 Critical Reasons
Tencent Database Technology
Tencent Database Technology
Feb 28, 2023 · Databases

Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)

This article explains how InnoDB uses undo segment states for crash‑safe recovery, details the XA transaction protocol, describes bugs in earlier MySQL versions, and shows how MySQL 8.0.30 introduces a new undo state and revised prepare order to make external XA transactions crash‑safe, including code examples and recovery steps.

InnoDBMySQLXA Transaction
0 likes · 11 min read
Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)
ITPUB
ITPUB
Feb 26, 2023 · Databases

Why InnoDB Stores Primary Keys in Secondary Index Leaves – A Deep Dive

This article explains InnoDB’s clustered and secondary index structures, why secondary index leaf nodes store primary key values, how lookups trigger “row‑lookup” (回表) operations, and how covering indexes can eliminate those extra scans, illustrated with MySQL examples.

Clustered IndexInnoDBMySQL
0 likes · 7 min read
Why InnoDB Stores Primary Keys in Secondary Index Leaves – A Deep Dive
Open Source Linux
Open Source Linux
Feb 24, 2023 · Databases

Master Oracle Backup & Recovery: Strategies, Scripts, and Best Practices

This article explains Oracle database backup and recovery fundamentals, classifies failure types, compares logical and physical backup methods, introduces flashback technology, outlines complete and incomplete recovery, and provides practical RMAN scripts and scheduling tips for reliable data protection.

OracleRMANRecovery
0 likes · 7 min read
Master Oracle Backup & Recovery: Strategies, Scripts, and Best Practices
DataFunSummit
DataFunSummit
Feb 23, 2023 · Databases

Understanding Redis Persistence: AOF, RDB, and Hybrid Mechanisms

This article explains Redis's three persistence options—Append‑Only File (AOF), Redis DataBase snapshots (RDB), and the hybrid mode—detailing their inner workings, configuration strategies, performance trade‑offs, and how to choose the most reliable solution for a given workload.

AOFHybridPersistence
0 likes · 23 min read
Understanding Redis Persistence: AOF, RDB, and Hybrid Mechanisms
政采云技术
政采云技术
Feb 23, 2023 · Databases

Understanding Next-Key Lock Deadlocks in MySQL: Analysis and Solutions

This article examines how common business operations using SELECT ... FOR UPDATE and INSERT can cause MySQL Next‑Key lock deadlocks, explains the underlying gap‑lock and row‑lock mechanisms, demonstrates practical experiments, and proposes strategies such as postponing locks or using primary‑key updates to avoid such deadlocks.

MySQLNext-key Lockdatabase
0 likes · 14 min read
Understanding Next-Key Lock Deadlocks in MySQL: Analysis and Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 22, 2023 · Databases

OceanBase Single‑Node Deployment and Tenant Management Guide

This article provides a comprehensive step‑by‑step tutorial on deploying OceanBase in a single‑node environment, covering resource unit, resource pool, and MySQL‑type tenant creation, modification, deletion, user management, and relevant system data dictionary tables, with full SQL command examples.

OceanBaseResource UnitTenant Management
0 likes · 10 min read
OceanBase Single‑Node Deployment and Tenant Management Guide
Architecture Digest
Architecture Digest
Feb 22, 2023 · Databases

Understanding the Execution Order of SQL Queries

This article explains the logical execution sequence of a typical SQL query, detailing each phase from FROM/JOIN/WHERE through GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT, and illustrating the process with diagrams and code examples.

From Join WhereGROUP BYHAVING
0 likes · 8 min read
Understanding the Execution Order of SQL Queries
Bilibili Tech
Bilibili Tech
Feb 21, 2023 · Databases

Building a Custom Go ORM: SQL Builder and Reflection-based Scanner

The article explains how to replace repetitive raw SQL and manual row scanning in Go by building a lightweight custom ORM that combines a chainable SQLBuilder for dynamic query construction with a reflection‑based Scanner that maps results to structs, also covering code generation and optional non‑reflection optimizations.

GoORMReflection
0 likes · 17 min read
Building a Custom Go ORM: SQL Builder and Reflection-based Scanner
政采云技术
政采云技术
Feb 21, 2023 · Databases

Understanding Next-Key Lock Deadlocks in MySQL and How to Avoid Them

This article examines how common business operations using SELECT ... FOR UPDATE and INSERT can cause Next‑Key lock deadlocks in MySQL under repeatable‑read isolation, demonstrates the locking behavior with practical SQL examples, and proposes strategies such as post‑locking and primary‑key updates to prevent such deadlocks.

Isolation LevelMySQLNext-key Lock
0 likes · 14 min read
Understanding Next-Key Lock Deadlocks in MySQL and How to Avoid Them
Open Source Linux
Open Source Linux
Feb 20, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries

This article examines eight frequent SQL anti‑patterns—including misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, condition push‑down, premature data reduction, and intermediate result handling—explaining why they degrade performance and providing concrete rewrite strategies and code examples to dramatically speed up queries.

MySQLPerformancedatabase
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
Code Ape Tech Column
Code Ape Tech Column
Feb 16, 2023 · Databases

Understanding and Solving BigKey and HotKey Issues in Redis Clusters

BigKey and HotKey are common Redis cluster problems that can degrade performance, cause timeouts, network congestion, and even system-wide failures; this article explains their definitions, impacts, detection methods, and practical mitigation strategies—including key splitting, local caching, and migration optimizations—based on real-world production cases.

BigKeyHotKeyOperations
0 likes · 22 min read
Understanding and Solving BigKey and HotKey Issues in Redis Clusters
DataFunSummit
DataFunSummit
Feb 9, 2023 · Databases

Comprehensive Guide to Multi-Table Queries and Joins in SQL

This article explains multi‑table SQL queries, detailing Cartesian products, various join types (inner, left/right/full outer, self‑join, natural join, USING), UNION operations, and provides practical examples and exercises to illustrate correct join syntax and performance considerations.

Cross JoinJoinsSQL99
0 likes · 18 min read
Comprehensive Guide to Multi-Table Queries and Joins in SQL
ITPUB
ITPUB
Feb 6, 2023 · Artificial Intelligence

Can ChatGPT Replace a DBA? Real‑World Tests Reveal Its Strengths and Flaws

The article recounts a hands‑on exploration of ChatGPT’s abilities for database administration, highlighting impressive language understanding, notable mistakes such as confusing pg_resetwal with pg_resetxlog, and the broader implications of large language models for AI‑driven search and workflow automation.

AIChatGPTLLM
0 likes · 8 min read
Can ChatGPT Replace a DBA? Real‑World Tests Reveal Its Strengths and Flaws
IT Architects Alliance
IT Architects Alliance
Feb 2, 2023 · Backend Development

Design and Implementation of a Weibo Feed Stream: Storage Architecture, Push vs Pull Models, and Performance Optimizations

This article examines the design of a Weibo‑style feed system, detailing storage tables, the trade‑offs between push (write‑fan‑out) and pull (read‑fan‑out) delivery models, their scalability challenges, and hybrid solutions using caching to achieve low latency and manageable storage costs.

Backendcachingdatabase
0 likes · 9 min read
Design and Implementation of a Weibo Feed Stream: Storage Architecture, Push vs Pull Models, and Performance Optimizations
Laravel Tech Community
Laravel Tech Community
Jan 31, 2023 · Databases

Redis 7.0.8 Released with Security and Bug Fixes

Redis version 7.0.8 has been released, addressing critical security vulnerabilities (CVE-2022-35977 and CVE-2023-22458) and fixing several bugs related to command handling, incremental rehashing, timeout blocking, and sentinel IP changes, with a full changelog available on GitHub.

BugFixVersion7.0.8database
0 likes · 2 min read
Redis 7.0.8 Released with Security and Bug Fixes
macrozheng
macrozheng
Jan 30, 2023 · Databases

Why Is MySQL count(*) So Slow and How to Supercharge It

This article explains why MySQL count(*) queries can become a performance bottleneck on InnoDB tables and presents practical optimization techniques such as Redis caching, secondary caches, multithreading, reducing joins, and even switching to ClickHouse for massive datasets.

MySQLcount(*)database
0 likes · 10 min read
Why Is MySQL count(*) So Slow and How to Supercharge It
IT Architects Alliance
IT Architects Alliance
Jan 27, 2023 · Backend Development

Comprehensive Guide to Building a Backend Technology Stack for Startup Companies

This article provides a detailed overview of the essential backend technology stack for startups, covering language choices, components, processes, systems, and cloud services, and offers practical recommendations for selecting databases, messaging, monitoring, CI/CD, and deployment tools to build a robust, scalable infrastructure.

BackendTechnology Stackdatabase
0 likes · 28 min read
Comprehensive Guide to Building a Backend Technology Stack for Startup Companies
Architect's Guide
Architect's Guide
Jan 24, 2023 · Databases

Understanding Database Indexes: How They Accelerate Query Performance

This article explains the evolution of data storage, the fundamentals of computer storage devices, how database indexes function like a book's table of contents, the role of binary search, the benefits and drawbacks of indexes, clustered versus non‑clustered indexes, and common SQL optimization techniques.

Clustered Indexdatabaseindex
0 likes · 11 min read
Understanding Database Indexes: How They Accelerate Query Performance
21CTO
21CTO
Jan 22, 2023 · Backend Development

What Makes a Scalable Web Application Architecture? A Complete Guide

This article explains the fundamentals of web application architecture, covering its core components, layered models, modern design patterns, popular technologies, and best practices for building secure, scalable, and maintainable web systems across cloud and on‑premise environments.

APIMicroservicesbackend-development
0 likes · 45 min read
What Makes a Scalable Web Application Architecture? A Complete Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 17, 2023 · Databases

Understanding Redis Persistence: RDB and AOF Overview

This article provides a comprehensive overview of Redis persistence mechanisms, detailing the concepts, features, advantages, disadvantages, trigger strategies, operational processes, configuration options, and troubleshooting steps for both RDB (snapshot) and AOF (append‑only file) approaches.

AOFBackupPersistence
0 likes · 10 min read
Understanding Redis Persistence: RDB and AOF Overview
Selected Java Interview Questions
Selected Java Interview Questions
Jan 14, 2023 · Databases

Understanding Redis: Is It Truly Single-Threaded?

This article clarifies the common misconception that Redis is purely single‑threaded by detailing its single‑threaded network I/O model, the evolution of multithreading support across versions, the client‑server request flow, and the underlying Reactor patterns that enable efficient concurrency.

Reactor Modelconcurrencydatabase
0 likes · 14 min read
Understanding Redis: Is It Truly Single-Threaded?
21CTO
21CTO
Jan 12, 2023 · Backend Development

How YouTube Scales to Billions: Inside Its Backend Database and Infrastructure

This article explores how YouTube handles massive video uploads and billions of daily views by detailing its backend micro‑services, MySQL‑based Vitess clustering, sharding, replication, disaster recovery, cloud‑native deployment, CDN strategy, and large‑scale storage architecture.

Cloud NativeVitessYouTube
0 likes · 12 min read
How YouTube Scales to Billions: Inside Its Backend Database and Infrastructure
Sanyou's Java Diary
Sanyou's Java Diary
Jan 12, 2023 · Databases

Master MySQL Transaction Isolation: From READ UNCOMMITTED to SERIALIZABLE

This article explains MySQL's transaction concepts, the four isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—detailing their effects on dirty reads, non‑repeatable reads and phantom reads, how they are implemented with locks and MVCC, and provides practical SQL examples and diagrams.

InnoDBMVCCMySQL
0 likes · 20 min read
Master MySQL Transaction Isolation: From READ UNCOMMITTED to SERIALIZABLE
Top Architect
Top Architect
Jan 12, 2023 · Databases

MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation

This article provides a comprehensive tutorial on configuring MySQL master‑slave replication with Docker, explains the roles of binlog and redo log, describes two‑phase commit, and demonstrates how to use Sharding‑JDBC (ShardingSphere) for read‑write splitting and horizontal sharding in a Spring Boot application, complete with configuration files and code examples.

MySQLReplicationShardingSphere
0 likes · 24 min read
MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation
Programmer DD
Programmer DD
Jan 11, 2023 · Databases

Redis Deep Dive: Pipelines, Pub/Sub, Persistence, Locks & Cluster

This comprehensive guide explores Redis fundamentals and advanced features, covering pipelines for reduced RTT, publish/subscribe messaging, key expiration strategies, transaction behavior, persistence mechanisms (RDB, AOF, hybrid), distributed locking techniques, sentinel high‑availability, and cluster sharding, with practical code examples and diagrams.

Distributed Systemsdatabaseredis
0 likes · 47 min read
Redis Deep Dive: Pipelines, Pub/Sub, Persistence, Locks & Cluster
Open Source Linux
Open Source Linux
Jan 10, 2023 · Databases

Essential MySQL Scripts: Export, Import, and Manage Databases & Tables

This guide compiles a comprehensive set of MySQL command‑line scripts for exporting whole databases, individual tables or schemas, importing data, and performing common database and table operations such as creation, selection, alteration, deletion, granting privileges, and viewing structure, all illustrated with ready‑to‑use code examples.

DDLData ExportDatabase Administration
0 likes · 11 min read
Essential MySQL Scripts: Export, Import, and Manage Databases & Tables
DataFunTalk
DataFunTalk
Jan 9, 2023 · Databases

What Does a Decade Mean for Apache Doris? – Highlights from Doris Summit 2022

The Doris Summit 2022 recap outlines a ten‑year journey from an internal Baidu project to a top‑level Apache OLAP database, detailing explosive community growth, 2022 milestones, major feature releases up to version 1.2, and an ambitious 2023 roadmap focused on performance, lakehouse integration, multi‑modal analysis, cost efficiency, and enhanced usability.

Apache DorisOLAPRoadmap
0 likes · 21 min read
What Does a Decade Mean for Apache Doris? – Highlights from Doris Summit 2022
Top Architect
Top Architect
Jan 8, 2023 · Databases

Understanding Redis: Architecture, Deployment Options, Persistence Models, and High Availability

This article provides a comprehensive overview of Redis, covering its definition as an in‑memory data structure server, various deployment topologies such as single instance, high‑availability, Sentinel, and Cluster, as well as detailed explanations of persistence mechanisms, forking, replication, and practical considerations for scaling and reliability.

ClusterPersistenceReplication
0 likes · 18 min read
Understanding Redis: Architecture, Deployment Options, Persistence Models, and High Availability
Liangxu Linux
Liangxu Linux
Jan 8, 2023 · Databases

Master MySQL: 13 Essential Functions and Commands for Efficient Data Handling

This comprehensive guide walks you through 13 practical MySQL techniques—including group_concat, char_length, locate, replace, now, insert‑select variations, on duplicate key update, show create table, explain, show processlist, and mysqldump—complete with clear examples, SQL snippets, and result screenshots to help you manage and optimize your data effectively.

MySQLPerformancedatabase
0 likes · 13 min read
Master MySQL: 13 Essential Functions and Commands for Efficient Data Handling
Liangxu Linux
Liangxu Linux
Jan 2, 2023 · Databases

13 Must‑Know MySQL Functions and Tricks for Everyday Development

This guide walks through a collection of practical MySQL functions and commands—including GROUP_CONCAT, CHAR_LENGTH, LOCATE, REPLACE, NOW, INSERT…SELECT, INSERT…IGNORE, SELECT FOR UPDATE, ON DUPLICATE KEY UPDATE, SHOW CREATE TABLE, CREATE TABLE … SELECT, EXPLAIN, SHOW PROCESSLIST and mysqldump—providing clear syntax, example queries, result screenshots and key usage notes to help developers write more efficient and reliable SQL.

Data MigrationMySQLdatabase
0 likes · 14 min read
13 Must‑Know MySQL Functions and Tricks for Everyday Development
Java Architecture Diary
Java Architecture Diary
Dec 28, 2022 · Backend Development

How to Add a Custom DM8 Database Plugin to Nacos 2.2

Starting with Nacos 2.2.0, this guide shows how to create a custom DM8 database plugin via the SPI mechanism, add Maven dependencies, import the required scripts, configure connection settings and set the platform property, enabling Nacos to persist data in a DM8 database.

BackendDM8Nacos
0 likes · 3 min read
How to Add a Custom DM8 Database Plugin to Nacos 2.2
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 26, 2022 · Databases

MySQL Replication Delay Analysis and Troubleshooting for Large Transactions

The article describes a MySQL 5.7.31 replication delay where Seconds_Behind_Master fluctuates between 0 and over 10,000 seconds, analyzes root causes such as single‑threaded replication, large or long‑running transactions, and provides preventive, diagnostic, and remediation steps including enabling parallel replication and using the infobin tool.

Large TransactionsMySQLReplication
0 likes · 10 min read
MySQL Replication Delay Analysis and Troubleshooting for Large Transactions
ITPUB
ITPUB
Dec 24, 2022 · Databases

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

This guide walks you through 13 practical MySQL techniques—from aggregating values with GROUP_CONCAT and measuring string length with CHAR_LENGTH, to locating substrings, replacing text, retrieving timestamps, bulk inserting data, handling duplicate keys, inspecting table structures, and using diagnostic commands like EXPLAIN and SHOW PROCESSLIST—complete with ready‑to‑run SQL examples and visual results.

GROUP_CONCATInsertMySQL
0 likes · 13 min read
Master MySQL: 13 Essential Functions and Commands Every Developer Should Know
Code Ape Tech Column
Code Ape Tech Column
Dec 22, 2022 · Backend Development

Why Database Connection Pools Do Not Use IO Multiplexing (Java Interview Question)

The article explains why Java applications typically use traditional database connection pools instead of IO multiplexing, covering JDBC’s blocking design, session management, ecosystem maturity, and the complexity of integrating non‑blocking I/O with existing frameworks, while noting that a non‑blocking implementation is technically feasible.

BackendConnection PoolIO Multiplexing
0 likes · 9 min read
Why Database Connection Pools Do Not Use IO Multiplexing (Java Interview Question)
dbaplus Community
dbaplus Community
Dec 20, 2022 · Databases

Why Redis Cluster’s CLUSTER SLOTS Command Slows Down Large Deployments and How to Fix It

This article analyzes the latency spikes observed in large‑scale Redis clusters after node expansion, identifies the CLUSTER SLOTS command and slot‑migration handling in hiredis‑vip and Jedis as the root cause, proposes a slot‑traversal optimization, and demonstrates a ten‑fold performance improvement with detailed benchmarks.

Clusterdatabaseredis
0 likes · 19 min read
Why Redis Cluster’s CLUSTER SLOTS Command Slows Down Large Deployments and How to Fix It
21CTO
21CTO
Dec 20, 2022 · Databases

Explore PostgreSQL 15: New Features, Performance Boosts, and Upgrade Guide

PostgreSQL 15 introduces a safer permission model, up to four‑fold sorting speed improvements, a MERGE command, enhanced logical replication with two‑phase commit, parallel query execution, JSON logging, Zstandard/ZL4 compression, new regex functions, and shared‑memory server statistics, making it a compelling upgrade for developers and DBAs.

New FeaturesPerformanceVersion 15
0 likes · 6 min read
Explore PostgreSQL 15: New Features, Performance Boosts, and Upgrade Guide
Top Architect
Top Architect
Dec 20, 2022 · Databases

Elasticsearch DSL Query Syntax Overview (Version 7.x)

This article provides a comprehensive beginner-friendly guide to Elasticsearch 7.x DSL query syntax, covering core keywords, mapping types, query examples, boolean logic, and code snippets to help readers understand and construct effective search queries.

Big DataDSLdatabase
0 likes · 8 min read
Elasticsearch DSL Query Syntax Overview (Version 7.x)
Top Architect
Top Architect
Dec 15, 2022 · Databases

Implementing Database Read‑Write Separation with Spring Boot and Dynamic DataSource Routing

This article explains how to achieve database read‑write separation in high‑concurrency scenarios using Spring Boot, Druid connection pool, dynamic DataSource routing, a ThreadLocal context holder, custom annotations, and AOP, providing complete configuration code and usage examples for both read and write operations.

DataSourceRoutingReadWriteSplittingSpringBoot
0 likes · 12 min read
Implementing Database Read‑Write Separation with Spring Boot and Dynamic DataSource Routing
Architects' Tech Alliance
Architects' Tech Alliance
Dec 12, 2022 · Industry Insights

What Drives China’s Xinchuang IT Industry? A Deep Dive into Hardware, OS, Middleware, and Databases

This article provides a comprehensive overview of China’s Xinchuang (information technology innovation) industry, explaining its core components—hardware, operating systems, middleware, databases, and firmware—while highlighting market share trends, classification schemes, and the strategic importance of each layer for national information security.

IT industryIndustry AnalysisOperating System
0 likes · 6 min read
What Drives China’s Xinchuang IT Industry? A Deep Dive into Hardware, OS, Middleware, and Databases
Sohu Tech Products
Sohu Tech Products
Dec 7, 2022 · Databases

How to Diagnose and Resolve Redis Performance Issues

This article explains how to identify Redis latency problems, measure baseline performance, monitor slow commands, and address common causes such as network RTT, forked RDB snapshots, transparent huge pages, swap usage, AOF configuration, key expiration bursts, and big keys, providing practical solutions and a checklist for remediation.

LatencyPerformancedatabase
0 likes · 18 min read
How to Diagnose and Resolve Redis Performance Issues
vivo Internet Technology
vivo Internet Technology
Dec 7, 2022 · Databases

vivo's Database Operations Platform: Challenges and Solutions in the Cloud-Native Era

Vivo’s Database‑as‑a‑Service platform tackles cloud‑native challenges by automating massive instance management with self‑service work orders and self‑healing, enabling elastic scaling through mixed‑deployment and multi‑threaded Redis tools, optimizing costs via automatic package shrinkage, and safeguarding personal data with full‑chain encryption, while outlining a roadmap toward AI‑driven fault handling, container‑based resources, and advanced privacy governance.

DaaSMySQLOperations
0 likes · 14 min read
vivo's Database Operations Platform: Challenges and Solutions in the Cloud-Native Era
JD Tech
JD Tech
Dec 7, 2022 · Databases

Practical Guide to Large‑Scale Data Migration Using Sharding‑Proxy

This article presents a step‑by‑step practice of migrating massive billing data to 32 sharded databases with Sharding‑Proxy, covering background, objectives, four migration solutions, detailed proxy installation and configuration, debugging, migration workflow, data validation, common issues and their resolutions.

Data MigrationSharding-Proxyconfiguration
0 likes · 14 min read
Practical Guide to Large‑Scale Data Migration Using Sharding‑Proxy
Laravel Tech Community
Laravel Tech Community
Dec 5, 2022 · Databases

Using MySQL Built‑in Commands for Comprehensive Database Monitoring

This article explains how to collect extensive MySQL performance metrics—including connections, buffer cache, locks, SQL status, statement counts, throughput, server configuration, and slow‑query logs—using only MySQL's native SHOW commands and the performance_schema, providing practical code snippets and optimization tips.

MySQLPerformancePerformance Schema
0 likes · 10 min read
Using MySQL Built‑in Commands for Comprehensive Database Monitoring
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 5, 2022 · Databases

Greenplum Standby Failure Diagnosis and Recovery Procedure

This article describes how to identify and fix Greenplum standby segment failures by inspecting segment status, comparing missing files, generating a recovery configuration, executing gprecoverseg commands, and verifying that all segments return to normal operation without service interruption.

GreenplumRecoverySegment
0 likes · 17 min read
Greenplum Standby Failure Diagnosis and Recovery Procedure
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 30, 2022 · Databases

Understanding Index Condition Pushdown (ICP) in MySQL and Its Impact on Query Cost

Index Condition Pushdown (ICP) in MySQL pushes filter conditions to the storage engine to reduce row lookups, but this article demonstrates through experiments that while ICP lowers runtime by decreasing back‑table accesses, the optimizer’s cost model often ignores its benefits, leading to suboptimal plan choices.

Cost ModelMySQLdatabase
0 likes · 10 min read
Understanding Index Condition Pushdown (ICP) in MySQL and Its Impact on Query Cost
Architect's Guide
Architect's Guide
Nov 30, 2022 · Information Security

How to Perform Fuzzy Queries on Encrypted Data

This article reviews why reversible encryption is needed for certain sensitive fields, classifies three categories of fuzzy‑search‑on‑encrypted‑data techniques—naïve, conventional, and advanced—and evaluates their implementation steps, performance trade‑offs, and practical recommendations.

AESalgorithmdata security
0 likes · 11 min read
How to Perform Fuzzy Queries on Encrypted Data
Architecture Digest
Architecture Digest
Nov 29, 2022 · Databases

MySQL InnoDB Deadlock Analysis and Resolution for a Video‑Conference Service

The article details a step‑by‑step investigation of an intermittent deadlock occurring during session creation in a video‑conference system, explains how InnoDB lock types caused the conflict between DELETE and INSERT statements on the session and session_endpoint tables, reproduces the issue, debugs MySQL source code, and presents a simple code‑order fix to eliminate the deadlock.

InnoDBMySQLdatabase
0 likes · 21 min read
MySQL InnoDB Deadlock Analysis and Resolution for a Video‑Conference Service
macrozheng
macrozheng
Nov 28, 2022 · Backend Development

18 Proven Strategies to Slash API Response Times from Seconds to Milliseconds

This article shares eighteen practical techniques—including batch database operations, asynchronous processing, caching, prefetching, pooling, event callbacks, parallel remote calls, lock granularity, file‑based staging, indexing, SQL tuning, transaction management, deep pagination fixes, code restructuring, payload compression, NoSQL adoption, thread‑pool tuning, and JVM/IO optimizations—to dramatically reduce backend interface latency and improve overall system performance.

Backenddatabase
0 likes · 20 min read
18 Proven Strategies to Slash API Response Times from Seconds to Milliseconds
dbaplus Community
dbaplus Community
Nov 27, 2022 · Databases

Unraveling MySQL InnoDB Deadlocks in Video Conference Sessions

A detailed investigation of intermittent MySQL InnoDB deadlocks occurring during video‑conference session creation, covering log extraction, lock analysis, source‑code debugging, reproducible test cases, and a simple code change that eliminates the deadlock while explaining the underlying locking mechanisms.

InnoDBLock AnalysisMySQL
0 likes · 22 min read
Unraveling MySQL InnoDB Deadlocks in Video Conference Sessions
ITPUB
ITPUB
Nov 26, 2022 · Databases

Mastering Redis Distributed Locks with Jedis: A Step‑by‑Step Guide

This article introduces Redis’s evolution, key features for distributed locking, explains lock and unlock workflows with Jedis, presents Java code examples, discusses pitfalls like non‑atomic operations, and offers configuration and performance tuning tips for reliable, high‑availability lock services.

Jedisdatabasedistributed-lock
0 likes · 20 min read
Mastering Redis Distributed Locks with Jedis: A Step‑by‑Step Guide
FunTester
FunTester
Nov 25, 2022 · Databases

100 Common SQL Interview Questions with Answers and Explanations

This article presents 100 typical SQL interview questions covering basic queries, advanced techniques, and database design, illustrated with three sample tables (employee, department, job) and detailed answers, code examples, and analysis for both MySQL and Oracle implementations.

QueriesSQL AdvancedSQL Basics
0 likes · 50 min read
100 Common SQL Interview Questions with Answers and Explanations
Selected Java Interview Questions
Selected Java Interview Questions
Nov 24, 2022 · Databases

Common MySQL Index Failure Scenarios and Optimization Techniques

This article explains why many MySQL queries cause index inefficiency, details the leftmost prefix rule for composite indexes, illustrates common index‑breaking patterns such as SELECT *, functions, range queries, LIKE, OR, IN, ORDER BY, and introduces Index Condition Pushdown (ICP) as an optimization to reduce row lookups.

Leftmost PrefixMySQLdatabase
0 likes · 19 min read
Common MySQL Index Failure Scenarios and Optimization Techniques
政采云技术
政采云技术
Nov 24, 2022 · Databases

Is Redis Really Slowing Down? A Comprehensive Diagnosis and Optimization Guide

This article explains how to determine whether Redis is truly experiencing latency issues, outlines benchmark testing methods, identifies common causes such as network problems, high‑complexity commands, big keys, slow logs, memory limits, fork overhead, AOF configuration, swap usage, fragmentation, and provides practical troubleshooting and optimization steps.

Latencydatabaseredis
0 likes · 26 min read
Is Redis Really Slowing Down? A Comprehensive Diagnosis and Optimization Guide
ITPUB
ITPUB
Nov 22, 2022 · Databases

How Redis RDB Works: Snapshotting, BGSAVE, and Copy‑On‑Write Explained

Redis achieves high speed by keeping data in memory, but to avoid data loss it offers two persistence methods—RDB and AOF; this article explains RDB’s snapshot mechanism, the SAVE vs BGSAVE commands, copy‑on‑write handling, automatic save configuration, and the internal structures that drive periodic backups.

BGSAVECopy-on-WritePersistence
0 likes · 13 min read
How Redis RDB Works: Snapshotting, BGSAVE, and Copy‑On‑Write Explained
Architects' Tech Alliance
Architects' Tech Alliance
Nov 20, 2022 · Databases

Columnar Storage vs Row Storage: Overview, Write/Read Comparison, Pros, Cons, and Use Cases

This article explains the differences between row-based and column-based storage, comparing their write and read performance, outlining advantages and disadvantages, and describing suitable scenarios such as OLAP queries, column families, compression, and indexing, to help choose the appropriate storage model.

Big DataColumnar StorageOLAP
0 likes · 10 min read
Columnar Storage vs Row Storage: Overview, Write/Read Comparison, Pros, Cons, and Use Cases
Architecture Digest
Architecture Digest
Nov 20, 2022 · Databases

Understanding and Mitigating Bigkey Issues in Redis Operations

The article explains what Redis bigkeys are, why they arise, the performance and availability problems they cause, and presents practical detection methods and optimization techniques—including key splitting, tool improvements, and migration safeguards—to help DBAs and developers prevent and resolve bigkey‑related incidents.

BigKeydatabaseredis
0 likes · 14 min read
Understanding and Mitigating Bigkey Issues in Redis Operations
NetEase LeiHuo Testing Center
NetEase LeiHuo Testing Center
Nov 18, 2022 · Game Development

Precise Testing and Management of Unity Art Asset Dependencies

This article explains how to accurately test, record, and maintain art asset dependencies in Unity projects, describing the use of Unity's Select Dependencies interface, database design for storing direct and indirect relationships, and practical applications such as automated SVN integration, resource cleanup, and impact alerts.

Dependency AnalysisUnityasset management
0 likes · 13 min read
Precise Testing and Management of Unity Art Asset Dependencies
IT Architects Alliance
IT Architects Alliance
Nov 17, 2022 · Backend Development

Cache Update Strategies and Concurrency Control: CAS, Distributed Locks, Asynchronous Updates, and Delayed Double Delete

This article examines cache update strategies in high‑concurrency systems, analyzing the trade‑offs of delete‑then‑write versus write‑then‑write approaches, illustrating race conditions, and presenting solutions such as CAS, distributed locks, asynchronous updates, and delayed double‑delete to maintain data consistency.

CASCacheConsistency
0 likes · 8 min read
Cache Update Strategies and Concurrency Control: CAS, Distributed Locks, Asynchronous Updates, and Delayed Double Delete
vivo Internet Technology
vivo Internet Technology
Nov 16, 2022 · Industry Insights

Vivo 2022 Dev Conference: Frontend Compiler, Low‑Code, Real‑Time & Cloud‑Native

The 2022 Vivo developer conference showcased a series of technical breakthroughs—including a custom wepy‑chameleon compiler for frontend upgrades, low‑code platforms for backend and game development, a real‑time computing platform built on Flink, advanced graph scheduling, cloud‑native container strategies, monitoring enhancements, database automation, and large‑scale messaging middleware—highlighting Vivo's comprehensive push toward efficiency and innovation across its internet services.

Cloud NativeContainerFrontend
0 likes · 14 min read
Vivo 2022 Dev Conference: Frontend Compiler, Low‑Code, Real‑Time & Cloud‑Native
DaTaobao Tech
DaTaobao Tech
Nov 12, 2022 · Industry Insights

How Taobao’s Double‑11 Tech Stack Redefined Shopping: Cloud‑Native DB, NeRF 3D, and Real‑Time Gaming

Taobao’s 2023 Double 11 showcased a suite of technical breakthroughs—including a cloud‑native Tair database for massive cart capacity, AI‑driven logistics forecasting, industry‑first NeRF‑based 3D product modeling, high‑definition live‑streaming, and a real‑time interactive gaming framework—demonstrating how infrastructure innovation can transform e‑commerce experiences.

AINeRFcloud-native
0 likes · 12 min read
How Taobao’s Double‑11 Tech Stack Redefined Shopping: Cloud‑Native DB, NeRF 3D, and Real‑Time Gaming
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 9, 2022 · Databases

Why Alibaba’s PolarDB Open‑Source Strategy Is a Game‑Changer for Cloud‑Native Databases

The October 25th PolarDB open‑source summit in Hangzhou gathered Alibaba Cloud executives, ecosystem partners and developers to discuss the daring decision to open‑source the flagship cloud‑native database, its compatibility and openness principles, real‑world case studies, and future trends shaping the next generation of distributed databases.

Alibaba CloudCloud NativeDistributed
0 likes · 20 min read
Why Alibaba’s PolarDB Open‑Source Strategy Is a Game‑Changer for Cloud‑Native Databases
dbaplus Community
dbaplus Community
Nov 8, 2022 · Databases

Mastering MySQL Performance: 5 Key Issues and Proven Tuning Strategies

This comprehensive guide outlines five common MySQL performance problems, a step‑by‑step investigation methodology, detailed Java middleware and database analyses, practical tuning tactics such as index optimization and sharding, and a governance framework for sustainable performance management.

DevOpsMySQLTuning
0 likes · 23 min read
Mastering MySQL Performance: 5 Key Issues and Proven Tuning Strategies
Python Programming Learning Circle
Python Programming Learning Circle
Nov 7, 2022 · Databases

Comprehensive SQL Techniques: Pivot/Unpivot, String Replacement, Date Conversion, Division, NULL Handling, and Performance Tips

This article presents a collection of practical T‑SQL techniques—including row‑to‑column pivots, column‑to‑row unpivots, string replacement, date/time conversion, division with percentage formatting, NULL handling, counting methods, UNION ALL inserts, cache inspection, plan cache clearing, line‑break handling, TRUNCATE vs DELETE, system diagnostics, and execution‑time measurement—each illustrated with complete SQL code examples.

T-SQLdata manipulationdatabase
0 likes · 17 min read
Comprehensive SQL Techniques: Pivot/Unpivot, String Replacement, Date Conversion, Division, NULL Handling, and Performance Tips
Architects Research Society
Architects Research Society
Nov 4, 2022 · Fundamentals

eBay Scalability Best Practices: Functional Partitioning, Horizontal Sharding, Async Decoupling, and More

This article outlines eBay's key scalability best practices—including functional decomposition, horizontal sharding, avoiding distributed transactions, asynchronous decoupling, virtualization, and intelligent caching—to demonstrate how large‑scale web systems can achieve linear resource growth and high availability.

ArchitectureAsynchronousOperations
0 likes · 14 min read
eBay Scalability Best Practices: Functional Partitioning, Horizontal Sharding, Async Decoupling, and More
ITPUB
ITPUB
Nov 1, 2022 · Databases

Why RocksDB 7.5.3 Beats 6.2.9: Deep Dive into Performance Optimizations

The new RocksDB 7.5.3 release dramatically reduces write‑stall time, lock contention and CPU usage while improving OPS and latency compared with 6.2.9.x, as shown by detailed memtier benchmark tests on a 4‑CPU, 32 GiB VM with NVMe storage.

BenchmarkLatencyPerformance
0 likes · 11 min read
Why RocksDB 7.5.3 Beats 6.2.9: Deep Dive into Performance Optimizations