BestHub
Sign in
Tagged articles
2769 articles
Page 11 of 28
Open Source Linux
Open Source Linux
May 5, 2023 · Databases

Mastering Subquery Unnesting: Turn Correlated Queries into Fast Joins

This article explains why correlated subqueries are a performance bottleneck, introduces the Apply (Correlated Join) operator and a systematic set of transformation rules that push Apply down and replace subqueries with efficient joins, covering scalar, existential, and quantified subqueries, aggregation handling, and set operations, all illustrated with TPC‑H examples.

Apply OperatorDatabase EnginesDecorrelate
0 likes · 17 min read
Mastering Subquery Unnesting: Turn Correlated Queries into Fast Joins
Liangxu Linux
Liangxu Linux
May 5, 2023 · Databases

Quickly Find the Highest CPU‑Consuming SQL in MySQL

This guide explains how to pinpoint the MySQL statements that use the most CPU by mapping OS thread IDs to MySQL sessions, querying performance_schema and information_schema, and reviewing the execution plan to identify optimization opportunities.

CPUdatabasemysql
0 likes · 3 min read
Quickly Find the Highest CPU‑Consuming SQL in MySQL
ITPUB
ITPUB
Apr 29, 2023 · Backend Development

When Multiple Indexes Meet: How MySQL’s Index Merge Optimizer Works

This article explains how MySQL handles queries that involve two separate indexed columns, demonstrates the index_merge execution plan with real‑world examples, details the three index‑merge strategies (intersect, union, sort_union), and shows how to control or disable the feature for better performance.

mysqloptimizerperformance
0 likes · 11 min read
When Multiple Indexes Meet: How MySQL’s Index Merge Optimizer Works
Sanyou's Java Diary
Sanyou's Java Diary
Apr 27, 2023 · Databases

12 Common MySQL Slow‑Query Causes and How to Fix Them

This article examines the most frequent reasons MySQL queries become slow—including missing or ineffective indexes, deep pagination, massive tables, excessive joins, IN‑list overload, dirty pages, ORDER BY file‑sort, lock contention, and hardware limits—while offering concrete optimization techniques and best‑practice recommendations.

Index Optimizationmysqlslow-query
0 likes · 29 min read
12 Common MySQL Slow‑Query Causes and How to Fix Them
Tencent Database Technology
Tencent Database Technology
Apr 27, 2023 · Databases

Understanding MySQL Partition Pruning: Which Partition Should Be Queried?

This article explains how MySQL implements partition pruning, describing the conditions under which the optimizer can skip irrelevant partitions, the internal data structures such as read_partitions and lock_partitions, the role of SEL_TREE and SEL_ARG, and provides a detailed example with code to illustrate the pruning process.

Database OptimizationQuery Performancemysql
0 likes · 15 min read
Understanding MySQL Partition Pruning: Which Partition Should Be Queried?
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 27, 2023 · Databases

Diagnosing Freeze and Dump Issues in OceanBase Memstore

This article explains how to verify whether OceanBase's freeze mechanism and memstore dump processes are functioning correctly by querying internal tables, inspecting logs, and checking related metrics such as active_memstore_used, major_freeze_trigger, and MemTable reference counts.

Database AdministrationDumpFreeze
0 likes · 14 min read
Diagnosing Freeze and Dump Issues in OceanBase Memstore
Top Architect
Top Architect
Apr 26, 2023 · Databases

Comparative Performance and Feature Analysis of Elasticsearch vs ClickHouse

This article presents a practical comparison between Elasticsearch and ClickHouse, detailing their architectures, Docker‑Compose deployment, data ingestion pipelines, a series of representative queries, and benchmark results that show ClickHouse generally outperforms Elasticsearch in basic search and aggregation scenarios.

Docker ComposeElasticsearchVector
0 likes · 14 min read
Comparative Performance and Feature Analysis of Elasticsearch vs ClickHouse
Liangxu Linux
Liangxu Linux
Apr 25, 2023 · Databases

How to Unnest Correlated Subqueries for Faster SQL Execution

This article explains why correlated subqueries are costly, introduces the Apply (correlated join) operator, and presents a series of systematic transformation rules that convert scalar, existential, and aggregate subqueries into efficient join‑based plans while preserving SQL semantics.

Apply OperatorDecorrelationSubquery
0 likes · 17 min read
How to Unnest Correlated Subqueries for Faster SQL Execution
ITPUB
ITPUB
Apr 24, 2023 · Databases

Master PostgreSQL Performance: From Hardware to Query Tuning

Effective PostgreSQL performance tuning requires a holistic approach, covering hardware sizing, OS sysctl tweaks, filesystem choices, query and schema design, key PostgreSQL parameters, concurrency settings, cache management, and careful scheduling of automated maintenance tasks to avoid resource conflicts.

OS Configurationperformance tuningpostgresql
0 likes · 10 min read
Master PostgreSQL Performance: From Hardware to Query Tuning
DataFunSummit
DataFunSummit
Apr 24, 2023 · Artificial Intelligence

OpenMLDB: A Production‑Grade Feature Platform for Consistent Online and Offline Machine Learning

OpenMLDB is an open‑source machine‑learning database that delivers a production‑grade, consistent online‑offline feature platform for real‑time AI applications such as recommendation, risk control and fraud detection, offering millisecond‑level feature computation, dual SQL engines, extensive ecosystem integration, and a roadmap of new capabilities.

AIFeature StoreOpenMLDB
0 likes · 13 min read
OpenMLDB: A Production‑Grade Feature Platform for Consistent Online and Offline Machine Learning
Architect
Architect
Apr 23, 2023 · Big Data

Performance Comparison of Elasticsearch and ClickHouse for Log Analytics

This article compares Elasticsearch and ClickHouse by describing their architectures, demonstrating a Docker‑compose test environment, executing equivalent queries via both systems, and presenting performance results that show ClickHouse generally outperforms Elasticsearch in basic search and aggregation scenarios for log data.

Elasticsearchclickhouseperformance
0 likes · 12 min read
Performance Comparison of Elasticsearch and ClickHouse for Log Analytics
ITPUB
ITPUB
Apr 23, 2023 · Databases

Why SQL Still Dominates Data Analysis: From Relational Algebra to Modern OLAP

This article explains how SQL, built on relational algebra, became the standard analysis language for OLAP engines, covering its history, data models, syntax, functions, aggregation techniques, window functions, subqueries, and practical optimization considerations for modern data warehouses.

OLAPRelational AlgebraSubqueries
0 likes · 46 min read
Why SQL Still Dominates Data Analysis: From Relational Algebra to Modern OLAP
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 22, 2023 · Databases

Weekly Tech News Digest – Database and SQL Updates

This weekly roundup curates the latest high‑quality technical shares on databases, featuring articles about PolarDB HTAP acceleration, MySQL datetime precision, new MySQL releases, ChatGPT as a database client, and the SQLE platform's recent enhancements and upcoming plans.

SQLEdatabasemysql
0 likes · 4 min read
Weekly Tech News Digest – Database and SQL Updates
ITPUB
ITPUB
Apr 18, 2023 · Databases

Mastering MySQL Index Merge: Principles, Algorithms, and Practical Tips

This article explains MySQL's index‑merge optimization, detailing how the EXPLAIN output indicates its use, the three underlying algorithms (intersect, union, sort‑union), practical query examples, configuration flags, and step‑by‑step guidance for testing with sample tables and indexes.

Algorithmsdatabaseindex merge
0 likes · 9 min read
Mastering MySQL Index Merge: Principles, Algorithms, and Practical Tips
Java Architect Essentials
Java Architect Essentials
Apr 16, 2023 · Databases

Alibaba Druid Connection Pool in Spring Boot: Concepts, Configuration, Monitoring and Customization

This article introduces Alibaba's Druid database connection pool, explains its core features and filters, shows how to add the Maven starter, configure properties and filters in Spring Boot, demonstrates the built‑in monitoring pages, slow‑SQL logging, Spring AOP integration, and provides methods to remove the default advertisement and retrieve monitoring data via code.

ConfigurationConnection PoolDruid
0 likes · 16 min read
Alibaba Druid Connection Pool in Spring Boot: Concepts, Configuration, Monitoring and Customization
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 14, 2023 · Databases

SQLE 2.2304.0-pre2 Release Notes – Project Overview, New Features, and Full Release Information

The article introduces the SQLE 2.2304.0-pre2 preview release, outlines the tool’s purpose for database users and administrators, details new enterprise‑level features such as affected‑row statistics and enhanced rule severity display, lists added MySQL audit rules, and provides complete release information and resource links.

Database AuditingRelease NotesSQLE
0 likes · 6 min read
SQLE 2.2304.0-pre2 Release Notes – Project Overview, New Features, and Full Release Information
MaGe Linux Operations
MaGe Linux Operations
Apr 10, 2023 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams Quickly

This guide introduces DBeaver, a free Java‑based database management tool, covering its cross‑platform installation, how to create connections for databases like PostgreSQL via JDBC, and how to generate ER diagrams from existing schemas, all illustrated with step‑by‑step screenshots.

DBeaverDatabase ManagementER Diagram
0 likes · 7 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams Quickly
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 10, 2023 · Big Data

Fine‑grained Configuration, State Migration, and Debugging Techniques for Flink SQL at Meituan

This article describes how Meituan addresses the rapid growth of Flink SQL jobs by introducing fine‑grained TTL and concurrency settings, an editable execution plan for state migration, pre‑analysis compatibility checks, and a bytecode‑instrumented debugging system that captures operator data and streams it to Kafka for analysis.

Big DataFlinkMeituan
0 likes · 24 min read
Fine‑grained Configuration, State Migration, and Debugging Techniques for Flink SQL at Meituan
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 10, 2023 · Databases

Understanding OceanBase Recycle Bin: Retrieval, Multiple Same‑Name Tables, Visibility, and Flashback Behavior

This article explains how OceanBase's recycle bin works, covering error causes when flashing back tables, methods to obtain a table's database, handling of multiple same‑name tables, visibility across tenants, and the ability to flash back tables or tenants even after the recycle bin is disabled.

Database ManagementFlashbackOceanBase
0 likes · 11 min read
Understanding OceanBase Recycle Bin: Retrieval, Multiple Same‑Name Tables, Visibility, and Flashback Behavior
Top Architect
Top Architect
Apr 7, 2023 · Databases

MySQL Performance Optimization Guidelines from a Senior Architect

This article presents a senior architect’s comprehensive MySQL optimization guide, covering execution process, naming conventions, storage engine choices, indexing strategies, query writing best practices, transaction handling, partitioning, and other performance‑tuning techniques to improve database efficiency and reliability.

DatabaseOptimizationindexingmysql
0 likes · 24 min read
MySQL Performance Optimization Guidelines from a Senior Architect
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 3, 2023 · Databases

SQL Quality Management with Open-Source SQLE: Insights from the 2023 DAMS China Data Intelligence Management Summit

The 2023 DAMS China Data Intelligence Management Summit in Shanghai featured a technical presentation by Zhang Shenbo on an open‑source SQLE solution for SQL quality control, covering multi‑database auditing, automated review workflows, and practical tips to reduce DBA workload and cross‑department communication.

Data GovernanceData QualityDatabase Management
0 likes · 3 min read
SQL Quality Management with Open-Source SQLE: Insights from the 2023 DAMS China Data Intelligence Management Summit
Top Architect
Top Architect
Apr 2, 2023 · Databases

Optimizing Large-Scale Pagination Queries in MySQL: Data Generation and Index Strategies

This article demonstrates how to generate millions of test rows in MySQL, analyzes the performance impact of deep pagination using LIMIT, explains why non‑clustered index lookups cause costly table scans, and presents two optimization approaches—sub‑query ID filtering and key‑set pagination—to dramatically reduce query latency.

Data GenerationIndex Optimizationmysql
0 likes · 8 min read
Optimizing Large-Scale Pagination Queries in MySQL: Data Generation and Index Strategies
ITPUB
ITPUB
Mar 31, 2023 · Databases

How to Recover From an Accidental Full‑Table Update in Oracle

When a mistaken UPDATE statement overwrites an entire Oracle table, this guide explains four practical recovery techniques—including transaction rollback, flashback queries, LogMiner undo extraction, and RMAN backup restoration—detailing their prerequisites, commands, and trade‑offs.

Data RecoveryFlashback QueryOracle
0 likes · 7 min read
How to Recover From an Accidental Full‑Table Update in Oracle
Java High-Performance Architecture
Java High-Performance Architecture
Mar 31, 2023 · Databases

Mastering Liquibase with Spring Boot: A Step‑by‑Step Database Change Management Guide

This tutorial walks through setting up Liquibase in a Spring Boot project, creating a Maven plugin to generate XML/YAML changelogs, configuring the application, and performing common database operations such as creating tables, adding columns, creating indexes, initializing data, while also addressing a common includeAll path issue.

LiquibaseMaven PluginSpring Boot
0 likes · 19 min read
Mastering Liquibase with Spring Boot: A Step‑by‑Step Database Change Management Guide
Sohu Tech Products
Sohu Tech Products
Mar 29, 2023 · Databases

Understanding the Purpose and Impact of WHERE 1=1 in SQL Queries

This article explains why developers often include the redundant condition “WHERE 1=1” in SQL statements, demonstrating through performance tests that it has no effect on execution time, and describing its practical use for simplifying the addition of further conditions in both static and dynamic queries.

Dynamic SQLWHERE clausebest practices
0 likes · 6 min read
Understanding the Purpose and Impact of WHERE 1=1 in SQL Queries
AntTech
AntTech
Mar 29, 2023 · Information Security

Introducing SCQL: Secure Collaborative Query Language for Privacy-Preserving Data Analysis

SCQL, an open‑source Secure Collaborative Query Language built on multi‑party computation, enables SQL‑style privacy‑preserving data analysis for small‑to‑medium organizations by offering easy integration, fine‑grained column‑level access control, broad data‑source support, and optimized performance for collaborative queries.

Privacy ComputingSCQLdata analysis
0 likes · 6 min read
Introducing SCQL: Secure Collaborative Query Language for Privacy-Preserving Data Analysis
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 29, 2023 · Databases

Understanding Local and Global Indexes in OceanBase

The article explains the concepts, differences, and practical usage scenarios of local (partition‑aligned) and global indexes in OceanBase, providing SQL examples for queries with and without partition keys and guidance on creating unique indexes using either index type.

Local IndexOceanBasedatabase
0 likes · 7 min read
Understanding Local and Global Indexes in OceanBase
Selected Java Interview Questions
Selected Java Interview Questions
Mar 27, 2023 · Databases

Optimizing Deep Pagination in MySQL: Data Generation, Index Behavior, and Fast Query Strategies

This article demonstrates how to generate two million MySQL rows, examines the performance impact of large OFFSET values in LIMIT clauses, explains why non‑clustered indexes cause back‑table lookups, and presents two optimization strategies—using sub‑queries to fetch IDs and employing key‑based pagination—to dramatically speed up deep page queries.

Index Optimizationdatabasemysql
0 likes · 10 min read
Optimizing Deep Pagination in MySQL: Data Generation, Index Behavior, and Fast Query Strategies
Top Architect
Top Architect
Mar 27, 2023 · Backend Development

Three MyBatis Batch Insert Methods and Their Performance Comparison

The article explains three ways to perform batch inserts with MyBatis—ordinary single-row inserts, foreach‑based bulk inserts, and ExecutorType.BATCH—analyzes their SQL logs, performance bottlenecks, MySQL limits, and provides practical recommendations for large‑scale data insertion.

Batch InsertExecutorTypeMyBatis
0 likes · 13 min read
Three MyBatis Batch Insert Methods and Their Performance Comparison
Selected Java Interview Questions
Selected Java Interview Questions
Mar 26, 2023 · Databases

9 Common Pitfalls of SQL Scripts During System Deployment and How to Avoid Them

This article outlines nine typical problems that arise when executing SQL scripts in production—such as missing scripts, syntax errors, wrong order, timing issues, wrong database selection, long‑running updates, lack of rollback, missing indexes, and field renaming—and provides practical solutions to prevent each pitfall.

DBADatabase DeploymentDevOps
0 likes · 11 min read
9 Common Pitfalls of SQL Scripts During System Deployment and How to Avoid Them
ITPUB
ITPUB
Mar 25, 2023 · Big Data

Mastering Efficient SQL in ODPS: Union, Count‑Distinct, and Join Optimizations

This article walks through common SQL development scenarios on ODPS, examining why naïve UNION and COUNT DISTINCT can be slow, how to rewrite queries with GROUP BY, UNION ALL, JSON aggregation, and map‑join techniques, and shows the resulting execution‑plan improvements with concrete code and performance numbers.

Big DataCountDistinctMapJoin
0 likes · 17 min read
Mastering Efficient SQL in ODPS: Union, Count‑Distinct, and Join Optimizations
ITPUB
ITPUB
Mar 24, 2023 · Big Data

What’s New in Apache Flink 1.17? Key Features, Performance Gains, and Streaming Warehouse Advances

Apache Flink 1.17 introduces a suite of batch and streaming enhancements—including a new Streaming Warehouse API, significant TPC‑DS performance boosts, adaptive batch scheduling, improved checkpointing, expanded SQL capabilities, Hive connector upgrades, and broader filesystem support—while also delivering upgrades to FRocksDB, Calcite, and the token framework to strengthen its position as a leading unified data‑processing engine.

Apache FlinkBatch ProcessingCheckpoint
0 likes · 23 min read
What’s New in Apache Flink 1.17? Key Features, Performance Gains, and Streaming Warehouse Advances
Efficient Ops
Efficient Ops
Mar 22, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries

This article reveals frequent SQL mistakes—such as misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS, condition push‑down, premature filtering, and intermediate result push‑down—and provides concrete rewrite techniques that dramatically improve MySQL query performance.

Query Tuningdatabaseindexes
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
Alimama Tech
Alimama Tech
Mar 22, 2023 · Big Data

Intelligent Merchant‑Side Diagnostic System: Architecture, Rule Engine, and Data Center

The article describes an intelligent merchant‑side diagnostic platform that unifies ad‑operation data in a centralized lake, uses a low‑code rule engine with arithmetic, code, and Java class modes to orchestrate reusable SOPs, and employs an acceleration layer for fast large‑scale queries, achieving over 90% coverage and outlining future expansion.

data pipelinediagnosticslow-code
0 likes · 12 min read
Intelligent Merchant‑Side Diagnostic System: Architecture, Rule Engine, and Data Center
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 22, 2023 · Databases

Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase

The article explains what OceanBase BUFFER (Queuing) tables are, why frequent bulk updates cause performance degradation, and provides three optimization methods—including binding execution plans, manual data transfer, and setting table_mode='queuing'—with concrete MySQL and Oracle examples and query scripts to monitor merges.

BUFFER tableOceanBasedatabase
0 likes · 7 min read
Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase
php Courses
php Courses
Mar 21, 2023 · Databases

Introduction to MySQL sql_mode and Its 10 Modes

This article explains the MySQL sql_mode setting, details each of its ten modes—including STRICT_TRANS_TABLES, STRICT_ALL_TABLES, and ONLY_FULL_GROUP_BY—provides a command to view the current mode, and also includes a brief promotion for a PHP training class.

Database ConfigurationDatabase SettingsSQL Mode
0 likes · 4 min read
Introduction to MySQL sql_mode and Its 10 Modes
Open Source Linux
Open Source Linux
Mar 21, 2023 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article reviews the SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, column renaming, and related API changes, while comparing SQLite’s support to other major database systems.

FILTER clauseSQLiteUpsert
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 20, 2023 · Databases

New Features and Enhancements in MySQL 8.0

MySQL 8.0 introduces numerous enhancements including InnoDB engine defaults, atomic DDL, instant column addition, CTE support, UTF8MB4 default charset, Clone plugin, resource groups, role management, multi-valued and functional indexes, invisible indexes, descending indexes, SET_VAR syntax, persistent parameters, window functions, online DDL, and improved backup and binlog capabilities.

8.0InnoDBdatabase
0 likes · 23 min read
New Features and Enhancements in MySQL 8.0
Laravel Tech Community
Laravel Tech Community
Mar 19, 2023 · Databases

How to Diagnose and Resolve MySQL Process CPU Usage Spiking to 900%

This article explains common scenarios that cause MySQL (and related services) to consume 900% CPU, outlines step‑by‑step diagnosis using tools like top and show processlist, and provides practical remediation such as killing offending threads, adding missing indexes, disabling slow‑log, and leveraging Redis caching to bring CPU usage down to acceptable levels.

CPUcachingindexing
0 likes · 6 min read
How to Diagnose and Resolve MySQL Process CPU Usage Spiking to 900%
ITPUB
ITPUB
Mar 19, 2023 · Databases

Why MySQL 8’s Default utf8mb4 Breaks Legacy utf8 Tables – A Deep Dive

Upgrading MySQL 5.6/5.7 databases to 8.0 can introduce charset mismatches between existing utf8 (utf8mb3) tables and newly created utf8mb4 tables, causing index loss and performance degradation that can be resolved by unifying the character set across all tables.

mysqlperformancesql
0 likes · 7 min read
Why MySQL 8’s Default utf8mb4 Breaks Legacy utf8 Tables – A Deep Dive
Programmer DD
Programmer DD
Mar 17, 2023 · Backend Development

Parse and Format SQL in Java Instantly with JSqlParser

This article introduces JSqlParser, a Java library that parses SQL statements into object structures, demonstrates how to extract query components with sample code, lists supported databases, and highlights additional features like formatting and framework integration.

JSqlParserbackend-developmentjava
0 likes · 3 min read
Parse and Format SQL in Java Instantly with JSqlParser
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 16, 2023 · Big Data

How SLS’s Schema‑on‑Read Scanning Boosts Log Analytics Flexibility and Cuts Costs

This article explains the motivation, design, and implementation of Alibaba Cloud's SLS Schema‑on‑Read scanning mode, showing how it enables SQL analysis on raw log data without pre‑built indexes, improves flexibility for evolving schemas, and reduces storage and index costs in various log‑analysis scenarios.

Big DataColumnar StorageCost Optimization
0 likes · 27 min read
How SLS’s Schema‑on‑Read Scanning Boosts Log Analytics Flexibility and Cuts Costs
StarRing Big Data Open Lab
StarRing Big Data Open Lab
Mar 15, 2023 · Databases

Why Distributed Analytical Databases Are the Future: Inside ArgoDB’s Architecture

This article explains the architecture and key components of distributed analytical databases, contrasting them with MPP systems, and details the design of StarRing’s ArgoDB—including its storage, compute, transaction, and SQL engines—highlighting scalability, elasticity, and resource management for modern data warehousing.

Analytical DatabaseArgoDBStorage Engine
0 likes · 16 min read
Why Distributed Analytical Databases Are the Future: Inside ArgoDB’s Architecture
Laravel Tech Community
Laravel Tech Community
Mar 12, 2023 · Databases

Why COUNT(*) May Be Slower Than COUNT(1) in MySQL InnoDB

This article analyses how MySQL 5.7 InnoDB processes COUNT(*) versus COUNT(1), COUNT(id) and COUNT on indexed or non‑indexed columns, showing execution‑plan differences across various index configurations, explaining why count(*) can be unexpectedly slower and offering practical guidance for query optimization.

InnoDB_countindex
0 likes · 10 min read
Why COUNT(*) May Be Slower Than COUNT(1) in MySQL InnoDB
ITPUB
ITPUB
Mar 12, 2023 · Databases

Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost

This article walks through a practical SQL optimization workflow, showing how to detect problematic queries via system metrics and execution plans, analyze table structures and indexes, apply concrete ALTER statements and index changes, and iteratively verify performance improvements, illustrated with a detailed MySQL case study that achieved a twenty‑fold speed increase.

Index Optimizationexecution planmysql
0 likes · 10 min read
Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost
Sanyou's Java Diary
Sanyou's Java Diary
Mar 9, 2023 · Databases

21 Essential SQL Habits to Boost Performance and Avoid Regrets

This guide presents 21 practical SQL habits covering performance tuning, safe data manipulation, and coding standards—such as using EXPLAIN, adding LIMIT to deletes, documenting tables, consistent formatting, proper indexing, and transaction handling—to help developers write more efficient, reliable, and maintainable queries.

Database Optimizationcoding standardsperformance
0 likes · 15 min read
21 Essential SQL Habits to Boost Performance and Avoid Regrets
ITPUB
ITPUB
Mar 9, 2023 · Databases

9 Common SQL Script Pitfalls When Deploying to Production and How to Avoid Them

Deploying SQL scripts to production often leads to missed scripts, syntax errors, wrong execution order, mistimed runs, wrong databases, long runtimes, lack of rollback, missing indexes, and illegal column renames, but following structured version‑controlled practices can prevent these costly issues.

Database DeploymentDevOpsScript Management
0 likes · 11 min read
9 Common SQL Script Pitfalls When Deploying to Production and How to Avoid Them
Alimama Tech
Alimama Tech
Mar 8, 2023 · Artificial Intelligence

Secure Data Hub: Alibaba's Marketing Privacy Computing Platform

Alibaba’s Secure Data Hub (SDH) is a privacy‑preserving data clean‑room platform that uses secure multi‑party computation and privacy‑enhancing machine learning to let advertisers, ad platforms, and auditors jointly analyze marketing data via a simple SQL API while keeping raw data encrypted, column‑level protected, and confined to each party’s private domain.

Big Datadata clean roomsql
0 likes · 13 min read
Secure Data Hub: Alibaba's Marketing Privacy Computing Platform
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 8, 2023 · Databases

OceanBase Tenant Deletion Methods and Syntax

This article explains OceanBase's three tenant deletion approaches—normal, delayed, and immediate—detailing the DROP TENANT syntax, recycle‑bin behavior, and providing step‑by‑step SQL examples for creating, dropping, restoring, and permanently removing tenants.

Database AdministrationOceanBaseTenant Deletion
0 likes · 7 min read
OceanBase Tenant Deletion Methods and Syntax
DataFunTalk
DataFunTalk
Mar 8, 2023 · Artificial Intelligence

Applying AI Algorithms to Big Data Governance: Use Cases and Future Directions

This article presents Datacake's experience of integrating AI algorithms into big data governance, covering the bidirectional relationship between AI and big data, health‑score assessment of data tasks, intelligent Spark parameter tuning, SQL engine selection, and future application scenarios across the data lifecycle.

AIBig DataData Governance
0 likes · 18 min read
Applying AI Algorithms to Big Data Governance: Use Cases and Future Directions
MaGe Linux Operations
MaGe Linux Operations
Mar 7, 2023 · Databases

How Indexes Can Slash MySQL Query Time by 30,000× – Real‑World Optimization

This article walks through a MySQL 5.6 scenario where a nested sub‑query to find students scoring 100 in Chinese took over 30,000 seconds, then demonstrates how adding single‑column and composite indexes, rewriting the query with EXISTS or JOIN, and analyzing execution plans dramatically reduces execution time to milliseconds while explaining index merge, covering indexes, left‑most prefix, and sorting optimizations.

Index OptimizationQuery Performancesql
0 likes · 17 min read
How Indexes Can Slash MySQL Query Time by 30,000× – Real‑World Optimization
ITPUB
ITPUB
Mar 7, 2023 · Databases

Why Oracle Auto Tasks Slow Your Database and How to Fix Them

The article explains how Oracle's built‑in auto‑task jobs run during specific weekday and weekend windows, why they can cause performance degradation by changing execution plans or consuming resources, and provides practical steps to diagnose, adjust windows, and selectively disable problematic tasks.

Auto TaskDatabase PerformanceOracle
0 likes · 9 min read
Why Oracle Auto Tasks Slow Your Database and How to Fix Them
Laravel Tech Community
Laravel Tech Community
Mar 6, 2023 · Databases

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

This article presents a comprehensive set of MySQL performance guidelines, including avoiding SELECT *, preferring specific columns, eliminating OR in WHERE clauses, using numeric types, choosing VARCHAR over CHAR, applying proper JOINs, leveraging LIMIT, UNION ALL, composite indexes, and other practical tips to improve query efficiency and resource usage.

databaseindexingmysql
0 likes · 17 min read
SQL Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, and Other Performance Tips
Sanyou's Java Diary
Sanyou's Java Diary
Mar 6, 2023 · Databases

15 Common MySQL Index Pitfalls and How to Avoid Them

This article compiles fifteen typical scenarios where MySQL indexes become ineffective—covering composite index left‑most matching, SELECT *, arithmetic on indexed columns, functions, LIKE patterns, type conversion, OR/AND logic, range queries, ORDER BY, and optimizer decisions—providing example SQL, EXPLAIN output, and practical tips to help developers prevent costly full‑table scans.

databaseindexmysql
0 likes · 24 min read
15 Common MySQL Index Pitfalls and How to Avoid Them
IT Services Circle
IT Services Circle
Mar 4, 2023 · Databases

Practical Guide to SQL Optimization: Identifying and Improving Slow Queries

This article walks through a hands‑on process for detecting problematic SQL statements, interpreting execution plans, and applying concrete optimizations such as index adjustments and data‑type fixes to dramatically improve query performance, illustrated with a real MySQL case study.

Explain PlanIndex Optimizationdatabase
0 likes · 11 min read
Practical Guide to SQL Optimization: Identifying and Improving Slow Queries
Architect's Guide
Architect's Guide
Mar 3, 2023 · Databases

SQL Optimization: Common Steps, Index Types, and Practical Case Analyses

This article explains how to identify slow SQL statements, analyze execution plans with EXPLAIN, use profiling and optimizer trace, and apply practical solutions such as index optimization, query rewriting, and alternative storage, illustrated with ten real‑world MySQL case studies.

mysqloptimizationperformance
0 likes · 11 min read
SQL Optimization: Common Steps, Index Types, and Practical Case Analyses
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 1, 2023 · Operations

Guide to Expanding an OceanBase Cluster: Adding Zones and Resources

This article provides a step‑by‑step guide for scaling an OceanBase cluster, covering both white‑screen and black‑screen methods to add zones (replicas) and resources (OBServers), including configuration file preparation, deployment commands, zone addition, verification queries, and procedures for both expansion and contraction.

Database operationsObserverOceanBase
0 likes · 12 min read
Guide to Expanding an OceanBase Cluster: Adding Zones and Resources
DataFunTalk
DataFunTalk
Mar 1, 2023 · Databases

Evolution and Optimization of Tencent Music Content Library Data Platform: From Architecture 1.0 to 4.0

This article details the evolution of Tencent Music's content library data platform from version 1.0 to 4.0, describing business requirements, architectural redesigns—including migration from ClickHouse to Apache Doris, introduction of a semantic layer, and extensive write, query, and cost optimizations—while sharing practical lessons and future directions.

Apache DorisBig DataFlink
0 likes · 21 min read
Evolution and Optimization of Tencent Music Content Library Data Platform: From Architecture 1.0 to 4.0
ITPUB
ITPUB
Feb 27, 2023 · Databases

Mastering SQL Joins: Boost Performance When Migrating from Oracle to Open‑Source Databases

This article explains why SQL join execution plans often cause severe performance drops after moving from Oracle to domestic or open‑source databases, demonstrates each join type with PostgreSQL examples, shows how plan choices like HASH JOIN versus NESTED LOOP affect speed, and offers rewrite techniques such as NOT EXISTS or UNION to restore efficiency.

JOINOracledatabase migration
0 likes · 8 min read
Mastering SQL Joins: Boost Performance When Migrating from Oracle to Open‑Source Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 24, 2023 · Databases

SQLE 2.2302.0 Release Notes – New Features, Enhancements, and Bug Fixes

The SQLE 2.2302.0 release introduces data source import from external platforms, operation‑record viewing, improved CloudBeaver integration, manual deployment support, numerous UI optimizations, and a long list of bug fixes, providing a more seamless and secure SQL auditing experience for both enterprise and community users.

Bug FixesCloudBeaverData Integration
0 likes · 8 min read
SQLE 2.2302.0 Release Notes – New Features, Enhancements, and Bug Fixes
政采云技术
政采云技术
Feb 23, 2023 · Databases

Understanding Next-Key Lock Deadlocks in MySQL: Analysis and Solutions

This article examines how common business operations using SELECT ... FOR UPDATE and INSERT can cause MySQL Next‑Key lock deadlocks, explains the underlying gap‑lock and row‑lock mechanisms, demonstrates practical experiments, and proposes strategies such as postponing locks or using primary‑key updates to avoid such deadlocks.

Next-key Lockdatabasedeadlock
0 likes · 14 min read
Understanding Next-Key Lock Deadlocks in MySQL: Analysis and Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 22, 2023 · Databases

OceanBase Single‑Node Deployment and Tenant Management Guide

This article provides a comprehensive step‑by‑step tutorial on deploying OceanBase in a single‑node environment, covering resource unit, resource pool, and MySQL‑type tenant creation, modification, deletion, user management, and relevant system data dictionary tables, with full SQL command examples.

OceanBaseResource UnitTenant Management
0 likes · 10 min read
OceanBase Single‑Node Deployment and Tenant Management Guide
Architecture Digest
Architecture Digest
Feb 22, 2023 · Databases

Understanding the Execution Order of SQL Queries

This article explains the logical execution sequence of a typical SQL query, detailing each phase from FROM/JOIN/WHERE through GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT, and illustrating the process with diagrams and code examples.

From Join WhereGROUP BYHAVING
0 likes · 8 min read
Understanding the Execution Order of SQL Queries
政采云技术
政采云技术
Feb 21, 2023 · Databases

Understanding Next-Key Lock Deadlocks in MySQL and How to Avoid Them

This article examines how common business operations using SELECT ... FOR UPDATE and INSERT can cause Next‑Key lock deadlocks in MySQL under repeatable‑read isolation, demonstrates the locking behavior with practical SQL examples, and proposes strategies such as post‑locking and primary‑key updates to prevent such deadlocks.

Isolation LevelNext-key Lockdatabase
0 likes · 14 min read
Understanding Next-Key Lock Deadlocks in MySQL and How to Avoid Them
ITPUB
ITPUB
Feb 20, 2023 · Databases

18 Must‑Know MySQL 8.0 Management Features to Boost Your DBA Skills

Discover 18 essential MySQL 8.0 management enhancements—including persistent global variables, admin IP/port settings, minimal installation packages, resource groups, read‑only databases, improved SHOW PROCESSLIST, instant DDL, faster DROP/TRUNCATE, OS thread visibility, connection memory limits, enriched slow‑log details, backup options, Clone plugin, upgrade process, client defaults, and RESTART command usage.

8.0Database Administrationmysql
0 likes · 12 min read
18 Must‑Know MySQL 8.0 Management Features to Boost Your DBA Skills
Open Source Linux
Open Source Linux
Feb 20, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries

This article examines eight frequent SQL anti‑patterns—including misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, condition push‑down, premature data reduction, and intermediate result handling—explaining why they degrade performance and providing concrete rewrite strategies and code examples to dramatically speed up queries.

databasemysqloptimization
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
Liangxu Linux
Liangxu Linux
Feb 19, 2023 · Databases

Mastering Sequel Pro: A Complete Guide to Managing MySQL Databases

This guide introduces Sequel Pro, explains how to configure Standard, Socket, or SSH connections with required fields, describes the main interface modules for browsing schemas, tables, relationships, triggers, and running queries, and highlights useful shortcuts for efficient MySQL management.

Database GUISequel Proconnection
0 likes · 3 min read
Mastering Sequel Pro: A Complete Guide to Managing MySQL Databases
DevOps Cloud Academy
DevOps Cloud Academy
Feb 19, 2023 · Databases

Implementing Database GitOps with Bytebase: A Step‑by‑Step Guide

This article walks through setting up a local MySQL cluster, configuring Ngrok, deploying Bytebase via Docker, enabling GitOps integration with GitHub, and managing SQL schema changes through automated pull‑request workflows, providing code snippets and detailed screenshots for each step.

BytebaseDatabase CI/CDDocker
0 likes · 7 min read
Implementing Database GitOps with Bytebase: A Step‑by‑Step Guide
Java Architect Essentials
Java Architect Essentials
Feb 19, 2023 · Databases

Understanding the Execution Order of SQL Queries

This article explains the step‑by‑step execution order of a standard SQL query, covering FROM/JOIN, WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY and LIMIT, and provides illustrative code snippets and diagrams to clarify each stage.

FROMGROUP BYHAVING
0 likes · 5 min read
Understanding the Execution Order of SQL Queries
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 17, 2023 · Databases

SQLE 2.2302.0-pre5 Release Notes and New Features

The preview release of SQLE version 2.2302.0-pre5 introduces optimized CloudBeaver integration, UI improvements, bug fixes, and provides detailed project information, release notes, and resources for database users and administrators.

CloudBeaver IntegrationDatabase AuditingRelease Notes
0 likes · 3 min read
SQLE 2.2302.0-pre5 Release Notes and New Features
DevOps Cloud Academy
DevOps Cloud Academy
Feb 15, 2023 · Databases

Using Bytebase for Database DevOps: A Step‑by‑Step Experience

This article walks through a hands‑on experience of deploying Bytebase via Docker‑Compose, configuring test and production environments, adding database instances, linking them to projects, performing a schema change with SQL, verifying the update, and completing the associated work‑order, offering practical insights for database DevOps practitioners.

BytebaseDatabase DevOpsDocker Compose
0 likes · 5 min read
Using Bytebase for Database DevOps: A Step‑by‑Step Experience