BestHub
Sign in
Tagged articles
2671 articles
Page 5 of 27
Code Ape Tech Column
Code Ape Tech Column
Jan 8, 2025 · Backend Development

Implementing High‑Concurrency Flash‑Sale (Seckill) in SpringBoot: Locking Strategies, Queue Solutions, and Performance Testing

This article demonstrates how to simulate a high‑concurrency flash‑sale scenario using SpringBoot, MySQL, Mybatis‑Plus and JMeter, analyzes the overselling problem caused by premature lock release, and presents seven solutions—including lock‑first strategies, AOP, pessimistic and optimistic locks, and queue‑based approaches—along with code samples and test results.

JMeterQueueSeckill
0 likes · 19 min read
Implementing High‑Concurrency Flash‑Sale (Seckill) in SpringBoot: Locking Strategies, Queue Solutions, and Performance Testing
Data Thinking Notes
Data Thinking Notes
Jan 7, 2025 · Databases

Unlocking LLM-Powered Text-to-SQL: From Basics to Cutting-Edge Techniques

This article provides a comprehensive overview of LLM-based Text-to-SQL technology, covering its background, evolution, challenges, various LLM-driven methods, benchmark datasets, evaluation metrics, and future research directions to guide researchers and practitioners in advancing natural language interfaces for databases.

LLMPrompt engineeringText-to-SQL
0 likes · 18 min read
Unlocking LLM-Powered Text-to-SQL: From Basics to Cutting-Edge Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 7, 2025 · Databases

Analysis of Redis Sentinel Failover Issue in Redis 7.4.0 and Resolution via Pub/Sub ACL Adjustment

This article investigates a Redis Sentinel failover anomaly in version 7.4.0 where the sentinel repeatedly elects a failed master, explains the underlying s_down/o_down states, examines network, configuration, and ACL settings, and resolves the issue by adjusting Pub/Sub permissions to allow proper failover.

ACLdatabasefailover
0 likes · 11 min read
Analysis of Redis Sentinel Failover Issue in Redis 7.4.0 and Resolution via Pub/Sub ACL Adjustment
Java Tech Enthusiast
Java Tech Enthusiast
Jan 4, 2025 · Databases

Understanding Redis Sets and Their Use Cases

Redis Sets are unordered collections of unique strings backed by hash tables that provide O(1) add, delete, and lookup operations, automatically switch to a compact integer array (intset) for small integer-only sets, and are ideal for deduplicated data and fast set operations such as intersection, union, and difference, exemplified by computing common friends in social applications.

Code ExampleSet OperationsSets
0 likes · 4 min read
Understanding Redis Sets and Their Use Cases
ITPUB
ITPUB
Jan 3, 2025 · Databases

Why ClickHouse Sharded Table Queries Return Inconsistent Row Counts—and How to Fix It

A ClickHouse cluster showed wildly varying row counts when querying sharded tables, while local tables behaved correctly; the article analyses the root cause in the cluster and table configuration, explains why the inconsistency occurs, and provides a step‑by‑step fix by switching to replicated tables.

Query InconsistencyReplicationclickhouse
0 likes · 7 min read
Why ClickHouse Sharded Table Queries Return Inconsistent Row Counts—and How to Fix It
IT Architects Alliance
IT Architects Alliance
Jan 1, 2025 · Backend Development

Comprehensive Guide to IT Architecture Optimization for System Performance

This article explores practical techniques for boosting system performance through IT architecture optimization, covering caching strategies, database query and connection‑pool tuning, load‑balancing, asynchronous messaging, code‑level refinements, memory pooling, network tricks, and real‑world case studies.

AsynchronousCode Optimizationcaching
0 likes · 18 min read
Comprehensive Guide to IT Architecture Optimization for System Performance
php Courses
php Courses
Dec 23, 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 connection.

PHPdatabasemysql
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
php Courses
php Courses
Dec 23, 2024 · Backend Development

Understanding PHP Built-in Objects and Their Practical Use

This article explains what PHP built-in objects are, categorizes them by request handling, file operations, database access, and exception handling, and demonstrates their usage with code examples to write more elegant, secure, and efficient backend code.

Built-in ObjectsException HandlingPHP
0 likes · 5 min read
Understanding PHP Built-in Objects and Their Practical Use
dbaplus Community
dbaplus Community
Dec 22, 2024 · Databases

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

This article examines how MySQL pagination performance degrades as table size grows, presents real‑world timing tests on a million‑row customer table, and offers three practical solutions—including selecting only primary keys, ID‑range filtering, and leveraging ElasticSearch—to dramatically improve query speed.

Large Tablesdatabasemysql
0 likes · 8 min read
Why MySQL Pagination Slows Down on Large Tables and How to Fix It
21CTO
21CTO
Dec 20, 2024 · Databases

Can Rust’s Limbo Outpace SQLite? Inside Turso’s Async Database Rewrite

Limbo, Turso’s Rust‑based rewrite of SQLite, aims for full compatibility while adding memory safety, asynchronous I/O via io_uring, deterministic simulation testing, and WebAssembly compilation, delivering comparable or superior performance on large datasets and showcasing the challenges and benefits of re‑engineering a mature database engine.

Deterministic TestingLimboRust
0 likes · 4 min read
Can Rust’s Limbo Outpace SQLite? Inside Turso’s Async Database Rewrite
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.

InnoDBUNDOdatabase
0 likes · 9 min read
How MySQL InnoDB Allocates Undo Segments
DevOps Operations Practice
DevOps Operations Practice
Dec 17, 2024 · Backend Development

From CPU Alert to Resolution: A Step‑by‑Step Backend Performance Debugging Guide

This article recounts a midnight CPU alert incident and walks through systematic backend troubleshooting—from initial system checks and JVM profiling to algorithm refactoring, database indexing, Docker‑based isolation, and proactive monitoring—demonstrating how to restore service performance and prevent future outages.

DockerJVMdatabase
0 likes · 7 min read
From CPU Alert to Resolution: A Step‑by‑Step Backend Performance Debugging Guide
Java Tech Enthusiast
Java Tech Enthusiast
Dec 17, 2024 · Databases

DBOS – Database‑Oriented Operating System

DBOS, a Database‑Oriented Operating System proposed by Matei Zaharia and Michael Stonebrake, builds the OS atop a distributed, ACID‑compliant database, storing all system and application state in tables, which simplifies scaling, ensures strong consistency, improves debugging, and reduces attack surface for cloud‑native workloads.

DBOSDistributed SystemsOperating System
0 likes · 8 min read
DBOS – Database‑Oriented Operating System
21CTO
21CTO
Dec 15, 2024 · Databases

Why Antirez Is Returning to Redis: Insights on Licensing, AI, and Vector Search

Redis Labs announces the return of its founder Antirez, who shares his reasons for rejoining, discusses the recent licensing shift, reflects on his past projects, and outlines future plans for AI integration, vector indexing, and community engagement within the Redis ecosystem.

AILicensingdatabase
0 likes · 16 min read
Why Antirez Is Returning to Redis: Insights on Licensing, AI, and Vector Search
dbaplus Community
dbaplus Community
Dec 14, 2024 · Databases

Why a Database‑First Operating System Could Replace Linux and Kubernetes

The article examines the DBOS concept—a database‑oriented operating system that places a distributed, transactional database at the core of OS services, tracing its roots from early database pioneers to modern cloud workloads and highlighting its potential advantages over traditional Linux‑Kubernetes stacks.

DBOSOperating SystemSpark
0 likes · 10 min read
Why a Database‑First Operating System Could Replace Linux and Kubernetes
DaTaobao Tech
DaTaobao Tech
Dec 13, 2024 · Databases

MyBatis Boolean vs Boolean: Unexpected 0 Value and Fix

Because MyBatis reads a primitive boolean field directly when no getter exists, the default false value is bound as 0, causing an unexpected zero in the MySQL tinyint column; changing the field to the Boolean wrapper (initialized to true) or fixing the update logic resolves the issue.

MyBatisORMboolean
0 likes · 9 min read
MyBatis Boolean vs Boolean: Unexpected 0 Value and Fix
JD Tech
JD Tech
Dec 13, 2024 · Databases

MySQL Join Algorithms and Optimization Techniques

This article explains how multi‑table joins in MySQL can become performance bottlenecks and walks through the four join algorithms—Simple Nested‑Loop, Block Nested‑Loop, Hash, and Index Nested‑Loop—showing their execution plans, code examples, and step‑by‑step optimizations using indexes and join buffers to dramatically improve query speed.

Join AlgorithmsSQL Optimizationdatabase
0 likes · 19 min read
MySQL Join Algorithms and Optimization Techniques
Java Architect Essentials
Java Architect Essentials
Dec 11, 2024 · Databases

Redis Expiration Listener: Scenario Testing and Performance Analysis

This article examines the pitfalls of using Redis key‑expiration notifications for delayed business actions, presents a Docker‑based benchmark, provides Spring‑Boot code for scheduling and listening to expirations, and analyzes how notification latency grows as the number of keys increases.

Key ExpirationPerformance TestingSpring Boot
0 likes · 11 min read
Redis Expiration Listener: Scenario Testing and Performance Analysis
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.

ContainersData SafetyDocker
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.

Queriesdatabasefunctions
0 likes · 14 min read
Master MySQL: 13 Essential Functions & Commands Every Developer Should Know
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.

JDBCTimeoutconnection
0 likes · 11 min read
Why Do JDBC Queries Hang? Understanding Timeout Mechanisms and Fixes
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.

BackupGTIDReplication
0 likes · 9 min read
MySQL Replication Filter Expansion: Adding New Databases with Efficient Backup and Restore
Open Source Tech Hub
Open Source Tech Hub
Nov 29, 2024 · Backend Development

Mastering ThinkPHP 4.0+ Entity Models: A Complete Backend Guide

This guide explains ThinkPHP 4.0+ entity models, covering their layered architecture, installation, entity and model definitions, automatic relation queries, new type casting, accessors, configuration options, virtual and view models, with full code examples and practical tips for backend developers.

Entity ModelORMPHP
0 likes · 11 min read
Mastering ThinkPHP 4.0+ Entity Models: A Complete Backend Guide
Full-Stack DevOps & Kubernetes
Full-Stack DevOps & Kubernetes
Nov 28, 2024 · Operations

20 Essential Linux & Kubernetes Troubleshooting Commands Every DevOps Engineer Should Know

This guide compiles the 20 most common Linux and Kubernetes troubleshooting commands, illustrating typical outputs and step‑by‑step diagnostic reasoning for high CPU load, disk pressure, network failures, pod crashes, node issues, service outages, database errors, and application performance problems.

KubernetesLinuxSystem Administration
0 likes · 15 min read
20 Essential Linux & Kubernetes Troubleshooting Commands Every DevOps Engineer Should Know
21CTO
21CTO
Nov 27, 2024 · Databases

Why Do the World’s Biggest Companies Choose PostgreSQL?

This article explores why leading enterprises and developers favor PostgreSQL, detailing its widespread adoption by major firms, its robust feature set, historical evolution, and how its extensibility and open‑source nature make it a compelling alternative to traditional enterprise databases.

Enterpriseclouddatabase
0 likes · 11 min read
Why Do the World’s Biggest Companies Choose PostgreSQL?
php Courses
php Courses
Nov 25, 2024 · Backend Development

Managing Laravel Application Settings with a Database-Driven Approach

This guide explains how to create a flexible, maintainable settings system in Laravel by storing configuration key‑value pairs in a database, generating migrations, models, seeders, service‑provider boot logic, and an admin Blade form for editing settings.

ConfigurationPHPSettings Management
0 likes · 6 min read
Managing Laravel Application Settings with a Database-Driven Approach
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.

databasemysqlnetwork
0 likes · 2 min read
MySQL 8 New Features and Network Communication Course Overview
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.

PHPdatabasemysql
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Su San Talks Tech
Su San Talks Tech
Nov 19, 2024 · Databases

18 Proven Ways to Supercharge Redis Performance

This article presents 18 practical techniques—including choosing optimal data structures, minimizing key sizes, leveraging pipelines, connection pooling, expiration policies, clustering, Lua scripting, and monitoring—to dramatically improve Redis performance in real-world applications overall.

databaseoptimizationperformance
0 likes · 9 min read
18 Proven Ways to Supercharge Redis Performance
Java Backend Technology
Java Backend Technology
Nov 17, 2024 · Databases

How a One‑Digit Decimal Error Multiplied Interest Tenfold – Database Lessons

A developer mistakenly entered an extra zero in a SQL update for daily interest rates, expanding calculated interest by ten times, and the error slipped through code review, testing, and production verification due to inadequate processes, highlighting the need for strict data‑change procedures, thorough testing, and monitoring.

Code reviewdatabaseprocess
0 likes · 13 min read
How a One‑Digit Decimal Error Multiplied Interest Tenfold – Database Lessons
Top Architect
Top Architect
Nov 16, 2024 · Cloud Native

Why Docker May Not Be Suitable for Running MySQL: Data Security, Performance, State, and Resource Isolation Issues

The article examines why deploying MySQL in Docker containers can be problematic, highlighting data‑security risks, performance bottlenecks, state‑management challenges, and limited resource isolation, while also noting specific scenarios where containerizing MySQL might still be viable.

Cloud NativeDockercontainerization
0 likes · 8 min read
Why Docker May Not Be Suitable for Running MySQL: Data Security, Performance, State, and Resource Isolation Issues
Liangxu Linux
Liangxu Linux
Nov 14, 2024 · Databases

Master SQLite with C: Essential Functions and Sample Code

This guide walks through using SQLite's C API—including opening databases, executing queries with and without callbacks, handling results, and performing insert, delete, and display operations—complete with code snippets, table schemas, and compilation instructions.

APISQLitec++
0 likes · 12 min read
Master SQLite with C: Essential Functions and Sample Code
Java Tech Enthusiast
Java Tech Enthusiast
Nov 14, 2024 · Backend Development

Comprehensive Backend Interview Q&A: Golang, Networking, OS, MySQL, Redis, Design Patterns, and Algorithms

The article presents recent tech-company salary figures and a comprehensive set of backend interview questions spanning Go language fundamentals, memory management, networking protocols, OS synchronization, MySQL transaction isolation and indexing, Redis performance, design‑pattern implementations, and classic algorithms such as quicksort.

AlgorithmsDesign PatternsGolang
0 likes · 11 min read
Comprehensive Backend Interview Q&A: Golang, Networking, OS, MySQL, Redis, Design Patterns, and Algorithms
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.

PHPdatabasemysql
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Linux Ops Smart Journey
Linux Ops Smart Journey
Nov 12, 2024 · Databases

Master PostgreSQL Monitoring with Grafana: Step-by-Step Guide

Learn how to deploy postgres_exporter, configure PostgreSQL extensions, set up Prometheus scraping, and create Grafana dashboards for comprehensive PostgreSQL performance monitoring, complete with command-line instructions and tips for verifying data collection and visualizing metrics.

GrafanaPrometheusdatabase
0 likes · 6 min read
Master PostgreSQL Monitoring with Grafana: Step-by-Step Guide
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.

Linuxdatabaselogging
0 likes · 5 min read
Database Monitoring and Logging Practices
Java Tech Enthusiast
Java Tech Enthusiast
Nov 9, 2024 · Databases

Java Connection Pool Optimization with HikariCP

The article examines Java connection pool technologies, comparing Commons Pool 2 with HikariCP and showing through JMH benchmarks that HikariCP delivers up to five‑times higher throughput, while detailing lifecycle management, configuration, eviction strategies, sizing best practices, and real‑world uses such as database, HTTP, and RPC connections.

Connection PoolHikariCPSpringBoot
0 likes · 12 min read
Java Connection Pool Optimization with HikariCP
DataFunSummit
DataFunSummit
Nov 8, 2024 · Artificial Intelligence

ChatDBA: An AI‑Powered Database Fault Diagnosis Assistant Using Retrieval‑Augmented Generation

ChatDBA, developed by Shanghai Aikesheng, is an AI-driven database operation assistant that leverages large language models and Retrieval‑Augmented Generation to provide fault diagnosis, knowledge learning, SQL generation and optimization, addressing challenges such as vague outputs, complex troubleshooting logic, and memory management through a structured architecture and multi‑modal retrieval strategies.

AIFault DiagnosisRAG
0 likes · 10 min read
ChatDBA: An AI‑Powered Database Fault Diagnosis Assistant Using Retrieval‑Augmented Generation
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.

DataMigrationShardingSphereSpringBoot
0 likes · 22 min read
Database Sharding Design and Implementation for Loan & Repayment Tables Using ShardingSphere and Spring Boot
Su San Talks Tech
Su San Talks Tech
Nov 6, 2024 · Databases

Why MySQL’s Case‑Insensitive Collation Returns Unexpected Duplicate Brands (and How to Fix It)

This article examines a puzzling MySQL case‑insensitive collation issue where a user‑defined brand "yoyo" cannot be saved because the database returns an existing uppercase "YOYO" entry, explains the underlying COLLATE settings, and proposes practical solutions to prevent duplicate brand data.

Brand ManagementUnique Indexcase-insensitive
0 likes · 8 min read
Why MySQL’s Case‑Insensitive Collation Returns Unexpected Duplicate Brands (and How to Fix It)
Java Architect Essentials
Java Architect Essentials
Nov 5, 2024 · Backend Development

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

This article provides a detailed tutorial on the Activiti 7 workflow engine, covering workflow concepts, BPMN modeling, environment configuration, Maven dependencies, database schema creation, deployment methods, process instance management, task handling, and historical data querying, with complete code examples for Java developers.

ActivitiBPMNProcessEngine
0 likes · 38 min read
Comprehensive Guide to Activiti 7 Workflow Engine: Concepts, Environment Setup, Deployment, and Usage
JD Retail Technology
JD Retail Technology
Nov 5, 2024 · Backend Development

Ensuring Inventory Consistency Under Concurrent Operations: Locking Pitfalls and Solutions

The article examines how frequent inventory adjustments in JD retail supply‑chain can suffer from concurrency issues, explains why traditional locking may fail, analyzes a real‑world case of lock misuse, and presents code‑level, database‑level, and architectural solutions to guarantee data consistency.

Consistencyconcurrencydatabase
0 likes · 7 min read
Ensuring Inventory Consistency Under Concurrent Operations: Locking Pitfalls and Solutions
Top Architect
Top Architect
Nov 2, 2024 · Backend Development

Optimizing MyBatis-Plus Batch Insert Performance with rewriteBatchedStatements and Multithreading

This article explains how to dramatically speed up MyBatis-Plus batch inserts by enabling the rewriteBatchedStatements JDBC property, creating custom batch insert/update methods, and applying multithreading, providing code examples, performance test results, and practical recommendations for handling large data synchronizations.

Batch Insertdatabasejava
0 likes · 15 min read
Optimizing MyBatis-Plus Batch Insert Performance with rewriteBatchedStatements and Multithreading
Java Tech Enthusiast
Java Tech Enthusiast
Nov 1, 2024 · Databases

Quick MySQL Configuration and Monitoring Queries

This guide presents essential MySQL configuration and monitoring queries—covering connection limits, Binlog/GTID status, InnoDB settings—plus a one‑click script that consolidates these checks, enabling quick health assessments and more efficient routine inspections of MySQL servers.

databasemonitoringmysql
0 likes · 2 min read
Quick MySQL Configuration and Monitoring Queries
Java Architect Essentials
Java Architect Essentials
Oct 29, 2024 · Backend Development

Optimizing Batch Insert Performance with MyBatis-Plus: Configuration, Custom Methods, and Multithreading

This article explains why MyBatis-Plus's saveBatch() can be slow for large data sets, shows how enabling rewriteBatchedStatements in the JDBC URL dramatically speeds up inserts, and demonstrates custom batch insert/update methods and multithreaded execution to further improve performance, complete with code examples and test results.

Batch Insertdatabasejava
0 likes · 14 min read
Optimizing Batch Insert Performance with MyBatis-Plus: Configuration, Custom Methods, and Multithreading
JavaEdge
JavaEdge
Oct 28, 2024 · Databases

Why Do MySQL Transactions Deadlock? Reproduce and Prevent InnoDB Deadlocks

This article explains how MySQL InnoDB deadlocks occur during order‑record idempotency checks, demonstrates step‑by‑step reproduction with SQL scripts, analyzes the lock types involved, and provides practical strategies to avoid and resolve such deadlocks in production systems.

InnoDBdatabasedeadlock
0 likes · 13 min read
Why Do MySQL Transactions Deadlock? Reproduce and Prevent InnoDB Deadlocks
php Courses
php Courses
Oct 24, 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 SELECT, INSERT, UPDATE, and DELETE operations, provides a complete example script with connection handling, query execution, result processing, and highlights related functions for fetching data.

PHPdatabasemysql
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Test Development Learning Exchange
Test Development Learning Exchange
Oct 24, 2024 · Databases

Comprehensive Testing of Business Data Migration in Enterprise Applications

This article details the comprehensive process of testing business data migration in enterprise applications, covering requirements analysis, environment preparation, test planning, data validation, performance testing, security checks, rollback strategies, and feedback mechanisms to ensure accuracy and integrity.

Data Migrationbackend-developmentdatabase
0 likes · 8 min read
Comprehensive Testing of Business Data Migration in Enterprise Applications
Top Architect
Top Architect
Oct 22, 2024 · Databases

EasyQuery – A High‑Performance Java ORM with Strongly Typed Query API

The article presents EasyQuery, a high‑performance, type‑safe Java ORM inspired by .NET solutions, demonstrating its query capabilities—including single‑record retrieval, pagination, joins, subqueries, streaming results, custom VO mapping, dynamic conditions, and native SQL fragments—while highlighting its advantages over MyBatis‑Plus.

ORMdatabaseeasyquery
0 likes · 15 min read
EasyQuery – A High‑Performance Java ORM with Strongly Typed Query API
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 22, 2024 · Databases

Analyzing OBServer Crash Logs with observer.log and gdb

This article explains how to locate OBServer crash logs, extract stack traces from observer.log, map memory addresses to source code using addr2line and gdb, identify the faulty function ObMPStmtExecute::copy_or_convert_str, and verify the issue through the OceanBase knowledge base, providing a systematic five‑step approach for rapid crash diagnosis.

CrashAnalysisOceanBasecoredump
0 likes · 9 min read
Analyzing OBServer Crash Logs with observer.log and gdb
php Courses
php Courses
Oct 22, 2024 · Backend Development

Using PHP mysqli_query to Execute MySQL Queries

This article explains how to use PHP's mysqli_query function to connect to a MySQL database, execute SELECT queries, handle result sets, and perform other operations such as INSERT, UPDATE, and DELETE, including a complete example code snippet and best practices for error handling.

PHPdatabasemysql
0 likes · 5 min read
Using PHP mysqli_query to Execute MySQL Queries
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Oct 19, 2024 · Databases

Understanding the HAVING Clause in SQL: Concepts, Examples, and Best Practices

This article explains the purpose and proper use of the SQL HAVING clause, contrasts it with WHERE, and provides multiple practical examples—including counting groups, detecting missing IDs, calculating mode and median, and filtering fully‑submitted records—while highlighting common pitfalls and performance considerations.

GROUP BYHAVINGaggregation
0 likes · 13 min read
Understanding the HAVING Clause in SQL: Concepts, Examples, and Best Practices
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Oct 18, 2024 · Databases

Master MySQL Performance: 20 Essential SQL Optimization Techniques

This article presents a comprehensive guide for Java engineers on MySQL query optimization, covering index usage, avoiding SELECT *, proper JOINs, efficient WHERE clauses, LIMIT, EXISTS vs IN, function indexes, connection pooling, batch processing, data types, execution plan analysis, materialized views, and regular performance monitoring, all illustrated with practical code examples.

SQL Optimizationdatabaseindexes
0 likes · 19 min read
Master MySQL Performance: 20 Essential SQL Optimization Techniques
ITPUB
ITPUB
Oct 17, 2024 · Databases

What’s New in MySQL 9.1.0? A Deep Dive into Features and Fixes

MySQL 9.1.0, released on October 15, 2024, introduces DDL atomicity, improved audit handling, new JavaScript defaults, VECTOR type support, enhanced GROUP REPLICATION logging, expanded EXPLAIN output, and numerous bug fixes across SQL syntax, performance, and security, while the 8.4.3 LTS patch remains feature‑free.

DDLGroupReplicationReleaseNotes
0 likes · 10 min read
What’s New in MySQL 9.1.0? A Deep Dive into Features and Fixes
Java Tech Enthusiast
Java Tech Enthusiast
Oct 17, 2024 · Fundamentals

Technical Interview Insights: Networking, TCP, HTTP, MySQL Locks, and C++ Level‑Order Traversal

The article explains why network protocols use layered design, details TCP's reliability and congestion‑control mechanisms, outlines HTTP status‑code categories, reviews MySQL lock scopes from global to row‑level, provides a C++ breadth‑first binary‑tree traversal example, and describes a three‑step weighing puzzle to find an odd ball.

AlgorithmsC++HTTP
0 likes · 15 min read
Technical Interview Insights: Networking, TCP, HTTP, MySQL Locks, and C++ Level‑Order Traversal
IT Services Circle
IT Services Circle
Oct 15, 2024 · Backend Development

Why C++ Graduates Struggle to Land Backend Development Jobs in Internet Companies and How to Improve Their Prospects

The article analyzes why C++‑focused graduates receive few backend interview opportunities at major internet firms, highlights the mismatch between C++ skill sets and common backend components, and offers practical advice on switching languages or augmenting projects to better align with industry demands.

C++GoJob Hunting
0 likes · 10 min read
Why C++ Graduates Struggle to Land Backend Development Jobs in Internet Companies and How to Improve Their Prospects
ITPUB
ITPUB
Oct 15, 2024 · Databases

Choosing the Right Database High‑Availability Architecture: Lessons from GBase 8s

The article explores the evolution of database high‑availability architectures, compares mainstream solutions like Oracle's HA, RAC and ADG, examines domestic offerings such as GBase 8s with HAC, RHAC and SSC clusters, and provides practical guidance for selecting cost‑effective HA designs to ensure continuous business operations.

EnterpriseGBaseHA Architecture
0 likes · 14 min read
Choosing the Right Database High‑Availability Architecture: Lessons from GBase 8s
Java Architect Essentials
Java Architect Essentials
Oct 11, 2024 · Backend Development

Mastering EasyQuery: A Strongly Typed Java ORM with Real‑World Query Examples

This article explains why the author created the EasyQuery ORM for Java, demonstrates a wide range of query patterns—including single‑record, pagination, joins, subqueries, streaming, custom VO mapping, dynamic conditions, grouping, native SQL, function columns, and high‑performance encryption—while providing complete code snippets and links to documentation and source repositories.

BackendORMdatabase
0 likes · 13 min read
Mastering EasyQuery: A Strongly Typed Java ORM with Real‑World Query Examples
Test Development Learning Exchange
Test Development Learning Exchange
Oct 11, 2024 · Backend Development

Comprehensive Python Scripts for Property Management System Functions

This article provides a collection of Python scripts that cover essential property management system features such as resident data handling, automated payment reminders, monthly report generation, emergency notifications, maintenance request processing, visitor logging, facility booking, vehicle entry/exit tracking, announcement publishing, and database backup.

Property ManagementPythonbackend-development
0 likes · 12 min read
Comprehensive Python Scripts for Property Management System Functions
macrozheng
macrozheng
Oct 11, 2024 · Backend Development

Does Spring Commit Before Unlock? Unraveling Transaction Timing in High‑Concurrency

This article dissects the exact moment a Spring @Transactional method commits relative to a surrounding lock, explains why committing after unlock can cause overselling, and provides source‑level debugging techniques to verify transaction start, commit, and rollback behavior in MySQL under high concurrency.

Lockconcurrencydatabase
0 likes · 21 min read
Does Spring Commit Before Unlock? Unraveling Transaction Timing in High‑Concurrency
Java Tech Enthusiast
Java Tech Enthusiast
Oct 9, 2024 · Databases

The History and Development of SQLite by Richard Hipp

SQLite, conceived by D. Richard Hipp after his naval‑ship software work revealed client‑server database fragility, became a self‑contained, byte‑code SQL engine that powers billions of devices—from early Motorola and Symbian adopters to Android’s default storage—maintained by a three‑person core team, an alliance of partners, and a rigorous 100 % MCDC test suite ensuring unmatched reliability.

Richard HippSQLitedatabase
0 likes · 13 min read
The History and Development of SQLite by Richard Hipp
Test Development Learning Exchange
Test Development Learning Exchange
Oct 5, 2024 · Fundamentals

Master Essential Python File, Network, and Data Operations in One Guide

This comprehensive guide walks you through core Python techniques for handling files and directories, making HTTP requests, processing data, managing system resources, performing text manipulation, executing mathematical calculations, building simple web applications, and interacting with various databases, all illustrated with ready‑to‑run code snippets.

File OperationsNetwork RequestsPython
0 likes · 27 min read
Master Essential Python File, Network, and Data Operations in One Guide
IT Services Circle
IT Services Circle
Oct 4, 2024 · Databases

Understanding Redis Split‑Brain: Causes, Data Loss, and Prevention Strategies

This article explains Redis split‑brain behavior, describing its definition, causes such as network failures and Sentinel elections, the resulting data loss during master‑slave switches, and practical prevention measures including quorum configuration, timeout tuning, network monitoring, proxy layers, and the min‑slaves‑to‑write and min‑slaves‑max‑lag settings.

Master‑SlaveSplit-Braindatabase
0 likes · 7 min read
Understanding Redis Split‑Brain: Causes, Data Loss, and Prevention Strategies
21CTO
21CTO
Oct 3, 2024 · Databases

MongoDB 8.0 Unveiled: Massive Performance Gains and New Vector Support

MongoDB 8.0 launches with up to 36% higher read throughput, 56% faster batch writes, 200% faster time‑series processing, 50‑fold faster sharding distribution, quantized vector search, and queryable encryption, delivering significant performance, cost, and security improvements for modern workloads.

MongoDBdatabaseencryption
0 likes · 4 min read
MongoDB 8.0 Unveiled: Massive Performance Gains and New Vector Support
IT Services Circle
IT Services Circle
Oct 1, 2024 · Databases

Effectiveness of Adding an Index on a Status Column in a Tens‑of‑Millions Row MySQL Table

This article explains how adding an index to a status column in a tens‑of‑millions‑row MySQL table affects query performance, covering the basic index lookup process, extreme cases where full scans are chosen, selectivity, covering indexes, composite indexes, partitioning, and using EXPLAIN to verify execution plans.

Partitioningdatabaseexplain
0 likes · 9 min read
Effectiveness of Adding an Index on a Status Column in a Tens‑of‑Millions Row MySQL Table
Efficient Ops
Efficient Ops
Sep 29, 2024 · Operations

Essential Linux Ops Tools Every Sysadmin Must Master

This guide outlines the ten core tool categories—from Linux basics and networking services to scripting, firewalls, monitoring, clustering, and backup—that a Linux operations engineer should master to become an effective sysadmin.

LinuxNetworkingOperations
0 likes · 6 min read
Essential Linux Ops Tools Every Sysadmin Must Master
Liangxu Linux
Liangxu Linux
Sep 28, 2024 · Databases

10 Advanced SQL Concepts Every Data Scientist Should Master

This guide walks through ten essential advanced SQL concepts—including CTEs, recursive queries, temporary functions, CASE‑based pivoting, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative totals, and date‑time manipulation—providing clear explanations and runnable examples to help data‑science professionals ace interview challenges.

Advanced QueriesCTEData Science
0 likes · 11 min read
10 Advanced SQL Concepts Every Data Scientist Should Master
ITPUB
ITPUB
Sep 28, 2024 · Databases

What’s New in PostgreSQL 17? A Deep Dive into Performance and Feature Boosts

PostgreSQL 17, announced on 2024‑09‑26, brings major performance upgrades, extensive SQL/JSON enhancements, improved logical replication, new security and management options, and a host of developer‑friendly features that position it as the world’s most advanced open‑source database.

Logical ReplicationSQL/JSONdatabase
0 likes · 14 min read
What’s New in PostgreSQL 17? A Deep Dive into Performance and Feature Boosts
dbaplus Community
dbaplus Community
Sep 25, 2024 · Databases

Segment‑wise Train Seat Allocation with SQL: A Practical Guide

The article recounts a personal experience of a failed train ticket change, analyzes segment‑wise seat availability, proposes a database model, and demonstrates a SQL query that allocates seats per segment, showing how such logic could enable full‑journey booking and even inspired a new feature on the 12306 platform.

OracleRailwaydatabase
0 likes · 10 min read
Segment‑wise Train Seat Allocation with SQL: A Practical Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2024 · Databases

Why Does a SELECT on performance_schema.data_locks Hang MySQL? Deep Dive & Fix

A batch INSERT triggers a massive lock record buildup, and a concurrent SELECT on performance_schema.data_locks causes a memory allocation error that leaves trx_sys‑mutex unreleased, leading to a full MySQL hang; the article reproduces the bug, analyses the stack, explains the root cause, and shows the official fix in MySQL 8.0.37.

Bug AnalysisInnoDBPerformance Schema
0 likes · 9 min read
Why Does a SELECT on performance_schema.data_locks Hang MySQL? Deep Dive & Fix
ITPUB
ITPUB
Sep 23, 2024 · Databases

Master PostgreSQL Table Partitioning: Types, Commands, and Best Practices

This guide explains PostgreSQL table partitioning, covering its definition, benefits, drawbacks, the three partition types (RANGE, LIST, HASH), step‑by‑step SQL commands for creating partitions, indexes, and managing them, and concludes with practical recommendations for effective use.

HashListPartitioning
0 likes · 10 min read
Master PostgreSQL Table Partitioning: Types, Commands, and Best Practices