BestHub
Sign in
Tagged articles
2776 articles
Page 1 of 28
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 25, 2026 · Databases

11 Golden Rules for SQL Performance Optimization

This article explains why inefficient SQL queries cause most database bottlenecks and presents eleven concrete rules—covering indexes, SELECT *, LIMIT, WHERE clause tuning, join strategies, execution‑plan analysis, subqueries, DISTINCT, ORDER BY/GROUP BY, UNION vs UNION ALL, and query decomposition with materialized views—to help developers systematically improve SQL execution speed on MySQL and Oracle.

IndexesOptimizationOracle
0 likes · 16 min read
11 Golden Rules for SQL Performance Optimization
IT Services Circle
IT Services Circle
May 24, 2026 · Information Security

Fired, He Deleted 96 Government Databases in Minutes and Asked AI How to Clear Logs

Just five minutes after being terminated, twin brothers with prior fraud convictions used SQL commands to drop 96 U.S. government databases, queried AI on log‑clearing techniques, and exposed critical failures in the company's off‑boarding process, leading to a high‑profile federal investigation and legal fallout.

AIIncident ResponseInformation Security
0 likes · 9 min read
Fired, He Deleted 96 Government Databases in Minutes and Asked AI How to Clear Logs
Big Data Tech Team
Big Data Tech Team
May 24, 2026 · Big Data

Data Warehouse Interview Pitfall Guide 2.0: Avoid Common SQL, Modeling, and ETL Mistakes

This guide compiles the most frequent interview pitfalls for data warehouse roles, covering SQL join and aggregation errors, window function misuse, subquery versus CTE performance myths, dimensional modeling mistakes, SCD implementation traps, layered design issues, data quality handling, ETL traps, Hive and Spark performance questions, real‑time warehousing considerations, and effective interview strategies.

Big DataETLHive
0 likes · 3 min read
Data Warehouse Interview Pitfall Guide 2.0: Avoid Common SQL, Modeling, and ETL Mistakes
dbaplus Community
dbaplus Community
May 20, 2026 · Databases

Stunning SQL Queries: From Tetris Game to Real‑Time Funnels

This article showcases a collection of impressive SQL queries—including a PostgreSQL Tetris implemented with a recursive CTE, window‑function session analysis, a ClickHouse real‑time funnel, dynamic WHERE clause generation, and a recursive employee hierarchy—while discussing performance tips and engine choices.

ClickHouseData WarehouseHive
0 likes · 25 min read
Stunning SQL Queries: From Tetris Game to Real‑Time Funnels
DataFunSummit
DataFunSummit
May 20, 2026 · Databases

Apache Doris 4.1: A Unified Data Store and Retrieval Engine for AI & Search

Apache Doris 4.1 introduces a systematic evolution for AI and search workloads, adding low‑cost massive vector storage, unified structured, full‑text and vector search, 100 MB JSON document support, Segment V3 metadata decoupling, sparse column optimizations, lakehouse lifecycle management, and a suite of performance‑boosting features such as aggregate push‑down, condition cache, and spill‑to‑disk, all backed by detailed benchmark results.

AIApache DorisLakehouse
0 likes · 30 min read
Apache Doris 4.1: A Unified Data Store and Retrieval Engine for AI & Search
Architect's Guide
Architect's Guide
May 20, 2026 · Databases

30 Essential SQL Query Optimization Techniques

This article presents thirty practical SQL optimization tips, covering index usage, avoiding full‑table scans caused by operators like !=, NULL checks, OR, LIKE, IN, functions, and expressions, as well as best practices for temporary tables, cursors, and transaction size to improve database performance.

DatabaseIndexesPerformance tuning
0 likes · 10 min read
30 Essential SQL Query Optimization Techniques
MaGe Linux Operations
MaGe Linux Operations
May 19, 2026 · Databases

How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds

This article walks through a real‑world MySQL slow‑query case, showing how to identify the bottleneck with EXPLAIN, design covering and composite indexes, rewrite the SQL, tune InnoDB parameters, and safely deploy the changes, ultimately shrinking execution time from seconds to a few milliseconds.

EXPLAINOptimizationPerformance tuning
0 likes · 32 min read
How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds
Su San Talks Tech
Su San Talks Tech
May 17, 2026 · Databases

Why Leading Companies Avoid NULL Values in MySQL

The article explains why major tech companies discourage using NULL in MySQL, covering its meaning as an unknown state, three-valued logic pitfalls such as NOT IN subqueries, index inefficiencies, aggregate function quirks, storage overhead, Java handling issues, and offers practical alternatives like NOT NULL constraints with sensible defaults.

Database DesignIndex OptimizationNULL
0 likes · 11 min read
Why Leading Companies Avoid NULL Values in MySQL
Architecture Digest
Architecture Digest
May 15, 2026 · Databases

Why Alibaba Bans Joins Over Three Tables – A Must‑Know Rule for SQL Engineers

Alibaba’s Java Development Manual mandates that any SQL involving more than three tables must be avoided, a rule that stems from the exponential cost of multi‑table joins in a single‑instance database, prompting engineers to rethink data modeling, adopt denormalization, wide tables, materialized views, CQRS or application‑level assembly instead of relying on complex joins.

AlibabaCQRSDatabase Design
0 likes · 12 min read
Why Alibaba Bans Joins Over Three Tables – A Must‑Know Rule for SQL Engineers
Architect's Guide
Architect's Guide
May 14, 2026 · Databases

8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them

The article enumerates eight common MySQL query patterns—such as large‑offset LIMIT, implicit type conversion, sub‑query updates, mixed ordering, unnecessary EXISTS, poor condition push‑down, early range reduction, and inefficient intermediate result handling—and shows rewritten SQL that reduces execution time from seconds to milliseconds.

IndexesJoinPerformance
0 likes · 15 min read
8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them
JD Tech
JD Tech
May 13, 2026 · Databases

Deep Dive into Using JSON Fields in Databases: Practical Lessons and Pitfalls

This article walks through the rationale, common functions, and real‑world case studies of storing and querying JSON columns in a relational database, exposing issues with null handling, batch updates, and dynamic SQL generation, and presents step‑by‑step debugging and robust solutions.

Batch UpdateDatabaseDynamic Queries
0 likes · 11 min read
Deep Dive into Using JSON Fields in Databases: Practical Lessons and Pitfalls
Aikesheng Open Source Community
Aikesheng Open Source Community
May 11, 2026 · Artificial Intelligence

SCALE April 2026 Large‑Model SQL Capability Ranking Unveiled

The SCALE April 2026 report adds four new models—DeepSeek‑V4‑Pro, DeepSeek‑V4‑Flash, GPT‑5.5 and Claude Opus 4.7—to its SQL capability leaderboard, evaluates them across SQL understanding, optimization and dialect conversion, and highlights each model’s strengths, weaknesses, and recommended deployment scenarios.

AI BenchmarkDialect ConversionSQL
0 likes · 17 min read
SCALE April 2026 Large‑Model SQL Capability Ranking Unveiled
SpringMeng
SpringMeng
May 2, 2026 · Artificial Intelligence

10 Essential AI Prompt Templates Every Programmer Needs

This article presents ten practical AI prompt templates that help programmers efficiently handle requirement clarification, unit test generation, code explanation, refactoring, exception troubleshooting, performance tuning, SQL creation, knowledge documentation, design review, and cross‑language translation, each illustrated with concrete examples and usage tips.

AI promptingBackend DevelopmentCode Review
0 likes · 13 min read
10 Essential AI Prompt Templates Every Programmer Needs
Lin is Dream
Lin is Dream
Apr 29, 2026 · Artificial Intelligence

Where Do Agent Capabilities Come From? A High‑Frequency Skill Toolset for AI Agents

This article presents a practical collection of high‑frequency tools—including Python, Shell, SQL, Mermaid, Pandoc, curl, ImageMagick, and PlantUML—that can be wrapped as Agent Skills to give AI agents real execution power, illustrated with concrete prompts and scripts that cut manual work from hours to seconds.

Agent SkillImageMagickMermaid
0 likes · 13 min read
Where Do Agent Capabilities Come From? A High‑Frequency Skill Toolset for AI Agents
Java Baker
Java Baker
Apr 22, 2026 · Databases

A Step‑by‑Step SOP for Seamless Business Data Migration

This article outlines a comprehensive, risk‑controlled SOP for migrating business data—including model changes, storage shifts, incremental dual‑write, back‑filling, full and incremental consistency checks, read‑switching, and final decommissioning—backed by concrete SQL examples and visual diagrams.

Data ConsistencyData MigrationDatabase
0 likes · 6 min read
A Step‑by‑Step SOP for Seamless Business Data Migration
AI Large-Model Wave and Transformation Guide
AI Large-Model Wave and Transformation Guide
Apr 20, 2026 · Artificial Intelligence

Build a No‑Code AI SQL Assistant with Dify in 12 Simple Steps

This step‑by‑step guide shows how to create a natural‑language database query assistant using Dify by preparing a test MySQL database, creating a read‑only user, installing the Dify database plugin, configuring the connection, building an Agent with a strong SQL‑capable LLM, setting prompts, adding Text‑to‑SQL and SQL‑Execute tools, testing simple, filtered and aggregate queries, and finally extending to multi‑table scenarios.

AIDatabaseDify
0 likes · 9 min read
Build a No‑Code AI SQL Assistant with Dify in 12 Simple Steps
dbaplus Community
dbaplus Community
Apr 19, 2026 · Databases

Why Vector Databases Exist: Overcoming SQL’s Blind Spot in AI Search

This guide explains how traditional relational databases and SQL struggle with semantic queries needed for AI applications, introduces vector databases and HNSW indexing for efficient similarity search, compares their architectures, and presents a real‑world fraud detection system that combines both technologies.

AIB+TreeHNSW
0 likes · 17 min read
Why Vector Databases Exist: Overcoming SQL’s Blind Spot in AI Search
Coder Trainee
Coder Trainee
Apr 7, 2026 · Backend Development

Setting Up Seata (pre‑1.0) for Distributed Transactions in Microservices

This guide explains what a distributed transaction is and walks through the complete setup of a Seata server (version 0.9.0), including downloading, configuring file.conf and registry.conf for Nacos, initializing the database, starting services, and creating the required undo_log table.

MicroservicesNacosSQL
0 likes · 4 min read
Setting Up Seata (pre‑1.0) for Distributed Transactions in Microservices
macrozheng
macrozheng
Apr 7, 2026 · Backend Development

Boost Your MyBatis Workflow in IDEA with MyBatisCodeHelper-Pro – A Complete Guide

This article introduces the MyBatisCodeHelper-Pro IntelliJ IDEA plugin, outlines its popular features such as mapper navigation, @Param generation, XML creation, pagination support, Spring integration, and SQL log conversion, and provides step‑by‑step installation and usage instructions with screenshots.

Backend DevelopmentIntelliJ IDEAMyBatis
0 likes · 5 min read
Boost Your MyBatis Workflow in IDEA with MyBatisCodeHelper-Pro – A Complete Guide
MaGe Linux Operations
MaGe Linux Operations
Apr 5, 2026 · Databases

Master MySQL Slow Query Optimization: From Logs to Indexes

This comprehensive guide explains how to detect, analyze, and optimize MySQL slow queries by configuring the slow‑query log, using pt‑query‑digest, interpreting EXPLAIN output, designing effective B+Tree indexes, avoiding common index pitfalls, optimizing count(*) operations, improving deep pagination, rewriting inefficient SQL patterns, and applying advanced table design techniques such as partitioning and sharding.

EXPLAINPerformance tuningSQL
0 likes · 40 min read
Master MySQL Slow Query Optimization: From Logs to Indexes
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 2, 2026 · Artificial Intelligence

How ADB MySQL Turns Agent Logs into Actionable Insights – A Step‑by‑Step Guide

This article analyzes why over 40% of Agentic AI projects fail due to inadequate observability, outlines three common pain points—trace blindness, uncontrolled token costs, and untraceable failures—and demonstrates a practical ADB MySQL solution that reconstructs logs, classifies failures with AI functions, quantifies token waste, and generates prompt‑optimization suggestions, all with a few SQL statements.

ADB MySQLAI agentsAgent Observability
0 likes · 10 min read
How ADB MySQL Turns Agent Logs into Actionable Insights – A Step‑by‑Step Guide
dbaplus Community
dbaplus Community
Mar 31, 2026 · Industry Insights

Why Most Data Governance Projects Fail and How to Build a Practical, Engineer‑Friendly Solution

Most companies see data governance fail not because of technology but because they start with the wrong direction, focusing on rules, platforms, and processes that add friction instead of improving data usability, and the article provides a step‑by‑step, low‑overhead approach with concrete SQL and Python templates to fix it.

Engineering ProductivityMetadata ManagementPython
0 likes · 25 min read
Why Most Data Governance Projects Fail and How to Build a Practical, Engineer‑Friendly Solution
Big Data Tech Team
Big Data Tech Team
Mar 30, 2026 · Big Data

2026 Data Warehouse Interview Guide: Essential Questions for All Three Rounds

This article compiles a comprehensive set of data‑warehouse interview questions—including self‑introduction prompts, SQL and window‑function challenges, data‑skew solutions, architecture design, file‑format trade‑offs, governance, and team‑leadership topics—to help candidates prepare for first, second, and third‑round interviews at leading tech firms.

Big DataInterview preparationSQL
0 likes · 7 min read
2026 Data Warehouse Interview Guide: Essential Questions for All Three Rounds
java1234
java1234
Mar 29, 2026 · Backend Development

Why MyBatis Is Called a Semi‑ORM Mapping Tool

MyBatis, a widely used Java persistence framework, blends SQL mapping with traditional JDBC, requiring developers to write SQL manually, offering greater flexibility and performance than full ORM solutions like Hibernate, while providing only persistence operations without encapsulating complex business logic.

HibernateJavaMyBatis
0 likes · 6 min read
Why MyBatis Is Called a Semi‑ORM Mapping Tool
dbaplus Community
dbaplus Community
Mar 26, 2026 · Databases

Six Fatal MySQL Index Traps and How to Avoid Them

A real‑world incident of soaring QPS reveals six common MySQL indexing pitfalls—type mismatches, function usage, left‑most prefix violations, implicit charset conversion, range query side effects, and optimizer mis‑selection—and provides concrete SQL fixes and verification tools to keep queries fast and reliable.

Database TuningIndex OptimizationQuery Pitfalls
0 likes · 6 min read
Six Fatal MySQL Index Traps and How to Avoid Them
Java Architect Essentials
Java Architect Essentials
Mar 23, 2026 · Databases

When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes

A backend engineer discovers that a massive MySQL table’s auto‑increment INT primary key reached its maximum value, causing insert failures, and walks through detailed analysis, three remediation options—including switching to BIGINT, redesigning IDs, and sharding—plus practical scripts, performance measurements, and lessons learned about concurrency and schema design.

BIGINTPerformanceSQL
0 likes · 10 min read
When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes
Architect's Guide
Architect's Guide
Mar 20, 2026 · Backend Development

How We Cut 1‑Second Query Times in a Legacy WAF Dashboard Using Redis Caching

Facing slow page loads in a legacy WAF reporting system, we dissected a 1000‑line Java method, introduced hourly aggregation, Redis auto‑increment counters, and scheduled synchronization, eliminating costly SQL scans and achieving sub‑second queries on 1.5 million logs, while outlining remaining optimization opportunities.

JavaPerformance OptimizationRedis
0 likes · 12 min read
How We Cut 1‑Second Query Times in a Legacy WAF Dashboard Using Redis Caching
JD Tech Talk
JD Tech Talk
Mar 18, 2026 · Databases

Mastering Dynamic JSON Fields in MySQL: Real‑World Cases and Pitfalls

This article explains how to store and query extensible JSON columns in a MySQL‑based system, lists the most useful JSON functions, walks through several real‑world scenarios—including dynamic extension queries and weight‑management cases—identifies subtle bugs caused by null values, and presents step‑by‑step SQL and MyBatis fixes to ensure reliable batch updates.

DatabaseDebuggingDynamicFields
0 likes · 15 min read
Mastering Dynamic JSON Fields in MySQL: Real‑World Cases and Pitfalls
Architecture & Thinking
Architecture & Thinking
Mar 18, 2026 · Databases

10 Common MySQL Index Failure Scenarios and How to Fix Them

Even well‑designed indexes can become ineffective in production, leading to full‑table scans; this article systematically examines ten typical MySQL index‑failure cases—ranging from functions on indexed columns to low selectivity—and provides concrete SQL rewrites, performance comparisons, and diagnostic tools to help developers avoid and resolve these issues.

OptimizationPerformanceSQL
0 likes · 17 min read
10 Common MySQL Index Failure Scenarios and How to Fix Them
21CTO
21CTO
Mar 14, 2026 · Databases

Why SQL Is Making a Comeback: From Browsers to Backend

The article explores how three emerging trends—lightweight client‑side databases, schema‑less JSONB support, and modern synchronization engines—are reviving SQL, making it a first‑class data language for browsers, edge computing, and traditional back‑ends while preserving strong consistency and developer productivity.

JSONBSQLSynchronization
0 likes · 10 min read
Why SQL Is Making a Comeback: From Browsers to Backend
Java Tech Enthusiast
Java Tech Enthusiast
Mar 13, 2026 · Databases

When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation

This article explains why using SELECT * does not automatically invalidate MySQL indexes, explores common scenarios that cause index loss such as left‑most prefix violations, function calls, implicit type conversions, wildcard LIKE patterns, OR/IN/NOT IN misuse, and ORDER BY pitfalls, and provides practical optimization recommendations with concrete SQL examples and verification methods.

DatabaseOptimizationQuery Tuning
0 likes · 14 min read
When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation
Architecture & Thinking
Architecture & Thinking
Mar 13, 2026 · Databases

Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It

The article explains how deep pagination on massive MySQL tables causes full‑table scans, massive I/O, and memory pressure, then presents six concrete optimization techniques—including delayed join, cursor pagination, covering indexes, ID‑range pagination, caching, and partitioning—backed by a real‑world e‑commerce case study and detailed execution‑plan analysis.

Performance OptimizationSQLdeep pagination
0 likes · 18 min read
Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It
StarRocks
StarRocks
Mar 11, 2026 · Databases

How StarRocks Supercharges Real‑Time Ad Funnel Monitoring and Creative Optimization

This article dissects the full advertising funnel, explains why CTR and eCPM are critical, and demonstrates how StarRocks combined with Flink can deliver minute‑level real‑time monitoring, material selection, anomaly alerts, A/B testing, and a successful migration from Druid for massive ad‑tech workloads.

AdvertisingMaterialized ViewsSQL
0 likes · 20 min read
How StarRocks Supercharges Real‑Time Ad Funnel Monitoring and Creative Optimization
Selected Java Interview Questions
Selected Java Interview Questions
Mar 9, 2026 · Databases

How to Paginate Efficiently Across Sharded Databases Without OOM

This article explains why pagination only becomes complex when querying across sharded databases, compares three common solutions—including global search, sequential ID‑based paging, and the discouraged secondary query method—provides practical SQL examples, outlines pros and cons, and offers a STAR‑style interview answer.

SQLShardingpagination
0 likes · 6 min read
How to Paginate Efficiently Across Sharded Databases Without OOM
JavaGuide
JavaGuide
Mar 9, 2026 · Databases

Does SELECT * Always Invalidate Indexes? Why Some Teams Ban It

While many believe that using SELECT * inevitably disables indexes, MySQL’s optimizer only skips indexes when a full table scan is cheaper, and patterns such as violating the left‑most prefix, applying functions or implicit casts, leading‑wildcard LIKE, OR/IN misuse, and mismatched ORDER BY can cause index invalidation, prompting some companies to forbid SELECT * in production.

DatabaseIndex OptimizationPerformance tuning
0 likes · 14 min read
Does SELECT * Always Invalidate Indexes? Why Some Teams Ban It
SpringMeng
SpringMeng
Mar 9, 2026 · Databases

10 Advanced MySQL Techniques to Supercharge Query Performance

This article walks through ten high‑level MySQL tricks—including EXPLAIN analysis, advanced indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user‑defined variables, online DDL, and generated columns—showing concrete examples, performance trade‑offs, and step‑by‑step guidance for turning slow queries into lightning‑fast operations.

CTEPartitioningPerformance
0 likes · 15 min read
10 Advanced MySQL Techniques to Supercharge Query Performance
java1234
java1234
Mar 8, 2026 · Backend Development

How to Build a Custom MyBatis Plugin: Step-by-Step Guide

This article explains the MyBatis plugin mechanism, walks through implementing the Interceptor interface, configuring the plugin in mybatis-config.xml, provides a complete code example, and outlines common use cases such as SQL logging, performance monitoring, permission control, and automatic field filling.

InterceptorJavaMyBatis
0 likes · 6 min read
How to Build a Custom MyBatis Plugin: Step-by-Step Guide
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 6, 2026 · Big Data

How DataWorks Turns Data Quality Rules into Code with Data Contracts

This article explains how DataWorks integrates data quality specifications directly into the SQL development workflow using Data Contracts, addressing governance lag, versioning gaps, and trust issues while providing a unified, version‑controlled, and automated quality assurance process for offline data pipelines.

DataWorksSQLYAML
0 likes · 12 min read
How DataWorks Turns Data Quality Rules into Code with Data Contracts
ITPUB
ITPUB
Mar 5, 2026 · Databases

How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide

This article explains what the Oracle TRUNCATE command does, why recovery is challenging, and provides detailed step‑by‑step instructions for four practical tools—FY_Recover_Data, ODU, BBED, and GDUL—to restore data from a mistakenly truncated table.

Data RecoveryDatabase AdministrationOracle
0 likes · 5 min read
How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide
ITPUB
ITPUB
Mar 2, 2026 · Backend Development

Eliminate Unstable Pagination Anchors: Reliable Cursor and Timestamp Strategies for Backend Systems

This article explains why traditional offset‑based pagination can cause duplicate or missing records when data changes, compares three practical solutions—including cursor pagination with timestamp + unique key, fixed‑window timestamp filtering, and Elasticsearch’s search_after/scroll methods—detailing their implementation, pros, cons, and suitable scenarios.

CursorElasticsearchPerformance
0 likes · 14 min read
Eliminate Unstable Pagination Anchors: Reliable Cursor and Timestamp Strategies for Backend Systems
Java Architect Handbook
Java Architect Handbook
Mar 1, 2026 · Backend Development

When to Use #{} vs ${} in MyBatis? A Deep Dive for Java Interviews

This article explains the interview focus on MyBatis placeholders, detailing the syntax, security implications, performance differences, appropriate scenarios, best‑practice guidelines, common pitfalls, and provides concrete code examples to help candidates master #{} and ${} usage.

InterviewJavaMyBatis
0 likes · 9 min read
When to Use #{} vs ${} in MyBatis? A Deep Dive for Java Interviews
ITPUB
ITPUB
Feb 24, 2026 · Databases

Why INSERT … SELECT Can Lock Your Table and How an Index Saves the Day

A real‑world MySQL incident shows that using INSERT … SELECT without proper indexing can cause full‑table scans and progressive row locks, leading to massive payment failures, but adding an index on the filter column prevents the lock and restores safe batch migration.

INSERT SELECTSQLindex
0 likes · 8 min read
Why INSERT … SELECT Can Lock Your Table and How an Index Saves the Day
ITPUB
ITPUB
Feb 20, 2026 · Databases

Master PostgreSQL Health Checks with Open‑Source SKILL Scripts

This guide introduces a collection of PostgreSQL SKILL scripts for automated health checks and operational analysis, explains the repository layout, shows how to run individual or full daily checks, lists all available skills, and provides a sample report with actionable recommendations.

Database MonitoringPostgreSQLSQL
0 likes · 11 min read
Master PostgreSQL Health Checks with Open‑Source SKILL Scripts
Java Tech Enthusiast
Java Tech Enthusiast
Feb 16, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents eleven practical MySQL advanced techniques—including execution‑plan analysis, sophisticated indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user variables, online DDL, and generated columns—each explained with real‑world examples, code snippets, and performance caveats to help developers move from basic usage to mastery.

AdvancedOptimizationSQL
0 likes · 20 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
dbaplus Community
dbaplus Community
Feb 10, 2026 · Backend Development

How to Eliminate Unstable Pagination Anchors and Data Duplication in Backend Systems

This article explains why offset‑based pagination can cause duplicate or missing records in backend list queries, illustrates real‑world cases, analyzes the root causes, and presents three practical solutions—including cursor pagination, timestamp windows, and Elasticsearch search_after—along with their trade‑offs and implementation details.

CursorElasticsearchPerformance
0 likes · 12 min read
How to Eliminate Unstable Pagination Anchors and Data Duplication in Backend Systems
Java Architecture Diary
Java Architecture Diary
Feb 10, 2026 · Artificial Intelligence

Boost RAG Accuracy with LangChain4j 1.11.0 Hybrid Search on PgVector

This guide explains why pure vector retrieval often fails for version‑specific queries, introduces hybrid search that combines semantic and keyword matching, and provides step‑by‑step code and SQL examples for enabling PgVector hybrid search in LangChain4j 1.11.0.

Full-Text SearchHybrid SearchLangChain4j
0 likes · 11 min read
Boost RAG Accuracy with LangChain4j 1.11.0 Hybrid Search on PgVector
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 9, 2026 · Databases

What the Latest SCALE Benchmark Shows About SQL Optimization in GLM‑4.7 and Seed‑OSS‑36B

The January 2026 SCALE benchmark adds an index‑suggestion metric and evaluates two new LLMs—智谱 GLM‑4.7 and 字节跳动 Seed‑OSS‑36B—revealing strengths in dialect conversion, moderate SQL understanding, and notable gaps in complex execution‑plan analysis and practical index recommendations.

AI benchmarkingDatabase OptimizationDialect Conversion
0 likes · 15 min read
What the Latest SCALE Benchmark Shows About SQL Optimization in GLM‑4.7 and Seed‑OSS‑36B
21CTO
21CTO
Feb 7, 2026 · Databases

Why Google Renamed ZetaSQL to GoogleSQL and What It Means for Developers

Google announced on February 6, 2026 that its open‑source SQL analysis framework ZetaSQL will be renamed GoogleSQL to unify the project name with the official language spec, eliminate community confusion, and clarify its role in the Google data ecosystem without changing any code or functionality.

BigQueryGoogleSQLOpenSource
0 likes · 4 min read
Why Google Renamed ZetaSQL to GoogleSQL and What It Means for Developers
ITPUB
ITPUB
Feb 5, 2026 · Databases

Master Oracle 19c RAC Architecture in 41 Diagrams – Quick Technical Guide

This article translates and consolidates Oracle Real Application Clusters 19c Technical Architecture, using 41 detailed diagrams to explain RAC concepts, configurations, cluster components, storage options, tools, and management commands for building and operating high‑availability Oracle databases.

ASMEnterprise ManagerGrid Infrastructure
0 likes · 52 min read
Master Oracle 19c RAC Architecture in 41 Diagrams – Quick Technical Guide
Data STUDIO
Data STUDIO
Feb 5, 2026 · Fundamentals

9 Underrated Python Libraries That Can Boost Your Development Speed Tenfold

The article introduces nine lesser‑known Python packages—msgspec, glom, watchfiles, beartype, pyinstrument, duckdb, fakeredis, boltons, and returns—explaining how each tackles common prototyping pain points such as data serialization, file watching, runtime type safety, performance profiling, SQL querying without a server, mock Redis, utility functions, and explicit error handling, ultimately accelerating development by up to ten times.

Functional ProgrammingProfilingPython
0 likes · 25 min read
9 Underrated Python Libraries That Can Boost Your Development Speed Tenfold
IT Services Circle
IT Services Circle
Feb 4, 2026 · Databases

How to Optimize Multi‑Table Joins in MySQL: Practical Strategies

This article explains why excessive MySQL joins—often inherited from legacy or Oracle‑migration code—cause performance and maintenance problems, and presents nine concrete optimization techniques including SQL splitting, temporary tables, redundant fields, index tuning, query rewriting, result‑set reduction, configuration tweaks, big‑data tools, and materialized summary tables.

Database PerformanceJOIN optimizationSQL
0 likes · 11 min read
How to Optimize Multi‑Table Joins in MySQL: Practical Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Feb 4, 2026 · Databases

How to Handle Pagination Across Sharded Databases Without Performance Pitfalls

This article explains why pagination only becomes complex when queries span multiple database shards, compares three mainstream solutions—including middleware, open‑source frameworks, and business compromises—highlights the pitfalls of global search for deep pages, and recommends sequential paging based on the previous page’s max ID, with interview‑ready STAR guidance.

InterviewPerformanceSQL
0 likes · 7 min read
How to Handle Pagination Across Sharded Databases Without Performance Pitfalls
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 28, 2026 · Databases

Master MySQL EXPLAIN: Decode Execution Plans with Real Examples

This guide introduces MySQL's EXPLAIN command, demonstrates how to create sample order and customer tables, runs various queries, and provides a detailed walkthrough of each column in the execution plan—including id, select_type, table, type, possible_keys, key, key_len, ref, rows, filtered, and extra—plus indexing tips and visual examples.

Database OptimizationEXPLAINSQL
0 likes · 7 min read
Master MySQL EXPLAIN: Decode Execution Plans with Real Examples
Top Architect
Top Architect
Jan 27, 2026 · Databases

How MySQL Router 8.2 Enables Seamless Read/Write Splitting with InnoDB ReplicaSet

This article demonstrates how MySQL Router 8.2 can automatically route read traffic to replica instances and write traffic to the primary instance in an InnoDB ReplicaSet, providing configuration steps, command examples, and observed behavior without requiring any changes to the application.

Database ConfigurationInnoDB ReplicaSetRouter
0 likes · 6 min read
How MySQL Router 8.2 Enables Seamless Read/Write Splitting with InnoDB ReplicaSet
FunTester
FunTester
Jan 21, 2026 · Databases

Mastering MySQL Upserts: INSERT IGNORE, REPLACE INTO, and ON DUPLICATE KEY UPDATE Explained

This article explains three MySQL INSERT variants—INSERT IGNORE, REPLACE INTO, and INSERT ... ON DUPLICATE KEY UPDATE—detailing their syntax, execution behavior, advantages, drawbacks, typical use cases, and practical comparison to help developers choose the most suitable method for handling duplicate or bulk data operations.

Duplicate KeyInsertSQL
0 likes · 12 min read
Mastering MySQL Upserts: INSERT IGNORE, REPLACE INTO, and ON DUPLICATE KEY UPDATE Explained
Big Data Tech Team
Big Data Tech Team
Jan 20, 2026 · Interview Experience

What ByteDance Asks: 3 Rounds of Data Warehouse Engineer Interview Questions

This article compiles the full set of first, second, and third‑round interview questions used by ByteDance for a data warehouse engineer role, covering topics such as window functions, data skew, shuffle mechanisms, data modeling, data quality, governance, and system design, along with interview duration and interviewer details.

ByteDanceData WarehouseSQL
0 likes · 5 min read
What ByteDance Asks: 3 Rounds of Data Warehouse Engineer Interview Questions
ITPUB
ITPUB
Jan 19, 2026 · Databases

Why IN/NOT IN Slow Down Queries and How to Replace Them

The article explains how using IN and NOT IN in SQL can dramatically hurt performance and produce incorrect results, especially with large tables or NULL values, and demonstrates safer alternatives such as EXISTS, NOT EXISTS, and JOIN with concrete code examples.

EXISTSINJoin
0 likes · 6 min read
Why IN/NOT IN Slow Down Queries and How to Replace Them
dbaplus Community
dbaplus Community
Jan 18, 2026 · Databases

Avoid These Common SQL Performance Pitfalls for Faster Queries

This guide enumerates frequent misconceptions in SQL performance—from over‑indexing and SELECT * misuse to improper transaction handling and outdated monitoring practices—explains why they hurt efficiency, and provides concrete, version‑aware solutions to optimize queries, schema design, and database operations.

DatabaseOptimizationPerformance
0 likes · 26 min read
Avoid These Common SQL Performance Pitfalls for Faster Queries
Top Architect
Top Architect
Jan 18, 2026 · Databases

Boost Your SQL Query Speed: Proven Optimization Techniques

This guide walks through the SQL query processing workflow, explains how parsing, optimization, and execution plans affect performance, and provides concrete techniques—such as selecting specific columns, avoiding DISTINCT, using proper indexes, preferring EXISTS over COUNT, limiting result sets, and replacing HAVING with WHERE—to dramatically speed up queries while keeping statements concise.

Database PerformanceIndexesSQL
0 likes · 8 min read
Boost Your SQL Query Speed: Proven Optimization Techniques
Ray's Galactic Tech
Ray's Galactic Tech
Jan 17, 2026 · Databases

Master MySQL Index Execution: From Index Key to Table Filter

This guide explains how MySQL processes queries in three index‑related stages—Index Key, Index Filter, and Table Filter—showing why keeping operations in the index layer dramatically improves performance and how to design and diagnose indexes effectively.

Database PerformanceIndex OptimizationSQL
0 likes · 9 min read
Master MySQL Index Execution: From Index Key to Table Filter
IT Services Circle
IT Services Circle
Jan 17, 2026 · Backend Development

Kuaishou Campus Salary Insights & Java Backend Interview Guide

The article reveals that Kuaishou’s 2023 campus hires for backend and frontend roles typically earn 40‑50 wan yuan annually, discusses salary trends compared with previous years, and then provides a comprehensive Java backend interview guide covering JVM memory, garbage collectors, CMS GC process, concurrency primitives, and SQL join differences.

InterviewJVMJava
0 likes · 15 min read
Kuaishou Campus Salary Insights & Java Backend Interview Guide
Go Development Architecture Practice
Go Development Architecture Practice
Jan 17, 2026 · Databases

What New SQL Features Did SQLite Add in 2018?

This article reviews SQLite's 2018 enhancements, covering boolean literals, window functions, the FILTER clause, upsert syntax, column‑renaming support, and related API changes, while also noting the remaining limitations compared with other major database systems.

Boolean LiteralsDatabase FeaturesSQL
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018?
SpringMeng
SpringMeng
Jan 16, 2026 · Backend Development

What Unexpected Pitfalls PageHelper Can Teach You After Years of Use

The article recounts a developer’s painful experience with PageHelper, detailing how duplicate registrations, truncated result sets, and password‑update errors stem from the plugin’s ThreadLocal pagination handling, and explains the underlying code paths and safe usage practices.

JavaMyBatisSQL
0 likes · 13 min read
What Unexpected Pitfalls PageHelper Can Teach You After Years of Use
Architect's Guide
Architect's Guide
Jan 16, 2026 · Databases

How to Safely Update Billions of MySQL Rows Without Overloading Binlog

This article explains why a naïve full‑table UPDATE on massive MySQL tables can cripple replication, explores deep‑pagination and IN‑clause inefficiencies, and presents a batch‑processing strategy using NO_CACHE, FORCE INDEX, and rate‑controlled scripts to perform safe, high‑performance updates.

Batch ProcessingFull Table UpdatePerformance Optimization
0 likes · 8 min read
How to Safely Update Billions of MySQL Rows Without Overloading Binlog
ITPUB
ITPUB
Jan 15, 2026 · Databases

How to Migrate ClickHouse Data to Doris: Three Practical Strategies Tested

Facing a ClickHouse cluster shutdown, the author explores three migration methods—using Doris’s ClickHouse catalog, exporting to files with Broker/Stream Load, and Spark—to transfer ~10 billion rows to Doris, evaluating each for simplicity, bugs, and performance, and sharing detailed steps, code snippets, and benchmark results.

ClickHouseData MigrationSQL
0 likes · 9 min read
How to Migrate ClickHouse Data to Doris: Three Practical Strategies Tested
macrozheng
macrozheng
Jan 15, 2026 · Databases

Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices

This guide explains why InnoDB fuzzy queries lose indexes, introduces MySQL full‑text search with inverted indexes, shows how to create and use full‑text indexes via CREATE TABLE and ALTER statements, and demonstrates natural language, boolean, and query‑expansion modes with practical SQL examples.

Boolean ModeDatabaseFull-Text Search
0 likes · 12 min read
Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices
Java Architect Handbook
Java Architect Handbook
Jan 13, 2026 · Databases

When to Normalize or Denormalize? A Deep Dive for Java Interview Prep

This article breaks down the interview expectations around database normalization, explains the theory and trade‑offs of normalization versus denormalization, provides SQL code examples, compares design impacts, offers best‑practice guidelines, and warns against common misconceptions.

Database DesignDenormalizationInterview preparation
0 likes · 11 min read
When to Normalize or Denormalize? A Deep Dive for Java Interview Prep
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Jan 13, 2026 · Databases

Turn PostgreSQL into a Graph Database with Apache AGE

This guide explains how Apache AGE extends PostgreSQL with OpenCypher‑compatible graph capabilities, covering architecture, installation, storage schema, Cypher‑SQL integration, common graph operations, and a LangChain example that turns natural‑language questions into executable graph queries.

Apache AGECypherGraph Database
0 likes · 11 min read
Turn PostgreSQL into a Graph Database with Apache AGE
Big Data Tech Team
Big Data Tech Team
Jan 12, 2026 · Fundamentals

Why Wide Tables Are Essential in DWS Layer: 10 Real-World Modeling Scenarios

This article explains the purpose of the DWS (Data Warehouse Service) layer, why wide‑table modeling is crucial for performance and service‑oriented interfaces, and provides ten practical wide‑table designs with core field definitions, CREATE TABLE statements, and sample INSERT queries for common business domains such as products, users, orders, regions, channels, suppliers, services, finance, logistics, and data quality monitoring.

AnalyticsETLSQL
0 likes · 34 min read
Why Wide Tables Are Essential in DWS Layer: 10 Real-World Modeling Scenarios
Ray's Galactic Tech
Ray's Galactic Tech
Jan 8, 2026 · Databases

Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching

This guide presents a comprehensive, step‑by‑step roadmap for accelerating slow SQL queries without altering the original statements, covering index creation, database parameter tuning, table partitioning, caching layers, read‑write splitting, sharding, statistics updates, hardware choices, and middleware routing.

CachingDatabase TuningIndexes
0 likes · 8 min read
Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching
Volcano Engine Developer Services
Volcano Engine Developer Services
Jan 8, 2026 · Databases

How VeDB Accelerates Fault Diagnosis with AI‑Powered RCA and Full‑SQL Insight

VeDB, ByteDance's cloud‑native distributed database, combines a four‑layer monitoring architecture, AI‑driven root‑cause analysis, full‑SQL insight, and second‑level metric collection to dramatically shorten MTTR, improve reliability, and support massive, high‑concurrency workloads across diverse production scenarios.

AIRCASQL
0 likes · 18 min read
How VeDB Accelerates Fault Diagnosis with AI‑Powered RCA and Full‑SQL Insight
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 8, 2026 · Databases

Understanding MySQL Transaction Isolation Levels with Practical Examples

This article explains MySQL's four transaction isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—by creating a simple table, running paired transactions, and showing how each level affects data visibility, concurrency, and potential anomalies such as dirty reads, non‑repeatable reads, and phantom reads.

Database ConcurrencyInnoDBSQL
0 likes · 10 min read
Understanding MySQL Transaction Isolation Levels with Practical Examples
SpringMeng
SpringMeng
Jan 7, 2026 · Interview Experience

Inside Xiao Meng’s Technical Interview: Real Questions and Insights

The article shares Xiao Meng’s full‑stack hiring process, listing practical first‑ and second‑round interview questions—from SQL pagination and SpringBoot CORS to RPC frameworks and AI‑assisted coding—while explaining the company’s focus on hands‑on ability and recent AI tool adoption.

AI coding toolsJavaSQL
0 likes · 6 min read
Inside Xiao Meng’s Technical Interview: Real Questions and Insights
Efficient Ops
Efficient Ops
Jan 6, 2026 · Databases

Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained

This article compiles a detailed comparison of PostgreSQL and MySQL, highlighting PostgreSQL's lack of text‑size limits, better NULL handling, native array and JSON support, built‑in optimistic locking, superior GIS types, MVCC, flexible indexing, robust replication, and overall stability, while also noting the few areas where MySQL still holds an edge.

GISJSONBPostgreSQL
0 likes · 9 min read
Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained
Woodpecker Software Testing
Woodpecker Software Testing
Jan 6, 2026 · Backend Development

How ChatGPT Analyzes and Optimizes Application Performance

The article shows how ChatGPT examines JMeter load‑test results, identifies CPU, database and I/O bottlenecks, and then proposes concrete optimizations such as adding indexes, tuning HikariCP pool settings, caching, code refactoring, and monitoring to improve login throughput and latency.

ChatGPTHikariCPJMeter
0 likes · 11 min read
How ChatGPT Analyzes and Optimizes Application Performance
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Jan 3, 2026 · Databases

Essential MySQL Commands Every DBA Should Know

This guide presents a comprehensive collection of essential MySQL commands, covering connection management, database creation and selection, table definition and alteration, CRUD operations, query optimization techniques, performance monitoring, and user permission handling, providing clear examples for each command.

AdministrationDatabasePerformance
0 likes · 7 min read
Essential MySQL Commands Every DBA Should Know
Java Architect Handbook
Java Architect Handbook
Jan 3, 2026 · Databases

When Should You Avoid JOINs in High‑Concurrency Systems?

The article analyzes a common Java interview question about using JOINs, explaining performance bottlenecks, scalability issues in distributed and micro‑service architectures, and offers practical guidelines and best‑practice alternatives for handling data associations efficiently.

Backend ArchitectureDatabase PerformanceJoin
0 likes · 9 min read
When Should You Avoid JOINs in High‑Concurrency Systems?
Ray's Galactic Tech
Ray's Galactic Tech
Jan 2, 2026 · Databases

How to Choose the Right PostgreSQL Isolation Level and Avoid Concurrency Bugs

PostgreSQL offers four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—each preventing specific concurrency anomalies like dirty reads, non‑repeatable reads, and phantom reads, and the article explains their behavior, configuration commands, practical usage, performance trade‑offs, and production best practices.

PostgreSQLSQLconcurrency
0 likes · 9 min read
How to Choose the Right PostgreSQL Isolation Level and Avoid Concurrency Bugs
Java Architect Handbook
Java Architect Handbook
Jan 1, 2026 · Databases

COUNT(*), COUNT(1) or COUNT(column) in MySQL? Deep Interview Guide

This article explains the semantic differences, performance characteristics, and optimal usage scenarios of COUNT(*), COUNT(1), and COUNT(column) in MySQL 8.0+, covering engine behavior, indexing effects, common misconceptions, and practical best‑practice recommendations for interview preparation and real‑world development.

COUNTInterviewPerformance
0 likes · 10 min read
COUNT(*), COUNT(1) or COUNT(column) in MySQL? Deep Interview Guide
Xiao Liu Lab
Xiao Liu Lab
Dec 30, 2025 · Databases

How to Diagnose and Fix ClickHouse CPU Spikes in Minutes

This guide walks you through a step‑by‑step process for quickly identifying the cause of high CPU usage in ClickHouse, from emergency triage and precise diagnosis using system tables to practical optimization techniques and a ready‑to‑run monitoring script.

CPUClickHousePerformance
0 likes · 21 min read
How to Diagnose and Fix ClickHouse CPU Spikes in Minutes
Alibaba Cloud Native
Alibaba Cloud Native
Dec 30, 2025 · Cloud Native

How Materialized Views Cut Log Query Times from Seconds to Milliseconds

Backend developers often struggle with log queries that become unbearably slow at scale, causing timeouts and alerts; this article details how applying Alibaba Cloud Log Service materialized views transformed several real‑world cases—from high‑concurrency SDK calls to complex de‑duplication and latency‑comparison queries—cutting response times from seconds to milliseconds and delivering stable performance.

Cloud NativeSQLlog query
0 likes · 7 min read
How Materialized Views Cut Log Query Times from Seconds to Milliseconds