BestHub
Sign in
Tagged articles

database

2754 articles · Page 5 of 28
Cognitive Technology Team
Cognitive Technology Team
Mar 24, 2025 · Databases

Understanding MySQL Replication: Architecture, Binlog Formats, Use Cases, and Best Practices

This article explains MySQL's replication mechanism, detailing master‑slave architecture, key threads, binlog formats (statement, row, mixed), common application scenarios such as backup, read/write splitting, and data migration, and highlights important considerations like network latency, consistency, delay, and security.

MySQLReplicationdatabase
0 likes · 7 min read
Understanding MySQL Replication: Architecture, Binlog Formats, Use Cases, and Best Practices
Architect's Must-Have
Architect's Must-Have
Mar 18, 2025 · Databases

Master MySQL Indexes: From Basics to B+Tree Optimization

This article explains what MySQL indexes are, how they work, their advantages and drawbacks, the different index types—including primary, ordinary, composite, full‑text, clustered and non‑clustered—and compares B‑Tree with B+Tree structures to help you design faster, more efficient queries.

B+TreeInnoDBMySQL
0 likes · 12 min read
Master MySQL Indexes: From Basics to B+Tree Optimization
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 14, 2025 · Databases

All About Redis Cluster: Architecture, Setup, Operations, and High‑Availability

This article provides a comprehensive guide to Redis Cluster, covering its background, overall architecture, deployment steps, configuration templates, cluster creation commands, basic key‑value operations, high‑availability testing, and how to manually assign master‑slave relationships for robust distributed caching.

ClusterRedisdatabase
0 likes · 14 min read
All About Redis Cluster: Architecture, Setup, Operations, and High‑Availability
Selected Java Interview Questions
Selected Java Interview Questions
Mar 13, 2025 · Backend Development

Implementing Dynamic Data Source Switching in Spring Boot with ThreadLocal and AbstractRoutingDataSource

This article demonstrates how to build a dynamic data source switching mechanism in Spring Boot by leveraging ThreadLocal for thread‑scoped context and AbstractRoutingDataSource for routing, covering manual implementation, annotation‑driven switching, and runtime addition of new data sources.

AbstractRoutingDataSourceDynamicDataSourceMybatisPlus
0 likes · 14 min read
Implementing Dynamic Data Source Switching in Spring Boot with ThreadLocal and AbstractRoutingDataSource
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Mar 12, 2025 · Databases

Comprehensive MySQL Core Commands Tutorial

This article provides a step‑by‑step guide to essential MySQL operations, covering connection methods, database creation and deletion, user management, password changes, data manipulation, query techniques, indexing strategies, performance tips, and backup procedures, all illustrated with complete command examples.

MySQLSQLbackup
0 likes · 7 min read
Comprehensive MySQL Core Commands Tutorial
Java Tech Enthusiast
Java Tech Enthusiast
Mar 11, 2025 · Databases

Performance Analysis of MySQL 5.7 to 8.0 Upgrade and ORDER BY Optimization

After upgrading from MySQL 5.7 to 8.0, a client observed that ORDER BY queries on wide SELECTs became dramatically slower because MySQL 8.0 deprecated the max_length_for_sort_data setting, causing the optimizer to perform full‑field sorting instead of index‑based sorting; adding an index on the ordered column restores performance.

MySQLPerformanceSQL optimization
0 likes · 6 min read
Performance Analysis of MySQL 5.7 to 8.0 Upgrade and ORDER BY Optimization
dbaplus Community
dbaplus Community
Mar 9, 2025 · Databases

Why a 2‑Billion‑Old PostgreSQL Transaction Can Crash Your Database

The article explains how PostgreSQL’s MVCC model, tuple visibility, and 32‑bit transaction ID wrap‑around can cause “sudden death” of old rows, why billions of old transactions may render data invisible, and how vacuuming and freezing prevent catastrophic database failures.

MVCCPostgreSQLTransaction ID
0 likes · 9 min read
Why a 2‑Billion‑Old PostgreSQL Transaction Can Crash Your Database
Code Mala Tang
Code Mala Tang
Mar 9, 2025 · Databases

When Should You Use UUIDs in Databases? Pros, Cons, and Better Alternatives

UUIDs offer global uniqueness for distributed systems but can hurt insertion speed and increase storage, especially with random UUIDv4 keys; this article explains UUID basics, performance drawbacks, and evaluates alternatives like UUIDv7, auto‑increment integers, and ULID to help you choose the right identifier for your database.

PerformanceStorageUUID
0 likes · 9 min read
When Should You Use UUIDs in Databases? Pros, Cons, and Better Alternatives
php Courses
php Courses
Mar 6, 2025 · Backend Development

Using mysqli_fetch_assoc to Retrieve Query Results in PHP

This article explains how to connect to a MySQL database using mysqli in PHP, execute a SELECT query, and retrieve each row with the mysqli_fetch_assoc function, providing complete example code and notes on handling results and closing the connection.

MySQLiPHPdatabase
0 likes · 3 min read
Using mysqli_fetch_assoc to Retrieve Query Results in PHP
php Courses
php Courses
Mar 6, 2025 · Databases

10 Essential MySQLi Functions to Boost PHP Development Efficiency and Security

This article introduces ten powerful MySQLi functions—including prepared statements, parameter binding, result retrieval, batch queries, transaction control, charset setting, and connection monitoring—that enhance PHP developers’ ability to write secure, efficient, and maintainable code when interacting with MySQL databases.

PHPPerformancedatabase
0 likes · 6 min read
10 Essential MySQLi Functions to Boost PHP Development Efficiency and Security
Architect's Guide
Architect's Guide
Mar 6, 2025 · Databases

Common Practices for Database Sharding and Pagination Optimization

This article explains typical sharding strategies—hash, range, and middle‑table—describes SDK, Proxy, and Sidecar middleware forms, and presents several pagination optimization techniques such as global query rewriting, average pagination, disabling cross‑page queries, secondary queries, and using intermediate tables to improve performance in distributed databases.

SQLdatabasepagination
0 likes · 17 min read
Common Practices for Database Sharding and Pagination Optimization
Sohu Tech Products
Sohu Tech Products
Mar 5, 2025 · Databases

Redis Persistence Mechanisms: AOF, RDB, and Hybrid Persistence

Redis offers three persistence options—AOF, which logs every write command; RDB, which creates periodic snapshots; and hybrid persistence, which combines both—to balance data safety, recovery speed, file size, and performance, with configurable settings for sync policies, rewrite processes, and compression.

AOFHybrid PersistencePersistence
0 likes · 20 min read
Redis Persistence Mechanisms: AOF, RDB, and Hybrid Persistence
dbaplus Community
dbaplus Community
Mar 4, 2025 · Databases

Why Does Redis Prefer Hash Slots Over Consistent Hashing?

Redis Cluster distributes data using 16,384 hash slots calculated via CRC16, a design that offers flexible slot allocation, simpler data migration, and better performance compared to traditional consistent hashing, and this article explains the slot mechanism, node scaling, client routing, and the reasons behind the 16K slot choice.

CRC16Hash SlotsRedis
0 likes · 9 min read
Why Does Redis Prefer Hash Slots Over Consistent Hashing?
php Courses
php Courses
Mar 4, 2025 · 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 statements, process result sets with mysqli_fetch_assoc, and handle other query types such as INSERT, UPDATE, and DELETE, including full example code and best practices.

BackendPHPdatabase
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
php Courses
php Courses
Mar 3, 2025 · Databases

MySQL Installation, Configuration, and Basic SQL Commands Guide

This guide explains how to download, install, and verify MySQL on Windows, macOS, and Linux, configure the server and user permissions, and demonstrates essential SQL commands for creating databases, tables, and manipulating data, providing a comprehensive introduction for beginners.

Configurationdatabase
0 likes · 6 min read
MySQL Installation, Configuration, and Basic SQL Commands Guide
Cognitive Technology Team
Cognitive Technology Team
Mar 1, 2025 · Databases

Async IO Thread in Redis 8.0 M3: Design, Implementation, and Performance Evaluation

The article explains why Redis needs asynchronous IO threading, describes the shortcomings of previous IO‑thread models, details the design of the new async IO thread architecture with event‑notified client queues and thread‑safety mechanisms, and presents performance test results showing up to double the QPS and significantly lower latency.

IO threadsPerformanceRedis
0 likes · 15 min read
Async IO Thread in Redis 8.0 M3: Design, Implementation, and Performance Evaluation
Cognitive Technology Team
Cognitive Technology Team
Mar 1, 2025 · Databases

Understanding and Mitigating Redis Large‑Key Issues

The article explains what constitutes a Redis large key, outlines its performance and stability risks, describes common scenarios and root causes, and provides practical detection commands, mitigation techniques such as splitting, compression, proper data modeling, and monitoring strategies to prevent future issues.

Large KeyMemory OptimizationPerformance
0 likes · 6 min read
Understanding and Mitigating Redis Large‑Key Issues
ITPUB
ITPUB
Mar 1, 2025 · Artificial Intelligence

Can DeepSeek AI Replace Your DBA? Real-World Database Scenarios Tested

This article examines DeepSeek, a Chinese AGI‑focused AI model, explains prompt‑engineering techniques, and evaluates its performance across database architecture, development, and operations tasks through concrete Q&A examples, SQL plan analysis, and shell‑script generation, while also discussing its broader impact on professionals, vendors and enterprises.

AIDeepSeekSQL optimization
0 likes · 10 min read
Can DeepSeek AI Replace Your DBA? Real-World Database Scenarios Tested
Cognitive Technology Team
Cognitive Technology Team
Feb 28, 2025 · Databases

Why Redis Is So Fast: An In‑Depth Analysis of Its High‑Performance Design

Redis achieves exceptional speed by storing all data in memory, using a single‑threaded event‑driven architecture with epoll/kqueue, employing efficient I/O multiplexing, optimizing data structures such as strings, hashes and sorted sets, and providing flexible persistence and high‑availability options, all of which are detailed in this article.

In-MemoryPerformanceRedis
0 likes · 7 min read
Why Redis Is So Fast: An In‑Depth Analysis of Its High‑Performance Design
IT Services Circle
IT Services Circle
Feb 27, 2025 · Fundamentals

Comprehensive Linux C/C++ Interview Questions and Topics

This article compiles a wide range of Linux C/C++ interview questions covering language fundamentals, data structures, algorithms, operating systems, networking, databases, and general problem‑solving approaches to help candidates assess and improve their technical knowledge.

C++Data StructuresLinux
0 likes · 9 min read
Comprehensive Linux C/C++ Interview Questions and Topics
php Courses
php Courses
Feb 26, 2025 · Backend Development

Using mysqli_fetch_assoc to Retrieve Query Results in PHP

This article demonstrates how to connect to a MySQL database using mysqli, execute SELECT queries, and retrieve results row by row with the mysqli_fetch_assoc function in PHP, providing complete code examples for connection, querying, result iteration, and proper resource cleanup.

Backend DevelopmentMySQLMySQLi
0 likes · 4 min read
Using mysqli_fetch_assoc to Retrieve Query Results in PHP
Sanyou's Java Diary
Sanyou's Java Diary
Feb 20, 2025 · Databases

How Redis Sentinel Ensures Automatic Failover and High Availability

Redis Sentinel provides a robust high‑availability solution by monitoring master‑slave clusters, automatically detecting failures, electing leaders, and performing failover, while using quorum voting, Pub/Sub communication, and configuration provisioning to ensure seamless master promotion and client redirection without manual intervention.

RedisSentineldatabase
0 likes · 16 min read
How Redis Sentinel Ensures Automatic Failover and High Availability
Pan Zhi's Tech Notes
Pan Zhi's Tech Notes
Feb 20, 2025 · Databases

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

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

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

How to Set Up a PHP Development Environment on Windows, macOS, and Linux

This guide explains step‑by‑step how to prepare the operating system, install required software, configure PHP and web servers, and test the setup on Windows, macOS, and Linux, providing practical tips and troubleshooting for a stable PHP development environment.

ConfigurationInstallationPHP
0 likes · 6 min read
How to Set Up a PHP Development Environment on Windows, macOS, and Linux
dbaplus Community
dbaplus Community
Feb 17, 2025 · Databases

How Machine Learning Transforms SQL Performance Anomaly Diagnosis

This article summarizes Professor Cai Peng's presentation on diagnosing online database performance anomalies, covering traditional rule‑based and statistical root‑cause SQL methods, novel learning‑based techniques such as adaptive time‑window selection and multi‑metric analysis, experimental results, and real‑world case studies.

MachineLearningRootCausedatabase
0 likes · 16 min read
How Machine Learning Transforms SQL Performance Anomaly Diagnosis
IT Services Circle
IT Services Circle
Feb 13, 2025 · Databases

Resolving ORA-000060 Deadlock in Oracle Batch Updates with MyBatis

The article describes a production deadlock (ORA-000060) caused by unsorted, duplicate user_id rows in a file processed in parallel batch updates, shows MyBatis XML code, illustrates conflicting thread execution, and provides practical solutions such as sorting the input and deduplicating records.

Batch UpdateMyBatisOracle
0 likes · 4 min read
Resolving ORA-000060 Deadlock in Oracle Batch Updates with MyBatis
php Courses
php Courses
Feb 13, 2025 · Backend Development

Using NativePHP to Extend Laravel for Efficient Desktop Applications

This article explains how to leverage the NativePHP library within the Laravel framework to build high‑performance desktop applications by executing CLI commands, manipulating the file system, and performing database operations with native PHP code examples.

CLIDesktop applicationFile System
0 likes · 4 min read
Using NativePHP to Extend Laravel for Efficient Desktop Applications
php Courses
php Courses
Feb 12, 2025 · 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.

MySQLPHPSQL
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Pan Zhi's Tech Notes
Pan Zhi's Tech Notes
Feb 10, 2025 · Information Security

Is Your Site Vulnerable? Understanding the Common SQL Injection Attack

This article explains the fundamentals of SQL injection attacks, demonstrates step‑by‑step exploitation using the DVWA platform—including data extraction, login bypass, and injection point detection—and outlines practical prevention techniques such as input validation, regex filtering, and prepared statements.

DVWAMySQLSQL injection
0 likes · 11 min read
Is Your Site Vulnerable? Understanding the Common SQL Injection Attack
Raymond Ops
Raymond Ops
Feb 6, 2025 · Databases

Master MongoDB Config: System Log, Network, Security & More

This article provides a comprehensive overview of MongoDB's configuration file, detailing system log options, process management, network settings, security parameters, storage engine configurations, slow query profiling, replication, sharding, and mongos-specific settings, with explanations of each option and recommended defaults.

MongoDBReplicationdatabase
0 likes · 12 min read
Master MongoDB Config: System Log, Network, Security & More
DataFunSummit
DataFunSummit
Feb 3, 2025 · Databases

NL2SQL from a Database Perspective: Overview, History, and Laboratory Projects (GAR, MetaSQL, PURPLE)

This article presents a comprehensive overview of NL2SQL, covering its definition, motivations, application scenarios, key technical components, evaluation metrics, historical development stages, and detailed descriptions of three laboratory projects—GAR, MetaSQL, and PURPLE—along with future research directions and a Q&A session.

AIMetaSQLNL2SQL
0 likes · 17 min read
NL2SQL from a Database Perspective: Overview, History, and Laboratory Projects (GAR, MetaSQL, PURPLE)
IT Services Circle
IT Services Circle
Feb 2, 2025 · Databases

Performance Comparison of MySQL COUNT Queries on InnoDB and MyISAM

This article experimentally compares the performance of various MySQL COUNT queries on an InnoDB table with one million rows, explains the underlying execution plans using EXPLAIN, analyzes primary‑key versus secondary‑index behavior, and contrasts InnoDB’s fast count implementation.

COUNTEXPLAINInnoDB
0 likes · 9 min read
Performance Comparison of MySQL COUNT Queries on InnoDB and MyISAM
Lobster Programming
Lobster Programming
Feb 2, 2025 · Backend Development

How to Prevent Redis Cache Avalanche, Breakdown, and Penetration

This article explains the three major Redis cache issues—cache avalanche, cache breakdown, and cache penetration—how they can overload databases, and provides practical solutions such as high‑availability deployment, appropriate key expiration, local caches, mutex locks, empty‑object caching, request validation, and Bloom filters.

PerformanceRediscache
0 likes · 5 min read
How to Prevent Redis Cache Avalanche, Breakdown, and Penetration
Top Architect
Top Architect
Jan 31, 2025 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article explains why MySQL alone struggles with large‑scale, complex queries, introduces Elasticsearch as a high‑performance search engine, and compares several synchronization approaches—including synchronous and asynchronous dual‑write, Logstash, binlog real‑time sync, Canal, and Alibaba Cloud DTS—highlighting their pros, cons, and suitable scenarios.

CanalElasticsearchLogstash
0 likes · 14 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
IT Services Circle
IT Services Circle
Jan 31, 2025 · Databases

Common MySQL Commands and Practical Usage Guide

This article provides a comprehensive, step‑by‑step guide to essential MySQL commands—including connection, process inspection, variable queries, lock information, transaction status, engine details, character set checks, import/export, index management, table creation, stored procedures, and view creation—complete with example code snippets for each operation.

AdministrationMySQLSQL
0 likes · 12 min read
Common MySQL Commands and Practical Usage Guide
MaGe Linux Operations
MaGe Linux Operations
Jan 30, 2025 · Databases

Master Redis Data Types and Commands: Strings, Hashes, Lists, Sets, Sorted Sets

This guide provides a comprehensive overview of Redis data structures—including strings, hashes, lists, sets, and sorted sets—along with essential commands for creating, reading, updating, and deleting keys, managing expirations, and performing set operations, enabling developers to effectively leverage Redis as a high‑performance NoSQL database.

Data TypesNoSQLRedis
0 likes · 31 min read
Master Redis Data Types and Commands: Strings, Hashes, Lists, Sets, Sorted Sets
Raymond Ops
Raymond Ops
Jan 25, 2025 · Databases

Master MongoDB Replication Sets and Sharding: Step‑by‑Step Guide

This comprehensive guide walks you through MongoDB replica set fundamentals, member roles, architecture, and configuration commands, then dives into sharding concepts, cluster components, chunk management, shard key selection, deployment steps, balancing operations, and practical troubleshooting tips, all illustrated with clear code examples and diagrams.

MongoDBReplicationdatabase
0 likes · 34 min read
Master MongoDB Replication Sets and Sharding: Step‑by‑Step Guide
JD Tech
JD Tech
Jan 23, 2025 · Databases

Comprehensive Migration Plan for MongoDB to Alternative Data Stores

This article presents a complete MongoDB migration solution, detailing the migration rhythm, code refactoring using a decorator pattern, data source replacement with JImKV, MySQL and ES, bulk and incremental data transfer strategies, and deployment safeguards such as monitoring, gray release, and rollback to ensure a seamless cut‑over without service disruption.

Decorator PatternMongoDBdata migration
0 likes · 8 min read
Comprehensive Migration Plan for MongoDB to Alternative Data Stores
Su San Talks Tech
Su San Talks Tech
Jan 23, 2025 · Backend Development

How to Prevent Overselling in High‑Concurrency Flash Sale Systems

This article explores common overselling problems in high‑concurrency flash‑sale scenarios and presents seven practical solutions—including lock timing adjustments, AOP locking, pessimistic and optimistic database locks, and queue‑based approaches—each illustrated with SpringBoot code and performance test results.

JavaLockSpringBoot
0 likes · 20 min read
How to Prevent Overselling in High‑Concurrency Flash Sale Systems
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 21, 2025 · Databases

New and Changed Features in MySQL 9.2.0

MySQL 9.2.0 introduces the CREATE_SPATIAL_REFERENCE_SYSTEM privilege, JavaScript library support, enhanced SQL stored routine APIs, ENUM and SET handling, EXPLAIN FORMAT=JSON version 2, while deprecating several version‑token functions and privileges and removing keyword restrictions, providing a comprehensive overview of additions, deprecations, and removals.

JavaScriptMySQLNewFeatures
0 likes · 9 min read
New and Changed Features in MySQL 9.2.0
JD Tech Talk
JD Tech Talk
Jan 20, 2025 · Backend Development

Inventory Pre-Reservation: Challenges, Solutions, and Performance Optimizations

The article examines inventory pre‑reservation in e‑commerce, detailing performance challenges under high concurrency, and evaluates solutions such as asynchronous rate limiting, horizontal stock splitting, Redis caching, database transaction handling, deadlock avoidance, and data consistency mechanisms, highlighting a 24‑fold throughput increase.

Inventorycachingconcurrency
0 likes · 9 min read
Inventory Pre-Reservation: Challenges, Solutions, and Performance Optimizations
Architect
Architect
Jan 18, 2025 · Backend Development

Mastering High‑Concurrency Flash‑Sale: 7 Locking & Queue Strategies in SpringBoot

This article analyzes a high‑concurrency flash‑sale scenario using SpringBoot, MySQL, and JMeter, demonstrates seven implementations—from service‑level locks to AOP, pessimistic/optimistic locks, and queue‑based designs—examines their trade‑offs with concrete code, test results, and practical recommendations.

JMeterLockQueue
0 likes · 20 min read
Mastering High‑Concurrency Flash‑Sale: 7 Locking & Queue Strategies in SpringBoot
Linux Cloud Computing Practice
Linux Cloud Computing Practice
Jan 17, 2025 · Operations

10 Essential Linux Sysadmin Tools Every Engineer Should Master

This guide outlines the ten fundamental Linux operations tools and skills—ranging from basic system knowledge and networking services to shell scripting, text processing, databases, firewalls, monitoring, clustering, and backup—that every aspiring sysadmin should learn and practice thoroughly.

NetworkingOperationsdatabase
0 likes · 6 min read
10 Essential Linux Sysadmin Tools Every Engineer Should Master
Sohu Tech Products
Sohu Tech Products
Jan 15, 2025 · Backend Development

Deep Dive into Druid Connection Pool: Initialization, Retrieval, and Recycling Explained

This technical guide breaks down Alibaba's Druid JDBC connection pool, detailing its initialization process, how connections are fetched and returned, the internal threads and condition‑signal coordination, execution handling, recommended configurations, and monitoring integration, all illustrated with code snippets and diagrams.

ConfigurationDruidJava
0 likes · 23 min read
Deep Dive into Druid Connection Pool: Initialization, Retrieval, and Recycling Explained
vivo Internet Technology
vivo Internet Technology
Jan 15, 2025 · Databases

Redis Persistence Mechanisms: AOF, RDB, and Hybrid Persistence

Redis offers three persistence options—Append‑Only File (AOF) which logs every write, RDB snapshots that capture point‑in‑time data, and a hybrid mode combining both—each configurable with trade‑offs in durability, recovery speed, file size, and performance to suit different application needs.

AOFPersistenceRDB
0 likes · 21 min read
Redis Persistence Mechanisms: AOF, RDB, and Hybrid Persistence
Java Tech Enthusiast
Java Tech Enthusiast
Jan 15, 2025 · Databases

How SQL Statements Are Executed in a Database

When a client sends an SQL statement over TCP, the parser checks syntax and semantics and builds a query tree, the optimizer evaluates possible execution plans using statistics to estimate costs and selects the most efficient one, and the executor runs the plan, using the buffer manager for reads or the transaction manager for updates while the lock manager enforces ACID properties.

OptimizationSQLdatabase
0 likes · 3 min read
How SQL Statements Are Executed in a Database
Programmer1970
Programmer1970
Jan 14, 2025 · Databases

MySQL Interview Scenario: Advanced SQL Analytics with Joins, Subqueries, and Window Functions

This article presents an e‑commerce interview case that defines three tables (orders, order_items, products), loads sample data, and walks through a step‑by‑step SQL solution using CTEs, aggregation, window functions and HAVING to calculate each customer's total spend, most expensive order, and favorite product category, filtering and sorting the results.

AggregationCTEMySQL
0 likes · 9 min read
MySQL Interview Scenario: Advanced SQL Analytics with Joins, Subqueries, and Window Functions
php Courses
php Courses
Jan 14, 2025 · Databases

MySQL 8 New Features and Network Communication Course Overview

This course introduces MySQL 8's latest features—including performance optimizations, security enhancements, and new data types—while deeply exploring its network communication mechanisms, advanced optimization techniques, and hands‑on projects to improve database performance and security.

CourseMySQLPerformance
0 likes · 3 min read
MySQL 8 New Features and Network Communication Course Overview
IT Services Circle
IT Services Circle
Jan 13, 2025 · Backend Development

Compilation of Common Backend Interview Questions and Answers for Small Companies

This article presents a comprehensive collection of written‑test and interview questions covering Java basics, Spring MVC annotations, JVM memory, garbage collection, database design, transaction management, distributed systems, version control, and development workflow, aimed at helping candidates prepare for small‑company technical interviews.

BackendGitJVM
0 likes · 6 min read
Compilation of Common Backend Interview Questions and Answers for Small Companies
MaGe Linux Operations
MaGe Linux Operations
Jan 11, 2025 · Databases

Step-by-Step Guide to Installing and Configuring MySQL on Windows

This article walks you through MySQL's default ports, provides a concise introduction, details how to download the Community Server, explains extraction, environment variable setup, configuration file creation, service registration, and shows essential commands for initializing, starting, stopping, and managing MySQL users on Windows.

ConfigurationInstallationMySQL
0 likes · 8 min read
Step-by-Step Guide to Installing and Configuring MySQL on Windows
php Courses
php Courses
Jan 10, 2025 · Backend Development

Implementing Logistics Tracking in a PHP E‑commerce Application

This guide outlines how to add a logistics tracking feature to a PHP e‑commerce site by collecting tracking data, integrating a courier API, parsing and storing the information, displaying it to users, and regularly updating the status to enhance trust and user satisfaction.

APIPHPdatabase
0 likes · 4 min read
Implementing Logistics Tracking in a PHP E‑commerce Application
Zhuanzhuan Tech
Zhuanzhuan Tech
Jan 9, 2025 · Databases

Understanding Druid Connection Pool: Initialization, Connection Acquisition, Execution, and Recycling

This article provides a comprehensive technical walkthrough of the Druid database connection pool, covering its architecture, initialization flow, connection acquisition and release mechanisms, execution and exception handling, as well as recommended configurations and monitoring practices for optimal performance.

DruidJavaconnection pool
0 likes · 23 min read
Understanding Druid Connection Pool: Initialization, Connection Acquisition, Execution, and Recycling
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 9, 2025 · Databases

Performance Improvements in MySQL 8.4.3 and 9.1.0: Benchmark Results and Key Optimizations

The article reports that MySQL versions 8.4.3 and 9.1.0 deliver notable performance gains across a variety of workloads, explains the benchmark methodology, presents quantitative QPS improvements, and details four key internal changes—including a binlog data‑structure switch, JOIN optimizations, and enhanced index range scans—that together raise write and read throughput by several percent.

MySQLOptimizationbenchmark
0 likes · 6 min read
Performance Improvements in MySQL 8.4.3 and 9.1.0: Benchmark Results and Key Optimizations
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.

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

LLMNatural Language ProcessingText-to-SQL
0 likes · 18 min read
Unlocking LLM-Powered Text-to-SQL: From Basics to Cutting-Edge Techniques
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 ExampleRedisSet Operations
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.

ClickHouseQuery InconsistencyReplication
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.

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

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

Backend DevelopmentFile SystemPHP
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.

MySQLdatabaselarge tables
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.

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

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

Cloud ComputingDBOSPostgreSQL
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.

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

Cloud ComputingDBOSSpark
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.

JavaMyBatisORM
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
Top Architect
Top Architect
Dec 10, 2024 · Databases

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

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

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

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

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

FunctionsMySQLPerformance
0 likes · 14 min read
Master MySQL: 13 Essential Functions & Commands Every Developer Should Know
dbaplus Community
dbaplus Community
Dec 8, 2024 · Databases

Why Do JDBC Queries Hang? Understanding Timeout Mechanisms and Fixes

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

JDBCMySQLSpring
0 likes · 11 min read
Why Do JDBC Queries Hang? Understanding Timeout Mechanisms and Fixes