BestHub
Sign in
Tagged articles
2769 articles
Page 17 of 28
Wukong Talks Architecture
Wukong Talks Architecture
Aug 4, 2021 · Databases

Understanding MySQL InnoDB Locks: Shared, Exclusive, Intention, Gap, Next‑Key, Auto‑Inc, and Predicate Locks

The article presents a detailed interview‑style walkthrough of MySQL InnoDB locking mechanisms, covering table‑ versus row‑level locks, shared and exclusive locks, intention locks, gap and next‑key locks, auto‑increment locks, predicate locks, and related SQL statements, illustrated with tables and code examples.

InnoDBLocksconcurrency
0 likes · 13 min read
Understanding MySQL InnoDB Locks: Shared, Exclusive, Intention, Gap, Next‑Key, Auto‑Inc, and Predicate Locks
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 3, 2021 · Big Data

How Hera Transforms Vipshop’s Data Service for Scalable E‑Commerce Analytics

This article explains how Vipshop built the Hera data service since 2019 to provide a unified API for warehouse access, detailing its background, architecture, core features such as multi‑engine queries, adaptive execution, custom Lisp syntax, task scheduling, metrics collection, and performance gains for both B‑to‑B and B‑to‑C workloads.

Data ServiceDistributed SystemsLisp
0 likes · 21 min read
How Hera Transforms Vipshop’s Data Service for Scalable E‑Commerce Analytics
Qunar Tech Salon
Qunar Tech Salon
Aug 3, 2021 · Databases

Deep Dive into MySQL 8.0 Server Architecture, Parser, and Optimizer

This article analyzes MySQL 8.0.25 source code, detailing the server architecture, parser reconstruction, prepare/rewrite stages, the optimizer transformations, and the new hypergraph optimizer, while also comparing these mechanisms with PostgreSQL’s processing pipeline.

Database InternalsHypergraphParser
0 likes · 12 min read
Deep Dive into MySQL 8.0 Server Architecture, Parser, and Optimizer
Python Programming Learning Circle
Python Programming Learning Circle
Aug 2, 2021 · Databases

Comprehensive Guide to Relational Database Concepts and SQL Syntax

This article provides a detailed tutorial on relational database fundamentals, covering key terminology, SQL syntax, DDL/DML/DCL/TCL commands, query clauses, joins, set operations, functions, aggregation, indexing, constraints, transactions, permission management, stored procedures, cursors, and triggers with practical code examples.

DDLDMLStored Procedures
0 likes · 20 min read
Comprehensive Guide to Relational Database Concepts and SQL Syntax
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 2, 2021 · Big Data

Comprehensive Big Data Interview Question Guide for Major Tech Companies

This article compiles extensive interview questions and topics covering Hadoop, Spark, Flink, Hive, Kafka, MySQL, Redis, Java fundamentals, and algorithms, organized by companies such as Xiaomi, ByteDance, Alibaba, Shopee, Tencent, Meituan, NetEase, and Baidu, to help candidates prepare effectively for big‑data engineering roles.

Big DataFlinkHadoop
0 likes · 22 min read
Comprehensive Big Data Interview Question Guide for Major Tech Companies
Java Architect Essentials
Java Architect Essentials
Jul 30, 2021 · Databases

How to Insert Non‑Duplicate Data in MySQL Using INSERT IGNORE, ON DUPLICATE KEY UPDATE, and REPLACE INTO

This article explains several MySQL techniques—INSERT IGNORE, ON DUPLICATE KEY UPDATE, and REPLACE INTO—to efficiently insert large volumes of data while preventing duplicate primary‑key or unique‑key rows, and provides practical code examples for single and batch operations.

INSERT IGNOREON DUPLICATE KEY UPDATEREPLACE INTO
0 likes · 6 min read
How to Insert Non‑Duplicate Data in MySQL Using INSERT IGNORE, ON DUPLICATE KEY UPDATE, and REPLACE INTO
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2021 · Databases

Migrating from MariaDB 10.3 to MySQL 5.7.25: Common Issues and Solutions

This article details the practical challenges encountered when migrating a MariaDB 10.3 database to MySQL 5.7.25, explains why certain defaults and engine-specific options cause import errors, and provides step‑by‑step fixes such as adjusting default expressions, removing Aria‑specific parameters, and configuring sql_mode.

CompatibilityMariaDBdatabase migration
0 likes · 5 min read
Migrating from MariaDB 10.3 to MySQL 5.7.25: Common Issues and Solutions
Laravel Tech Community
Laravel Tech Community
Jul 29, 2021 · Databases

Common MySQL Commands and Operations Guide

This article provides a comprehensive collection of MySQL command-line instructions for exporting databases or tables, importing data, managing databases and tables, performing DDL and DML operations, handling field types, and configuring user privileges, all illustrated with practical code examples.

DDLDMLDatabase Commands
0 likes · 10 min read
Common MySQL Commands and Operations Guide
MaGe Linux Operations
MaGe Linux Operations
Jul 29, 2021 · Databases

How to Efficiently Remove Duplicate Rows in Large MySQL Tables

This article explains why a naïve Python script for deduplicating millions of rows is too slow, then walks through a series of MySQL queries—including how to identify duplicate names, avoid the 1093 error, and delete duplicates while keeping a single representative row—demonstrating fast, reliable cleanup of large tables.

Database Optimizationdata cleaningdelete duplicates
0 likes · 5 min read
How to Efficiently Remove Duplicate Rows in Large MySQL Tables
Fulu Network R&D Team
Fulu Network R&D Team
Jul 27, 2021 · Databases

Understanding Flyway: Database Migration Tool Overview and Spring Integration

Flyway is an open‑source database migration tool that version‑controls SQL scripts, supports many databases, and integrates with Maven and Spring to automate schema changes across environments, offering commands such as migrate, clean, info, validate, baseline, undo and repair, with detailed configuration examples.

Flywaydatabase migrationmaven
0 likes · 9 min read
Understanding Flyway: Database Migration Tool Overview and Spring Integration
Python Programming Learning Circle
Python Programming Learning Circle
Jul 26, 2021 · Fundamentals

Step-by-Step Guide to Data Analysis with Python: Import, Clean, Visualize, and Merge Using Pandas

This tutorial walks data analysts through setting up a Python environment with Jupyter and Anaconda, importing diverse datasets via Pandas, cleaning and reshaping data, performing calculations, filtering, visualizing results, and finally merging and grouping data to produce insightful analyses comparable to SQL and Excel workflows.

Data visualizationExcelJupyter Notebook
0 likes · 12 min read
Step-by-Step Guide to Data Analysis with Python: Import, Clean, Visualize, and Merge Using Pandas
Architect's Tech Stack
Architect's Tech Stack
Jul 26, 2021 · Databases

Efficient Methods to Remove Duplicate Rows in MySQL Tables

This article explains how to identify and delete duplicate records in large MySQL tables, discusses why a naïve delete fails, and provides two robust SQL solutions—one that removes all duplicates and another that retains a single row per duplicated key—demonstrating fast execution even on tables with hundreds of thousands of rows.

data cleaningduplicate removalmysql
0 likes · 5 min read
Efficient Methods to Remove Duplicate Rows in MySQL Tables
Open Source Linux
Open Source Linux
Jul 22, 2021 · Databases

Master SQL: Essential Syntax, Queries, and Advanced Techniques

This comprehensive guide covers SQL fundamentals—including database terminology, syntax structure, DDL/DML/TCL/DCL commands, CRUD operations, subqueries, joins, unions, functions, ordering, grouping, indexes, constraints, transactions, permissions, stored procedures, cursors, and triggers—providing clear examples and best practices for relational database development.

CRUDStored ProceduresTransactions
0 likes · 26 min read
Master SQL: Essential Syntax, Queries, and Advanced Techniques
Architect
Architect
Jul 21, 2021 · Databases

MySQL 100 Interview Questions: Indexes, Transactions, Table Design, and Storage Engines

This article compiles 100 common MySQL interview questions for developers, covering index structures and optimization, transaction ACID properties and isolation levels, primary‑key design, storage‑engine choices, sharding strategies, and miscellaneous SQL nuances such as binlog formats and MyBatis parameter handling.

Storage Enginesindexesmysql
0 likes · 20 min read
MySQL 100 Interview Questions: Indexes, Transactions, Table Design, and Storage Engines
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 21, 2021 · Databases

MySQL Index Design Specification and Best Practices

This article summarizes comprehensive MySQL index design guidelines, covering naming conventions, column selection criteria, index count control, handling of frequently updated columns, function and duplicate indexes, small‑table considerations, and index ordering to optimize query performance.

Database designindexingmysql
0 likes · 8 min read
MySQL Index Design Specification and Best Practices
Python Programming Learning Circle
Python Programming Learning Circle
Jul 20, 2021 · Databases

Removing Duplicate Data in MySQL and Keeping Only One Record

This article describes how to identify and delete duplicate rows in MySQL tables—first showing a naive Python‑based approach, then presenting efficient SQL queries that locate duplicate names, explain MySQL's limitation on deleting from the same table being queried, and provide a safe sub‑query solution to remove all duplicates while preserving a single representative row.

duplicate removalmysqlsql
0 likes · 6 min read
Removing Duplicate Data in MySQL and Keeping Only One Record
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 19, 2021 · Databases

Understanding MySQL 5.7 SQL Mode: Default Values, Usage, and Practical Examples

This article explains MySQL's SQL Mode concept, lists the default mode values for MySQL 5.7, demonstrates how to view and change the mode with SQL commands, describes the impact of common modes such as STRICT_TRANS_TABLES and ONLY_FULL_GROUP_BY, and provides a complete reference table of all supported mode values and predefined mode combinations.

SQL Modedata validationmysql
0 likes · 10 min read
Understanding MySQL 5.7 SQL Mode: Default Values, Usage, and Practical Examples
Python Programming Learning Circle
Python Programming Learning Circle
Jul 19, 2021 · Databases

52 SQL Statement Performance Optimization Strategies

This article provides a comprehensive collection of 52 practical tips for improving SQL query performance, covering index creation, query rewriting, data type selection, storage engine choices, and execution plan analysis to help developers write faster, more efficient database statements.

Query Tuningindexesperformance optimization
0 likes · 16 min read
52 SQL Statement Performance Optimization Strategies
Python Crawling & Data Mining
Python Crawling & Data Mining
Jul 18, 2021 · Databases

How Indexing Can Slash Oracle Query Time from Minutes to Seconds

This article examines a real‑world Oracle SQL query, identifies costly full‑table scans and low‑selectivity columns, and demonstrates how creating an index on a key column reduces execution time from 24 minutes to just one second, highlighting essential SQL performance‑tuning techniques.

AWRDatabase OptimizationOracle
0 likes · 7 min read
How Indexing Can Slash Oracle Query Time from Minutes to Seconds
Top Architect
Top Architect
Jul 17, 2021 · Databases

Understanding MySQL Query Optimization and Index Design

This article explains MySQL’s logical architecture, query processing steps, and the principles behind query optimization, covering topics such as client‑server protocol, query cache, parsing, cost‑based optimizer, execution engine, and practical index design strategies to improve performance.

Database Performanceindexesmysql
0 likes · 35 min read
Understanding MySQL Query Optimization and Index Design
Java Captain
Java Captain
Jul 17, 2021 · Databases

Optimizing Existence Checks: Use SELECT 1 LIMIT 1 Instead of SELECT count(*)

Developers often use SELECT count(*) to check record existence, but replacing it with SELECT 1 … LIMIT 1 improves performance by stopping after the first match, allowing simpler Java null checks and potentially reducing index usage, especially when only a binary presence test is needed.

Database OptimizationExistence Checkjava
0 likes · 3 min read
Optimizing Existence Checks: Use SELECT 1 LIMIT 1 Instead of SELECT count(*)
Java High-Performance Architecture
Java High-Performance Architecture
Jul 13, 2021 · Databases

Elasticsearch vs ClickHouse: Which Delivers Faster Log Search?

This article compares Elasticsearch and ClickHouse for log analytics, detailing their architectures, node roles, query capabilities, and performance through Docker‑Compose stacks and synthetic syslog data, concluding that ClickHouse generally outperforms Elasticsearch in speed and aggregation efficiency.

Columnar DatabaseElasticsearchLog Analytics
0 likes · 11 min read
Elasticsearch vs ClickHouse: Which Delivers Faster Log Search?
Top Architect
Top Architect
Jul 10, 2021 · Backend Development

Optimizing Complex Search Queries with Redis: A Backend Development Demo

This article explores how backend developers can handle intricate e‑commerce search filters by first attempting a monolithic SQL solution, then improving performance with index analysis and query splitting, and finally achieving fast, scalable results using Redis sets, sorted sets, and transaction commands.

backend-developmentcachingperformance
0 likes · 8 min read
Optimizing Complex Search Queries with Redis: A Backend Development Demo
Python Programming Learning Circle
Python Programming Learning Circle
Jul 9, 2021 · Databases

Key Features of ClickHouse: DBMS Capabilities, Columnar Storage, Vectorized Execution, and Distributed Architecture

ClickHouse is an MPP column‑oriented DBMS that combines full DBMS functionality, advanced columnar storage with high compression, SIMD‑based vectorized execution, a rich relational SQL interface, diverse table engines, multi‑master clustering, and flexible sharding and distributed query capabilities, making it exceptionally fast for analytical workloads.

Columnar StorageDBMSDistributed Systems
0 likes · 21 min read
Key Features of ClickHouse: DBMS Capabilities, Columnar Storage, Vectorized Execution, and Distributed Architecture
dbaplus Community
dbaplus Community
Jul 8, 2021 · Databases

Why ClickHouse Outperforms Elasticsearch for Log Storage and Analytics

This article compares ClickHouse and Elasticsearch for API log storage, detailing development activity, schema handling, query performance, statistical functions, MySQL integration, new features, and practical drawbacks, while providing concrete SQL examples and migration tips.

AnalyticsElasticsearchJSON
0 likes · 14 min read
Why ClickHouse Outperforms Elasticsearch for Log Storage and Analytics
macrozheng
macrozheng
Jul 7, 2021 · Operations

Query Linux Logs with SQL Using the ‘q’ Command-Line Tool

The article introduces the command‑line utility q, explains how to install it on Linux and Windows, and demonstrates using familiar SQLite‑style SQL queries to search, filter, join, and aggregate log files and command output, offering a convenient alternative to traditional shell tools.

Linuxcommand-linelog analysis
0 likes · 10 min read
Query Linux Logs with SQL Using the ‘q’ Command-Line Tool
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 5, 2021 · Databases

Fetching the Latest Record per Name Group in MySQL 5.6/5.7

The article explains why a simple GROUP BY query in MySQL 5.6 returns the earliest rows instead of the most recent ones, demonstrates how to correctly obtain the latest record per name using sub‑queries or window functions, and discusses the impact of the ONLY_FULL_GROUP_BY mode in MySQL 5.7.

GROUP BYdatabasemysql
0 likes · 5 min read
Fetching the Latest Record per Name Group in MySQL 5.6/5.7
DeWu Technology
DeWu Technology
Jul 2, 2021 · Databases

MySQL Deep Pagination Optimization

MySQL deep pagination can be dramatically accelerated by ordering on the primary key, indexing the sort column, and using keyset pagination or a sub‑query join instead of scanning millions of rows, while only minor tweaks like increasing sort_buffer_size provide negligible gains.

deep paginationindexingmysql
0 likes · 10 min read
MySQL Deep Pagination Optimization
Top Architect
Top Architect
Jun 30, 2021 · Databases

Analyzing and Optimizing MySQL Pagination Performance with Large Offsets

This article investigates why MySQL queries with large LIMIT offsets become extremely slow, demonstrates the issue with simulated millions‑of‑row datasets, and presents three optimization strategies—including index‑covering subqueries, remembering the last primary‑key position, and applying offset throttling—to achieve consistent, fast pagination performance.

indexinglarge datasetsmysql
0 likes · 12 min read
Analyzing and Optimizing MySQL Pagination Performance with Large Offsets
Java Interview Crash Guide
Java Interview Crash Guide
Jun 30, 2021 · Databases

How to Quickly Remove Duplicate Rows in MySQL Without Locking

This article walks through a practical MySQL tutorial that identifies duplicate records, explains why naïve row‑by‑row deletion is slow, and provides efficient DELETE statements—including derived‑table tricks—to clean up large tables while preserving one record per duplicate group.

DELETEdatabase cleanupduplicate removal
0 likes · 6 min read
How to Quickly Remove Duplicate Rows in MySQL Without Locking
DataFunTalk
DataFunTalk
Jun 29, 2021 · Big Data

In-depth Analysis of Flink SQL 1.13 Features and Improvements

This article provides a comprehensive overview of Apache Flink SQL 1.13, detailing new Window TVF support, cumulate windows, performance optimizations, time‑zone handling, enhanced Hive compatibility, SQL client upgrades, DataStream‑Table conversion improvements, and outlines the roadmap for the upcoming 1.14 release.

DataStreamFlinkHive Integration
0 likes · 15 min read
In-depth Analysis of Flink SQL 1.13 Features and Improvements
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 28, 2021 · Databases

How to Check and Optimize MySQL Table Space Fragmentation

This article explains how to detect table‑space fragmentation in MySQL, demonstrates the performance impact of deleted rows, and provides step‑by‑step commands—including ALTER TABLE FORCE, OPTIMIZE TABLE, and mysqlcheck—to reclaim space and improve query speed.

Database Maintenancefragmentationmysql
0 likes · 8 min read
How to Check and Optimize MySQL Table Space Fragmentation
Python Crawling & Data Mining
Python Crawling & Data Mining
Jun 27, 2021 · Artificial Intelligence

How SQLFlow Turns Simple SQL Queries into Powerful AI Models

SQLFlow is an open‑source platform that lets users build and run machine‑learning and deep‑learning models directly from SQL statements, lowering the barrier for business analysts to apply AI by abstracting complex pipelines into familiar database queries.

Artificial IntelligenceDeep LearningSQLFlow
0 likes · 8 min read
How SQLFlow Turns Simple SQL Queries into Powerful AI Models
YunZhu Net Technology Team
YunZhu Net Technology Team
Jun 24, 2021 · Databases

Introduction to ClickHouse and Step‑by‑Step Cluster Deployment Guide

This article provides a comprehensive overview of ClickHouse, covering its columnar OLAP architecture, key features such as data compression, vectorized processing, distributed query handling, and SQL support, followed by detailed step‑by‑step instructions for deploying a multi‑node ClickHouse cluster with MergeTree and ReplicatedMergeTree engines, configuration files, and Java MyBatis integration.

Cluster DeploymentColumnar DatabaseMergeTree
0 likes · 10 min read
Introduction to ClickHouse and Step‑by‑Step Cluster Deployment Guide
Liangxu Linux
Liangxu Linux
Jun 23, 2021 · Operations

Query Linux Logs with SQL Using the ‘q’ Tool – A Practical Guide

This article introduces the command‑line utility q, explains how to install it on Linux and Windows, and demonstrates using full SQLite‑compatible SQL syntax to query, filter, join, and aggregate plain‑text log files, offering a database‑style alternative to traditional shell tools.

Linuxcommand-linelog analysis
0 likes · 10 min read
Query Linux Logs with SQL Using the ‘q’ Tool – A Practical Guide
ITPUB
ITPUB
Jun 22, 2021 · Databases

Master DataGrip: Essential Tips for Efficient Database Management

This guide walks you through installing DataGrip, configuring drivers, connecting to various databases, using its powerful SQL editor with shortcuts, customizing appearance, performing data export/import, and leveraging advanced navigation and editing features to boost productivity.

Data ExportDataGripDatabase Management
0 likes · 12 min read
Master DataGrip: Essential Tips for Efficient Database Management
Python Programming Learning Circle
Python Programming Learning Circle
Jun 22, 2021 · Databases

Decorrelation of Correlated Subqueries: Theory, Operators, and Optimization Rules

This article explains why correlated subqueries are a performance bottleneck, introduces the Apply (Correlated Join) operator, classifies subquery types, shows how to transform them into efficient joins, and discusses rule‑based push‑down techniques for Project, Filter, Aggregate, and Set operations.

Apply OperatorDecorrelationSubquery
0 likes · 15 min read
Decorrelation of Correlated Subqueries: Theory, Operators, and Optimization Rules
Programmer DD
Programmer DD
Jun 22, 2021 · Databases

Mastering Backslash Escapes in MySQL: Insert & SELECT Gotchas

This article explains how MySQL treats backslashes in INSERT and SELECT statements, demonstrates the resulting storage differences with practical examples, and clarifies the double‑escaping rules that developers must handle to avoid unexpected query results.

Insertbackslashescaping
0 likes · 6 min read
Mastering Backslash Escapes in MySQL: Insert & SELECT Gotchas
Python Programming Learning Circle
Python Programming Learning Circle
Jun 21, 2021 · Databases

Comprehensive Guide to Using DataGrip for Database Management

This article provides a detailed, step‑by‑step tutorial on installing, configuring, and using JetBrains DataGrip—including connection setup, SQL editing, result navigation, data import/export, and advanced editor shortcuts—demonstrating why the tool is considered a powerful and user‑friendly database client.

DataGripDatabase ManagementDatabase client
0 likes · 12 min read
Comprehensive Guide to Using DataGrip for Database Management
Java Backend Technology
Java Backend Technology
Jun 20, 2021 · Databases

Avoid These 10 Fatal SQL Mistakes Every Java Developer Makes

Java developers often mishandle SQL, leading to performance, correctness, and maintenance issues; this article outlines ten common pitfalls—from misunderstanding NULL and misusing UNION to neglecting MERGE and batch inserts—and provides practical solutions to write efficient, reliable database queries.

JDBCbest practicesdatabase
0 likes · 11 min read
Avoid These 10 Fatal SQL Mistakes Every Java Developer Makes
Top Architect
Top Architect
Jun 19, 2021 · Databases

SQL Query Performance Optimization Tips

This article provides a comprehensive collection of practical MySQL and SQL performance optimization techniques, covering index usage, query rewriting, avoiding full table scans, proper data types, efficient joins, backup strategies, and other best practices to improve database speed and reliability.

databaseindexesmysql
0 likes · 18 min read
SQL Query Performance Optimization Tips
Laravel Tech Community
Laravel Tech Community
Jun 18, 2021 · Databases

Understanding NULL Values in Databases

This article explains the special nature of NULL in SQL, how to correctly test for NULL using IS NULL, the three‑valued logic of true/false/unknown, and the pitfalls of NOT, NOT IN, and Oracle’s handling of empty strings versus NULL.

IS NULLNULLThree-valued logic
0 likes · 6 min read
Understanding NULL Values in Databases
ITPUB
ITPUB
Jun 18, 2021 · Databases

How to Build a Fast Search API with Redis: From Complex SQL to Set‑Based Caching

This article walks through the challenges of implementing a multi‑criteria product search for a shopping site, compares a naïve SQL solution with optimized query splitting, and then shows how Redis sets, sorted sets, and transactions can dramatically improve performance while adding pagination and update handling.

redissearchsql
0 likes · 9 min read
How to Build a Fast Search API with Redis: From Complex SQL to Set‑Based Caching
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 17, 2021 · Big Data

Comprehensive Guide to Presto: Origins, Architecture, Optimization, and Real‑World Applications

This article provides an in‑depth overview of Presto, covering its history, core principles, architectural components, query optimization techniques, resource management, tuning tips, data model, and case studies from companies like Didi and Youzan, offering practical guidance for deploying and operating the distributed SQL engine at scale.

PrestoQuery EngineResource Management
0 likes · 33 min read
Comprehensive Guide to Presto: Origins, Architecture, Optimization, and Real‑World Applications
Efficient Ops
Efficient Ops
Jun 14, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Turn All Values to Zero

This article examines how misplaced quotation marks in MySQL UPDATE statements can unintentionally set fields to zero, explains MySQL’s implicit type conversion that causes the condition to always evaluate true, and offers practical steps for detecting and preventing such bugs.

Data RecoveryImplicit ConversionUpdate Statement
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Turn All Values to Zero
Architecture Digest
Architecture Digest
Jun 12, 2021 · Databases

Why Reusing Stored Procedures Can Be Problematic: A Practical Example with Job, Certification, and Disclosure Checks

This article examines the pitfalls of reusing existing SQL stored procedures to determine the presence of Job, Certification, and Disclosure data for a user, illustrating maintenance challenges with temporary tables, output parameters, and code‑reuse limitations through concrete code examples.

BackendStored Procedurescode-reuse
0 likes · 5 min read
Why Reusing Stored Procedures Can Be Problematic: A Practical Example with Job, Certification, and Disclosure Checks
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 11, 2021 · Databases

MySQL 8.0.23 Invisible Columns Feature Overview

Starting with MySQL 8.0.23, columns can be marked INVISIBLE, causing them to be omitted from SELECT * queries unless explicitly referenced; this article explains the feature, demonstrates creation, inspection, DML considerations, schema modifications, backup behavior, and its impact on database design.

Database designInvisible Columnsmysql
0 likes · 8 min read
MySQL 8.0.23 Invisible Columns Feature Overview
IT Xianyu
IT Xianyu
Jun 11, 2021 · Databases

10 Common Mistakes Java Developers Make When Writing SQL

The article outlines ten frequent errors that Java programmers encounter when writing SQL—ranging from misunderstanding NULL handling to misusing UNION, pagination, and batch inserts—and provides practical solutions to improve correctness, performance, and maintainability of database interactions.

JDBCbest practicesdatabase
0 likes · 9 min read
10 Common Mistakes Java Developers Make When Writing SQL
Programmer DD
Programmer DD
Jun 11, 2021 · Backend Development

10 Common SQL Mistakes Java Developers Make and How to Fix Them

This article outlines ten frequent errors Java programmers encounter when writing SQL, explains why each mistake occurs, and provides practical solutions to improve correctness, performance, and maintainability of database interactions in Java applications.

JDBCjavasql
0 likes · 10 min read
10 Common SQL Mistakes Java Developers Make and How to Fix Them
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 10, 2021 · Databases

Why Hand‑Written SQL Parsers Outperform Auto‑Generated Ones: Design & Performance Insights

This article examines the trade‑offs between automatically generated and manually crafted SQL parsers, detailing lexical‑syntax analysis techniques, performance challenges in OLAP workloads, and the authors’ custom parser design that achieves up to 30‑50× speed gains in complex queries and bulk inserts.

Parserdatabaselexical analysis
0 likes · 17 min read
Why Hand‑Written SQL Parsers Outperform Auto‑Generated Ones: Design & Performance Insights
Open Source Linux
Open Source Linux
Jun 10, 2021 · Databases

MySQL vs MariaDB: Real-World Performance Benchmark and Analysis

This article reviews the history of MySQL and MariaDB, describes a test environment, runs insertion, batch, and query benchmarks (with and without indexes), and concludes that MariaDB generally outperforms MySQL in speed and memory usage while highlighting trade‑offs of indexing.

Database PerformanceInnoDBMariaDB
0 likes · 9 min read
MySQL vs MariaDB: Real-World Performance Benchmark and Analysis
IT Xianyu
IT Xianyu
Jun 10, 2021 · Backend Development

Comprehensive Guide to MyBatis-Plus: CRUD, Annotations, Condition Builders, Pagination, and Advanced Features

This article provides a detailed tutorial on using MyBatis-Plus in Java, covering setup, entity and mapper definitions, CRUD operations, annotations, condition builders, pagination, AR mode, logical deletion, automatic field filling, optimistic locking, performance analysis, multi‑tenant support, dynamic table names, configuration options, and code generation.

CRUDORMannotations
0 likes · 45 min read
Comprehensive Guide to MyBatis-Plus: CRUD, Annotations, Condition Builders, Pagination, and Advanced Features
Laravel Tech Community
Laravel Tech Community
Jun 9, 2021 · Databases

Comprehensive Guide to SQL Syntax, Commands, and Advanced Features

This article provides a thorough overview of relational database fundamentals, SQL syntax structures, data definition and manipulation languages, transaction control, permission management, as well as detailed examples of CRUD operations, subqueries, joins, unions, functions, constraints, stored procedures, cursors, and triggers, all illustrated with practical code snippets.

DDLDMLTransactions
0 likes · 23 min read
Comprehensive Guide to SQL Syntax, Commands, and Advanced Features
58 Tech
58 Tech
Jun 9, 2021 · Big Data

Designing and Implementing a Unified Data Metric System for 58 Commercial Data Team

This article explains how 58's commercial data team built a comprehensive data metric system—from identifying common metric definition issues to establishing a domain‑driven hierarchy, distinguishing atomic and derived metrics, implementing a unified metric management platform, and providing APIs and examples for querying and visualizing metrics.

Big DataData Governancejava
0 likes · 17 min read
Designing and Implementing a Unified Data Metric System for 58 Commercial Data Team
IT Architects Alliance
IT Architects Alliance
Jun 7, 2021 · Databases

Analyzing and Optimizing MySQL Pagination Performance with Large Offsets

The article examines a production MySQL query that suffers severe slowdown due to large LIMIT offsets, demonstrates how to reproduce the issue with massive test data, analyzes the root cause, and presents three optimization strategies—including index covering, keyset pagination, and offset limiting—to dramatically improve query performance.

indexingmysqloptimization
0 likes · 13 min read
Analyzing and Optimizing MySQL Pagination Performance with Large Offsets
Volcano Engine Developer Services
Volcano Engine Developer Services
Jun 7, 2021 · Databases

Why Distributed Database Architectures Matter: From Shared‑Nothing to Shared‑Storage

This article introduces the fundamentals of distributed database architectures, compares Shared‑Nothing and Shared‑Storage designs, explains their three‑tier structure, core engine components, SQL execution flow, performance and cost optimizations, and showcases a real‑world high‑traffic deployment in Douyin’s Spring Festival event.

Cost Optimizationdistributed databasesperformance
0 likes · 19 min read
Why Distributed Database Architectures Matter: From Shared‑Nothing to Shared‑Storage
Programmer DD
Programmer DD
Jun 7, 2021 · Databases

Why Misplaced Quotes Turn MySQL UPDATE Results into Zero

This article explains how incorrect placement of quotation marks in MySQL UPDATE statements can cause the SET values to be evaluated as boolean expressions, leading to implicit type conversion that updates fields to zero, and offers practical steps to prevent such errors.

Database ErrorsImplicit ConversionQuotation Marks
0 likes · 5 min read
Why Misplaced Quotes Turn MySQL UPDATE Results into Zero
Architect
Architect
Jun 6, 2021 · Databases

Optimizing MySQL Pagination for Large Datasets: Analysis and Solutions

An engineer describes a production MySQL pagination issue where large offset queries caused severe slowdown, analyzes the root cause, demonstrates data simulation scripts, and presents three optimization strategies—including index covering with subqueries, redefining start positions, and applying offset limits—to improve query performance on massive tables.

databasemysqlpagination
0 likes · 13 min read
Optimizing MySQL Pagination for Large Datasets: Analysis and Solutions
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 6, 2021 · Big Data

Understanding Data Warehouses: Concepts, Architecture, Modeling, and Governance

This article provides a comprehensive overview of data warehouses, explaining their purpose, differences from databases, OLTP vs OLAP, traditional versus internet data warehouse models, layered architecture, modeling theories, metric dictionaries, date dimensions, naming conventions, data governance, and incremental synchronization techniques with practical SQL examples.

Big DataData GovernanceETL
0 likes · 24 min read
Understanding Data Warehouses: Concepts, Architecture, Modeling, and Governance
Code Ape Tech Column
Code Ape Tech Column
Jun 4, 2021 · Databases

8 MySQL Performance Tricks to Slash Query Time from Seconds to Milliseconds

This article examines common MySQL performance pitfalls such as inefficient LIMIT offsets, implicit type conversions, suboptimal UPDATE/DELETE joins, mixed sorting, misuse of EXISTS, and limited condition pushdown, then demonstrates concrete rewrites—including range reduction and WITH clauses—that reduce execution times from seconds to milliseconds.

Query Tuningdatabasemysql
0 likes · 12 min read
8 MySQL Performance Tricks to Slash Query Time from Seconds to Milliseconds
Java Backend Technology
Java Backend Technology
Jun 3, 2021 · Databases

Why MySQL TIMESTAMP Is a Hidden Pitfall and How to Avoid It

This article explains MySQL's three time types, highlights the quirks and automatic defaults of TIMESTAMP—including the 2038 problem, high‑concurrency issues, and unexpected behavior in non‑strict mode—provides practical examples, and offers guidance on configuring server variables or switching to DATETIME for safer handling.

2038 problemTimezonedatabases
0 likes · 11 min read
Why MySQL TIMESTAMP Is a Hidden Pitfall and How to Avoid It
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 1, 2021 · Big Data

Understanding Idle State Retention Time in Flink SQL

Flink SQL's idle state retention time feature prevents state explosion by automatically cleaning up state for keys that remain inactive beyond a configurable time window, requiring both minimum and maximum retention settings, with implementation details involving CleanupState, timers, and KeyedProcessFunctionWithCleanupState.

FlinkIdle State RetentionState Management
0 likes · 8 min read
Understanding Idle State Retention Time in Flink SQL
Big Data Technology Architecture
Big Data Technology Architecture
May 31, 2021 · Big Data

Practical Experience of Using Flink + Iceberg 0.11 on Qunar Data Platform

This article presents Qunar's practical experience with Flink and Iceberg 0.11, covering background challenges such as Kafka data loss and Hive metadata pressure, explaining Iceberg architecture, query planning, and detailed solutions including real‑time ingestion, small‑file handling, sorting, and code examples for seamless migration.

FlinkIcebergReal-time Processing
0 likes · 12 min read
Practical Experience of Using Flink + Iceberg 0.11 on Qunar Data Platform
MaGe Linux Operations
MaGe Linux Operations
May 31, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data

A developer’s production fix using dozens of UPDATE statements unintentionally set a column to zero because of misplaced quotation marks, illustrating how MySQL’s implicit conversion and syntax quirks can turn seemingly correct SQL into disastrous data loss.

Data RecoveryImplicit ConversionUPDATE
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data
Aikesheng Open Source Community
Aikesheng Open Source Community
May 28, 2021 · Databases

Comprehensive MySQL Inspection Checklist and Command Reference

This guide presents a detailed MySQL inspection checklist covering operating‑system metrics, critical MySQL parameters, status queries, replication health, high‑availability components, and useful SQL scripts, enabling DBAs to efficiently monitor performance, detect issues, and maintain reliable database services.

Replicationhigh availabilityinspection
0 likes · 11 min read
Comprehensive MySQL Inspection Checklist and Command Reference
Selected Java Interview Questions
Selected Java Interview Questions
May 27, 2021 · Backend Development

Java Backend Interview Experience: Spring, Nacos, Redis, SQL Optimization and More

The article shares a developer's post‑interview reflections covering self‑introduction, Spring ecosystem usage, Nacos vs Eureka service discovery, SpringBoot startup mechanics, design patterns, Linux commands, Redis operations, Excel POI handling, SQL optimization techniques, and other practical interview questions.

NacosSpringBootinterview
0 likes · 9 min read
Java Backend Interview Experience: Spring, Nacos, Redis, SQL Optimization and More
Aikesheng Open Source Community
Aikesheng Open Source Community
May 26, 2021 · Databases

Practical Guide to Using MySQL Full-Text Indexes

This article explains MySQL full‑text indexing, compares its syntax with ordinary SQL, demonstrates how to create and query a full‑text index using natural language, boolean, and query‑expansion modes, and shows performance differences through execution‑plan analysis and relevance ranking.

Boolean ModeFull-Text IndexNatural Language Mode
0 likes · 9 min read
Practical Guide to Using MySQL Full-Text Indexes
Top Architect
Top Architect
May 25, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Cause Columns to Be Set to Zero

The article explains how incorrectly placed double‑quotation marks in MySQL UPDATE statements change the intended string assignment into a boolean comparison that evaluates to 0, leading to all affected rows being updated with zero values, and shows how to detect and avoid this pitfall.

Data RecoveryDatabase DebuggingQuote Error
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Cause Columns to Be Set to Zero
Aikesheng Open Source Community
Aikesheng Open Source Community
May 17, 2021 · Databases

Using MySQL Federated Storage Engine for Remote Table Access

This article explains how to enable and configure MySQL's Federated storage engine to access remote tables without data synchronization, covering engine architecture, supported features, environment setup, server configuration, table creation, data manipulation, and binlog verification, along with practical code examples.

Database ReplicationFederated EngineRemote Table Access
0 likes · 10 min read
Using MySQL Federated Storage Engine for Remote Table Access
Top Architect
Top Architect
May 16, 2021 · Databases

Understanding LEFT JOIN, Common Pitfalls, and Practical Solutions in SQL

This article explains how LEFT JOIN works in SQL, illustrates why duplicate rows can appear when joining tables, and provides practical techniques such as DISTINCT, GROUP BY, MAX, and IN subqueries to ensure a one‑to‑one result set while also covering RIGHT JOIN, INNER JOIN, update and delete operations, and the concept of Cartesian products.

JOINLEFT JOINdatabase
0 likes · 14 min read
Understanding LEFT JOIN, Common Pitfalls, and Practical Solutions in SQL