BestHub
Sign in
Tagged articles
2675 articles
Page 6 of 27
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 AnalysisDatabaseInnoDB
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.

DatabaseHashList
0 likes · 10 min read
Master PostgreSQL Table Partitioning: Types, Commands, and Best Practices
Open Source Tech Hub
Open Source Tech Hub
Sep 22, 2024 · Backend Development

How WebMan Leverages Workerman for High‑Performance PHP HTTP Services

This article explains the WebMan HTTP service framework built on Workerman, describes its single‑process, multi‑thread/coroutine, IO‑multiplexing and EventLoop modes, clarifies why it lacks a database connection pool, and presents detailed performance test results under various concurrency levels.

DatabaseIO Multiplexinghttp framework
0 likes · 12 min read
How WebMan Leverages Workerman for High‑Performance PHP HTTP Services
Top Architect
Top Architect
Sep 21, 2024 · Databases

Implementing Pagination and Multi‑Condition Fuzzy Query in Redis

This article explains how to implement pagination, multi‑condition fuzzy search, and their combination using Redis Sorted Sets and Hashes, discusses performance optimizations and expiration strategies, and also contains promotional material for ChatGPT services and a community offering.

DatabaseHashPerformance Optimization
0 likes · 12 min read
Implementing Pagination and Multi‑Condition Fuzzy Query in Redis
AntTech
AntTech
Sep 21, 2024 · Artificial Intelligence

Insights from the 2024 Inclusion·Bund Conference: From Data for AI to AI for Data

The 2024 Inclusion·Bund conference brought together academia and industry leaders to discuss how data technologies are evolving and aligning with AI, covering trends in large‑model storage, synthetic data generation, AI‑enhanced databases, and Ant Group's emerging AI‑centric data ecosystem.

AIAI alignmentDatabase
0 likes · 7 min read
Insights from the 2024 Inclusion·Bund Conference: From Data for AI to AI for Data
Java High-Performance Architecture
Java High-Performance Architecture
Sep 21, 2024 · Backend Development

Master MyBatis-Mate: Advanced Features for Secure, Sharded Java Backends

This article introduces MyBatis‑Mate, an enterprise‑grade MyBatis extension that provides sharding, data auditing, sensitive‑word filtering, field encryption, dictionary binding, dynamic DDL maintenance, data‑scope permissions and performance monitoring, complete with practical code examples and configuration guidance.

DatabaseJavaMyBatis
0 likes · 15 min read
Master MyBatis-Mate: Advanced Features for Secure, Sharded Java Backends
Open Source Linux
Open Source Linux
Sep 20, 2024 · Databases

Redis Master‑Slave Replication and Sentinel: How They Work and Scale

This article explains Redis master‑slave replication, synchronization steps, handling of network partitions, and how Sentinel provides automatic failover through monitoring, leader election, and notification, offering strategies to reduce master load and ensure high availability.

DatabaseMaster‑SlaveRedis
0 likes · 9 min read
Redis Master‑Slave Replication and Sentinel: How They Work and Scale
Liangxu Linux
Liangxu Linux
Sep 19, 2024 · Databases

10 Advanced SQL Concepts Every Data Scientist Should Master

This guide walks through ten essential advanced SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations with LAG/LEAD, cumulative sums, and date‑time manipulation—to help data professionals ace interview challenges and write cleaner, more powerful queries.

Advanced SQLCTEDatabase
0 likes · 11 min read
10 Advanced SQL Concepts Every Data Scientist Should Master
dbaplus Community
dbaplus Community
Sep 19, 2024 · Databases

How MySQL Implements SQL Flow Control to Protect CPU Resources

This article explains the design and implementation of MySQL's SQL flow‑control feature, covering its purpose, architecture, external commands, rule management, matching logic, data‑access layer, performance considerations, usage guidelines, and known limitations.

DatabasePerformanceSQL flow control
0 likes · 15 min read
How MySQL Implements SQL Flow Control to Protect CPU Resources
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 19, 2024 · Databases

Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues

This article explains how to troubleshoot a slow OceanBase stored procedure by locating its trace_id, analyzing audit logs to identify non‑cached UPDATE statements, revealing that preceding TRUNCATE operations invalidate the plan cache, and finally recommending replacing TRUNCATE with DELETE to restore performance.

DatabaseOceanBasePerformance tuning
0 likes · 10 min read
Diagnosing Slow Stored Procedure Execution in OceanBase: Trace ID Analysis and Plan Cache Issues
macrozheng
macrozheng
Sep 19, 2024 · Databases

Why LEFT JOIN Still Returns All Left Rows: ON vs WHERE Explained

This article explains why a LEFT JOIN always returns all rows from the left table, clarifies the difference between ON and WHERE clauses, demonstrates the behavior with multiple SQL examples and code snippets, and highlights the special handling of LEFT/RIGHT/FULL joins versus inner joins.

DatabaseLEFT JOINON clause
0 likes · 6 min read
Why LEFT JOIN Still Returns All Left Rows: ON vs WHERE Explained
DeWu Technology
DeWu Technology
Sep 18, 2024 · Operations

Automated Resource Balancing Scheduling in Redis Management Platform

Gotu’s Redis management platform now runs an unattended 5 AM scheduler that automatically selects and migrates nodes based on priority rules, verifies master‑slave synchronization, and rebalances host memory to stay below safe thresholds, improving utilization, reducing DBA effort, and supporting future auto‑deployment and recovery.

DatabaseRedisResource Balancing
0 likes · 12 min read
Automated Resource Balancing Scheduling in Redis Management Platform
21CTO
21CTO
Sep 17, 2024 · Databases

MariaDB’s Journey: From MySQL Fork to K1 Private Equity Takeover

The article traces MariaDB’s evolution from its MySQL roots and community‑driven development, through its NYSE listing, financial performance, restructuring, and the recent K1 Investment Management acquisition, while highlighting key figures, product features, and industry reactions.

AcquisitionDatabaseMariaDB
0 likes · 12 min read
MariaDB’s Journey: From MySQL Fork to K1 Private Equity Takeover
IT Services Circle
IT Services Circle
Sep 14, 2024 · Backend Development

Spring Transaction Pitfalls: Common Scenarios Where Transactions Fail and How to Fix Them

This article explains the most common reasons why Spring @Transactional annotations may become ineffective or fail to roll back, covering access‑modifier issues, final methods, internal calls, self‑injection, multithreading, unsupported table engines, mis‑configured propagation, exception handling, nested transactions, large‑transaction problems, and the advantages of programmatic transaction management.

AOPDatabaseJava
0 likes · 20 min read
Spring Transaction Pitfalls: Common Scenarios Where Transactions Fail and How to Fix Them
php Courses
php Courses
Sep 12, 2024 · Backend Development

Using mysqli_fetch_assoc to Retrieve Query Results in PHP

This article explains how to connect to a MySQL database with mysqli_connect, execute queries using mysqli_query, and fetch each row as an associative array with mysqli_fetch_assoc, providing a complete PHP code example and best‑practice tips.

DatabaseMySQLiPHP
0 likes · 4 min read
Using mysqli_fetch_assoc to Retrieve Query Results in PHP
Liangxu Linux
Liangxu Linux
Sep 10, 2024 · Databases

Essential MySQL Scripts for Export, Import, and Database Management

This guide provides a comprehensive collection of MySQL command‑line scripts covering database and table export/import, creation, deletion, schema inspection, data manipulation, user privilege management, and common DDL operations, all with practical examples.

DDLDatabaseExport
0 likes · 10 min read
Essential MySQL Scripts for Export, Import, and Database Management
IT Services Circle
IT Services Circle
Sep 10, 2024 · Databases

Understanding MySQL Indexes: Types, Structures, and Optimization Techniques

This article provides a comprehensive overview of MySQL indexing, covering index classifications, B+Tree and Hash structures, primary and secondary (clustered and non‑clustered) indexes, covering index push‑down, index merge, covering indexes, cost‑based index selection, and common pitfalls that cause index inefficiency.

DatabaseIndexesPerformance
0 likes · 27 min read
Understanding MySQL Indexes: Types, Structures, and Optimization Techniques
Sanyou's Java Diary
Sanyou's Java Diary
Sep 9, 2024 · Databases

Master MySQL Indexes: B+Tree, Hash, Clustering & Optimization

This article provides a comprehensive guide to MySQL indexing, covering index types, data structures, clustering and non‑clustering indexes, hash indexes, B+Tree mechanics, index lookup, covering indexes, index push‑down, index merge, cost‑based index selection, common pitfalls, and best practices for designing effective indexes.

DatabaseOptimizationPerformance
0 likes · 34 min read
Master MySQL Indexes: B+Tree, Hash, Clustering & Optimization
Su San Talks Tech
Su San Talks Tech
Sep 9, 2024 · Backend Development

Why Your Spring @Transactional Might Fail: 7 Common Pitfalls and How to Fix Them

This article explains why Spring transactions can become ineffective or fail to roll back, covering issues such as wrong method visibility, final methods, internal calls, missing Spring bean registration, multithreading, unsupported table engines, misconfigured propagation, exception handling, and offers practical solutions for each case.

AOPDatabaseJava
0 likes · 21 min read
Why Your Spring @Transactional Might Fail: 7 Common Pitfalls and How to Fix Them
Test Development Learning Exchange
Test Development Learning Exchange
Sep 5, 2024 · Backend Development

Build a Clean, Efficient MySQL Utility Class in Python

This article walks you through designing a lightweight, high‑performance MySQL helper class in Python, covering singleton connection management, robust exception handling, logging, context‑managed connections, and practical query/execute methods with example code and usage scenarios.

DatabaseError HandlingPython
0 likes · 7 min read
Build a Clean, Efficient MySQL Utility Class in Python
JD Tech Talk
JD Tech Talk
Sep 5, 2024 · Databases

Why MySQL Auto‑Increment Primary Keys Can Become Non‑Continuous

This article explains the mechanisms behind MySQL auto‑increment primary keys, why gaps appear after failed inserts, unique‑index violations, transaction rollbacks, and batch operations, and how storage engines and innodb_autoinc_lock_mode settings influence the continuity of generated IDs.

DatabaseInnoDBUnique Index
0 likes · 11 min read
Why MySQL Auto‑Increment Primary Keys Can Become Non‑Continuous
JD Cloud Developers
JD Cloud Developers
Sep 5, 2024 · Databases

Why Do MySQL Auto‑Increment IDs Skip? Understanding Gaps and Solutions

This article explains why MySQL auto‑increment primary keys can become non‑continuous, covering storage mechanisms, unique‑index violations, transaction rollbacks, batch inserts, and step‑size settings, and provides practical examples and diagrams to help developers diagnose and avoid ID gaps.

DatabaseInnoDBUnique Index
0 likes · 11 min read
Why Do MySQL Auto‑Increment IDs Skip? Understanding Gaps and Solutions
Tencent Architect
Tencent Architect
Sep 4, 2024 · Databases

X‑Stor: A Cloud‑Native Multi‑Model NoSQL Database Service – Design, Architecture, and Evaluation

The article introduces X‑Stor, a cloud‑native NoSQL database service that supports multiple data models and process‑level multi‑tenant isolation, describes its plugin‑based architecture and Request Unit metric, and presents experimental results showing superior performance, effective tenant isolation, and load‑balancing benefits compared with traditional single‑model NoSQL systems.

Cloud-nativeDatabaseMulti‑tenant
0 likes · 11 min read
X‑Stor: A Cloud‑Native Multi‑Model NoSQL Database Service – Design, Architecture, and Evaluation
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 2, 2024 · Databases

MySQL 8.0 Achievements and Community Highlights

The article reviews MySQL's 29‑year evolution, detailing the 8.0 release’s extensive contributions, new features, bug‑fix statistics, and the vital role of the global community and Oracle’s ongoing investment in both the open‑source edition and the HeatWave cloud service.

CommunityDatabaseOpenSource
0 likes · 11 min read
MySQL 8.0 Achievements and Community Highlights
StarRocks
StarRocks
Aug 30, 2024 · Databases

How Cloud‑Native Persistent Index Boosts StarRocks Performance 10× in Elastic Scheduling

StarRocks 3.3.1 introduces a cloud‑native persistent index that moves index files to object storage, eliminates local‑disk constraints, and supports elastic scaling, delivering up to ten‑fold latency improvement over local‑disk indexes in elastic scheduling while matching performance in batch and real‑time imports.

Cloud NativeDatabasePerformance
0 likes · 11 min read
How Cloud‑Native Persistent Index Boosts StarRocks Performance 10× in Elastic Scheduling
FunTester
FunTester
Aug 30, 2024 · Backend Development

Choosing a Java ORM Framework: Key Factors, Popular Options, and Implementation Steps

This article explains why Java ORM frameworks are essential for simplifying database access, outlines the critical criteria for selecting the right ORM, compares popular choices such as Hibernate, JPA, EclipseLink, and DataNucleus, and provides a step‑by‑step guide for successful implementation.

DatabaseHibernateJava
0 likes · 14 min read
Choosing a Java ORM Framework: Key Factors, Popular Options, and Implementation Steps
Sohu Tech Products
Sohu Tech Products
Aug 28, 2024 · Databases

MySQL Data Migration with Double‑Write Using MyBatis Plugin

The article details how the vivo Game Center’s appointment service migrated billions of rows to a dedicated MySQL database with zero‑downtime by implementing a double‑write strategy via a custom MyBatis interceptor that mirrors updates and queries to the new database, handling full and incremental sync, primary‑key consistency, transaction limits, and final cut‑over steps.

Data MigrationDatabaseMyBatis
0 likes · 19 min read
MySQL Data Migration with Double‑Write Using MyBatis Plugin
IT Services Circle
IT Services Circle
Aug 28, 2024 · Backend Development

Interview Experience and Technical Guide: HTTP Versions, Java Network Programming, OS I/O, Database Concurrency, Bloom Filter, Reflection, Annotations, and Synchronization

The article shares a graduate's interview experience and provides a comprehensive technical guide covering HTTP/1.x vs HTTP/2 differences, Java socket and HTTP server code, OS I/O buffering vs direct I/O, database concurrency control, Bloom filter principles, Java reflection, annotation usage, and synchronized locking semantics.

DatabaseHTTPJava
0 likes · 21 min read
Interview Experience and Technical Guide: HTTP Versions, Java Network Programming, OS I/O, Database Concurrency, Bloom Filter, Reflection, Annotations, and Synchronization
Zhuanzhuan Tech
Zhuanzhuan Tech
Aug 27, 2024 · Databases

MySQL InnoDB Deadlock Analysis and Resolution Guide

This article presents a detailed walkthrough of a MySQL InnoDB deadlock case, covering background, log inspection, data preparation, reproduction steps, lock analysis, root‑cause explanation, and practical solutions to prevent and resolve similar deadlock issues.

DatabaseInnoDBTroubleshooting
0 likes · 14 min read
MySQL InnoDB Deadlock Analysis and Resolution Guide
Selected Java Interview Questions
Selected Java Interview Questions
Aug 27, 2024 · Databases

MySQL Full‑Text Search: Inverted Index, Query Modes, and Usage

This article explains how MySQL InnoDB implements full‑text search using inverted indexes, shows how to create and drop full‑text indexes, and demonstrates the three query modes—Natural Language, Boolean, and Query Expansion—along with their syntax, operators, relevance calculation, and practical examples.

Boolean ModeDatabaseinverted index
0 likes · 11 min read
MySQL Full‑Text Search: Inverted Index, Query Modes, and Usage
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 27, 2024 · Databases

Understanding Repeatable Read in OceanBase Oracle Mode and the Correct JDBC Configuration

This article explains why the OBOracle "set transaction read only" command provides repeatable‑read semantics, evaluates the behavior of the JDBC conn.setReadOnly(true) setting, and shows how to achieve true repeatable‑read isolation by enabling the oracleChangeReadOnlyToRepeatableRead option in the OceanBase client.

DatabaseJDBCOceanBase
0 likes · 8 min read
Understanding Repeatable Read in OceanBase Oracle Mode and the Correct JDBC Configuration
dbaplus Community
dbaplus Community
Aug 25, 2024 · Databases

Boost Real‑Time App Performance with ReadySet: A Hands‑On Guide to SQL Caching

This article introduces ReadySet, an open‑source SQL caching layer for MySQL and PostgreSQL, explains its architecture and advantages, and provides step‑by‑step instructions for installing the Docker image, configuring connections, creating caches, and testing query performance to achieve millisecond‑level response times.

DatabaseDockerPostgreSQL
0 likes · 7 min read
Boost Real‑Time App Performance with ReadySet: A Hands‑On Guide to SQL Caching
MaGe Linux Operations
MaGe Linux Operations
Aug 25, 2024 · Databases

How to Install and Configure MySQL 5.7 on ARM (Aarch64) with Master‑Slave Replication

This guide walks through checking the OS architecture, preparing the environment, downloading the appropriate MySQL 5.7 packages for ARM, installing and configuring MySQL, setting up automatic startup and environment variables, initializing the server, securing the root account, and finally configuring master‑slave replication between two servers.

ARMDatabaseLinux
0 likes · 15 min read
How to Install and Configure MySQL 5.7 on ARM (Aarch64) with Master‑Slave Replication
ITPUB
ITPUB
Aug 25, 2024 · Databases

How to Allocate Train Seats Across Segments Using SQL

This article recounts L's attempt to change a train ticket, analyzes seat availability across four segments, and presents a minimal SQL model with table creation, data insertion, and a query that determines feasible seat combinations, demonstrating how segment‑wise seat allocation can enable complete journey booking.

DatabaseOracleSQL
0 likes · 9 min read
How to Allocate Train Seats Across Segments Using SQL
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Aug 23, 2024 · Backend Development

Master Spring Boot: Complete Roadmap for Enterprise Java Development

This guide walks you through why Java remains vital, explains what Spring Boot is, outlines its core features, and provides a detailed learning roadmap covering Java fundamentals, Spring core concepts, web development, AOP, microservices, databases, security, DevOps tools, and deployment strategies for building robust enterprise applications.

Backend DevelopmentDatabaseDevOps
0 likes · 16 min read
Master Spring Boot: Complete Roadmap for Enterprise Java Development
vivo Internet Technology
vivo Internet Technology
Aug 21, 2024 · Databases

MySQL Data Migration with Double‑Write Strategy Using a MyBatis Plugin

The article details a zero‑downtime migration of a high‑traffic reservation service from a shared MySQL instance to an isolated database by employing a double‑write strategy implemented through a custom MyBatis plugin, covering full and incremental sync, consistency verification, traffic shifting, and key lessons on primary‑key handling and asynchronous write side‑effects.

Data MigrationDatabaseMyBatis
0 likes · 19 min read
MySQL Data Migration with Double‑Write Strategy Using a MyBatis Plugin
Cognitive Technology Team
Cognitive Technology Team
Aug 17, 2024 · Operations

GitHub Outage on August 14, 2024: Causes, Impact, and Recovery

On August 14, 2024, GitHub experienced a massive site-wide outage caused by a database infrastructure configuration change that disrupted traffic routing, leading to loss of database connections and affecting core services such as Pull Requests, Pages, Copilot, and the API, with full restoration confirmed later that evening.

DatabaseGitHubIncident Management
0 likes · 2 min read
GitHub Outage on August 14, 2024: Causes, Impact, and Recovery
Deepin Linux
Deepin Linux
Aug 8, 2024 · Databases

Understanding Database Connection Pools: Principles, Mechanisms, and Popular Implementations

This article explains the concept of database connection pools, why they are needed, their core principles and runtime mechanisms, compares traditional direct connections with pooled connections, and reviews major Java pool implementations such as DBCP, C3P0, Druid and HikariCP along with configuration tips and best‑practice considerations.

C3P0Connection PoolDBCP
0 likes · 27 min read
Understanding Database Connection Pools: Principles, Mechanisms, and Popular Implementations
Java Tech Enthusiast
Java Tech Enthusiast
Aug 6, 2024 · Databases

MySQL Storage Engines: Overview, Differences, and Interview Guidance

MySQL’s pluggable storage‑engine architecture lets each table use a specific engine, with InnoDB (the default in MySQL 8.x) offering row‑level locking, ACID transactions, foreign‑key support, crash recovery, MVCC and a buffer pool, while MyISAM provides only table‑level locking, no transactions, and is suited mainly for read‑intensive workloads lacking recovery requirements.

DatabaseInnoDBInterview
0 likes · 9 min read
MySQL Storage Engines: Overview, Differences, and Interview Guidance
IT Architects Alliance
IT Architects Alliance
Aug 4, 2024 · Information Security

How to Perform Fuzzy Search on Encrypted Data

This article examines the challenges of fuzzy searching encrypted data and compares three implementation approaches—naïve, conventional, and advanced—detailing their principles, performance implications, storage costs, and security trade‑offs, ultimately recommending the conventional token‑based method for most practical applications.

DatabaseInformation Securityalgorithm
0 likes · 13 min read
How to Perform Fuzzy Search on Encrypted Data
Top Architect
Top Architect
Jul 31, 2024 · Backend Development

Design and Implementation of a Generic Asynchronous Processing SDK for Spring Applications

This article introduces a Spring‑based asynchronous processing SDK that leverages annotations, transaction event listeners, Kafka, XXL‑Job, and a dedicated database to achieve non‑blocking execution, fault tolerance, and eventual consistency while preserving transaction integrity and providing a clear configuration and usage guide.

DatabaseKafkabackend
0 likes · 12 min read
Design and Implementation of a Generic Asynchronous Processing SDK for Spring Applications
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2024 · Databases

Can a MySQL Replica Omit sync_binlog=1? Experiment and Analysis

This article examines whether a MySQL replica can safely omit setting sync_binlog=1, explains the underlying InnoDB and GTID mechanisms, presents an experiment reproducing power‑loss scenarios, and analyzes how different master_auto_position settings affect data consistency and GTID continuity during recovery.

DatabaseGTIDbinlog
0 likes · 10 min read
Can a MySQL Replica Omit sync_binlog=1? Experiment and Analysis
Liangxu Linux
Liangxu Linux
Jul 27, 2024 · Fundamentals

7 Must‑Know Russian‑Created Software That Power Our Daily Tech

This article highlights seven world‑class software projects originated by Russian developers—including 7‑Zip, Telegram, Nginx, Kaspersky, JetBrains IDE suite, ClickHouse, and the classic Tetris game—explaining their history, key technologies, and impact on everyday computing.

DatabaseIDEOpen Source
0 likes · 6 min read
7 Must‑Know Russian‑Created Software That Power Our Daily Tech
ITPUB
ITPUB
Jul 27, 2024 · Databases

How to Diagnose and Optimize Extremely Slow MySQL Queries

This article explains what constitutes a slow SQL query, how to detect and analyze it using MySQL tools, and provides practical optimization steps—including indexing, business logic review, caching, scheduling, and partitioning—to dramatically reduce execution time.

DatabaseOptimizationPerformance
0 likes · 7 min read
How to Diagnose and Optimize Extremely Slow MySQL Queries
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 25, 2024 · Databases

Analyzing and Optimizing Slow Scalar Subqueries in OceanBase 3.2.3.3

This article examines why a scalar subquery in an OceanBase 3.2.3.3 SQL statement takes over 1000 seconds, breaks down the execution plan, identifies the costly nested-loop behavior, and presents a rewrite using WITH and LEFT JOIN that reduces the cost from 788 million to 3.6 million and cuts runtime to about 10 seconds.

DatabaseOceanBasePerformance Optimization
0 likes · 12 min read
Analyzing and Optimizing Slow Scalar Subqueries in OceanBase 3.2.3.3
Java Tech Enthusiast
Java Tech Enthusiast
Jul 24, 2024 · Databases

Differences Between MySQL TINYINT(1) and BIT(1) for Boolean Storage

MySQL’s TINYINT(1) stores a full byte integer allowing any value from 0‑255 (or –128‑127 signed) and works with arithmetic, offering broad compatibility, while BIT(1) stores a single bit limited to 0 or 1, is MySQL‑specific, and is best used only when true/false storage and minimal space are essential, making TINYINT(1) the generally preferred choice unless strict boolean constraints apply.

BitData TypesDatabase
0 likes · 4 min read
Differences Between MySQL TINYINT(1) and BIT(1) for Boolean Storage
Architecture & Thinking
Architecture & Thinking
Jul 24, 2024 · Databases

Why MySQL Pagination Slows Down and How to Speed It Up

This article examines why MySQL pagination using large LIMIT OFFSET values becomes increasingly slow, explains the underlying scanning behavior, and presents six practical optimization techniques—including indexed subqueries, cursor‑based pagination, column selection, partitioning, caching, and hardware considerations—to dramatically improve query performance on massive tables.

DatabaseOptimizationSQL
0 likes · 7 min read
Why MySQL Pagination Slows Down and How to Speed It Up
Architect
Architect
Jul 23, 2024 · Databases

How to Perform Fuzzy Searches on Encrypted Data: Methods, Pros & Cons

This article examines three categories of techniques—naïve, conventional, and advanced—for enabling fuzzy queries on encrypted data, comparing their implementation steps, performance impact, storage overhead, and security trade‑offs, and provides practical examples and reference links for further study.

DatabasePerformanceencrypted data
0 likes · 11 min read
How to Perform Fuzzy Searches on Encrypted Data: Methods, Pros & Cons
Selected Java Interview Questions
Selected Java Interview Questions
Jul 22, 2024 · Backend Development

Using a Database as a Central Configuration Center in SpringBoot

This article analyzes the problems of scattered property configuration in SpringBoot projects, designs a database table to store configuration items, implements a configuration loader that injects database values into the Spring environment, and demonstrates testing and best‑practice considerations for a robust backend configuration solution.

DatabaseJavaPropertyInjection
0 likes · 11 min read
Using a Database as a Central Configuration Center in SpringBoot
php Courses
php Courses
Jul 22, 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 full example that creates a connection, runs a query, processes results, and closes the connection.

DatabaseMySQLiPHP
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Jul 22, 2024 · Databases

Why StarRocks Is Redefining Fast Unified OLAP Analytics

StarRocks combines vectorized execution, a new cost‑based optimizer, materialized views, a real‑time storage engine, pipeline execution, and distributed joins to deliver a unified, high‑performance OLAP solution that supports both traditional and lakehouse analytics while reducing operational complexity.

CBODatabaseLakehouse
0 likes · 14 min read
Why StarRocks Is Redefining Fast Unified OLAP Analytics
The Dominant Programmer
The Dominant Programmer
Jul 19, 2024 · Databases

Writing High‑Quality SQL: Practical MySQL Optimization Tips

To avoid common MySQL pitfalls, the article compiles practical SQL writing guidelines—selecting specific columns instead of *, using LIMIT 1, avoiding OR in WHERE, optimizing pagination, handling LIKE patterns, minimizing redundant indexes, preferring INNER JOIN, and leveraging covering indexes and EXPLAIN for efficient query execution.

Best PracticesDatabaseSQL optimization
0 likes · 18 min read
Writing High‑Quality SQL: Practical MySQL Optimization Tips
Top Architect
Top Architect
Jul 19, 2024 · Databases

Design and Implementation of Database Table Sharding for a Loan Repayment System

The article details a real‑world backend engineering project where a loan repayment service is refactored to use table sharding with ShardingSphere, covering design decisions, table naming, sharding algorithms, historical data migration, dynamic switches, transaction management, code examples, and practical pitfalls.

Databasebackenddata-migration
0 likes · 19 min read
Design and Implementation of Database Table Sharding for a Loan Repayment System
Selected Java Interview Questions
Selected Java Interview Questions
Jul 16, 2024 · Databases

SQL Query Optimization Techniques

This article explains how to speed up SQL queries while keeping statements concise, covering the query processing workflow, optimization goals, and practical tips such as selecting specific columns, avoiding DISTINCT, using proper indexes, preferring EXISTS over COUNT, limiting result sets, favoring WHERE over HAVING, and replacing correlated subqueries with joins.

DatabaseIndexesSQL
0 likes · 9 min read
SQL Query Optimization Techniques
FunTester
FunTester
Jul 16, 2024 · Backend Development

Mastering JDBC: Best Practices for Secure and Efficient Java Database Access

This guide explains how to set up JDBC drivers, construct connection URLs, use PreparedStatement instead of Statement, iterate ResultSet safely, manage resources with try‑with‑resources, handle transactions, employ connection pools, and properly process SQLExceptions for robust Java database applications.

Connection PoolDatabaseJDBC
0 likes · 15 min read
Mastering JDBC: Best Practices for Secure and Efficient Java Database Access
Java Tech Enthusiast
Java Tech Enthusiast
Jul 12, 2024 · Databases

New Features, Deprecations, and Removals in MySQL 9.0

MySQL 9.0, released July 2 2024, introduces EXPLAIN JSON output stored in variables, native EVENT DDL statements, and two new performance‑schema tables for variable metadata, while deprecating the old variables_info columns and removing the mysql_native_password plugin in favor of caching_sha2_password, enhancing observability and security.

AuthenticationDatabaseEXPLAIN
0 likes · 11 min read
New Features, Deprecations, and Removals in MySQL 9.0
Tencent Cloud Developer
Tencent Cloud Developer
Jul 11, 2024 · Databases

LibraDB Execution Engine Architecture Evolution and Optimization

LibraDB, the column‑store replica of TDSQL MySQL, has evolved its execution engine from a simple scatter‑gather model to a vectorized SMP pipeline that integrates MPP parallelism, asynchronous I/O, SIMD‑accelerated aggregation and join operators, work‑stealing, and runtime filters, thereby fully exploiting CPU, memory, network and disk resources for both OLTP and analytical queries.

DatabaseExecution EngineHash Join
0 likes · 22 min read
LibraDB Execution Engine Architecture Evolution and Optimization
Architecture Digest
Architecture Digest
Jul 8, 2024 · Backend Development

Introducing Easy-Query: A High‑Performance Java ORM with Fluent Query API

This article explains the motivation behind creating the Easy-Query ORM for Java, demonstrates its fluent query capabilities—including single‑record, list, pagination, joins, sub‑queries, group‑by, native SQL and dynamic condition features—provides extensive code examples, and shares repository links for further exploration.

Backend DevelopmentDatabaseEasy-Query
0 likes · 10 min read
Introducing Easy-Query: A High‑Performance Java ORM with Fluent Query API
Java Tech Enthusiast
Java Tech Enthusiast
Jul 7, 2024 · Databases

MySQL Query Optimization and Performance Tuning Guide

This guide presents a thorough MySQL performance checklist, covering efficient SQL writing, data‑type choices, selective column retrieval, smart joins, batch inserts, and query‑cache settings; it details key InnoDB and server variable tuning, proper index creation and usage, common pitfalls, and how to analyze and improve queries with EXPLAIN.

Databasemysqlquery optimization
0 likes · 17 min read
MySQL Query Optimization and Performance Tuning Guide
Architect
Architect
Jul 5, 2024 · Databases

Step-by-Step Guide to Deploy PostgreSQL Master‑Slave Replication

This article provides a comprehensive, hands‑on tutorial for planning, installing, configuring, and verifying a PostgreSQL master‑slave (streaming replication) setup on two Linux nodes, including user creation, remote connection settings, data export/import, and troubleshooting tips.

DatabaseLinuxMaster‑Slave
0 likes · 14 min read
Step-by-Step Guide to Deploy PostgreSQL Master‑Slave Replication
Zhuanzhuan Tech
Zhuanzhuan Tech
Jul 3, 2024 · Databases

Analysis of MySQL DELETE Deadlock and Locking Mechanisms

This article examines why identical DELETE statements on a MySQL table with a unique index can cause deadlocks, reviews InnoDB lock types, reproduces the issue with SQL and Java code, and discusses mitigation strategies such as version upgrades, isolation level changes, and distributed locks.

DELETEDatabaseInnoDB
0 likes · 14 min read
Analysis of MySQL DELETE Deadlock and Locking Mechanisms
Python Programming Learning Circle
Python Programming Learning Circle
Jul 3, 2024 · Operations

17 Practical Python Scripts for Automating Everyday Tasks

This article presents 17 versatile Python scripts that automate common tasks such as file management, web scraping, email handling, Excel processing, database interaction, system administration, and more, offering code examples and explanations to help developers and analysts improve productivity.

DatabasePythonScripting
0 likes · 28 min read
17 Practical Python Scripts for Automating Everyday Tasks
Java Tech Enthusiast
Java Tech Enthusiast
Jul 3, 2024 · Databases

MySQL Database Backup with Shell Script and Cron

This guide explains how to set up automated MySQL database backups using a shell script that runs mysqldump (optionally compressed), stores the files on a local disk, makes the script executable, and schedules it with a cron job after verifying disk space and cron availability.

DatabaseLinuxbackup
0 likes · 5 min read
MySQL Database Backup with Shell Script and Cron
dbaplus Community
dbaplus Community
Jul 2, 2024 · Databases

What’s New in MySQL 9.0 Innovation Edition? Key Features and Improvements

MySQL 9.0 Innovation Edition, released on July 1, 2024, introduces major changes such as the removal of the mysql_native_password plugin, new PREPARE support for event statements, expanded Performance Schema tables, JSON‑formatted EXPLAIN ANALYZE output, Windows installer fixes, and several MySQL Shell enhancements.

DatabaseInnovationEditionMySQLShell
0 likes · 4 min read
What’s New in MySQL 9.0 Innovation Edition? Key Features and Improvements
macrozheng
macrozheng
Jul 2, 2024 · Backend Development

How to Speed Up Excel-to-Database Imports with Async and Thread Pool Tuning

Learn how to efficiently import large Excel files into a database using POI, JDBC, MyBatis, and Spring Boot, with step-by-step code examples, performance bottlenecks, and optimization techniques such as caching, asynchronous processing, multi-threaded batch inserts, and thread‑pool configuration for maximum throughput.

AsyncDatabaseExcel
0 likes · 16 min read
How to Speed Up Excel-to-Database Imports with Async and Thread Pool Tuning
Java Architect Essentials
Java Architect Essentials
Jun 26, 2024 · Databases

Why Organizations Should Consider Using Apache Kafka Instead of Relational Databases

This article explains why organizations may replace traditional relational databases with Apache Kafka as a system of record, highlighting Kafka's economic, scalable, immutable log capabilities, event replay, flexibility for diverse use cases, and its suitability for highly regulated, data‑intensive environments.

Data StreamingDatabaseEvent-Driven Architecture
0 likes · 10 min read
Why Organizations Should Consider Using Apache Kafka Instead of Relational Databases
php Courses
php Courses
Jun 26, 2024 · Backend Development

Implementing Purchase Quantity Limits in a PHP E‑Commerce Store

This article explains how to design the database, modify product detail, cart, and order pages, and use Ajax in PHP to enforce purchase quantity limits based on stock levels, ensuring accurate inventory management and improved user experience in online stores.

Databasebackende-commerce
0 likes · 4 min read
Implementing Purchase Quantity Limits in a PHP E‑Commerce Store
DevOps
DevOps
Jun 26, 2024 · Backend Development

Understanding Distributed Transaction Challenges and Practical Solutions in Microservices

This article analyzes why distributed transactions are difficult in large‑scale microservice architectures, explains the importance of unique transaction IDs, idempotency, and timeout handling, and presents pragmatic approaches such as local logging, undo‑log tables, NoSQL ID arrays, and selective locking to achieve reliable consistency.

DatabaseIdempotencyMicroservices
0 likes · 15 min read
Understanding Distributed Transaction Challenges and Practical Solutions in Microservices
Su San Talks Tech
Su San Talks Tech
Jun 22, 2024 · Backend Development

How to Speed Up Excel-to-Database Imports with Async and Thread‑Pool Tuning in Java

This article explains the common slow approach of reading Excel files with POI and inserting rows via JDBC, then presents three practical optimizations—caching data, using asynchronous multithreaded reads, and per‑file async processing—along with thread‑pool configuration tips and EasyExcel examples to dramatically reduce import time from minutes to seconds.

AsyncDatabaseExcel
0 likes · 17 min read
How to Speed Up Excel-to-Database Imports with Async and Thread‑Pool Tuning in Java
macrozheng
macrozheng
Jun 21, 2024 · Backend Development

Master MyBatis Dynamic SQL: 9 Essential Tag Techniques for Cleaner Code

This article walks through MyBatis dynamic SQL tags—foreach, concat, choose, selectKey, if, where, trim, set, and sql fragments—explaining their attributes, usage patterns, and common pitfalls, and provides complete XML and Java code examples for each technique.

DatabaseDynamic SQLJava
0 likes · 20 min read
Master MyBatis Dynamic SQL: 9 Essential Tag Techniques for Cleaner Code
php Courses
php Courses
Jun 19, 2024 · Databases

Using mysqli_fetch_assoc in PHP to Retrieve Query Results

This tutorial explains how to connect to a MySQL database using PHP's mysqli extension, execute queries with mysqli_query, and retrieve each row with mysqli_fetch_assoc, providing complete code examples and a full script for efficient database handling.

DatabaseMySQLiPHP
0 likes · 4 min read
Using mysqli_fetch_assoc in PHP to Retrieve Query Results