BestHub
Sign in
Tagged articles

SQL Optimization

355 articles · Page 2 of 4
Java Architect Essentials
Java Architect Essentials
Jul 29, 2024 · Backend Development

Optimizing a High‑Concurrency Interface: Reducing Response Time from 30 seconds to 0.8 seconds

This article presents a real‑world case study of a high‑concurrency transaction‑statistics API that originally took 30 seconds to respond, detailing problem diagnosis, SQL and Java code analysis, and a series of optimizations—including SQL rewrites, database‑side calculations, and Caffeine caching—that ultimately brought the response time below one second.

PostgreSQLSQL Optimizationcaching
0 likes · 10 min read
Optimizing a High‑Concurrency Interface: Reducing Response Time from 30 seconds to 0.8 seconds
Java Tech Enthusiast
Java Tech Enthusiast
Jul 21, 2024 · Backend Development

Interface Performance Optimization Techniques for Backend Development

The article outlines practical backend interface performance optimizations—including proper indexing, SQL tuning, parallel remote calls, batch queries, asynchronous processing, scoped transactions, fine-grained locking, pagination batching, multi-level caching, sharding, and monitoring tools—to dramatically reduce latency and improve throughput.

IndexingSQL OptimizationSharding
0 likes · 25 min read
Interface Performance Optimization Techniques for Backend Development
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.

DatabaseIndexingMySQL
0 likes · 18 min read
Writing High‑Quality SQL: Practical MySQL Optimization Tips
Code Ape Tech Column
Code Ape Tech Column
Jul 18, 2024 · Backend Development

Optimizing a High‑Concurrency Data Processing Interface: Reducing Response Time from 30 s to 0.8 s

This article presents a real‑world case study of a high‑concurrency transaction‑handling API that originally required 30 seconds to process over two million records, and details the step‑by‑step SQL, Java, and caching optimizations that brought the response time down to under one second.

MyBatisPostgreSQLSQL Optimization
0 likes · 10 min read
Optimizing a High‑Concurrency Data Processing Interface: Reducing Response Time from 30 s to 0.8 s
Efficient Ops
Efficient Ops
Jul 10, 2024 · Databases

Boost MySQL DBA Productivity with Essential Open‑Source Tools

This article introduces a collection of practical open‑source utilities—including SQLTXPLAIN, SOAR, SQLAdvisor, and Percona Toolkit tools—that streamline common MySQL DBA tasks such as schema changes, replication checks, slow‑query analysis, and data consistency verification, helping engineers work faster and more efficiently.

DBA toolsMySQLOpen Source
0 likes · 8 min read
Boost MySQL DBA Productivity with Essential Open‑Source Tools
DataFunSummit
DataFunSummit
Jul 9, 2024 · Big Data

Materialized Views in MaxCompute: Design, Implementation, and Best Practices

This article explains the concept, advantages, and drawbacks of materialized views, describes how MaxCompute implements them—including creation syntax, maintenance properties, automatic query rewrite, smart recommendation, and auto‑materialization—and shares performance results and future improvement plans.

Automatic RefreshBig DataMaxCompute
0 likes · 13 min read
Materialized Views in MaxCompute: Design, Implementation, and Best Practices
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Jul 3, 2024 · Databases

How WeTune 2.0 Automates SQL Query Rewrite for GaussDB Performance Boost

WeTune 2.0, a revolutionary tool developed by Shanghai Jiao Tong University and GaussDB experts, automatically discovers and validates SQL rewrite rules, dramatically improving query performance in Huawei Cloud GaussDB by eliminating manual rule creation, supporting extensive rule enumeration, equivalence verification, and cost‑based evaluation, while addressing scalability challenges.

GaussDBQuery RewriteSQL Optimization
0 likes · 11 min read
How WeTune 2.0 Automates SQL Query Rewrite for GaussDB Performance Boost
ITPUB
ITPUB
Jun 17, 2024 · Databases

Boost MySQL DBA Productivity with Essential Open‑Source Tools

This guide introduces a collection of practical MySQL DBA utilities—including SQLTXPLAIN, SOAR, SQLAdvisor, and Percona Toolkit commands such as pt‑duplicate-key-checker, pt‑kill, pt‑mysql-summary, pt‑query-digest, pt‑table-checksum, and pt‑table-sync—showing how to install them, run key commands, and interpret their outputs to streamline database administration tasks.

DBAMySQLOpen-source tools
0 likes · 9 min read
Boost MySQL DBA Productivity with Essential Open‑Source Tools
Liangxu Linux
Liangxu Linux
Jun 11, 2024 · Databases

Boost MySQL Performance: Master LIMIT, Implicit Conversion, JOIN Updates, and More

This article explains common MySQL performance pitfalls such as inefficient LIMIT pagination, implicit type conversion, sub‑query‑based updates, mixed ordering, misuse of EXISTS, and condition push‑down, and provides concrete rewrites and examples that reduce query times from seconds to milliseconds.

MySQLQuery TuningSQL Optimization
0 likes · 13 min read
Boost MySQL Performance: Master LIMIT, Implicit Conversion, JOIN Updates, and More
FunTester
FunTester
May 19, 2024 · Databases

Essential Database Testing Checklist: From CRUD to Performance Optimization

This guide outlines comprehensive database testing practices, covering relational and non‑relational types, CRUD validation, index and view checks, empty‑database scenarios, data integrity, design principles, stress testing, and detailed SQL optimization techniques with concrete examples and code snippets.

Design GuidelinesIndexingPerformance Testing
0 likes · 12 min read
Essential Database Testing Checklist: From CRUD to Performance Optimization
37 Interactive Technology Team
37 Interactive Technology Team
May 16, 2024 · Databases

Optimizing SQL Query Performance with EXPLAIN Statements

Optimizing SQL query performance hinges on confirming that the database engine fully leverages indexes, and the EXPLAIN statement provides a detailed execution plan—including key_len values—that shows whether each index field is completely used, enabling developers to identify and fix inefficient index usage.

Database PerformanceEXPLAIN StatementIndex Utilization
0 likes · 5 min read
Optimizing SQL Query Performance with EXPLAIN Statements
Top Architect
Top Architect
May 9, 2024 · Databases

Effective Indexing Strategies for Database Performance

This article provides comprehensive guidance on effective database indexing, covering when and how to create various index types, practical SQL examples, strategies for equality, range, fuzzy, join, and composite queries, and tips for verifying index usage with EXPLAIN.

SQL Optimizationdatabase indexingperformance-tuning
0 likes · 11 min read
Effective Indexing Strategies for Database Performance
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 30, 2024 · Big Data

Mastering ODPS SQL: Proven Tips to Slash Query Time and Tackle Data Skew

This article explores practical SQL optimization techniques for Alibaba's ODPS platform, covering fundamentals, common pitfalls like null handling and select *, advanced strategies such as multi‑insert, partition limiting, UDF placement, data‑skew mitigation, parameter tuning, and real‑world case studies that dramatically reduce query runtimes.

Big DataData SkewHive
0 likes · 23 min read
Mastering ODPS SQL: Proven Tips to Slash Query Time and Tackle Data Skew
Lobster Programming
Lobster Programming
Apr 27, 2024 · Databases

Essential MySQL Optimization: SQL Tricks and Parameter Tuning

This guide covers practical MySQL performance improvements, detailing SQL-level optimizations such as limit pagination, proper LIKE usage, UNION ALL, EXISTS vs IN, TRUNCATE, batch inserts, early filtering, function placement, data type minimization, CHAR/VARCHAR choices, indexing strategies, force index, as well as server parameter tuning for buffer pool and redo log settings.

MySQLSQL Optimizationdatabase tuning
0 likes · 10 min read
Essential MySQL Optimization: SQL Tricks and Parameter Tuning
Architect's Journey
Architect's Journey
Apr 24, 2024 · Databases

A Graceful Approach to Multi‑Table Queries: Embrace Aggregation, Avoid Stitching

The article compares redundant and normalized storage, explains their trade‑offs, and introduces an in‑memory aggregation technique implemented via a repository "fill" method in Java, showing how to replace costly SQL joins with flexible, code‑driven data merging while preserving consistency and performance.

Database DesignDenormalizationIn-Memory Join
0 likes · 11 min read
A Graceful Approach to Multi‑Table Queries: Embrace Aggregation, Avoid Stitching
vivo Internet Technology
vivo Internet Technology
Apr 17, 2024 · Big Data

Retention Analysis Model Practice Based on ClickHouse

The article explains retention analysis models, their importance for user loyalty, outlines offline Hive architecture, then shows how ClickHouse’s retention() function and columnar storage dramatically speed up multi‑day retention calculations, providing SQL examples and practical guidance for product analytics.

ClickHouseData ModelingHive
0 likes · 17 min read
Retention Analysis Model Practice Based on ClickHouse
DataFunTalk
DataFunTalk
Apr 16, 2024 · Big Data

Materialized Views in MaxCompute: Design, Implementation, and Best Practices

This article explains how MaxCompute leverages materialized views as a query accelerator, covering their history, advantages and drawbacks, creation and maintenance details, automatic query rewriting, intelligent recommendation, auto‑materialization, and future enhancements for large‑scale data warehousing.

Automatic RefreshBig DataIntelligent Recommendation
0 likes · 13 min read
Materialized Views in MaxCompute: Design, Implementation, and Best Practices
Liangxu Linux
Liangxu Linux
Apr 14, 2024 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article presents eight practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting joins, handling mixed ordering, replacing EXISTS with joins, pushing down conditions, pre‑filtering data, and using WITH clauses—to dramatically reduce query execution time.

MySQLQuery RewriteSQL Optimization
0 likes · 13 min read
Boost MySQL Performance: 8 Proven SQL Optimization Techniques
Efficient Ops
Efficient Ops
Apr 6, 2024 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article explores eight common MySQL performance pitfalls—from inefficient LIMIT usage and implicit type conversion to subquery joins, mixed ordering, EXISTS clauses, condition pushdown, early result limiting, and intermediate result set optimization—offering concrete rewrites and execution plan analyses to dramatically speed up queries.

DatabaseMySQLSQL Optimization
0 likes · 14 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
Su San Talks Tech
Su San Talks Tech
Mar 16, 2024 · Databases

Master MySQL Performance: Deep Dive into Indexes and Explain Plans

This comprehensive guide explains MySQL's architecture, the importance of SQL optimization, detailed index types and creation methods, how to interpret EXPLAIN output, and practical techniques to improve query performance while avoiding common pitfalls.

Explain PlanMySQLSQL Optimization
0 likes · 35 min read
Master MySQL Performance: Deep Dive into Indexes and Explain Plans
Architecture Digest
Architecture Digest
Mar 1, 2024 · Databases

SQL Performance Optimization and Index Tuning in MySQL

This article walks through a MySQL 5.6 scenario with course, student, and score tables, demonstrates why a naïve sub‑query is extremely slow, and shows step‑by‑step how adding single‑column, composite, and covering indexes, as well as rewriting the query to joins, can reduce execution time from hours to milliseconds.

DatabaseIndex TuningMySQL
0 likes · 10 min read
SQL Performance Optimization and Index Tuning in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 22, 2024 · Databases

Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance

This article explains the differences between global and local indexes in OceanBase, analyzes why queries using global unique indexes run significantly faster than those using local indexes during Oracle migration, and provides detailed SQL examples, execution plans, and performance testing results to guide database optimization.

Database MigrationLocal IndexOceanBase
0 likes · 32 min read
Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance
Java Backend Technology
Java Backend Technology
Feb 20, 2024 · Databases

7 Proven MySQL Query Optimizations to Slash Execution Time

This article examines common MySQL performance pitfalls—such as large OFFSET limits, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, and condition push‑down—and demonstrates concise rewrites, including JOINs, UNION ALL, early range reduction, and WITH clauses that can reduce query execution from seconds to milliseconds.

MySQLQuery RewriteSQL Optimization
0 likes · 13 min read
7 Proven MySQL Query Optimizations to Slash Execution Time
Alibaba Cloud Developer
Alibaba Cloud Developer
Dec 25, 2023 · Big Data

How to Cut Data Cube Processing Time by 60% with Deduplication Optimization

This article explains how to dramatically reduce the cost of deduplication‑Cube calculations in large‑scale data pipelines by replacing costly data‑expansion steps with a UID‑level tagging approach, detailing the scenario, common methods, performance analysis, a new solution, implementation steps, and experimental results.

Big DataSQL Optimizationdata cube
0 likes · 15 min read
How to Cut Data Cube Processing Time by 60% with Deduplication Optimization
dbaplus Community
dbaplus Community
Dec 24, 2023 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

When a system’s data grows, MySQL queries can become slow and cause latency; this article presents practical optimization strategies—including query tuning, pagination, join improvements, subquery replacement, order‑by and group‑by enhancements, and count() efficiency—illustrated with sample tables, code snippets, and performance screenshots.

GROUP BYIndexingJOIN
0 likes · 13 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
Efficient Ops
Efficient Ops
Dec 12, 2023 · Databases

How to Diagnose MySQL Lock Waits and Transaction Timeouts with MyAWR

This article explains how commercial banks can analyze MySQL lock‑wait events and transaction timeouts using MDL metadata lock monitoring, innodb_lock_wait_timeout, custom MyAWR collection, SQL de‑parameterization, and post‑mortem queries to pinpoint blocking SQL and its source.

Lock WaitMySQLSQL Optimization
0 likes · 19 min read
How to Diagnose MySQL Lock Waits and Transaction Timeouts with MyAWR
JD Retail Technology
JD Retail Technology
Dec 12, 2023 · Databases

Common SQL Optimization Techniques for MySQL

This article reviews MySQL's execution process and presents a comprehensive list of practical SQL optimization strategies—including indexing, query rewriting, avoiding costly operators, using batch operations, and leveraging EXPLAIN—to improve database performance and maintainability.

MySQLSQL Optimizationdatabase tuning
0 likes · 14 min read
Common SQL Optimization Techniques for MySQL
macrozheng
macrozheng
Dec 6, 2023 · Databases

When and How to Implement Database Sharding and Partitioning for High‑Scale Systems

This article explains why database sharding and partitioning become necessary, outlines performance bottlenecks, presents software and hardware optimization techniques, details horizontal and vertical splitting strategies, and discusses the added complexity such as cross‑database joins, distributed transactions, and ID generation.

SQL OptimizationTable Partitioningdatabase sharding
0 likes · 13 min read
When and How to Implement Database Sharding and Partitioning for High‑Scale Systems
Java High-Performance Architecture
Java High-Performance Architecture
Nov 13, 2023 · Databases

Master MySQL Performance: Deep Dive into Indexes, Explain Plans & Optimization

This comprehensive guide explores MySQL’s architecture, explains how queries are parsed and executed, and provides detailed techniques for optimizing SQL performance through effective indexing, understanding EXPLAIN output, and avoiding common pitfalls that cause index misuse and slow query execution.

Database PerformanceExplain PlanIndexing
0 likes · 37 min read
Master MySQL Performance: Deep Dive into Indexes, Explain Plans & Optimization
Volcano Engine Developer Services
Volcano Engine Developer Services
Nov 9, 2023 · Databases

How ByteHouse Redefines ELT for Cloud‑Native Data Warehousing

This article explains how ByteHouse, a cloud‑native data warehouse, shifts traditional ETL to ELT, simplifies data pipelines, enhances scalability, and introduces advanced features such as stage‑by‑stage scheduling, adaptive resource management, async execution, and future roadmap for big‑data workloads.

ByteHouseData WarehouseELT
0 likes · 16 min read
How ByteHouse Redefines ELT for Cloud‑Native Data Warehousing
Su San Talks Tech
Su San Talks Tech
Nov 8, 2023 · Databases

Speed Up Your SpringBoot App with Druid Connection Pool and SQL Optimization

The article walks through diagnosing a 10‑second backend loading delay, explains connection‑pool concepts, introduces Alibaba's Druid pool with its monitoring UI, shows how to identify and optimize slow SQL queries using DISTINCT and indexes, and provides step‑by‑step SpringBoot integration instructions.

DatabaseDruidSQL Optimization
0 likes · 16 min read
Speed Up Your SpringBoot App with Druid Connection Pool and SQL Optimization
Architect
Architect
Nov 7, 2023 · Databases

MySQL Architecture, Indexes, and SQL Optimization Guide

This article explains MySQL's basic architecture, demonstrates how to view and set storage engines, and provides comprehensive guidance on SQL optimization methods, index types, creation, usage, and performance analysis using EXPLAIN, helping readers improve query efficiency and avoid common pitfalls.

Database PerformanceEXPLAINMySQL
0 likes · 35 min read
MySQL Architecture, Indexes, and SQL Optimization Guide
Selected Java Interview Questions
Selected Java Interview Questions
Nov 3, 2023 · Databases

Comprehensive Guide to MySQL Architecture, SQL Optimization Techniques, and Explain Plan Analysis

This article provides an in‑depth overview of MySQL’s core architecture, storage engines, index types, and practical SQL optimization methods, followed by detailed explanations of the EXPLAIN plan keywords and numerous real‑world examples to help developers improve query performance and avoid common indexing pitfalls.

Database PerformanceExplain PlanSQL Optimization
0 likes · 34 min read
Comprehensive Guide to MySQL Architecture, SQL Optimization Techniques, and Explain Plan Analysis
Architect's Guide
Architect's Guide
Oct 19, 2023 · Databases

Understanding Database Indexes: Storage Principles, Types, and Optimization Techniques

This article explains how computer storage works, why database indexes dramatically speed up queries, the mechanics of binary search, the differences between clustered and non‑clustered indexes, common pitfalls of over‑indexing, and practical SQL optimization strategies to avoid full table scans and index invalidation.

Clustered IndexIndexSQL Optimization
0 likes · 12 min read
Understanding Database Indexes: Storage Principles, Types, and Optimization Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
Oct 7, 2023 · Big Data

Comprehensive Guide to OLAP Optimization and ClickHouse Performance Tuning

This article explains how to optimize OLAP workloads by balancing normalization and denormalization, applying data sharding, replication, indexing, partitioning, materialized views, columnar storage, compression, and lifecycle management, and provides practical ClickHouse SQL examples for index creation, partitioning, and query plan analysis.

ClickHouseData ModelingIndexing
0 likes · 15 min read
Comprehensive Guide to OLAP Optimization and ClickHouse Performance Tuning
JD Cloud Developers
JD Cloud Developers
Oct 4, 2023 · Databases

Master MySQL Slow Query Optimization: EXPLAIN and Index Strategies

This article explains how to use MySQL's EXPLAIN statement to analyze slow queries, detailing each output column, various select types, access methods, and common pitfalls, then provides practical optimization techniques such as proper indexing, query rewriting, index merging, handling COUNT, UNION, OFFSET, and table maintenance.

EXPLAINMySQLSQL Optimization
0 likes · 22 min read
Master MySQL Slow Query Optimization: EXPLAIN and Index Strategies
Java High-Performance Architecture
Java High-Performance Architecture
Sep 23, 2023 · Backend Development

From JDBC to MyBatis: Why Java Persistence Evolved and How to Optimize It

This article walks through the step‑by‑step JDBC query process, explains why wrapping JDBC in a framework like MyBatis is beneficial, analyzes MyBatis’s core components and execution flow, and presents five practical optimizations—from connection pooling to dynamic SQL and result caching—to improve Java backend performance.

Connection PoolingDesign PatternsJDBC
0 likes · 35 min read
From JDBC to MyBatis: Why Java Persistence Evolved and How to Optimize It
Java Architect Essentials
Java Architect Essentials
Sep 19, 2023 · Databases

Chat2DB Review: Open-Source AI-Powered Multi-Database Client with SQL Generation

Chat2DB is an open‑source, cross‑platform database client that integrates AI capabilities to translate natural language to SQL and vice versa, offers optimization suggestions, supports multiple databases, provides team collaboration features, and can be installed via native packages or Docker with detailed usage examples.

AI SQLChat2DBDatabase Client
0 likes · 7 min read
Chat2DB Review: Open-Source AI-Powered Multi-Database Client with SQL Generation
Java Interview Crash Guide
Java Interview Crash Guide
Sep 8, 2023 · Databases

Boost MySQL Performance: 9 Proven SQL Optimization Techniques

This article explains nine practical MySQL optimization methods—including smarter LIMIT usage, implicit conversion pitfalls, JOIN‑based updates, mixed ordering tricks, EXISTS rewrites, predicate pushdown, early range reduction, intermediate result pushdown, and a concise summary—showing how to transform slow queries into sub‑millisecond operations.

LIMIT clauseMySQLPredicate Pushdown
0 likes · 12 min read
Boost MySQL Performance: 9 Proven SQL Optimization Techniques
Selected Java Interview Questions
Selected Java Interview Questions
Sep 4, 2023 · Databases

Common MySQL Query Performance Issues and Optimization Techniques

This article discusses common MySQL performance pitfalls such as inefficient LIMIT usage, implicit type conversion, subquery updates, mixed ordering, EXISTS clauses, condition pushdown, and intermediate result handling, and provides optimized SQL rewrites and best practices to dramatically improve query execution speed.

Database PerformanceQuery TuningSQL Optimization
0 likes · 13 min read
Common MySQL Query Performance Issues and Optimization Techniques
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.

DatabaseQuery ExecutionSQL
0 likes · 6 min read
Unveiling the Real SQL Execution Order: From FROM to LIMIT Explained
Sanyou's Java Diary
Sanyou's Java Diary
Aug 21, 2023 · Databases

Master MySQL Optimization: Indexing, Locking, Pagination & Profiling Tips

This article presents practical MySQL optimization techniques—including proper index creation, avoiding index invalidation, choosing appropriate lock granularity, efficient pagination strategies, steering clear of SELECT *, and using EXPLAIN and SHOW PROFILE—to help developers write faster, more reliable SQL queries.

Database LocksIndexingMySQL
0 likes · 10 min read
Master MySQL Optimization: Indexing, Locking, Pagination & Profiling Tips
MaGe Linux Operations
MaGe Linux Operations
Aug 19, 2023 · Databases

How Deep Pagination Slowed Our System and the SQL Fixes That Saved It

This article walks through a real‑world incident where a pagination‑related slow‑query caused massive CPU spikes, details the step‑by‑step investigation, and presents several MySQL optimization techniques—including ID‑based queries, sub‑queries, and cursor‑based pagination—that ultimately resolved the performance crisis.

Database PerformanceDeep PaginationMySQL
0 likes · 10 min read
How Deep Pagination Slowed Our System and the SQL Fixes That Saved It
Java Architecture Diary
Java Architecture Diary
Aug 9, 2023 · Backend Development

What’s New in MyBatis‑Plus 3.5.13? Top Features and Performance Boosts

MyBatis‑Plus 3.5.13 introduces dynamic SQL smart optimization, a richer code generator, significant heap‑memory reduction, Spring Boot 3 and JDK 17 native support, new database adapters, enhanced optimistic locking, multi‑parameter filling, and comprehensive SQL‑injection safeguards, all aimed at faster, more productive backend development.

ORMSQL OptimizationSpring Boot
0 likes · 9 min read
What’s New in MyBatis‑Plus 3.5.13? Top Features and Performance Boosts
Senior Tony
Senior Tony
Jul 29, 2023 · Fundamentals

Essential Coding Habits Every Engineer Should Master

The article outlines practical coding habits—thorough input validation, comprehensive logging, careful RPC handling, batch processing, cautious SQL execution, safe extensions, disciplined refactoring, minimal dependencies, data consistency, and avoiding over‑engineering—to help engineers write reliable, maintainable code.

Batch ProcessingData ConsistencyInput Validation
0 likes · 9 min read
Essential Coding Habits Every Engineer Should Master
DataFunTalk
DataFunTalk
Jul 7, 2023 · Databases

Apache Doris 2.0-beta Release: New Query Optimizer, Pipeline Execution Engine, Workload Management and Major Performance Improvements

Apache Doris 2.0-beta, released on July 3, 2023, introduces a new Cascades‑based query optimizer, adaptive pipeline execution engine, workload‑aware resource isolation, enhanced memory management, partial column updates, multi‑catalog support, and numerous performance gains across real‑time analytics, ETL, and high‑concurrency point queries.

Apache DorisDatabase PerformancePipeline Execution
0 likes · 25 min read
Apache Doris 2.0-beta Release: New Query Optimizer, Pipeline Execution Engine, Workload Management and Major Performance Improvements
Selected Java Interview Questions
Selected Java Interview Questions
Jul 3, 2023 · Databases

Root Cause Analysis and Solutions for Pagination Slow Queries in a Backend System

This article details a real‑world incident of severe pagination slow queries, walks through the timeline of detection, diagnosis, and mitigation steps, and presents multiple MySQL optimization techniques—including ID‑based queries, sub‑queries, scroll queries, and join‑based solutions—to resolve deep pagination performance issues.

MySQLSQL OptimizationSlow Query
0 likes · 11 min read
Root Cause Analysis and Solutions for Pagination Slow Queries in a Backend System
Architecture Digest
Architecture Digest
Jun 29, 2023 · Databases

Chat2DB: Open‑Source AI‑Powered Multi‑Database Client – Installation, Configuration, and Feature Demonstration

This article introduces Chat2DB, an open‑source AI‑enhanced multi‑database client, walks through its download, installation, configuration, demonstrates natural‑language‑to‑SQL, SQL explanation and optimization features using sample MySQL tables, and outlines future roadmap for developers.

AIChat2DBDatabase Client
0 likes · 13 min read
Chat2DB: Open‑Source AI‑Powered Multi‑Database Client – Installation, Configuration, and Feature Demonstration
Java Backend Technology
Java Backend Technology
Jun 21, 2023 · Databases

How to Supercharge MySQL Queries: 9 Proven Optimization Techniques

This article walks through nine common MySQL performance pitfalls—such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, intermediate result push‑down, and more—showing how to rewrite each query and its execution plan to achieve dramatic speed improvements.

MySQLSQL Optimizationdatabase tuning
0 likes · 14 min read
How to Supercharge MySQL Queries: 9 Proven Optimization Techniques
JD Cloud Developers
JD Cloud Developers
May 30, 2023 · Big Data

ClickHouse & Flink: Choosing Engines, Tuning Queries, and Scaling Concurrency

This article details how JDQ, Flink, and ClickHouse were integrated to replace Elasticsearch for real‑time reporting, covering table‑engine selection, Flink sink implementation, performance bottlenecks, CPU hot‑spots, query optimization techniques, and strategies for handling high concurrency while ensuring data consistency and system stability.

ClickHouseData EngineeringFlink
0 likes · 46 min read
ClickHouse & Flink: Choosing Engines, Tuning Queries, and Scaling Concurrency
Su San Talks Tech
Su San Talks Tech
May 30, 2023 · Databases

Master MySQL Indexes: From B+ Trees to Index Merge and Optimization

This article explains MySQL index fundamentals—including classification, B+‑tree and hash structures, clustered and secondary indexes, single‑ and composite‑column indexes, covering indexes, index condition pushdown, index merge strategies, cost‑based index selection, common index‑invalidating scenarios, and practical guidelines for creating effective indexes.

B+TreeDatabase PerformanceIndex
0 likes · 29 min read
Master MySQL Indexes: From B+ Trees to Index Merge and Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
May 15, 2023 · Databases

Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques

The article investigates why pure‑read QPS drops significantly after bulk updates in OceanBase, reproduces the issue with a sysbench workload, analyses flame‑graph and SQL audit data, explains the LSM‑Tree read‑amplification mechanism, and proposes practical mitigation steps such as major freeze, plan binding, index creation, and the queuing‑table feature.

LSM TreeMajor FreezeOceanBase
0 likes · 16 min read
Performance Degradation After Data Updates in OceanBase and Its Optimization Techniques
DataFunSummit
DataFunSummit
May 7, 2023 · Big Data

Tencent SuperSQL: A Unified Adaptive Big Data Computing Platform

The article presents Tencent's SuperSQL platform, detailing the big‑data challenges of heterogeneous data sources and fragmented SQL experiences, describing its multi‑layer adaptive architecture, core technologies such as unified SQL parsing, cost‑based and history‑based optimization, federated computation, materialized views and security, and summarizing its performance gains, industry impact and community contributions.

Big DataSQL OptimizationSuperSQL
0 likes · 16 min read
Tencent SuperSQL: A Unified Adaptive Big Data Computing Platform
DataFunTalk
DataFunTalk
Apr 18, 2023 · Big Data

Real-time OLAP with Apache Doris: Architecture, Use Cases, and Optimization at Dingdong Maicai

This article details Dingdong Maicai's adoption of Apache Doris as a real‑time OLAP engine, covering business requirements, comparative evaluation with ClickHouse, system architecture, practical applications such as real‑time analytics, B‑end queries, tag systems, and performance‑boosting techniques like Colocate Join, bitmap, prefix and Bloom‑filter indexes, materialized views, and streamlined Broker Load workflows.

Apache DorisBig DataData Warehouse
0 likes · 19 min read
Real-time OLAP with Apache Doris: Architecture, Use Cases, and Optimization at Dingdong Maicai
JD Retail Technology
JD Retail Technology
Apr 14, 2023 · Big Data

Understanding Data Skew and Its Mitigation in Hive and Spark

This article explains the concept of data skew, its symptoms such as slow tasks and OOM errors, and provides comprehensive mitigation techniques and configuration examples for Hive and Spark, including custom partitioning, map joins, adaptive execution, and key detection methods.

Adaptive ExecutionBig DataData Skew
0 likes · 15 min read
Understanding Data Skew and Its Mitigation in Hive and Spark
Sohu Tech Products
Sohu Tech Products
Apr 12, 2023 · Databases

MySQL Query Optimization Strategies: Pagination, Joins, Subqueries, Sorting, Group By, and Count

This article presents practical MySQL query optimization techniques—including pagination, index‑based join improvements, subquery replacement with joins, order‑by and group‑by indexing, and count() efficiency—illustrated with real‑world examples, execution‑plan analysis, and ready‑to‑run SQL code.

IndexingMySQLSQL Optimization
0 likes · 11 min read
MySQL Query Optimization Strategies: Pagination, Joins, Subqueries, Sorting, Group By, and Count
IT Architects Alliance
IT Architects Alliance
Apr 11, 2023 · Databases

MySQL Execution Process and Comprehensive Optimization Best Practices

This article explains MySQL's query execution flow and provides extensive best‑practice guidelines—including naming conventions, storage engine choices, primary‑key design, character set settings, query writing tips, indexing strategies, batch operations, and performance‑enhancing techniques—to help developers write efficient and maintainable SQL code.

Database PerformanceIndexingMySQL
0 likes · 24 min read
MySQL Execution Process and Comprehensive Optimization Best Practices
ITPUB
ITPUB
Apr 8, 2023 · Databases

Master MySQL Performance: 13 Essential SQL Optimization Techniques

This comprehensive guide walks you through practical MySQL optimization strategies—including slow‑query analysis, deep‑pagination fixes, explain plan interpretation, index tuning, large‑table design, and common pitfalls—so you can dramatically improve query speed and overall database performance.

MySQLSQL Optimization
0 likes · 22 min read
Master MySQL Performance: 13 Essential SQL Optimization Techniques
dbaplus Community
dbaplus Community
Apr 2, 2023 · Big Data

Unlock Faster ODPS SQL: Proven UNION, COUNT DISTINCT, and Join Optimizations

This article walks through common ODPS SQL scenarios—union, count distinct, large‑table joins, mapjoin, and predicate placement—explains why naïve implementations can be inefficient, shows how to read and interpret execution plans, and provides concrete rewritten queries that dramatically improve performance and resource usage.

Big DataCOUNT DISTINCTMapJoin
0 likes · 17 min read
Unlock Faster ODPS SQL: Proven UNION, COUNT DISTINCT, and Join Optimizations
Top Architect
Top Architect
Mar 31, 2023 · Backend Development

Why MyBatis PageHelper Pagination Is Slow and How to Optimize It

The article explains that MyBatis PageHelper performs an extra full‑table count query causing pagination to take over eight seconds on a 10,000‑row table, analyzes the root cause, and provides a concrete solution by customizing the count SQL with a _COUNT method and optimized mapper definitions.

MyBatisSQL Optimizationbackend development
0 likes · 6 min read
Why MyBatis PageHelper Pagination Is Slow and How to Optimize It
Top Architect
Top Architect
Mar 29, 2023 · Databases

MySQL Query Optimization and Index Tuning: From Subqueries to Joins and Composite Indexes

This article demonstrates MySQL query performance issues with large tables, shows how a subquery without indexes can take hours, and walks through step‑by‑step optimizations including adding single‑column indexes, converting to EXISTS and JOIN queries, creating composite indexes, covering indexes, and sorting improvements, achieving speedups of thousands of times.

Composite IndexCovering IndexDatabase Performance
0 likes · 12 min read
MySQL Query Optimization and Index Tuning: From Subqueries to Joins and Composite Indexes
ITPUB
ITPUB
Feb 28, 2023 · Databases

Master MySQL Query Performance: A Step‑by‑Step SQL Optimization Guide

This article explains how to prepare and tune MySQL SQL statements before execution, covering logical and physical optimization, table and view analysis, join‑key checks, query rewriting, and execution‑plan evaluation to achieve faster, more efficient database queries.

Database PerformanceMySQLQuery Tuning
0 likes · 9 min read
Master MySQL Query Performance: A Step‑by‑Step SQL Optimization Guide
dbaplus Community
dbaplus Community
Feb 19, 2023 · Databases

Essential MySQL Optimization Checklist: 46 Proven Practices to Boost Performance

This comprehensive guide outlines 46 practical MySQL optimization rules—from understanding the query execution flow and naming conventions to index design, join strategies, pagination techniques, and safe use of data types—providing concrete examples and code snippets that help developers dramatically improve database performance and reliability.

MySQLSQL Optimizationbest practices
0 likes · 26 min read
Essential MySQL Optimization Checklist: 46 Proven Practices to Boost Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 15, 2023 · Databases

SQL Statement Optimization Practices for MySQL

This article explains how DBAs can improve MySQL query performance by applying logical and physical optimizations, analyzing table structures, indexes, and execution plans, and provides a step‑by‑step checklist for diagnosing and rewriting slow or poorly optimized SQL statements.

Database PerformanceIndexingMySQL
0 likes · 8 min read
SQL Statement Optimization Practices for MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 13, 2023 · Databases

Why the Same SQL Has Different Execution Plans in QA and DEV Environments and How to Optimize It

The article analyzes why an identical MySQL query runs faster in a QA environment than in DEV, examines execution‑plan differences caused by table driving choices, optimizer settings, and unnecessary conditions, and demonstrates how rewriting the SQL and adjusting hints can achieve a stable, efficient plan.

Database PerformanceIndexMySQL
0 likes · 17 min read
Why the Same SQL Has Different Execution Plans in QA and DEV Environments and How to Optimize It
Open Source Linux
Open Source Linux
Feb 9, 2023 · Databases

Master MySQL Optimization: Indexes, Explain Plans, and Performance Tips

This comprehensive guide explores MySQL architecture, index types, query execution plans, and practical optimization techniques, offering detailed examples of creating, modifying, and analyzing indexes, avoiding common pitfalls, and improving query performance through proper use of EXPLAIN, composite indexes, and query rewriting.

Explain PlanMySQLSQL Optimization
0 likes · 36 min read
Master MySQL Optimization: Indexes, Explain Plans, and Performance Tips
DataFunTalk
DataFunTalk
Feb 4, 2023 · Big Data

Design and Practice of Tencent Lighthouse Fusion Analysis Engine

This article presents the design and implementation of Tencent Lighthouse's Fusion Analysis Engine, covering its background, challenges, fusion architecture, kernel optimizations, acceleration techniques, practical outcomes, and future evolution directions for high‑performance data access.

Big DataFusion EngineLighthouse
0 likes · 12 min read
Design and Practice of Tencent Lighthouse Fusion Analysis Engine
Java Architect Essentials
Java Architect Essentials
Jan 30, 2023 · Databases

Boost MySQL Performance: 9 Proven Query Optimization Techniques

This article presents nine practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting subqueries as joins, handling mixed sorting, replacing EXISTS with joins, pushing conditions into subqueries, early range reduction, and using CTEs—to dramatically improve query execution time across common scenarios.

CTEDatabase IndexesJOIN
0 likes · 14 min read
Boost MySQL Performance: 9 Proven Query Optimization Techniques
MaGe Linux Operations
MaGe Linux Operations
Jan 22, 2023 · Databases

How to Fix Deep Pagination Slow Queries in MySQL: A Real Incident Walkthrough

This article recounts a real‑world MySQL pagination outage, detailing how deep‑page queries caused massive CPU spikes, the step‑by‑step investigation, and the series of SQL redesigns—including ID‑based range queries, sub‑queries, scroll queries and join‑based solutions—that finally restored stable performance.

Database PerformanceDeep PaginationSQL Optimization
0 likes · 10 min read
How to Fix Deep Pagination Slow Queries in MySQL: A Real Incident Walkthrough
JD Tech
JD Tech
Jan 13, 2023 · Big Data

UData: Solving the Last Mile of Data Usage – Architecture, Query Engine Design, and Federated Query Enhancements

This article introduces the UData platform, explains its data‑integration architecture, details the StarRocks‑based query engine workflow from SQL parsing to distributed execution, and describes recent optimizations such as computation push‑down, support for JSF/HTTP/ClickHouse external tables, and a proxy‑based federated query framework.

Big DataData IntegrationFederated Query
0 likes · 20 min read
UData: Solving the Last Mile of Data Usage – Architecture, Query Engine Design, and Federated Query Enhancements
Java High-Performance Architecture
Java High-Performance Architecture
Jan 4, 2023 · Databases

Why Do Database Indexes Speed Up Queries? A Deep Dive into Storage and Optimization

This article explains how databases store data on physical devices, how indexes work like a book’s table of contents to accelerate queries, covers storage fundamentals, binary search, clustered vs non‑clustered indexes, and practical SQL optimization tips to avoid full‑table scans and index pitfalls.

IndexingSQL Optimizationstorage
0 likes · 12 min read
Why Do Database Indexes Speed Up Queries? A Deep Dive into Storage and Optimization
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Jan 4, 2023 · Big Data

How Hologres + FBI Powers Real‑Time Experience Insight at Alibaba: A Deep Dive

This article explains how Alibaba's CCO team built a scalable, real‑time experience‑insight platform using Hologres and FBI, detailing the evolution from pre‑aggregated cubes to lightweight summary tables and finally to ad‑hoc detail‑wide queries, along with practical schema, partition, and deduplication techniques.

Data WarehouseFBIHologres
0 likes · 22 min read
How Hologres + FBI Powers Real‑Time Experience Insight at Alibaba: A Deep Dive
Laravel Tech Community
Laravel Tech Community
Jan 2, 2023 · Databases

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, and More

This article presents a series of practical MySQL performance‑tuning methods—including smarter LIMIT usage, handling implicit type conversion, rewriting UPDATE/DELETE with JOIN, mixed‑order optimization, EXISTS replacement, condition push‑down, early result filtering, and CTE usage—to dramatically reduce query execution time across common scenarios.

CTEJOINLIMIT
0 likes · 13 min read
Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, and More
MaGe Linux Operations
MaGe Linux Operations
Dec 29, 2022 · Databases

Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide

This article explains how to collect comprehensive MySQL performance data—including connections, buffer cache, locks, statement counts, throughput, server configuration, and slow‑query logs—using only native SHOW commands, providing step‑by‑step SQL snippets, calculation formulas, and best‑practice tips for efficient monitoring.

Database MonitoringPerformance SchemaSHOW commands
0 likes · 10 min read
Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide
Java Architect Essentials
Java Architect Essentials
Nov 21, 2022 · Databases

MySQL Query Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, Joins, and Other Performance Tips

This article presents a comprehensive set of MySQL optimization guidelines, covering the avoidance of SELECT *, proper use of specific columns, eliminating OR and != in WHERE clauses, preferring numeric types, choosing VARCHAR over CHAR, using TRUNCATE, batch operations, index design, join selection, GROUP BY efficiency, and other practical tips to improve query performance.

MySQLSQL Optimizationdatabase indexing
0 likes · 18 min read
MySQL Query Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, Joins, and Other Performance Tips
Programmer DD
Programmer DD
Oct 26, 2022 · Databases

Boost MySQL Performance: 20 Proven SQL Optimization Tips

This article presents a comprehensive set of MySQL optimization techniques, covering everything from avoiding SELECT * and OR conditions to proper index usage, join strategies, batch operations, and query planning, all aimed at reducing resource consumption, improving execution speed, and ensuring reliable database design.

Database PerformanceIndexingMySQL
0 likes · 19 min read
Boost MySQL Performance: 20 Proven SQL Optimization Tips
Top Architect
Top Architect
Oct 25, 2022 · Databases

Understanding Database Indexes: Storage Principles, Binary Search, and Optimization Techniques

This article explains how databases store data on various storage media, why indexes dramatically speed up queries through sorted structures and binary search, discusses different index types such as clustered indexes, and outlines common SQL optimization practices while warning against excessive indexing and typical pitfalls.

Clustered IndexSQL OptimizationStorage Hierarchy
0 likes · 12 min read
Understanding Database Indexes: Storage Principles, Binary Search, and Optimization Techniques
MaGe Linux Operations
MaGe Linux Operations
Oct 15, 2022 · Databases

20 Essential MySQL Optimization Tips to Boost Query Performance

This article presents a comprehensive set of MySQL best‑practice guidelines—including avoiding SELECT *, steering clear of OR in WHERE clauses, preferring numeric over string types, using VARCHAR instead of CHAR, limiting DELETE/UPDATE, leveraging proper JOIN types, and many other indexing and query‑execution tricks—to dramatically improve query speed, reduce resource consumption, and maintain healthy database design.

Database DesignIndexingMySQL
0 likes · 18 min read
20 Essential MySQL Optimization Tips to Boost Query Performance