BestHub
Sign in
Tagged articles

Database

2745 articles · Page 10 of 28
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Oct 23, 2023 · Backend Development

Boost Spring Performance: AOP Logging, Caching, Thread Pools & DB Optimizations

This article presents practical Spring performance optimization techniques—including AOP‑based logging, second‑level caching with @Cacheable, reducing database queries via fetch strategies, employing thread‑pool executors, and general database query tuning—to improve application speed and resource efficiency.

AOPDatabasePerformance
0 likes · 9 min read
Boost Spring Performance: AOP Logging, Caching, Thread Pools & DB Optimizations
Java Architect Essentials
Java Architect Essentials
Oct 17, 2023 · Databases

Understanding LEFT JOIN ON vs WHERE Conditions in SQL

This article explains how LEFT JOIN works in SQL, clarifying the difference between ON‑clause conditions that affect the join process and WHERE‑clause filters that operate on the resulting temporary table, using multiple example queries and visual illustrations.

DatabaseLeft JoinON clause
0 likes · 5 min read
Understanding LEFT JOIN ON vs WHERE Conditions in SQL
Top Architect
Top Architect
Oct 17, 2023 · Backend Development

Implementation and Comparison of Fluent MyBatis, Native MyBatis, and MyBatis‑Plus for Student Score Statistics

This article presents a typical requirement to calculate count, minimum, maximum, and average scores for three subjects in a student_score table, demonstrates how to fulfill it using raw SQL, then shows step‑by‑step implementations with Fluent MyBatis, native MyBatis XML, and MyBatis‑Plus code generation, and finally compares the three approaches highlighting their pros and cons.

DatabaseFluent-MyBatisJava
0 likes · 9 min read
Implementation and Comparison of Fluent MyBatis, Native MyBatis, and MyBatis‑Plus for Student Score Statistics
MaGe Linux Operations
MaGe Linux Operations
Oct 17, 2023 · Databases

How Large Linux Pages Can Boost Database Throughput on Kubernetes by Up to 8×

This article explains how Linux page size, especially using 2 MB or 1 GB huge pages, dramatically improves database throughput on Kubernetes nodes—showing up to an eight‑fold increase for 4 KB pages—by reducing TLB misses and optimizing memory access, and provides practical guidance for configuring huge pages in various environments.

DatabaseHugePagesKubernetes
0 likes · 12 min read
How Large Linux Pages Can Boost Database Throughput on Kubernetes by Up to 8×
php Courses
php Courses
Oct 16, 2023 · Backend Development

Techniques to Optimize PHP and MySQL Access Speed

This article presents practical methods—including indexing, query consolidation, field selection, PHP code refinements, and caching strategies with Redis and page caching—to significantly improve the performance of PHP‑MySQL applications, accompanied by concrete code examples.

DatabaseMySQLOptimization
0 likes · 6 min read
Techniques to Optimize PHP and MySQL Access Speed
IT Services Circle
IT Services Circle
Oct 15, 2023 · Backend Development

Comprehensive Tencent Backend Development Interview Review: Java, OS, Networking, Algorithms, Databases and System Design

This article provides a detailed walkthrough of a Tencent backend interview covering Java thread models, HashMap internals, garbage collection, operating‑system concepts, process scheduling, IPC mechanisms, I/O multiplexing, virtual memory, networking protocols, Redis data types, MySQL B+‑tree characteristics, and a classic logic puzzle, offering both theory and practical insights.

DatabaseJavabackend interview
0 likes · 38 min read
Comprehensive Tencent Backend Development Interview Review: Java, OS, Networking, Algorithms, Databases and System Design
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Oct 12, 2023 · Backend Development

Mastering Spring Transaction Timeouts: Configurations, Tests, and Internals

This article explains how to configure transaction timeout in Spring 5.3.23 using annotations and programmatic approaches, demonstrates four test scenarios with a large table, analyzes the resulting timeout exceptions, and delves into the underlying mechanisms in DataSourceTransactionManager, JdbcTemplate, and related utility classes.

DatabaseJavaSpring
0 likes · 8 min read
Mastering Spring Transaction Timeouts: Configurations, Tests, and Internals
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 11, 2023 · Databases

Implementing Auto‑Increment Primary Keys When Migrating MySQL to OB Oracle

This article demonstrates two practical approaches for handling MySQL auto‑increment columns during migration to OB Oracle—creating custom sequences with DBCAT and using the GENERATED BY DEFAULT AS IDENTITY attribute—provides step‑by‑step commands, scripts, and validation results to help DBA engineers achieve seamless primary‑key migration.

Auto-IncrementDataXDatabase
0 likes · 16 min read
Implementing Auto‑Increment Primary Keys When Migrating MySQL to OB Oracle
php Courses
php Courses
Oct 9, 2023 · Backend Development

Debugging and Optimizing Database Connections in PHP

This article explains how to debug and optimize PHP database connections using PDO and mysqli, demonstrates error handling and logging techniques, and presents performance improvements such as persistent connections, connection pooling, and query optimization with practical code examples.

DatabaseDebuggingOptimization
0 likes · 6 min read
Debugging and Optimizing Database Connections in PHP
php Courses
php Courses
Oct 7, 2023 · Backend Development

PHP Performance Optimization Techniques and Functions

This article outlines key PHP performance optimization strategies—including caching with Memcache or Redis, using efficient database access via PDO, selecting optimal loop constructs like foreach and array_map, and avoiding redundant function calls—to improve execution speed and user experience.

DatabaseLoopsOptimization
0 likes · 5 min read
PHP Performance Optimization Techniques and Functions
Su San Talks Tech
Su San Talks Tech
Oct 6, 2023 · Databases

How MySQL Executes SQL: From Connection Pools to Log Files Explained

This article walks through how a Java application interacts with MySQL, covering the driver, connection pooling, thread handling, query parsing, the optimizer, storage engine, buffer pool, undo/redo logs, binlog, and transaction commit, providing a complete end‑to‑end view of MySQL’s internal processing.

DatabaseInnoDBMySQL
0 likes · 22 min read
How MySQL Executes SQL: From Connection Pools to Log Files Explained
ITPUB
ITPUB
Sep 28, 2023 · Databases

Mastering MySQL Index Merge: How Three Algorithms Boost Query Performance

Learn how MySQL's index merge optimization works, explore its three algorithms—intersect, union, and sort_union—understand when each applies, see practical setup and sample queries, and discover configuration flags and best‑practice tips to improve query efficiency.

DatabaseMySQLQuery Optimization
0 likes · 9 min read
Mastering MySQL Index Merge: How Three Algorithms Boost Query Performance
Selected Java Interview Questions
Selected Java Interview Questions
Sep 27, 2023 · Databases

Understanding MySQL Binlog and Its Business Applications

This article explains MySQL's binlog as a binary log for recording data changes and master‑slave replication, then explores how parsing binlog can enable data heterogeneity, cache consistency, and task distribution, highlighting its role in building middleware solutions for backend systems.

Data synchronizationDatabasereplication
0 likes · 5 min read
Understanding MySQL Binlog and Its Business Applications
php Courses
php Courses
Sep 27, 2023 · Backend Development

Building a Simple Online Recruitment System with PHP

This article explains how to design and implement a basic online recruitment platform using PHP, covering requirement analysis, system architecture, database schema, front‑end layout, back‑end logic, and provides a complete code example for user registration, illustrating the core functionalities of such a system.

DatabasePHPRecruitment System
0 likes · 5 min read
Building a Simple Online Recruitment System with PHP
php Courses
php Courses
Sep 26, 2023 · Databases

Best Practices for MySQL Backup: Strategy, Tools, Automation, and Recovery

This guide outlines a comprehensive MySQL backup solution, covering backup strategy planning, choosing physical versus logical backups, using tools like mysqldump and Percona XtraBackup, automating backups with scripts and cron, storage and retention considerations, and regular recovery testing to ensure data integrity.

DatabaseMySQLPercona XtraBackup
0 likes · 5 min read
Best Practices for MySQL Backup: Strategy, Tools, Automation, and Recovery
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Sep 20, 2023 · Databases

How Huawei’s Multi‑Master Cloud Database Beats Aurora and CockroachDB

The article explains Huawei's VLDB 2023 paper on a cloud‑native multi‑master database, detailing its architecture, novel VS‑clock and hybrid lock techniques, and presents extensive performance experiments that show near‑linear scalability and superior throughput and latency compared with Aurora and CockroachDB.

DatabasePerformancecloud-native
0 likes · 19 min read
How Huawei’s Multi‑Master Cloud Database Beats Aurora and CockroachDB
php Courses
php Courses
Sep 20, 2023 · Backend Development

PHP stripslashes() Function: Syntax, Usage, and Precautions

The article explains PHP's stripslashes() function, its syntax, how to use it for removing backslash escapes in strings and database results, precautions such as escape order and scope, and best practices for safe string handling.

DatabasePHPaddslashes
0 likes · 6 min read
PHP stripslashes() Function: Syntax, Usage, and Precautions
DaTaobao Tech
DaTaobao Tech
Sep 18, 2023 · Databases

Comprehensive Approach to Slow SQL Detection and Governance

The Taobao platform’s slow‑SQL governance team implemented a comprehensive detection and governance pipeline—combining internal slow‑log tools, database slow‑query logs, and JVM‑Sandbox instrumentation to capture full SQL details, scoring high‑risk queries by execution time, scans, and standards violations, then prioritizing remediation through health scores, branch‑diff checks, and issue tracking—significantly cutting DB‑related incidents and boosting system stability.

DatabaseGovernancePerformance
0 likes · 12 min read
Comprehensive Approach to Slow SQL Detection and Governance
Bilibili Tech
Bilibili Tech
Sep 15, 2023 · Databases

Understanding and Detecting BigKey and HotKey Issues in Redis Clusters

BigKey and HotKey issues in Redis clusters arise when oversized keys block processing or a single key receives excessive requests, causing timeouts, memory overflow, shard collapse, and performance degradation, but can be detected during testing using Redis commands, visual clients, and open‑source analysis tools.

BigKeyCacheDatabase
0 likes · 8 min read
Understanding and Detecting BigKey and HotKey Issues in Redis Clusters
Shepherd Advanced Notes
Shepherd Advanced Notes
Sep 15, 2023 · Backend Development

How to Prevent Duplicate Order Submissions in Flash‑Sale Systems: An Idempotency Guide

The article explains the concept of idempotency, outlines common duplicate‑submission scenarios such as form resubmission, malicious voting, client retries, and message re‑consumption, and details three practical implementation methods—database constraints, token‑based middleware, and state‑machine logic—complete with code examples and trade‑off considerations.

DatabaseOptimistic LockPessimistic Lock
0 likes · 13 min read
How to Prevent Duplicate Order Submissions in Flash‑Sale Systems: An Idempotency Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 9, 2023 · Databases

SQL Queries for Identifying High‑Salary, Low‑Performance Employees in Layoff Scenarios

This article demonstrates how to use MySQL to create employee and performance tables, populate them with sample data, and write SQL statements that first select employees whose salaries exceed their department's average and then filter out those with non‑A performance ratings, providing a complete layoff‑target list.

DatabaseEmployeeMySQL
0 likes · 7 min read
SQL Queries for Identifying High‑Salary, Low‑Performance Employees in Layoff Scenarios
macrozheng
macrozheng
Sep 5, 2023 · Operations

How to Manage Linux, MySQL, Redis, and MongoDB with the Web Tool Mayfly-go

This article introduces the open‑source web platform Mayfly-go, explains its key features for Linux system, MySQL, PostgreSQL, Redis, and MongoDB management, provides step‑by‑step installation and configuration instructions, and demonstrates how to use its project, machine, database, and system administration capabilities.

DatabaseOperationsWeb Management
0 likes · 8 min read
How to Manage Linux, MySQL, Redis, and MongoDB with the Web Tool Mayfly-go
Liangxu Linux
Liangxu Linux
Sep 4, 2023 · Databases

What Really Happens Inside SQL? A Step‑by‑Step Walkthrough of Execution Order

This article breaks down the true execution sequence of an SQL query—from FROM and JOIN through WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, and finally LIMIT—explaining each stage with examples, code snippets, and visual diagrams to help developers write more efficient queries.

DatabaseExecution OrderQuery Optimization
0 likes · 7 min read
What Really Happens Inside SQL? A Step‑by‑Step Walkthrough of Execution Order
MaGe Linux Operations
MaGe Linux Operations
Aug 30, 2023 · Databases

Understanding SQL Execution Order: From FROM to LIMIT Explained

This article walks through the exact sequence a database follows when executing a SQL query—starting with FROM and JOIN, then WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, and finally LIMIT—highlighting key differences from the textual order of the statement.

DatabaseExecution OrderQuery Optimization
0 likes · 5 min read
Understanding SQL Execution Order: From FROM to LIMIT Explained
21CTO
21CTO
Aug 29, 2023 · Databases

Unveiling the Real SQL Execution Order: From FROM to LIMIT Explained

This article demystifies the actual execution sequence of SQL queries, detailing how FROM and JOIN establish table relationships, WHERE filters rows, GROUP BY groups data, HAVING applies aggregate conditions, SELECT retrieves fields, ORDER BY sorts results, and LIMIT restricts the final output.

DatabasePerformanceQuery Execution
0 likes · 6 min read
Unveiling the Real SQL Execution Order: From FROM to LIMIT Explained
Architect's Guide
Architect's Guide
Aug 29, 2023 · Databases

Why Running MySQL in Docker May Not Be Ideal: Data Safety, Performance, and Resource Isolation Issues

This article examines why containerizing MySQL with Docker can be problematic, highlighting data safety concerns, performance degradation due to I/O bottlenecks, state management limitations, and resource isolation challenges, while also presenting scenarios where containerization may be feasible and offering mitigation strategies.

ContainersData SafetyDatabase
0 likes · 5 min read
Why Running MySQL in Docker May Not Be Ideal: Data Safety, Performance, and Resource Isolation Issues
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 28, 2023 · Databases

MySQL InnoDB Cluster Read Replicas: Adding, Configuring, and Managing Read‑Only Nodes

This article explains how MySQL InnoDB Cluster 8.1 introduces read‑only replica instances, shows step‑by‑step commands to create and configure them, describes their failover behavior, routing options with MySQL Router, health‑check isolation, replication‑lag handling, and how to hide replicas from traffic.

DatabaseHigh AvailabilityInnoDB Cluster
0 likes · 17 min read
MySQL InnoDB Cluster Read Replicas: Adding, Configuring, and Managing Read‑Only Nodes
Liangxu Linux
Liangxu Linux
Aug 27, 2023 · Databases

Understanding the Real Execution Order of SQL Queries

This article explains the true execution sequence of SQL statements—starting with FROM and JOIN, then WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, and LIMIT—illustrating each step with diagrams, examples, and code snippets to clarify how databases process queries.

DatabaseFROMGROUP BY
0 likes · 6 min read
Understanding the Real Execution Order of SQL Queries
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Aug 27, 2023 · Databases

Understanding MySQL Transactions, Isolation Levels, and MVCC

This article explains MySQL transaction fundamentals, the ACID properties, how to start and control transactions, the problems of dirty, non‑repeatable and phantom reads, isolation level settings, MVCC mechanics, read‑view structures, and the role of undo logs in ensuring data consistency.

DatabaseInnoDBIsolation Levels
0 likes · 15 min read
Understanding MySQL Transactions, Isolation Levels, and MVCC
Architect
Architect
Aug 24, 2023 · Backend Development

How Vivo’s E‑Commerce Inventory System Scales: Architecture, Challenges, and Solutions

This article details the evolution and design of Vivo’s e‑commerce inventory platform, covering its layered architecture, multiple inventory types, deduction workflows, idempotent APIs, anti‑oversell mechanisms, high‑concurrency strategies, hotspot mitigation, and synchronization techniques, while explaining the reasoning behind each technical choice.

CacheDatabaseE‑commerce
0 likes · 18 min read
How Vivo’s E‑Commerce Inventory System Scales: Architecture, Challenges, and Solutions
Top Architect
Top Architect
Aug 21, 2023 · Databases

Introducing MySQL Innovation and Long-Term Support (LTS) Versions

Oracle announces a new MySQL version model that separates Innovation releases, which deliver new features and frequent updates, from Long‑Term Support (LTS) releases that provide stable, minimal‑change versions with extended support, outlining upgrade paths, deprecation policies, and detailed release schedules.

DatabaseInnovationLTS
0 likes · 17 min read
Introducing MySQL Innovation and Long-Term Support (LTS) Versions
Java High-Performance Architecture
Java High-Performance Architecture
Aug 18, 2023 · Databases

Redis 7.2 Unified Release: Boost AI, Vector Search, and Real‑Time Functions

Redis 7.2, the first Unified Redis Release, introduces AI‑ready vector indexing, hybrid semantic search, scalable RAG support, server‑side Triggers and Functions, enhanced geospatial queries, and a preview of high‑performance searchable indexes, while expanding client library support and integrating Redis Data Integration for seamless enterprise data pipelines.

AIDatabaseRAG
0 likes · 8 min read
Redis 7.2 Unified Release: Boost AI, Vector Search, and Real‑Time Functions
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 16, 2023 · Databases

Common Cases When MySQL Indexes Are Ignored

This article explains how to set up a MySQL test table and indexes, then enumerates nine typical scenarios—such as leading‑wildcard LIKE, arithmetic or functions on indexed columns, type mismatches, composite‑index misuse, character‑set differences, and OR conditions with non‑indexed fields—that cause queries to bypass indexes and perform full table scans.

DatabaseIndexMySQL
0 likes · 8 min read
Common Cases When MySQL Indexes Are Ignored
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 15, 2023 · Databases

Root Cause Analysis of MySQL Replication Error 1590 Caused by INCIDENT_EVENT During Partial Permission Changes

The article analyzes a MySQL 5.7 replication failure where the slave SQL thread stops with error 1590 because the master writes an INCIDENT_EVENT to the binlog when a GRANT or CREATE USER statement partially succeeds due to password‑validation plugin constraints, leading to replication breakage.

DatabaseIncident EventMySQL
0 likes · 11 min read
Root Cause Analysis of MySQL Replication Error 1590 Caused by INCIDENT_EVENT During Partial Permission Changes
Architect's Guide
Architect's Guide
Aug 12, 2023 · Databases

Why Redis Becomes Slow and How to Optimize It

This article explains the common reasons why Redis performance degrades—such as network latency, high‑complexity commands, big keys, concentrated expirations, memory limits, fork overhead, huge pages, AOF settings, CPU binding, swap usage, and memory fragmentation—and provides detailed optimization and troubleshooting steps to restore low latency.

DatabaseMemoryOptimization
0 likes · 34 min read
Why Redis Becomes Slow and How to Optimize It
Selected Java Interview Questions
Selected Java Interview Questions
Aug 11, 2023 · Databases

Introduction to MySQL Locks and Their Types

This article explains the purpose, classification, and implementation of MySQL locks—including global, table, page, row, intention, and gap/record/next-key locks—as well as optimistic and pessimistic locking strategies, providing code examples and usage scenarios for ensuring data consistency in concurrent transactions.

DatabaseInnoDBIsolation
0 likes · 11 min read
Introduction to MySQL Locks and Their Types
Tencent Database Technology
Tencent Database Technology
Aug 10, 2023 · Databases

Optimizing Buffer Pool Memory Management in TDSQL-C Serverless

This article explains the architecture of TDSQL-C Serverless buffer pool, details how InnoDB buffer pool resize works, analyzes performance bottlenecks such as IO and mutex contention, and presents optimization techniques like chunk pre‑allocation, delayed release, and hash‑resize improvements that make serverless scaling more stable.

Buffer PoolDatabaseMySQL
0 likes · 11 min read
Optimizing Buffer Pool Memory Management in TDSQL-C Serverless
Architecture Digest
Architecture Digest
Aug 9, 2023 · Databases

Using Redis SCAN to Safely Enumerate Keys Instead of KEYS

The article explains why using the KEYS command on a large Redis dataset can block the server, introduces the SCAN command as a non‑blocking alternative with cursor‑based iteration, and provides usage examples and best‑practice tips for safely listing prefixed keys.

CacheDatabaseKEYS
0 likes · 4 min read
Using Redis SCAN to Safely Enumerate Keys Instead of KEYS
Top Architect
Top Architect
Aug 8, 2023 · Databases

MySQL Pagination Query Optimization Techniques and Performance Testing

The article examines various MySQL pagination strategies—including simple LIMIT clauses, sub‑query approaches, ID‑range filtering, and temporary‑table methods—provides performance measurements on a table with millions of rows, and offers practical recommendations for reducing query latency in large datasets.

DatabaseMySQLPagination
0 likes · 9 min read
MySQL Pagination Query Optimization Techniques and Performance Testing
Programmer DD
Programmer DD
Aug 8, 2023 · Databases

Why Mastering MySQL Is Essential for Every Tech Professional

This article explains why MySQL, the world’s most popular open‑source relational database, is a fundamental skill for developers, operators and testers, and outlines a two‑book learning path covering installation, SQL mastery, InnoDB internals, indexing and performance optimization.

DatabaseInnoDBMySQL
0 likes · 7 min read
Why Mastering MySQL Is Essential for Every Tech Professional
Test Development Learning Exchange
Test Development Learning Exchange
Aug 7, 2023 · Databases

Python Code Examples for Connecting to Common Databases

This article provides concise Python code snippets for connecting to and querying a variety of popular databases—including MySQL, PostgreSQL, SQLite, MongoDB, Oracle, SQL Server, Redis, Elasticsearch, Cassandra, Couchbase, Firebase, DynamoDB, Neo4j, and InfluxDB—illustrating the essential steps for each.

DatabaseMongoDBMySQL
0 likes · 8 min read
Python Code Examples for Connecting to Common Databases
Laravel Tech Community
Laravel Tech Community
Aug 3, 2023 · Databases

MySQL Data Deletion Methods: DELETE, TRUNCATE, and DROP

This article explains the three primary ways to delete data in MySQL—using DELETE, TRUNCATE, and DROP—detailing their execution speed, underlying mechanisms, storage‑engine differences, and best‑practice considerations such as space reclamation and auto‑increment handling.

DELETEDROPDatabase
0 likes · 5 min read
MySQL Data Deletion Methods: DELETE, TRUNCATE, and DROP
Top Architect
Top Architect
Aug 3, 2023 · Backend Development

Introduction to MyBatis-Flex: Features, Comparison, and Quick‑Start Guide

This article introduces MyBatis‑Flex, a lightweight yet high‑performance MyBatis enhancement framework, outlines its key features, compares it with similar tools, lists supported databases, and provides a step‑by‑step Spring Boot quick‑start tutorial with complete code examples.

DatabaseJavaMyBatis-Flex
0 likes · 11 min read
Introduction to MyBatis-Flex: Features, Comparison, and Quick‑Start Guide
php Courses
php Courses
Aug 3, 2023 · Backend Development

Common PHP Performance Optimization and Tuning Techniques

This article presents several practical PHP performance optimization methods—including caching, avoiding duplicate database queries, merging and compressing assets, using MySQL query cache, and efficient database operations—accompanied by clear code examples to help developers improve web application speed.

DatabaseOptimization
0 likes · 5 min read
Common PHP Performance Optimization and Tuning Techniques
Liangxu Linux
Liangxu Linux
Jul 31, 2023 · Databases

Understanding MySQL’s New Innovation and LTS Version Model

Oracle introduces a new MySQL versioning strategy that separates Innovation releases, featuring frequent new features and fixes, from Long‑Term Support (LTS) releases with stable behavior, outlining transition timelines, upgrade/downgrade paths, HeatWave service options, and support lifecycles for developers and DBAs.

DatabaseInnovationLTS
0 likes · 14 min read
Understanding MySQL’s New Innovation and LTS Version Model
Top Architect
Top Architect
Jul 28, 2023 · Backend Development

An Introduction to MyBatis-Flex: Features, Comparison, and Quick‑Start Guide

This article introduces MyBatis‑Flex, a lightweight yet powerful MyBatis enhancement framework, outlines its key features and advantages, compares it with similar tools, presents performance benchmarks, lists supported databases, and provides a step‑by‑step quick‑start tutorial with code examples for Spring Boot integration.

DatabaseJavaMyBatis-Flex
0 likes · 9 min read
An Introduction to MyBatis-Flex: Features, Comparison, and Quick‑Start Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 24, 2023 · Databases

Introducing MySQL Innovation and Long‑Term Support (LTS) Versions

Oracle announces a new MySQL version model that separates Innovation releases, which deliver new features and frequent updates, from Long‑Term Support (LTS) releases that provide stable, minimal‑change versions with extended support, outlining transition paths, upgrade‑downgrade strategies, and product portfolio impacts.

DatabaseInnovationLTS
0 likes · 14 min read
Introducing MySQL Innovation and Long‑Term Support (LTS) Versions
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 20, 2023 · Databases

Understanding the Dynamic Freeze Threshold in OceanBase: Source Code Analysis and Debugging

This article investigates why OceanBase's memory freeze threshold changes during load testing by analyzing monitoring data, inspecting the relevant source code, and demonstrating debugging steps, ultimately revealing that the threshold is computed dynamically based on real‑time memory usage and can be lowered when other memory modules consume space.

DatabaseFreeze ThresholdOceanBase
0 likes · 18 min read
Understanding the Dynamic Freeze Threshold in OceanBase: Source Code Analysis and Debugging
Top Architect
Top Architect
Jul 17, 2023 · Databases

Using Redis as a Database: Python Code Samples and Comparison with MySQL

This article provides Python code examples for using Redis as a database—including connection, basic CRUD, list and sorted set operations, key expiration, publishing/subscribing, distributed locking, and caching—followed by a detailed comparison of Redis and MySQL across data model, persistence, query capabilities, performance, scalability, and transaction support.

DatabaseMySQL ComparisonPython
0 likes · 11 min read
Using Redis as a Database: Python Code Samples and Comparison with MySQL
JavaEdge
JavaEdge
Jul 14, 2023 · Databases

How to Efficiently Insert 1,000 Records with MyBatis: Loop vs Batch

When interviewers ask how to insert a thousand rows with MyBatis, the answer isn’t just a simple Java for‑loop; you need to consider batch processing, disable autocommit, and understand MyBatis’s limits to choose the most reliable and performant approach.

Batch InsertDatabaseJava
0 likes · 3 min read
How to Efficiently Insert 1,000 Records with MyBatis: Loop vs Batch
Laravel Tech Community
Laravel Tech Community
Jul 13, 2023 · Databases

MyBatis-Flex: An Elegant MyBatis Enhancement Framework

MyBatis-Flex is a lightweight, high‑performance extension to MyBatis that adds full CRUD, pagination, multi‑table and batch operations while preserving all MyBatis features, supports multi‑datasource relations, recursive queries, and provides extensive annotations such as @Relation for flexible data mapping, with recent v1.4.9 updates and bug fixes.

DatabaseFrameworkJava
0 likes · 5 min read
MyBatis-Flex: An Elegant MyBatis Enhancement Framework
Laravel Tech Community
Laravel Tech Community
Jul 5, 2023 · Databases

Performance Testing and Optimization of Large‑Scale MySQL Queries

This article demonstrates how to generate, insert, and query millions of rows in a MySQL 5.7 table, measures pagination performance under varying offsets and result sizes, and presents several optimization techniques—including sub‑queries, indexed look‑ups, and column selection—to dramatically reduce query latency.

DatabaseLarge DataMySQL
0 likes · 10 min read
Performance Testing and Optimization of Large‑Scale MySQL Queries
21CTO
21CTO
Jul 5, 2023 · Databases

Why MariaDB Is More Than Just a MySQL Fork: Exploring Its Powerful Tools

This article explains how MariaDB evolved from a MySQL branch into a comprehensive database ecosystem, covering the Community and Enterprise servers, diverse storage engines, MaxScale proxy, ColumnStore analytics, Xpand distributed scaling, and the SkySQL fully managed cloud service.

AnalyticsCloud DatabaseDatabase
0 likes · 8 min read
Why MariaDB Is More Than Just a MySQL Fork: Exploring Its Powerful Tools
Big Data Technology Architecture
Big Data Technology Architecture
Jul 4, 2023 · Databases

Apache Doris 2.0‑beta Release: New Query Optimizer, Pipeline Engine, Workload Management and Performance Enhancements

Apache Doris 2.0‑beta, released on July 3, 2023, introduces a modern Cascades‑based query optimizer, a data‑driven pipeline execution engine, fine‑grained workload groups, enhanced memory management, partial‑column updates, compute nodes, cold‑hot tiering and cross‑cluster replication, delivering up to tenfold speedups and significant cost reductions for real‑time analytics.

Apache DorisDatabasePipeline Execution
0 likes · 24 min read
Apache Doris 2.0‑beta Release: New Query Optimizer, Pipeline Engine, Workload Management and Performance Enhancements
php Courses
php Courses
Jul 3, 2023 · Databases

MySQL Queries That Cannot Use Indexes

Certain MySQL queries, such as those using functions, leading wildcards in LIKE, OR operators, inequality comparisons, or NULL checks, prevent the database engine from utilizing indexes, leading to slower performance, and should be rewritten for optimal query efficiency.

DatabaseMySQLPerformance
0 likes · 3 min read
MySQL Queries That Cannot Use Indexes
Java Architect Essentials
Java Architect Essentials
Jun 30, 2023 · Backend Development

Why Database Connection Pools Do Not Use IO Multiplexing in Java

Although IO multiplexing can improve performance, Java applications typically use traditional connection pools like c3p0 or Tomcat because JDBC is built on blocking I/O, DB sessions require separate connections, and integrating NIO would complicate program architecture, making connection pools the pragmatic, mature solution.

DatabaseIO MultiplexingJDBC
0 likes · 9 min read
Why Database Connection Pools Do Not Use IO Multiplexing in Java
IT Services Circle
IT Services Circle
Jun 23, 2023 · Backend Development

Comprehensive Java Backend Interview Review: Threads, Collections, Networking, HTTP, TCP, and MySQL

This article presents a detailed Java backend interview recap covering self‑introduction, thread‑pool choices, Snowflake ID usage, List implementations, List vs Set differences, common HTTP status codes, flow and congestion control, URL request flow, TCP three‑way handshake, HTTP vs HTTPS, database index types, B+‑tree advantages, transaction isolation problems, and practical interview preparation tips.

DatabaseJavaMySQL
0 likes · 21 min read
Comprehensive Java Backend Interview Review: Threads, Collections, Networking, HTTP, TCP, and MySQL
Code Ape Tech Column
Code Ape Tech Column
Jun 23, 2023 · Databases

Chat2DB: An Open-Source AI-Powered Multi-Database Client – Installation, Configuration, and Usage Guide

This article introduces Chat2DB, an open‑source AI‑enhanced multi‑database client, explains how to download, install and configure it with OpenAI keys, demonstrates creating data sources and sample tables, and showcases natural‑language‑to‑SQL, SQL explanation, and optimization features with practical examples.

AIChat2DBDatabase
0 likes · 11 min read
Chat2DB: An Open-Source AI-Powered Multi-Database Client – Installation, Configuration, and Usage Guide
DataFunTalk
DataFunTalk
Jun 20, 2023 · Databases

Hot and Cold Data Tiering in Apache Doris 2.0: Architecture, Configuration, and Performance Evaluation

This article explains the hot‑cold data tiering technique in Apache Doris 2.0, covering its motivation, storage‑layer design, configuration steps (resource, storage policy, table/partition settings), cost‑saving calculations, query performance impact, cold‑data compaction, and cache mechanisms, with practical code examples.

Apache DorisCold Data TieringDatabase
0 likes · 18 min read
Hot and Cold Data Tiering in Apache Doris 2.0: Architecture, Configuration, and Performance Evaluation
Past Memory Big Data
Past Memory Big Data
Jun 19, 2023 · Databases

Why esProc SPL Outperforms SQLite for Small Java Applications

The article analyzes SQLite's shortcomings in data‑source support, complex calculations, and workflow handling for tiny Java apps, then demonstrates how the open‑source esProc SPL engine offers richer data‑source integration, simpler SQL‑like syntax, powerful calculation capabilities, and built‑in flow control, making it a more suitable lightweight database alternative.

Data ProcessingDatabaseJava
0 likes · 16 min read
Why esProc SPL Outperforms SQLite for Small Java Applications
php Courses
php Courses
Jun 15, 2023 · Databases

20 Common MySQL Functions and Their Usage

This article introduces twenty commonly used MySQL functions, explains their purposes, and provides clear SQL examples with expected results to help developers efficiently manipulate and process data, including string, numeric, date, and aggregate functions, each illustrated with sample queries and output.

DatabaseMySQLSQL
0 likes · 5 min read
20 Common MySQL Functions and Their Usage
vivo Internet Technology
vivo Internet Technology
Jun 14, 2023 · Backend Development

Stability Practices for Vivo Account System: Service Governance, Data Architecture, and Monitoring

Vivo’s account platform, serving 270 million users and over 100 billion daily requests, achieves high‑performance stability through disciplined service splitting, hierarchical dependency control, layered caching and sharding strategies, and comprehensive multi‑layer monitoring that together ensure scalability, availability, and rapid fault diagnosis.

DatabaseService Governancebackend
0 likes · 24 min read
Stability Practices for Vivo Account System: Service Governance, Data Architecture, and Monitoring
Code Ape Tech Column
Code Ape Tech Column
Jun 12, 2023 · Databases

Understanding MySQL DDL Execution and Online DDL Mechanisms

This article explains the differences between MySQL DDL and DML, describes how online DDL works—including copy and inplace algorithms, execution phases, common pitfalls, limitations, and recent MySQL 8.0 enhancements—providing practical guidance for safely altering large tables.

DDLDatabaseInnoDB
0 likes · 16 min read
Understanding MySQL DDL Execution and Online DDL Mechanisms
Architect's Guide
Architect's Guide
Jun 11, 2023 · Databases

Redis Data Types and Their Internal Implementations

This article provides a comprehensive overview of Redis's ten data types—including strings, hashes, lists, sets, sorted sets, streams, hyperloglog, geospatial, bitmap, and bitfield—detailing their structures, encoding mechanisms, application scenarios, and underlying implementation details with code examples.

Data TypesDatabaseRedis
0 likes · 29 min read
Redis Data Types and Their Internal Implementations
IT Services Circle
IT Services Circle
Jun 10, 2023 · Databases

Comprehensive MySQL Interview Guide: Key Concepts and Practices

This article provides a systematic, interview‑focused overview of MySQL fundamentals—including normal forms, DML vs DDL, primary and foreign keys, storage engines, redo and binlog mechanisms, indexing strategies, transaction properties, MVCC, lock types, replication, and common performance pitfalls—helping candidates quickly master essential database knowledge for interview success.

DatabaseMySQLSQL
0 likes · 32 min read
Comprehensive MySQL Interview Guide: Key Concepts and Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 10, 2023 · Databases

Weekly Tech Share Summary – SQL and Database Highlights

This weekly newsletter curates top industry tech articles covering SQL deployment capabilities, MySQL replication issues, LLM‑to‑SQL benchmarks, connection limit errors, OceanBase tracing, and provides an open‑source SQL quality management platform update with development progress and upcoming plans.

AuditDatabaseMySQL
0 likes · 4 min read
Weekly Tech Share Summary – SQL and Database Highlights
Liangxu Linux
Liangxu Linux
Jun 6, 2023 · Databases

Why MySQL Chooses B+ Trees Over Skip Lists for Indexing

The article explains the structural differences between B+ trees and skip lists, compares their read‑write performance in MySQL and Redis, and shows why MySQL prefers B+ trees while Redis adopts skip lists for its in‑memory ZSET implementation.

B+ treeDatabaseMySQL
0 likes · 13 min read
Why MySQL Chooses B+ Trees Over Skip Lists for Indexing
dbaplus Community
dbaplus Community
Jun 5, 2023 · Operations

Mastering Production Faults: Diagnose and Fix Network, Server, Database Issues

This guide outlines the most common production failures—including network, server, database, software, security, storage, configuration, and third‑party service issues—and provides step‑by‑step methods to detect, troubleshoot, and resolve each problem, helping maintain system stability and reliability.

DatabaseOperationsProduction
0 likes · 30 min read
Mastering Production Faults: Diagnose and Fix Network, Server, Database Issues