BestHub
Sign in
Tagged articles

SQL

2820 articles · Page 14 of 29
Top Architect
Top Architect
Aug 4, 2022 · Databases

Implementing Multi‑Business‑Unit Sales Statistics Queries with Row‑by‑Row Comparison in MySQL

The article explains how to query sales statistics for multiple business units and their associated products in MySQL, compares several implementation strategies such as looping, OR‑concatenation, mixed filtering, and finally adopts the SQL‑92 row‑by‑row comparison technique to achieve a single‑query solution that respects indexing and corporate coding standards.

Dynamic SQLMySQLRow Comparison
0 likes · 8 min read
Implementing Multi‑Business‑Unit Sales Statistics Queries with Row‑by‑Row Comparison in MySQL
Java Architect Essentials
Java Architect Essentials
Aug 3, 2022 · Databases

Comprehensive SQL Server Database Operations and Replication Guide

This article provides an extensive collection of SQL Server commands and techniques covering basic database creation, table manipulation, advanced queries, backup and maintenance, as well as detailed steps for setting up linked servers, snapshot replication, and synchronization procedures between servers.

Linked ServerSQLSQL Server
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Replication Guide
DataFunTalk
DataFunTalk
Aug 3, 2022 · Artificial Intelligence

Building a Complete Machine Learning Application with OpenMLDB and OneFlow: JD High‑Potential User Purchase Intent Prediction

This tutorial demonstrates how to use OpenMLDB together with OneFlow to build an end‑to‑end machine‑learning pipeline for predicting high‑potential JD users' purchase intent, covering environment setup, data loading, SQL table creation, offline feature extraction, DeepFM model training, model serving, online feature extraction, deployment, and real‑time inference.

DockerFeatureEngineeringModelServing
0 likes · 22 min read
Building a Complete Machine Learning Application with OpenMLDB and OneFlow: JD High‑Potential User Purchase Intent Prediction
AntTech
AntTech
Aug 2, 2022 · Databases

Introducing CeresDB: An Open‑Source Distributed High‑Performance Time Series Database

CeresDB, a distributed high‑availability time‑series database originally built at Ant Group, is now open‑sourced with version 0.2.0, offering high‑throughput writes, multi‑dimensional queries, SQL support, compatibility with Prometheus and OpenTSDB, and a range of features targeting both monitoring and analytical workloads.

CeresDBRustSQL
0 likes · 11 min read
Introducing CeresDB: An Open‑Source Distributed High‑Performance Time Series Database
Architect
Architect
Jul 28, 2022 · Information Security

Implementing Data Masking in MySQL and Java Using MyBatis‑Mate Sensitive Jackson

This article demonstrates how to mask sensitive data such as phone numbers, ID cards, and emails in MySQL and Java applications by combining SQL string functions with the MyBatis‑Mate Sensitive Jackson plugin, providing complete configuration, custom strategies, and runnable Spring Boot examples.

Data MaskingJavaMyBatis
0 likes · 9 min read
Implementing Data Masking in MySQL and Java Using MyBatis‑Mate Sensitive Jackson
Top Architect
Top Architect
Jul 28, 2022 · Databases

SQL Optimization Steps and Common Scenarios: Index Usage, EXPLAIN, Profiling, and Trace

This article explains how to identify and resolve performance bottlenecks in MySQL by locating slow queries, analyzing execution plans with EXPLAIN, focusing on type, rows and extra information, using profiling and trace tools, and applying practical optimization techniques illustrated through multiple real‑world cases.

IndexingMySQLPerformance Tuning
0 likes · 11 min read
SQL Optimization Steps and Common Scenarios: Index Usage, EXPLAIN, Profiling, and Trace
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 28, 2022 · Big Data

Spark SQL UNION Causing driver.maxResultSize Error and Its Resolution

When executing a Spark SQL query with dozens of UNION subqueries that each contain JOIN operations on Spark 3.1.2, the job fails because the total serialized result size of the tasks exceeds the driver’s maxResultSize limit, and the issue can be resolved by reducing the initial partition number used by Adaptive Query Execution.

DriverMaxResultSizePerformanceTuningSQL
0 likes · 10 min read
Spark SQL UNION Causing driver.maxResultSize Error and Its Resolution
Programmer DD
Programmer DD
Jul 28, 2022 · Databases

Why MongoDB Is Adding Native Analytics and What It Means for Developers

MongoDB is evolving from a purely operational document store to a hybrid system that embeds native analytics, cloud‑native features, and SQL access, aiming to boost developer productivity, support real‑time insights, and complement rather than replace traditional data warehouses.

AnalyticsCloudData Lake
0 likes · 12 min read
Why MongoDB Is Adding Native Analytics and What It Means for Developers
政采云技术
政采云技术
Jul 28, 2022 · Databases

Analyzing and Resolving MySQL Next‑Key Lock Deadlocks: A Practical Case Study

This article walks through a real MySQL deadlock scenario, explaining the four necessary deadlock conditions, illustrating how Next‑Key locks on non‑unique indexes cause gap locks, and presenting step‑by‑step analysis, experimental verification, and practical recommendations to avoid such deadlocks in production systems.

DeadlockLockingMySQL
0 likes · 15 min read
Analyzing and Resolving MySQL Next‑Key Lock Deadlocks: A Practical Case Study
21CTO
21CTO
Jul 27, 2022 · Databases

Master 10 Essential Advanced SQL Concepts for Data Professionals

This article presents ten crucial intermediate‑to‑advanced SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—to help data professionals ace interview questions and write cleaner, more powerful queries.

CTESQLWindow Functions
0 likes · 11 min read
Master 10 Essential Advanced SQL Concepts for Data Professionals
dbaplus Community
dbaplus Community
Jul 26, 2022 · Databases

Master MySQL Data Archiving with pt-archiver: Install, Run, and Optimize

This guide explains how to use Percona Toolkit's pt-archiver for MySQL data archiving, covering installation, basic and bulk commands, underlying two‑phase‑commit logic, performance trade‑offs of various parameters, and best‑practice tips for safe, efficient archiving and deletion.

Data ArchivingMySQLReplication Lag
0 likes · 19 min read
Master MySQL Data Archiving with pt-archiver: Install, Run, and Optimize
Top Architect
Top Architect
Jul 26, 2022 · Databases

Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss

This article explains the differences between row-based and column-based storage in databases, compares their advantages and disadvantages, presents experimental results using openGauss including space usage and insert performance, and offers practical guidance on selecting the appropriate storage model for various workloads.

Column StoreDatabase StorageRow Store
0 likes · 10 min read
Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss
ITPUB
ITPUB
Jul 24, 2022 · Databases

How Apache Doris Enables Real‑Time Queries on Hudi Data Lakes

This article explains Apache Doris’s architecture, introduces the Hudi data‑lake format, compares Lambda and Kappa approaches, and details the design and implementation of Doris’s Hudi external table support, including practical steps, code examples, and future roadmap.

Apache DorisBig DataData Lake
0 likes · 10 min read
How Apache Doris Enables Real‑Time Queries on Hudi Data Lakes
dbaplus Community
dbaplus Community
Jul 22, 2022 · Databases

Why MongoDB Is Adding Native Analytics and What It Means for Developers

The article examines MongoDB’s evolution toward built‑in analytics, detailing new features like native search, time‑series support, change streams, Atlas analytics nodes, and the upcoming Atlas SQL interface, while arguing that these capabilities aim to empower developers rather than replace dedicated data‑warehouse solutions.

ATLASAnalyticsHTAP
0 likes · 10 min read
Why MongoDB Is Adding Native Analytics and What It Means for Developers
Open Source Linux
Open Source Linux
Jul 22, 2022 · Databases

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

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert support, column renaming, and related API changes, while highlighting limitations and compatibility notes compared with other major databases.

Boolean LiteralsSQLSQL features
0 likes · 12 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Top Architect
Top Architect
Jul 21, 2022 · Databases

Overview of SQLite’s New SQL Features in 2018 (Versions 3.22.0–3.26.0)

The article explains SQLite’s 2018 enhancements—including boolean literals, window functions, FILTER clause, UPSERT syntax, and column‑renaming—detailing how these features work, their syntax, limitations, and providing code examples for developers seeking to use SQLite in production environments.

Database FeaturesFILTER clauseSQL
0 likes · 10 min read
Overview of SQLite’s New SQL Features in 2018 (Versions 3.22.0–3.26.0)
Efficient Ops
Efficient Ops
Jul 20, 2022 · Databases

How Indexes Can Speed Up MySQL Queries by Tens of Thousands of Times

This article walks through a MySQL scenario where a nested sub‑query runs for hours, demonstrates how adding single‑column and multi‑column indexes, rewriting the query as a join, and analyzing execution plans can reduce execution time from thousands of seconds to a few milliseconds.

Database TuningIndex OptimizationMySQL
0 likes · 12 min read
How Indexes Can Speed Up MySQL Queries by Tens of Thousands of Times
IT Architects Alliance
IT Architects Alliance
Jul 20, 2022 · Backend Development

Preventing Coupon Over‑Issuance in High‑Concurrency Scenarios: Java Locks, SQL Constraints, and Redis Distributed Locks

This article analyzes the coupon over‑issuance issue caused by concurrent requests, demonstrates how simple SQL updates can fail under load, and presents four solutions—including Java synchronized blocks, SQL row‑level locking, optimistic locking, and Redis‑based distributed locks with Redisson—to ensure atomic coupon allocation.

CouponJavaRedis
0 likes · 11 min read
Preventing Coupon Over‑Issuance in High‑Concurrency Scenarios: Java Locks, SQL Constraints, and Redis Distributed Locks
Python Programming Learning Circle
Python Programming Learning Circle
Jul 20, 2022 · Databases

10 Essential SQL Concepts for Interview Preparation

This article presents ten core SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—each explained with clear descriptions and practical query examples to help candidates ace data‑analysis interviews.

CASE WHENCTERanking
0 likes · 11 min read
10 Essential SQL Concepts for Interview Preparation
Liangxu Linux
Liangxu Linux
Jul 19, 2022 · Databases

Master MySQL Stored Procedures, Events, and Triggers for Automated Data Workflows

This guide explains how to use MySQL stored procedures, events (timers), and triggers—including their creation, variable handling, control structures, parameter passing, loops, scheduling options, and practical examples—to automate reporting, data monitoring, and business logic directly at the database layer.

Database AutomationEvent SchedulerMySQL
0 likes · 11 min read
Master MySQL Stored Procedures, Events, and Triggers for Automated Data Workflows
Architecture Digest
Architecture Digest
Jul 19, 2022 · Databases

Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages, and Experimental Evaluation

This article explains the fundamental differences between row‑based and column‑based storage in databases, compares their read/write performance, presents experimental results on openGauss showing space and speed trade‑offs, and offers practical guidance on when to choose each storage model.

Column StoreDatabase StorageRow Store
0 likes · 11 min read
Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages, and Experimental Evaluation
DataFunTalk
DataFunTalk
Jul 18, 2022 · Big Data

Integrating Apache Doris with Hudi: Design, Implementation, and Future Plans

This article introduces Apache Doris, an MPP analytical database, and explains how it integrates with the Hudi data lake format, covering architectural features, design choices, implementation steps including external table creation and query processing, and outlines future enhancements for supporting MOR snapshots and incremental queries.

Apache DorisData LakeHudi
0 likes · 12 min read
Integrating Apache Doris with Hudi: Design, Implementation, and Future Plans
Architects' Tech Alliance
Architects' Tech Alliance
Jul 17, 2022 · Databases

Comprehensive Overview of Database Evolution, Architecture, and Core Technologies

This article provides a detailed survey of database fundamentals, historical evolution from early relational systems to modern distributed and cloud‑native solutions, explains various architectural components and core technologies such as query processing, indexing, transaction management, and discusses business‑driven classifications, distributed designs, SMP versus MPP, and resource‑access models.

HTAPNoSQLSQL
0 likes · 34 min read
Comprehensive Overview of Database Evolution, Architecture, and Core Technologies
Top Architect
Top Architect
Jul 16, 2022 · Databases

Understanding MySQL Locks: Table, Row, and Gap Locks in InnoDB and MyISAM

This article explains MySQL locking mechanisms—including table‑level, row‑level, shared and exclusive locks, as well as gap locks—covers the differences between MyISAM and InnoDB engines, shows how to monitor lock statistics, and provides practical optimization tips for reducing lock contention.

InnoDBLocksMyISAM
0 likes · 9 min read
Understanding MySQL Locks: Table, Row, and Gap Locks in InnoDB and MyISAM
MaGe Linux Operations
MaGe Linux Operations
Jul 15, 2022 · Databases

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

SQLite, often underestimated, introduced several powerful SQL enhancements in 2018—including boolean literals, window functions, FILTER clauses, UPSERT syntax, and column renaming—bringing its capabilities closer to major RDBMSes while retaining its lightweight, file‑based design.

Boolean LiteralsDatabase FeaturesSQL
0 likes · 11 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Top Architect
Top Architect
Jul 15, 2022 · Databases

SQL Query Optimization Tips to Avoid Full Table Scans

This article presents a comprehensive list of practical SQL query optimization techniques, emphasizing how to avoid full table scans by using proper indexing, rewriting WHERE clauses, avoiding certain operators, functions, and expressions, and providing example code snippets to improve database performance.

Query OptimizationSQLT-SQL
0 likes · 10 min read
SQL Query Optimization Tips to Avoid Full Table Scans
Liangxu Linux
Liangxu Linux
Jul 14, 2022 · Databases

What New SQL Features Did SQLite Add in 2018?

This article reviews the SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0 in 2018, covering boolean literals, window functions, FILTER clauses, UPSERT syntax, column renaming, and related API changes with code examples and practical notes.

SQLSQLiteUpsert
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018?
Java High-Performance Architecture
Java High-Performance Architecture
Jul 11, 2022 · Backend Development

Preventing Coupon Over‑Issuance in High‑Concurrency Java Applications

This article examines why coupon stock can become negative under concurrent requests and presents four practical solutions—including Java synchronized blocks, SQL conditional updates, Redis distributed locks, and Redisson client usage—to reliably prevent coupon over‑issuance in high‑traffic systems.

ConcurrencyCouponDistributed Lock
0 likes · 11 min read
Preventing Coupon Over‑Issuance in High‑Concurrency Java Applications
DeWu Technology
DeWu Technology
Jul 11, 2022 · Databases

SQL Fine-Grained Management and Concurrency Control Best Practices

The guide recommends fine‑grained MySQL management in a MyBatis‑based order system—avoiding generic or dynamic SQL, explicitly using indexes, listing columns, limiting results, batching inserts, and checking row counts—while applying appropriate concurrency control (pessimistic FOR UPDATE or optimistic versioning) to improve performance, stability, and data integrity.

Concurrency ControlLockingMyBatis
0 likes · 18 min read
SQL Fine-Grained Management and Concurrency Control Best Practices
Selected Java Interview Questions
Selected Java Interview Questions
Jul 10, 2022 · Databases

Comparison of PostgreSQL and MySQL

This article provides a detailed technical comparison between PostgreSQL and MySQL, covering architecture, stored procedures, transactions, performance, high availability, replication, permission control, SQL support, data types, fault tolerance, table organization, development interfaces, and community maintenance.

Database ComparisonPostgreSQLSQL
0 likes · 12 min read
Comparison of PostgreSQL and MySQL
IT Services Circle
IT Services Circle
Jul 8, 2022 · Databases

Safely Deleting Massive Tables: Avoid Long Transactions with Batch SQL and Insert‑Instead Strategies

This article explains why executing a single DELETE on a half‑billion‑row table can cause long‑running transactions, lock contention, and replication lag, and demonstrates how to split the operation into indexed batch deletes or replace it with an insert‑into‑new‑table workflow to improve safety and performance.

Batch DeletionLarge TablesSQL
0 likes · 8 min read
Safely Deleting Massive Tables: Avoid Long Transactions with Batch SQL and Insert‑Instead Strategies
Liangxu Linux
Liangxu Linux
Jul 7, 2022 · Databases

30 Essential SQL Query Optimization Tips to Avoid Full Table Scans

This article presents thirty practical tips for optimizing SQL queries—covering index creation, avoiding costly operators, rewriting predicates, using set‑based logic, and managing temporary objects—to dramatically reduce full table scans and improve overall database performance.

IndexesPerformanceSQL
0 likes · 11 min read
30 Essential SQL Query Optimization Tips to Avoid Full Table Scans
IT Services Circle
IT Services Circle
Jul 6, 2022 · Databases

Understanding MySQL COUNT() Performance and Strategies for Large Tables

This article explains how MySQL COUNT() works under different storage engines, why counting rows becomes slow on large InnoDB tables, and presents practical methods such as using EXPLAIN rows, auxiliary count tables, batch processing, and transaction‑based updates to obtain approximate or exact row counts efficiently.

COUNTInnoDBMonitoring
0 likes · 12 min read
Understanding MySQL COUNT() Performance and Strategies for Large Tables
Cognitive Technology Team
Cognitive Technology Team
Jul 5, 2022 · Backend Development

Avoiding Unexpected Comma Formatting of Large Integers with MessageFormat in MyBatis SQL Generation

When using MessageFormat to inject integer parameters into dynamically generated MyBatis SQL, large numbers are automatically formatted with commas (e.g., 10000 becomes 10,000), which can break SQL statements, and the article explains why this happens and how to prevent it by converting numbers to strings before formatting.

DecimalFormatIntegerFormattingJava
0 likes · 3 min read
Avoiding Unexpected Comma Formatting of Large Integers with MessageFormat in MyBatis SQL Generation
Programmer DD
Programmer DD
Jul 5, 2022 · Databases

SQLite 2018: New SQL Features – Booleans, Window Functions, Upserts & More

SQLite, often underestimated, has added powerful SQL capabilities in 2018—including true/false literals, advanced boolean checks, window functions, FILTER clauses, upsert support via INSERT ON CONFLICT, and column renaming—bringing its feature set closer to major databases while retaining its lightweight, file‑based architecture.

Boolean LiteralsSQLSQLite
0 likes · 12 min read
SQLite 2018: New SQL Features – Booleans, Window Functions, Upserts & More
Open Source Linux
Open Source Linux
Jun 29, 2022 · Databases

Top MySQL Interview Questions & Answers Every DBA Should Know

This article compiles essential MySQL interview questions covering primary and candidate keys, date functions, trigger limits, index column counts, data copying techniques, core MySQL concepts, feature highlights, transaction ACID properties, heap versus clustered tables, numeric type differences, and objects creatable with CREATE statements.

Heap TableInterview QuestionsMySQL
0 likes · 9 min read
Top MySQL Interview Questions & Answers Every DBA Should Know
dbaplus Community
dbaplus Community
Jun 28, 2022 · Databases

Master 10 Advanced SQL Concepts Every Data Scientist Should Know

This article presents ten essential advanced SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking windows, delta calculations, cumulative totals, and date‑time manipulation—each explained with clear examples and code snippets for interview preparation.

CASE WHENCTEData Science Interviews
0 likes · 11 min read
Master 10 Advanced SQL Concepts Every Data Scientist Should Know
MaGe Linux Operations
MaGe Linux Operations
Jun 28, 2022 · Databases

How Indexes Can Speed Up MySQL Queries by 50,000×: A Deep Dive

This article walks through a MySQL scenario with large tables, demonstrates why a sub‑query that took over eight hours runs in just a second after adding appropriate single‑column and composite indexes, and explains how to read and interpret execution plans for further tuning.

Index OptimizationMySQLSQL
0 likes · 11 min read
How Indexes Can Speed Up MySQL Queries by 50,000×: A Deep Dive
ITPUB
ITPUB
Jun 25, 2022 · Big Data

How Spark SQL’s Catalyst Optimizer Accelerates Big Data Queries

This article explains Apache Spark’s role in large‑scale data processing, traces the evolution from Shark to Spark SQL’s DataFrame and Dataset APIs, and details the internal Catalyst optimizer—including its rule‑based and cost‑based strategies—through step‑by‑step examples and code snippets.

CatalystOptimizationSQL
0 likes · 11 min read
How Spark SQL’s Catalyst Optimizer Accelerates Big Data Queries
php Courses
php Courses
Jun 24, 2022 · Databases

Comprehensive List of MySQL Interview Questions

This article compiles 66 MySQL interview questions covering fundamentals such as joins, data types, indexes, storage engines, transaction properties, locking mechanisms, replication, sharding, performance tuning, and high‑availability concepts for interview preparation.

IndexingMySQLPerformance
0 likes · 3 min read
Comprehensive List of MySQL Interview Questions
Sanyou's Java Diary
Sanyou's Java Diary
Jun 23, 2022 · Backend Development

Master MyBatis: From Basics to Advanced Features and Best Practices

This comprehensive guide explains what MyBatis is, compares it with Hibernate, details its core components, configuration, dynamic SQL, caching, plugins, pagination, and practical usage patterns, providing Java developers with clear examples, code snippets, and visual diagrams to master the framework efficiently.

Dynamic SQLMyBatisORM
0 likes · 38 min read
Master MyBatis: From Basics to Advanced Features and Best Practices
Baidu Geek Talk
Baidu Geek Talk
Jun 22, 2022 · Databases

Analyzing Go SQL Connection Pool Resource Release and Transaction Management

The article explains how Go's database/sql pool retains connections until Rows, Stmt, or Tx objects are explicitly closed or a timeout context is cancelled, demonstrates experiments showing blocked goroutines when resources aren't released, and offers practical guidelines—using QueryContext with timeouts, deferring Close/Cancel, and always committing or rolling back transactions—to prevent pool exhaustion and improve MySQL reliability.

Connection PoolSQLTransaction Management
0 likes · 19 min read
Analyzing Go SQL Connection Pool Resource Release and Transaction Management
Qunar Tech Salon
Qunar Tech Salon
Jun 22, 2022 · Operations

Design and Implementation of Multi‑Cluster HPA Metrics Collection, Analysis, and Reporting in Kubernetes

This article explains the background, benefits, and measurement criteria of Kubernetes Horizontal‑Pod‑Autoscaler (HPA), describes the creation of metric tables and SQL queries for collecting scaling events and CPU usage, and presents a Python‑based workflow that aggregates the data, stores daily reports, validates results, and sends automated email summaries.

HPAKubernetesMonitoring
0 likes · 19 min read
Design and Implementation of Multi‑Cluster HPA Metrics Collection, Analysis, and Reporting in Kubernetes
JD Tech
JD Tech
Jun 20, 2022 · Backend Development

Analyzing MyBatis Query Process and Fixing a Pre‑3.4.5 foreach Variable Bug

This article examines a MyBatis bug present in versions prior to 3.4.5 by reproducing the issue, walking through the complete query execution flow from configuration parsing to result handling, identifying the root cause in foreach variable binding, and presenting official fixes and practical work‑arounds.

BugFixMyBatisORM
0 likes · 19 min read
Analyzing MyBatis Query Process and Fixing a Pre‑3.4.5 foreach Variable Bug
dbaplus Community
dbaplus Community
Jun 19, 2022 · Databases

Master MySQL Upgrades with pt‑upgrade: Detect Compatibility Issues Seamlessly

This article explains why MySQL upgrades can cause syntax, semantic and performance incompatibilities, introduces the Percona Toolkit's pt‑upgrade tool, details its detection logic and common usage patterns, provides a full demo with real query results, and lists essential parameters and precautions for safely migrating from MySQL 5.7 to 8.0.

MySQLSQLcompatibility testing
0 likes · 17 min read
Master MySQL Upgrades with pt‑upgrade: Detect Compatibility Issues Seamlessly
dbaplus Community
dbaplus Community
Jun 18, 2022 · Operations

Zabbix vs Prometheus: Architecture, Pros, and super_exporter Integration

This article compares the open‑source monitoring systems Zabbix and Prometheus, detailing their architectures, component roles, strengths, and weaknesses, then describes how to integrate Zabbix data into Prometheus using a custom super_exporter and visualise the combined metrics with Grafana.

GrafanaPrometheusSQL
0 likes · 14 min read
Zabbix vs Prometheus: Architecture, Pros, and super_exporter Integration
Su San Talks Tech
Su San Talks Tech
Jun 16, 2022 · Databases

Master MySQL Index Design: Essential Principles for Optimal Performance

This article explains MySQL index fundamentals, covering clustered and secondary indexes, best‑practice design rules such as using auto‑increment primary keys, avoiding large or low‑cardinality columns, respecting the left‑most prefix, and common scenarios that cause index loss, with practical SQL examples.

MySQLSQLindex design
0 likes · 12 min read
Master MySQL Index Design: Essential Principles for Optimal Performance
Top Architect
Top Architect
Jun 14, 2022 · Databases

Understanding MySQL Execution Process: Connectors, Cache, Parser, Optimizer, and Executor

This article explains MySQL's internal execution process—including the connector, cache, parser, optimizer, and executor—describes privilege tables and verification, discusses query caching removal, outlines logical SQL execution order, and provides practical tips for ordering WHERE conditions to improve performance.

Database InternalsMySQLPerformance Tuning
0 likes · 12 min read
Understanding MySQL Execution Process: Connectors, Cache, Parser, Optimizer, and Executor
Programmer DD
Programmer DD
Jun 13, 2022 · Databases

Master DataGrip: Essential Tips for Efficient Database Management

This guide walks you through installing DataGrip, configuring database connections, customizing the IDE, and leveraging its powerful SQL editing, navigation, and data import/export features, providing a comprehensive overview for developers seeking a streamlined database client experience.

DataGripDatabase ManagementIDE
0 likes · 12 min read
Master DataGrip: Essential Tips for Efficient Database Management
Java Architect Essentials
Java Architect Essentials
Jun 12, 2022 · Backend Development

MyBatis-Mate: Advanced Features and Usage Guide for MyBatis-Plus in Java Backend Development

This article introduces MyBatis-Mate, an official MyBatis-Plus extension that offers enterprise‑grade capabilities such as dictionary binding, field encryption, data masking, dynamic DDL generation, multi‑datasource sharding, data‑scope filtering, and SQL performance logging, complete with Maven dependency setup and code examples.

DataEncryptionMyBatisORM
0 likes · 12 min read
MyBatis-Mate: Advanced Features and Usage Guide for MyBatis-Plus in Java Backend Development
ITPUB
ITPUB
Jun 12, 2022 · Databases

10 Proven Ways to Prevent Dangerous SQL Mistakes in Production

This article presents ten practical techniques—ranging from avoiding chat‑tool SQL transmission to using logical deletes, backups, and temporary tables—to help developers and DBAs safely execute and modify data in production environments while minimizing accidental data loss.

Best PracticesData SafetyMySQL
0 likes · 14 min read
10 Proven Ways to Prevent Dangerous SQL Mistakes in Production
Java Backend Technology
Java Backend Technology
Jun 11, 2022 · Information Security

How to Mask Sensitive Data in MySQL and Java with MyBatis‑Mate

This article demonstrates practical techniques for data masking, covering MySQL string functions for phone and ID masking, a Java library for various sensitive fields, and a MyBatis‑Mate extension that applies custom and built‑in masking strategies through annotations and REST endpoints.

JavaMyBatisSQL
0 likes · 8 min read
How to Mask Sensitive Data in MySQL and Java with MyBatis‑Mate
Zuoyebang Tech Team
Zuoyebang Tech Team
Jun 7, 2022 · Big Data

How Doris Powered Zuoyebang’s Real‑Time Data Warehouse for Faster Insights

Zuoyebang’s data team replaced fragmented, slow query solutions with Apache Doris, building a unified real‑time data warehouse that dramatically cut query latency from hours to seconds, streamlined data modeling, and improved reliability across diverse business scenarios, while integrating with Flink, Kafka, and ES via a unified API.

Apache DorisElasticsearchFlink
0 likes · 20 min read
How Doris Powered Zuoyebang’s Real‑Time Data Warehouse for Faster Insights
Ops Development Stories
Ops Development Stories
Jun 5, 2022 · Databases

What Really Happens Inside MySQL When You Run a SELECT Query?

This article walks through the complete lifecycle of a MySQL SELECT statement, from establishing the TCP connection and authentication, through query cache, parsing, optimization, and execution, detailing how the server and storage engine collaborate and explaining concepts like index usage, connection handling, and memory management.

Database ArchitectureIndex OptimizationMySQL
0 likes · 20 min read
What Really Happens Inside MySQL When You Run a SELECT Query?
Ops Development Stories
Ops Development Stories
Jun 1, 2022 · Databases

Master MySQL Indexes: From B+Tree Basics to Advanced Optimization

This article explains MySQL index fundamentals, covering B+Tree structures, various index types, creation syntax, and practical optimization techniques such as prefix, covering, and composite indexes, while illustrating how to avoid common pitfalls like index misuse and performance‑degrading scenarios.

B+TreeMySQLSQL
0 likes · 23 min read
Master MySQL Indexes: From B+Tree Basics to Advanced Optimization
Big Data Technology & Architecture
Big Data Technology & Architecture
May 31, 2022 · Databases

Vectorization and Roaring Bitmap Techniques in Database Query Execution

This article explains how classic SQL execution engines use the volcano model and expression trees, discusses their performance drawbacks, introduces vectorized execution to reduce overhead, and describes Roaring Bitmap compression methods with container types for efficient storage and processing of integer sets.

Big DataDatabase EngineOperator Tree
0 likes · 10 min read
Vectorization and Roaring Bitmap Techniques in Database Query Execution
Big Data Technology & Architecture
Big Data Technology & Architecture
May 30, 2022 · Big Data

Doris Architecture, Principles, and Key Features Overview

This article provides a comprehensive overview of Doris's architecture—including its FE and BE components, metadata management, data organization, execution planning—and details its major features such as adaptive join aggregation, vectorized execution, materialized views, and Elasticsearch integration, supplemented with example DDL and query code.

Big DataDatabase ArchitectureDoris
0 likes · 7 min read
Doris Architecture, Principles, and Key Features Overview
Architect's Tech Stack
Architect's Tech Stack
May 28, 2022 · Big Data

Data Lake Challenges and the Open SPL Computing Engine

The article examines the inherent trade‑offs of data lakes—maintaining raw data, enabling efficient computation, and keeping costs low—explains why traditional data‑warehouse approaches fall short, and introduces the open‑source SPL engine that provides multi‑source, file‑based, high‑performance analytics to overcome these limitations.

Big DataData LakeETL
0 likes · 12 min read
Data Lake Challenges and the Open SPL Computing Engine
Big Data Technology & Architecture
Big Data Technology & Architecture
May 24, 2022 · Databases

Apache Doris Basics: Creating Databases, Tables, Partitioning, Data Import, and Rollup

This article provides a comprehensive guide to Apache Doris, covering how to create databases and tables with single and composite partitions, import data via broker and routine loads, understand its aggregate, uniq, and duplicate data models, and leverage rollup and prefix index features for optimized querying.

Apache DorisPartitioningSQL
0 likes · 20 min read
Apache Doris Basics: Creating Databases, Tables, Partitioning, Data Import, and Rollup
Cognitive Technology Team
Cognitive Technology Team
May 23, 2022 · Backend Development

Custom MyBatis Interceptor Mechanism – Java Dynamic Proxy

This article explains how to create a custom MyBatis Interceptor using Java dynamic proxies, detailing the Interceptor interface, the plugin generation process, the wrap and invoke methods, and common use‑cases such as pagination, SQL analysis, encryption, and performance monitoring.

Dynamic ProxyJavaMyBatis
0 likes · 4 min read
Custom MyBatis Interceptor Mechanism – Java Dynamic Proxy
IT Architects Alliance
IT Architects Alliance
May 19, 2022 · Big Data

How Apache Kylin Enables Sub‑Second OLAP on Massive Data Sets

Apache Kylin leverages pre‑computed OLAP cubes on Hadoop/Spark/Flink to deliver sub‑second query responses for massive datasets, detailing its architecture, integration with BI platforms, user security, cube building, monitoring, and storage using HBase, illustrating how it overcomes big‑data analytical challenges.

Apache KylinBig DataData Warehouse
0 likes · 12 min read
How Apache Kylin Enables Sub‑Second OLAP on Massive Data Sets
Big Data Technology & Architecture
Big Data Technology & Architecture
May 18, 2022 · Databases

Understanding ClickHouse Distributed JOIN Implementation and Best Practices

This article explains ClickHouse's single‑node and distributed JOIN mechanisms, compares ordinary, GLOBAL, Broadcast, Shuffle and Colocate JOINs, illustrates execution flows with code examples, and provides practical recommendations to reduce join size, avoid query amplification, and leverage data pre‑distribution for optimal performance.

Big DataClickHousePerformance
0 likes · 10 min read
Understanding ClickHouse Distributed JOIN Implementation and Best Practices
IT Architects Alliance
IT Architects Alliance
May 17, 2022 · Databases

Inside MySQL: How Queries Are Processed from Client to Execution

This article explains the complete MySQL query processing pipeline, covering the connector, authentication, privilege checks, caching, parser, optimizer, executor, and the detailed SQL execution order with examples of each stage, helping readers understand and optimize their SQL statements.

MySQLPerformanceQuery Execution
0 likes · 13 min read
Inside MySQL: How Queries Are Processed from Client to Execution
IT Xianyu
IT Xianyu
May 17, 2022 · Databases

SQL Optimization Steps and Common Scenarios

This article explains how to identify slow SQL statements, analyze execution plans with EXPLAIN, use profiling and tracing tools, and apply specific optimization techniques such as index tuning, query rewriting, and alternative storage solutions across a range of real‑world cases.

EXPLAINIndexingOptimization
0 likes · 11 min read
SQL Optimization Steps and Common Scenarios
Top Architect
Top Architect
May 15, 2022 · Backend Development

Understanding MyBatis Batch Processing: Common Pitfalls and Optimized Solutions

This article walks through the challenges of inserting massive data sets with MyBatis, explains the inner workings of batch execution, highlights common mistakes with commit, clearCache and flushStatements, and presents progressively refined code examples—including Oracle-specific optimizations—to dramatically improve performance.

JavaMyBatisSQL
0 likes · 12 min read
Understanding MyBatis Batch Processing: Common Pitfalls and Optimized Solutions
dbaplus Community
dbaplus Community
May 12, 2022 · Big Data

How Bilibili Scaled Presto on Hadoop: Architecture, Optimizations, and Performance Gains

This article details Bilibili's end‑to‑end Presto on Hadoop architecture, covering the multi‑engine SQL stack, dispatcher routing, cluster scale, stability enhancements like coordinator HA and real‑time punish, query limits, Hive UDF compatibility, insert‑overwrite support, Alluxio caching, multi‑datacenter routing, query result caching, Raptorx local cache, JDK upgrades, dynamic filtering, and future roadmap, illustrating how these innovations boosted query throughput and reduced latency.

Big DataHadoopSQL
0 likes · 32 min read
How Bilibili Scaled Presto on Hadoop: Architecture, Optimizations, and Performance Gains
Java High-Performance Architecture
Java High-Performance Architecture
May 12, 2022 · Backend Development

Master MyBatis Batch Processing: Common Pitfalls and Optimized Solutions

This article walks readers through MyBatis batch processing from basics to advanced, highlighting common mistakes, explaining the roles of commit, clearCache, and flushStatements, and presenting three progressively refined code versions plus Oracle-specific optimizations to dramatically improve bulk insert performance.

Backend DevelopmentJavaMyBatis
0 likes · 12 min read
Master MyBatis Batch Processing: Common Pitfalls and Optimized Solutions
dbaplus Community
dbaplus Community
May 11, 2022 · Big Data

How JD Logistics Tackled Billion-Scale Data Challenges with Doris

This article details JD Logistics' journey from fragmented, massive‑scale data to a unified, real‑time analytics platform, covering business needs, pain points, tool evaluation, a new Doris‑based architecture, table management, data import procedures, automation scripts, and future roadmap for data engineering.

BI ToolsBig DataData Warehouse
0 likes · 16 min read
How JD Logistics Tackled Billion-Scale Data Challenges with Doris
Zuoyebang Tech Team
Zuoyebang Tech Team
May 9, 2022 · Big Data

How Flink SQL Powered Real‑Time Learning Analytics at Zuoyebang

Zuoyebang’s big‑data team shares how they evolved from SparkStreaming to a Flink‑SQL‑centric real‑time platform, detailing three development stages, challenges in DAG optimization, Redis‑based table design, and platform features for unified deployment, ease of use, and operational governance.

FlinkPlatformReal-time
0 likes · 14 min read
How Flink SQL Powered Real‑Time Learning Analytics at Zuoyebang
Baidu Geek Talk
Baidu Geek Talk
May 9, 2022 · Big Data

How a Spark Offline Framework Boosts Data Backtracking Efficiency

This article introduces a Spark offline development framework that separates configuration from code, supports SQL and Java applications, and provides fast, automated data backtracking with reduced environment preparation time, lower failure rates, and significant performance gains for large‑scale data warehouses.

Big DataData BacktrackingJava
0 likes · 17 min read
How a Spark Offline Framework Boosts Data Backtracking Efficiency
ITPUB
ITPUB
May 5, 2022 · Databases

When Does MySQL Use Temporary Tables and How Does It Choose the Storage Engine?

MySQL creates two kinds of temporary tables—external and internal—based on CREATE TEMPORARY TABLE statements or internal query processing, and uses the MEMORY engine by default unless large objects or the big_tables variable force MyISAM or InnoDB, with detailed guidance on scenarios, storage engine selection, conversion thresholds, indexing, and performance tuning.

MySQLQuery OptimizationSQL
0 likes · 19 min read
When Does MySQL Use Temporary Tables and How Does It Choose the Storage Engine?
Architecture Digest
Architecture Digest
May 3, 2022 · Databases

Performance Comparison of Elasticsearch and ClickHouse for Log Search

This article compares Elasticsearch and ClickHouse in architecture, query capabilities, and performance for log search workloads, presenting Docker‑compose setups, data ingestion pipelines, sample queries, and benchmark results that show ClickHouse generally outperforms Elasticsearch, especially in aggregation scenarios.

SQLVectorlog search
0 likes · 11 min read
Performance Comparison of Elasticsearch and ClickHouse for Log Search
Senior Brother's Insights
Senior Brother's Insights
May 1, 2022 · Databases

How to Quickly Diagnose and Resolve MySQL Table Locks in Production

Facing a sudden MySQL table lock? This guide walks through real‑world troubleshooting steps—from checking table usage and process lists to inspecting InnoDB transaction and lock tables, identifying lock‑wait relationships, and safely killing offending sessions, while also explaining lock types and common metadata‑lock scenarios.

InnoDBMySQLSQL
0 likes · 10 min read
How to Quickly Diagnose and Resolve MySQL Table Locks in Production