Tagged articles

SQL

2820 articles · Page 19 of 29

Apr 7, 2021 · Backend Development

Nine MyBatis SQL Tricks for SpringBoot Web Applications (MySQL Example)

This article presents nine practical MyBatis techniques—including pagination, preset column selection, one‑to‑many and one‑to‑one associations, foreach‑in queries, dynamic where clauses, choose/otherwise logic, hidden _parameter usage, and dynamic set updates—illustrated with SpringBoot and MySQL code examples.

Backend DevelopmentDynamic SQLMyBatis

0 likes · 6 min read

Nine MyBatis SQL Tricks for SpringBoot Web Applications (MySQL Example)

dbaplus Community

Apr 6, 2021 · Databases

10 Proven Strategies to Prevent Dangerous SQL Mistakes in Production

This article outlines ten practical techniques—from avoiding chat tools for SQL transmission to using soft deletes, backup tables, and proper field management—to help developers, testers, and DBAs safeguard production databases against accidental data loss and costly errors.

MySQLProductionSQL

0 likes · 13 min read

10 Proven Strategies to Prevent Dangerous SQL Mistakes in Production

Code Ape Tech Column

Apr 6, 2021 · Backend Development

Common Reasons Why Indexes Are Ignored in SQL Queries

This article explains various situations—such as column-to-column comparisons, NULL values, NOT conditions, wildcard LIKE patterns, functions on indexed columns, low‑cardinality leading columns in composite indexes, implicit datatype conversions, arithmetic predicates, virtual and invisible indexes—that can cause an otherwise usable index to be bypassed by the optimizer, leading to full‑table scans.

OraclePerformanceQuery Optimization

0 likes · 8 min read

Common Reasons Why Indexes Are Ignored in SQL Queries

Java Architect Essentials

Apr 4, 2021 · Databases

Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Generation

This guide introduces DBeaver, a free open‑source database management tool, explains how to download and install it on various operating systems, shows how to create and test database connections (e.g., PostgreSQL), manage JDBC drivers, and generate ER diagrams from existing schemas.

DBeaverDatabase ManagementER Diagram

0 likes · 6 min read

Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Generation

Top Architect

Apr 2, 2021 · Databases

MySQL Index Types, Usage Guidelines, and EXPLAIN Interpretation

This article explains MySQL index types—including ordinary, unique, primary, composite, and full‑text indexes—their creation syntax, optimal usage scenarios, situations where indexes should be avoided, cases that render indexes ineffective, and how to interpret EXPLAIN output types for query performance analysis.

EXPLAINMySQLSQL

0 likes · 7 min read

MySQL Index Types, Usage Guidelines, and EXPLAIN Interpretation

Top Architect

Apr 1, 2021 · Databases

Comparative Analysis of Java Persistence Frameworks: JOOQ, MyBatis, Hibernate, JPA, and JDBC Template

This article evaluates several Java persistence solutions—JOOQ, MyBatis, Hibernate, JPA, and JDBC Template—by examining SQL encapsulation, DSL adaptability, cross‑database portability, security, and the specific drawbacks of JOOQ, ultimately concluding that JDBC Template best fits the project’s needs.

HibernateJOOQJava

0 likes · 13 min read

Comparative Analysis of Java Persistence Frameworks: JOOQ, MyBatis, Hibernate, JPA, and JDBC Template

Qunar Tech Salon

Mar 31, 2021 · Databases

Tracing Full SQL Statements in PostgreSQL Transactions Using Log Configuration

This article explains how DBAs can use PostgreSQL's extensive logging parameters and log_line_prefix settings to locate and reconstruct every SQL statement within a transaction, illustrated with practical cases, command‑line examples, and step‑by‑step log‑analysis techniques for lock troubleshooting.

DBADatabase LoggingLock Troubleshooting

0 likes · 24 min read

Tracing Full SQL Statements in PostgreSQL Transactions Using Log Configuration

ITPUB

Mar 30, 2021 · Databases

10 Essential MySQL Development Rules Every DBA and Developer Should Follow

This article outlines ten practical MySQL development guidelines—from always using InnoDB and simple data types to avoiding SELECT *, ENUM, and low‑cardinality indexes, while emphasizing proper naming, charset choices, NOT NULL constraints, and continuous SQL monitoring with Percona Toolkit.

Best PracticesDBADatabase Design

0 likes · 5 min read

10 Essential MySQL Development Rules Every DBA and Developer Should Follow

Efficient Ops

Mar 29, 2021 · Databases

10 Essential MySQL Development Rules Every DBA and Developer Should Follow

This article outlines ten practical MySQL development guidelines—from using InnoDB tables and simple data types to avoiding SELECT * and unnecessary ENUMs—helping DBAs and developers collaborate more efficiently and write cleaner, faster SQL.

Best PracticesDBADatabase Design

0 likes · 5 min read

Full-Stack Internet Architecture

Mar 29, 2021 · Databases

Implementing Distributed Read‑Write Locks with MySQL

This article explains how to build a distributed read‑write lock using MySQL tables and transactions, covering the business scenario, lock table design, detailed SQL procedures for write and read operations, logging, dead‑lock handling, and a cleanup job.

DatabaseConcurrencyDeadlockDistributedLock

0 likes · 13 min read

Implementing Distributed Read‑Write Locks with MySQL

Python Programming Learning Circle

Mar 29, 2021 · Databases

User Retention, Funnel, and Session Analysis in ClickHouse Using Bitmap and Retention Functions

The article explains how to perform efficient user retention, funnel, and session analysis on large ClickHouse datasets by replacing costly multi‑table joins with bitmap compression, the built‑in retention function, windowFunnel, and high‑order array functions, providing practical SQL examples and performance insights.

ClickHouseSQLSession

0 likes · 18 min read

User Retention, Funnel, and Session Analysis in ClickHouse Using Bitmap and Retention Functions

Alibaba Cloud Developer

Mar 29, 2021 · Databases

Mastering Correlated Subqueries: Decorrelation, Push‑Down Rules, and Optimization Techniques

This article explains what correlated subqueries are, why they challenge database engines, and how they can be transformed into ordinary SQL using decorrelation, push‑down rules, result reuse, and window‑function tricks, illustrated with TPCH examples and code snippets.

Correlated SubqueryDecorrelationQuery Optimization

0 likes · 24 min read

Mastering Correlated Subqueries: Decorrelation, Push‑Down Rules, and Optimization Techniques

Laravel Tech Community

Mar 27, 2021 · Databases

Using MySQL Binlog for Data Recovery and Rollback

This guide explains how to verify that MySQL binlog is enabled, locate binlog files, use the mysqlbinlog utility to extract change logs for specific time ranges or tables, and apply the extracted SQL to recover or roll back erroneous data modifications.

BinlogData RecoveryMySQL

0 likes · 5 min read

Using MySQL Binlog for Data Recovery and Rollback

Architect's Tech Stack

Mar 27, 2021 · Databases

Introducing ClickHouse: Columnar Database Overview, MySQL Migration, Performance Comparison, and Practical Tips

This article introduces ClickHouse, explains its column‑oriented architecture versus row‑oriented databases, details a MySQL‑to‑ClickHouse migration, shows a performance benchmark that reduces query time from minutes to seconds, and shares practical deployment tips and common pitfalls.

ClickHouseColumnar DatabaseData Migration

0 likes · 8 min read

Introducing ClickHouse: Columnar Database Overview, MySQL Migration, Performance Comparison, and Practical Tips

Aikesheng Open Source Community

Mar 25, 2021 · Databases

Using MySQL LOAD DATA for Importing Text and Fixed‑Length Files

This article explains how to use MySQL's LOAD DATA command to import CSV and fixed‑length text files, covering basic parameters, sample data and table structures, four practical scenarios, and best‑practice tips for handling mismatched schemas and large files.

ETLFixed-lengthMySQL

0 likes · 12 min read

Using MySQL LOAD DATA for Importing Text and Fixed‑Length Files

Aikesheng Open Source Community

Mar 24, 2021 · Databases

Understanding MySQL Multi-Value Indexes and Their Use Cases

This article explains the difference between MySQL multi-value indexes and composite indexes, demonstrates how to create and query multi-value indexes using JSON columns, and shows performance benefits and practical scenarios when dealing with tables that have a large number of columns.

Multi-Value IndexMySQLPerformance

0 likes · 13 min read

Understanding MySQL Multi-Value Indexes and Their Use Cases

Top Architect

Mar 24, 2021 · Databases

Understanding the Use of WHERE 1=1 in Dynamic SQL

The article explains why developers insert the clause "WHERE 1=1" in dynamically generated SQL statements, shows example Java code, discusses how it prevents syntax errors when concatenating AND conditions, and offers advice on adding selective filters and indexes to avoid full table scans.

Dynamic QueryIndexingSQL

0 likes · 3 min read

Understanding the Use of WHERE 1=1 in Dynamic SQL

Big Data Technology Architecture

Mar 23, 2021 · Big Data

Integrating Apache Kylin with MLSQL for In‑Place ETL and Analytics

The article explains how Apache Kylin and MLSQL complement each other, detailing Kylin's OLAP strengths, MLSQL's data‑processing and AI capabilities, and demonstrates a low‑code integration that enables users to perform ETL directly within Kylin’s interface while outlining future deep‑link scenarios.

Data IntegrationETLKylin

0 likes · 10 min read

Integrating Apache Kylin with MLSQL for In‑Place ETL and Analytics

Big Data Technology Architecture

Mar 23, 2021 · Big Data

Overview of SparkSQL Join Execution Process and Implementations

This article explains SparkSQL's overall workflow, introduces the basic elements of joins, and details the physical execution processes for various join types—including sort‑merge, broadcast, and hash joins—along with their implementation conditions and optimization considerations.

Distributed ComputingJOINSQL

0 likes · 12 min read

Overview of SparkSQL Join Execution Process and Implementations

Selected Java Interview Questions

Mar 23, 2021 · Backend Development

Understanding MyBatis: Concepts, Advantages, Disadvantages, Usage Scenarios, and Advanced Features

This article provides a comprehensive overview of MyBatis, a semi‑ORM Java framework, covering its core concepts, benefits, drawbacks, appropriate use cases, differences from Hibernate, parameter handling, dynamic SQL, caching, lazy loading, mapper binding, plugin development, and various configuration techniques.

JavaMyBatisORM

0 likes · 22 min read

Understanding MyBatis: Concepts, Advantages, Disadvantages, Usage Scenarios, and Advanced Features

Laravel Tech Community

Mar 22, 2021 · Databases

MySQL Index Not Used Due to Implicit Character Set Conversion and How to Fix It

This article explains why a MySQL join query may ignore an index because of implicit character‑set conversion, demonstrates how to diagnose the issue with EXPLAIN and schema queries, and provides a fix by converting the column to UTF8 in the SQL statement.

Character SetMySQLSQL

0 likes · 4 min read

MySQL Index Not Used Due to Implicit Character Set Conversion and How to Fix It

Su San Talks Tech

Mar 19, 2021 · Databases

10 Proven Ways to Prevent Dangerous SQL Mistakes in Production

Learn ten practical strategies—from avoiding chat tools for SQL to using logical deletes, backups, and proper field management—to dramatically reduce the risk of costly database mishaps in production environments, ensuring safer data operations and easier recovery.

Data ManagementSQLdatabase safety

0 likes · 13 min read

10 Proven Ways to Prevent Dangerous SQL Mistakes in Production

Code Ape Tech Column

Mar 18, 2021 · Backend Development

Master MyBatis: Core Concepts, Best Practices, and Advanced Techniques

This comprehensive guide explains what MyBatis is, its advantages and drawbacks, suitable use cases, differences from Hibernate, parameter handling, dynamic SQL, pagination, caching, lazy loading, and how to use mapper interfaces, XML mappings, and plugins with clear code examples.

JavaMyBatisORM

0 likes · 20 min read

Master MyBatis: Core Concepts, Best Practices, and Advanced Techniques

NetEase Cloud Music Tech Team

Mar 17, 2021 · Backend Development

Analyzing Node.js .heapsnapshot Files and Using heapquery for Memory‑Leak Investigation

The article shows how to generate a Node.js V8 heap snapshot with v8.getHeapSnapshot, explains the JSON‑like .heapsnapshot structure of nodes, edges, and strings, and demonstrates using the heapquery tool to import the data into SQLite for SQL queries that locate and trace memory‑leaking objects such as a HugeObj instance.

HeapSnapshotNode.jsSQL

0 likes · 17 min read

Analyzing Node.js .heapsnapshot Files and Using heapquery for Memory‑Leak Investigation

Big Data Technology & Architecture

Mar 16, 2021 · Big Data

Using Flink Upsert‑Kafka Connector for Real‑Time Data Aggregation and TiDB Synchronization

This article explains the upsert‑kafka connector in Flink, its configuration parameters, step‑by‑step usage with SQL examples, and demonstrates a complete pipeline that reads Kafka streams, aggregates page view metrics, and synchronizes the results to TiDB in real time.

FlinkSQLStreaming

0 likes · 13 min read

Using Flink Upsert‑Kafka Connector for Real‑Time Data Aggregation and TiDB Synchronization

Code Ape Tech Column

Mar 15, 2021 · Databases

Why Large OFFSETs Slow MySQL Queries and How to Fix Them

A developer discovers that massive OFFSET values in MySQL pagination cause full‑table scans and severe latency, then reproduces the issue with simulated data, benchmarks the slowdown, and presents three practical solutions—including index‑covering subqueries, cursor‑based pagination, and offset limits—to restore query performance.

Index OptimizationKeyset PaginationLarge OFFSET

0 likes · 16 min read

Why Large OFFSETs Slow MySQL Queries and How to Fix Them

Selected Java Interview Questions

Mar 14, 2021 · Databases

Understanding Prefix Indexes in MySQL: Concepts, Use Cases, and Performance Testing

This article explains what a prefix (partial) index is in MySQL, why it can reduce index size and improve query speed, outlines suitable scenarios and limitations, and demonstrates performance differences through a series of tests with varying prefix lengths on a large test table.

MySQLPrefix IndexSQL

0 likes · 6 min read

Understanding Prefix Indexes in MySQL: Concepts, Use Cases, and Performance Testing

Qunar Tech Salon

Mar 11, 2021 · Information Security

Implementing Row-Level and Column-Level Security in PostgreSQL

This article explains how to use PostgreSQL's row-level and column-level security features to restrict user access to specific rows and columns, providing step‑by‑step examples, code snippets, and discussion of policies, BYPASSRLS, and performance considerations.

Column-Level SecurityDatabase Access ControlSQL

0 likes · 9 min read

Implementing Row-Level and Column-Level Security in PostgreSQL

Laravel Tech Community

Mar 9, 2021 · Databases

Understanding Various SQL Join Types and Their Differences

This article explains the different SQL join types—including equi‑join, natural join, inner join, self‑join, outer joins, and cross join—detailing their syntax, behavior, and practical usage with example queries and optimization tips.

Cross JoinINNER JOINJoins

0 likes · 8 min read

Understanding Various SQL Join Types and Their Differences

php Courses

Mar 8, 2021 · Databases

Using PDO for Database Write and Read Operations in PHP

This article explains how to manage database write and query operations in PHP using PDO, covering initialization, error handling, and providing complete code examples for inserting and selecting records.

CRUDPDOPHP

0 likes · 4 min read

Using PDO for Database Write and Read Operations in PHP

dbaplus Community

Mar 7, 2021 · Databases

Why Does MySQL GROUP BY Return Sorted Results? Uncovering Implicit Sorting

This article explains how MySQL versions prior to 8.0 automatically sorted GROUP BY results, why the optimizer added this hidden ordering, how the behavior was removed in MySQL 8.0, and what developers must watch for when migrating, illustrated with concrete SQL examples and EXPLAIN output.

GROUP BYMigrationMySQL

0 likes · 11 min read

Why Does MySQL GROUP BY Return Sorted Results? Uncovering Implicit Sorting

DataFunTalk

Mar 7, 2021 · Big Data

Building Stream‑Batch Integrated ETL with Flink SQL: Data Warehouse and Data Integration

This article explains how Flink SQL can be used to construct a unified stream‑batch ETL pipeline for data warehouses and data lakes, covering data integration, CDC support, streaming writes to Hive and Iceberg, and various join techniques such as regular, interval, and temporal joins.

CDCData IntegrationETL

0 likes · 20 min read

Building Stream‑Batch Integrated ETL with Flink SQL: Data Warehouse and Data Integration

Architecture Digest

Mar 4, 2021 · Databases

Performance Comparison Between MariaDB and MySQL

This article reviews the history of MySQL, introduces MariaDB as its open‑source fork, and presents a series of benchmark tests—including single‑row inserts, batch inserts, and various query scenarios—showing that MariaDB generally outperforms MySQL in speed while using more memory.

BenchmarkDatabase PerformanceMariaDB

0 likes · 8 min read

Performance Comparison Between MariaDB and MySQL

Architect

Mar 2, 2021 · Databases

SQL Query Optimization for Large-Scale MES Reporting Using Stored Procedures

An in-depth case study describes how to dramatically improve the performance of a massive MES reporting query—reducing execution from over half an hour to seconds—by analyzing inefficient SQL, adding proper indexes, avoiding full table scans, redesigning with stored procedures, temporary tables, and selective use of NOLOCK.

IndexingMESSQL

0 likes · 22 min read

SQL Query Optimization for Large-Scale MES Reporting Using Stored Procedures

dbaplus Community

Feb 28, 2021 · Databases

Why Two Non‑Overlapping UPDATE Statements Trigger a MySQL Deadlock and How to Prevent It

During a holiday‑time alert, a seemingly harmless pair of UPDATE statements on the same InnoDB table caused a deadlock, and the article walks through log analysis, reproduction steps, lock mechanics, and practical ways to avoid such deadlocks in MySQL.

InnoDBLockMySQL

0 likes · 14 min read

Why Two Non‑Overlapping UPDATE Statements Trigger a MySQL Deadlock and How to Prevent It

Big Data Technology & Architecture

Feb 28, 2021 · Databases

Understanding the SQL Execution Process in ClickHouse

This article explains in detail how ClickHouse processes a user‑submitted SQL query, covering the server’s request handling, parsing, query rewrite, optimization, interpreter execution, and result transmission, while illustrating key source code snippets and architectural components.

ClickHouseDatabase InternalsParser

0 likes · 18 min read

Understanding the SQL Execution Process in ClickHouse

Big Data Technology & Architecture

Feb 26, 2021 · Databases

Overview of ClickHouse Table Engines and Their Usage

This article provides a comprehensive overview of ClickHouse's table engines, explaining the purpose and characteristics of each engine series—including Log, Integration, Special, and the various MergeTree families—while offering detailed SQL examples and guidance on when to use each engine for different data workloads.

ClickHouseMergeTreeSQL

0 likes · 16 min read

Overview of ClickHouse Table Engines and Their Usage

Top Architect

Feb 26, 2021 · Databases

52 Practical SQL Query Performance Optimization Strategies

This article compiles fifty‑two actionable tips for improving SQL query performance, covering index creation, query rewriting, use of temporary tables, proper data types, server configuration, and best practices for MySQL and other relational databases.

IndexesOptimizationPerformance

0 likes · 18 min read

52 Practical SQL Query Performance Optimization Strategies

Code Ape Tech Column

Feb 24, 2021 · Databases

Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines

This article translates and expands on a HikariCP wiki post, explaining why smaller database connection pools often yield better performance, presenting benchmark videos and data, describing the underlying CPU, disk, and network constraints, and offering a simple formula to calculate an optimal pool size for typical server configurations.

Connection PoolDatabase PerformanceHikariCP

0 likes · 9 min read

Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines

Java Backend Technology

Feb 23, 2021 · Databases

Why Misplaced Quotes Turn MySQL Updates into Zeroes – A Deep Dive

This article explains how incorrectly placed double‑quotation marks in MySQL UPDATE and SELECT statements cause implicit type conversion, turning intended string assignments into zero values and making WHERE clauses always true, leading to massive data corruption and unexpected query results.

MySQLQuotation MarksSQL

0 likes · 7 min read

Why Misplaced Quotes Turn MySQL Updates into Zeroes – A Deep Dive

Java Architect Essentials

Feb 22, 2021 · Databases

Boost MySQL Pagination: Practical Optimizations and Performance Benchmarks

This article examines several MySQL pagination techniques—including basic LIMIT, subquery‑based, ID‑range, and temporary‑table methods—provides detailed performance measurements on a multi‑million‑row table, and offers practical recommendations for fast and scalable data retrieval.

MySQLOptimizationPerformance

0 likes · 10 min read

Boost MySQL Pagination: Practical Optimizations and Performance Benchmarks

Big Data Technology & Architecture

Feb 22, 2021 · Databases

Introduction to Apache IoTDB: Features, Architecture, Installation, and Basic Usage

This article introduces Apache IoTDB, a high‑performance time‑series database for IoT, covering its key features, overall architecture, installation procedures, command‑line operations, and JDBC usage with example code to help newcomers quickly start storing and querying sensor data.

Apache IoTDBInstallationIoT

0 likes · 15 min read

Introduction to Apache IoTDB: Features, Architecture, Installation, and Basic Usage

JavaEdge

Feb 20, 2021 · Databases

Understanding SQL: DDL, DML, and DCL Explained

The article explains the three main types of SQL statements—DDL for defining database objects, DML for manipulating data, and DCL for controlling access—detailing their purposes, common keywords, and typical usage scenarios in relational database systems.

DCLDDLDML

0 likes · 3 min read

Understanding SQL: DDL, DML, and DCL Explained

Laravel Tech Community

Feb 18, 2021 · Databases

Why NULL Columns Can Break MySQL Indexes and How to Avoid It

This article explains how MySQL treats NULL values, why columns defined with NULL can invalidate indexes, demonstrates the behavior of IS NULL, IS NOT NULL, the spaceship operator, IFNULL, COUNT, DISTINCT, GROUP BY and ORDER BY with NULLs, and offers practical recommendations for schema design.

Database DesignIndexesMySQL

0 likes · 13 min read

Why NULL Columns Can Break MySQL Indexes and How to Avoid It

ITPUB

Feb 18, 2021 · Databases

52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries

This article compiles fifty‑two practical SQL tuning strategies—including proper indexing, query rewriting, avoiding full table scans, using temporary tables, managing locks, and choosing the right storage engine—to help developers dramatically improve database query performance and scalability.

IndexingPerformanceQuery Tuning

0 likes · 22 min read

52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries

Top Architect

Feb 18, 2021 · Databases

Introducing DBeaver: A Free Open‑Source Universal Database Management Tool and Installation Guide

This article introduces DBeaver, a free open‑source, Java‑based universal database client that supports a wide range of databases via JDBC, outlines its rich features, and provides step‑by‑step installation and connection setup instructions for Windows, macOS, and Linux.

DBeaverData ManagementJDBC

0 likes · 5 min read

Introducing DBeaver: A Free Open‑Source Universal Database Management Tool and Installation Guide

DataFunTalk

Feb 17, 2021 · Big Data

Apache Iceberg 0.11.0: New Partition Support, SortOrder, Flink Streaming Reader, and Ecosystem Integrations

The article details Apache Iceberg 0.11.0's core enhancements—including partition changes, SortOrder, extensive Flink and Spark integrations, CDC/Upsert support, hash‑based write distribution to reduce small files, and upcoming 0.12.0 roadmap—while providing practical SQL and API examples for data‑lake practitioners.

Apache IcebergBig DataCDC

0 likes · 13 min read

Apache Iceberg 0.11.0: New Partition Support, SortOrder, Flink Streaming Reader, and Ecosystem Integrations

ITPUB

Feb 17, 2021 · Databases

52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries

This article compiles 52 practical SQL tuning strategies—including index best practices, query rewriting, use of temporary tables, proper data types, and server configuration tips—to dramatically improve MySQL query speed and overall database efficiency.

IndexesMySQLPerformance

0 likes · 23 min read

Top Architect

Feb 17, 2021 · Backend Development

Understanding and Optimizing MyBatis PageHelper Pagination Performance

This article analyzes the performance bottlenecks of PageHelper's pagination in MyBatis, demonstrates how large offsets degrade MySQL query speed, and presents a more efficient sub‑query join solution along with suggestions for refactoring the interceptor to improve backend pagination efficiency.

JavaMyBatisPerformance

0 likes · 9 min read

Understanding and Optimizing MyBatis PageHelper Pagination Performance

DataFunTalk

Feb 16, 2021 · Big Data

Understanding Presto: Architecture, Query Execution, and Youzan’s Practical Experience

This article explains Presto’s core architecture and low‑latency query execution process, describes how Youzan adopts Presto for various data‑platform scenarios, discusses the evolution of its deployment, and outlines the performance challenges and future enhancements such as Alluxio integration and session property management.

Big DataSQLYouzan

0 likes · 13 min read

Understanding Presto: Architecture, Query Execution, and Youzan’s Practical Experience

Code Ape Tech Column

Feb 16, 2021 · Databases

52 Proven SQL Optimization Techniques to Supercharge Your Queries

This article compiles 52 practical SQL performance‑tuning strategies—including indexing rules, query‑writing shortcuts, join optimizations, lock handling, temporary tables, storage‑engine choices, data‑type recommendations, backup tips, and useful code examples—to help developers dramatically improve query speed and overall database efficiency.

IndexingOptimizationPerformance

0 likes · 20 min read

52 Proven SQL Optimization Techniques to Supercharge Your Queries

Selected Java Interview Questions

Feb 16, 2021 · Databases

Analysis of MySQL Index Usage Cases and Best Practices

This article demonstrates how to create a test table, build indexes, and analyze their effectiveness across multiple query scenarios using MySQL's EXPLAIN output, highlighting the best‑left‑prefix rule, range condition impacts, ORDER BY considerations, and common pitfalls such as Using filesort and temporary tables.

EXPLAINMySQLSQL

0 likes · 6 min read

Analysis of MySQL Index Usage Cases and Best Practices

Top Architect

Feb 15, 2021 · Databases

The 50‑Year Evolution of Relational Databases and SQL

This article traces the fifty‑year history of relational databases, from early storage systems and the IDS and CODASYL network model to Codd’s relational model, the rise of SQL, its standards, competitors, and the principles that have kept SQL dominant in modern data management.

CoddData ModelsDatabase history

0 likes · 13 min read

The 50‑Year Evolution of Relational Databases and SQL

Selected Java Interview Questions

Feb 15, 2021 · Databases

Using IN vs EXISTS in SQL: When a Small Table Drives a Large Table

This article explains why a small table should drive a large table in SQL queries, demonstrates data preparation, compares IN and EXISTS performance when the small table is either the inner or outer query, and concludes with practical guidelines for choosing between IN and EXISTS.

EXISTSINPerformance

0 likes · 4 min read

Using IN vs EXISTS in SQL: When a Small Table Drives a Large Table

MaGe Linux Operations

Feb 14, 2021 · Databases

Why MariaDB Outperforms MySQL: A Detailed Performance Comparison

This article traces MySQL’s evolution, introduces MariaDB’s origins, and presents a comprehensive benchmark comparing insert and query performance of MySQL 8.0.19 and MariaDB 10.4.12 on identical hardware, highlighting speed differences with and without indexes.

BenchmarkInnoDBMariaDB

0 likes · 9 min read

Why MariaDB Outperforms MySQL: A Detailed Performance Comparison

Java Captain

Feb 14, 2021 · Databases

52 SQL Statement Performance Optimization Strategies

This article presents a comprehensive collection of 52 practical tips for optimizing SQL queries, covering index usage, query rewriting, data type selection, storage engine choices, transaction handling, and backup strategies to improve database performance and reduce resource consumption.

IndexesOptimizationPerformance

0 likes · 18 min read

52 SQL Statement Performance Optimization Strategies

Java Architect Essentials

Feb 10, 2021 · Databases

Master DBeaver: Free Open‑Source Database Tool and Easy Installation Guide

This article introduces DBeaver, a free open‑source, cross‑platform database management tool that supports numerous databases via JDBC, outlines its rich features such as data editors, ER diagrams, import/export, and provides step‑by‑step installation instructions for Windows, macOS, and Linux, plus tips for creating connections.

Data ManagementDatabase ToolsInstallation

0 likes · 5 min read

Master DBeaver: Free Open‑Source Database Tool and Easy Installation Guide

Liangxu Linux

Feb 9, 2021 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database

This guide explains how to download, install, and configure DBeaver, connect to various relational and NoSQL databases via JDBC, manage drivers manually when needed, and generate entity‑relationship diagrams directly from existing database schemas.

DBeaverDatabase ManagementER Diagram

0 likes · 6 min read

Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database

php Courses

Feb 9, 2021 · Databases

Impact of Quoting String Primary Keys on MySQL Query Performance

Testing shows that omitting single quotes around a string primary key in MySQL queries can cause a full table scan and increase execution time by about 100‑fold, while quoting the value enables index usage and dramatically improves performance, a difference that disappears when the column is an INT.

IndexingQuery OptimizationSQL

0 likes · 4 min read

Impact of Quoting String Primary Keys on MySQL Query Performance

Code Ape Tech Column

Feb 8, 2021 · Databases

Evaluating the ‘No Join Over Three Tables’ Rule from Alibaba Java Development Manual with MySQL and Oracle Experiments

This article investigates why the Alibaba Java Development Manual advises against joining more than three tables by designing and executing large‑scale MySQL and Oracle experiments, analyzing query performance, indexing effects, and data‑generation scripts to determine the practical limits of multi‑table joins.

Data GenerationJoin PerformanceMySQL

0 likes · 11 min read

Evaluating the ‘No Join Over Three Tables’ Rule from Alibaba Java Development Manual with MySQL and Oracle Experiments

Big Data Technology & Architecture

Feb 7, 2021 · Big Data

Building a Flink SQL Platform on Zeppelin: Installation, Configuration, and Advanced Use Cases

This guide walks through setting up Apache Zeppelin as a low‑cost, SQL‑centric development platform for Flink, covering environment preparation, installation, interpreter configuration, execution modes, verification, common pitfalls, dimension‑table joins, custom UDFs, Redis integration, and dual‑stream join techniques.

FlinkRedisSQL

0 likes · 24 min read

Building a Flink SQL Platform on Zeppelin: Installation, Configuration, and Advanced Use Cases

DataFunTalk

Feb 7, 2021 · Big Data

Optimizations and Extensions for Flink SQL in Tencent Real‑Time Computing Platform

This article, presented by Tencent senior engineer Du Li, details the current state of Flink SQL, compares Jar, Canvas, and SQL modes, introduces window‑function extensions, retract‑stream optimizations, and outlines future roadmap plans for cost‑based optimization and new features in the real‑time computing platform.

Big DataFlinkRetract Stream

0 likes · 19 min read

Optimizations and Extensions for Flink SQL in Tencent Real‑Time Computing Platform

JD Tech Talk

Feb 5, 2021 · Big Data

Design and Implementation of a Real‑Time OLAP Engine Using ClickHouse in JD Energy Management Platform

This article describes how JD's Energy Management Platform leverages ClickHouse as a high‑performance, MPP‑based OLAP engine to provide real‑time, multi‑dimensional analytics on IoT energy data, covering business background, technology selection, system architecture, data ingestion, storage, replication, and a generic query interface with code examples.

ClickHouseKafkaOLAP

0 likes · 11 min read

Design and Implementation of a Real‑Time OLAP Engine Using ClickHouse in JD Energy Management Platform

ITPUB

Feb 5, 2021 · Databases

Mastering Subquery Unnesting: Theory, Apply Operator, and Practical Rules

This article explains why correlated subqueries are a performance bottleneck, introduces the Apply (Correlated Join) operator, and presents a comprehensive set of transformation rules—including basic unnesting, Project/Filter push‑down, Aggregate handling, and Set‑operation rewrites—to convert subqueries into efficient join plans for modern SQL engines.

Apply OperatorQuery OptimizationSQL

0 likes · 18 min read

Mastering Subquery Unnesting: Theory, Apply Operator, and Practical Rules

Python Crawling & Data Mining

Feb 4, 2021 · Backend Development

Execute Native SQL in Django and Return Results as Dictionaries

This article explains three ways to run raw SQL in Django, demonstrates why the built‑in extra method is discouraged, shows how to use the raw manager and the low‑level connection cursor, and provides helper functions that return query results as dictionaries for easier processing.

DjangoPythonRaw Query

0 likes · 6 min read

Execute Native SQL in Django and Return Results as Dictionaries

Architect

Feb 3, 2021 · Databases

Understanding Database Connection Pool Sizing: Lessons from HikariCP and Real‑World Performance Tests

The article explains why a small database connection pool combined with a large queue of waiting threads yields better performance, illustrates this with Oracle and PostgreSQL benchmark data, and provides a practical formula for calculating the optimal pool size based on CPU cores and effective disks.

Connection PoolHikariCPPostgreSQL

0 likes · 11 min read

Understanding Database Connection Pool Sizing: Lessons from HikariCP and Real‑World Performance Tests

ITPUB

Feb 3, 2021 · Artificial Intelligence

Can GPT‑3 Write Complex SQL Queries? A Hands‑On Exploration

This article demonstrates how GPT‑3 can translate plain‑English questions into SQL statements, starting with simple counts and progressing to multi‑table joins, while highlighting prompting techniques, limitations, and the impact of model variants such as GPT‑3 Instruct.

AI-generated codeDatabase AutomationGPT-3

0 likes · 7 min read

Can GPT‑3 Write Complex SQL Queries? A Hands‑On Exploration

Selected Java Interview Questions

Feb 3, 2021 · Databases

Why Physical Pagination Uses LIMIT and Its Performance Implications in MySQL

This article explains the difference between logical and physical pagination, demonstrates how MySQL's LIMIT clause works, compares two query methods on a large MEMORY table, analyzes their performance with indexes and EXPLAIN, and provides practical pagination examples and Java code for efficient data retrieval.

LIMITMySQLSQL

0 likes · 7 min read

Why Physical Pagination Uses LIMIT and Its Performance Implications in MySQL

Java Captain

Feb 3, 2021 · Databases

Why MySQL UPDATE Statements Can Turn All Values to Zero When Quotes Are Misplaced

The article analyzes a production incident where dozens of MySQL UPDATE statements unintentionally set a column to zero because misplaced quotation marks caused MySQL to interpret the expression as a boolean comparison with implicit type conversion, and it explains how to detect and prevent such errors.

DataRecoveryDatabaseSafetyImplicitConversion

0 likes · 6 min read

Why MySQL UPDATE Statements Can Turn All Values to Zero When Quotes Are Misplaced

Architecture Digest

Feb 2, 2021 · Databases

Why Alibaba's Java Development Manual Prohibits Joins Over Three Tables – MySQL and Oracle Performance Experiments

The article investigates the Alibaba Java Development Manual's rule against joining more than three tables by designing and executing extensive MySQL and Oracle experiments, generating massive test data, measuring query performance, and concluding that the restriction stems from join scalability limits on large datasets.

Data GenerationJoin PerformanceMySQL

0 likes · 11 min read

Why Alibaba's Java Development Manual Prohibits Joins Over Three Tables – MySQL and Oracle Performance Experiments

NetEase Smart Enterprise Tech+

Feb 2, 2021 · Big Data

How to Build a Scalable Elasticsearch-Powered Data Reporting System

This article explains how to design and implement a flexible, accurate data reporting platform using Elasticsearch aggregation, covering architecture, data synchronization, metric definition, SDK integration, and future scaling considerations for enterprise analytics.

Data ReportingElasticsearchSQL

0 likes · 12 min read

How to Build a Scalable Elasticsearch-Powered Data Reporting System

Practical DevOps Architecture

Feb 2, 2021 · Databases

SQL DDL and DML Commands: Creating, Modifying, and Querying Databases and Tables

This article introduces the classification of SQL statements and provides practical DDL and DML commands for creating, altering, and querying databases and tables, including examples of creating databases, showing database information, and modifying table structures.

DDLDMLSQL

0 likes · 4 min read

SQL DDL and DML Commands: Creating, Modifying, and Querying Databases and Tables

Big Data Technology & Architecture

Feb 1, 2021 · Big Data

Flink 1.12 Enhancements: Full SQL Support, Hive Integration, and Streaming Write to Hive

The article reviews Flink 1.12's major enhancements, including comprehensive SQL capabilities, deep integration with Hive via catalog and streaming support, and a practical code example that demonstrates how to write streaming data into Hive tables while handling partition commits and small‑file merging.

Data IntegrationFlinkHive

0 likes · 7 min read

Flink 1.12 Enhancements: Full SQL Support, Hive Integration, and Streaming Write to Hive

ITPUB

Feb 1, 2021 · Databases

Master MySQL Index Interview Questions: 9 Essential Concepts Explained

This article breaks down nine core MySQL index concepts—including index types, B+Tree advantages, search steps, covering indexes, index invalidation, left‑most prefix rules, index push‑down, and safe index creation on large tables—to help candidates answer interview questions about tree‑search operations and performance trade‑offs.

B+TreeMySQLSQL

0 likes · 16 min read

Master MySQL Index Interview Questions: 9 Essential Concepts Explained

Laravel Tech Community

Jan 31, 2021 · Databases

Why MySQL UPDATE Statements Can Turn All Values to Zero When Quotes Are Misplaced

The article analyzes a real‑world incident where a series of MySQL UPDATE statements with incorrectly placed quotation marks caused the entire source_name column to be set to zero, explains MySQL's implicit type conversion behavior, and shows how to recover the data using binlog analysis and flashback SQL.

BinlogDataRecoveryImplicitConversion

0 likes · 5 min read

JD Cloud Developers

Jan 28, 2021 · Big Data

How JD’s Energy Management Platform Leverages ClickHouse for Real‑Time OLAP at Scale

This article explains how JD’s Energy Management Platform uses ClickHouse as an MPP‑based OLAP engine to ingest, store, and provide multi‑dimensional real‑time analytics on energy consumption data, covering architecture decisions, data pipelines, replication, sharding, and a generic query interface.

Big DataClickHouseOLAP

0 likes · 12 min read

How JD’s Energy Management Platform Leverages ClickHouse for Real‑Time OLAP at Scale

dbaplus Community

Jan 27, 2021 · Big Data

How We Upgraded a 1500-Node Flink Cluster to 1.10: Challenges and Solutions

Facing a massive 1500‑node Flink 1.4.2 cluster handling over 12,000 tasks and 30 trillion daily events, we migrated to Flink 1.10, detailing new DDL/Catalog support, SQL enhancements, memory tuning, compatibility patches, extensive testing, and engine optimizations such as task‑load metrics and balanced sub‑task scheduling.

Big DataFlinkSQL

0 likes · 13 min read

How We Upgraded a 1500-Node Flink Cluster to 1.10: Challenges and Solutions

php Courses

Jan 27, 2021 · Backend Development

Understanding ThinkPHP Db Class: Integration of Connector, Query Builder, and SQL Generation

This article provides a detailed walkthrough of ThinkPHP's Db class, explaining how it combines connectors, query builders, and SQL generators to perform database operations, including method calls like __callStatic, table handling, where clause parsing, getLastSql retrieval, and the underlying execution flow.

DBORMPHP

0 likes · 11 min read

Understanding ThinkPHP Db Class: Integration of Connector, Query Builder, and SQL Generation

Big Data Technology & Architecture

Jan 26, 2021 · Big Data

Comprehensive Guide to Apache Superset: Features, Installation, Data Source Integration, and Permissions

This article provides an in‑depth overview of Apache Superset, covering its recent graduation to a top‑level Apache project, key visualization features, extensive data source support, step‑by‑step installation via pip or Docker, PostgreSQL connection, role‑based permission model, and practical usage insights.

Apache SupersetData VisualizationDocker

0 likes · 8 min read

Comprehensive Guide to Apache Superset: Features, Installation, Data Source Integration, and Permissions

Aikesheng Open Source Community

Jan 25, 2021 · Databases

Understanding the FRAME Clause in MySQL 8.0 Window Functions

This article explains MySQL 8.0 window function FRAME clause syntax, differentiates ROWS and RANGE units, and demonstrates various frame boundaries such as CURRENT ROW, UNBOUNDED PRECEDING/FOLLOWING, and expression‑based preceding/following with concrete query examples.

FRAME ClauseMySQLQuery Optimization

0 likes · 10 min read

Understanding the FRAME Clause in MySQL 8.0 Window Functions

Big Data Technology & Architecture

Jan 24, 2021 · Big Data

Design and Implementation of a Big Data OLAP Platform Based on Apache Kylin

This article explains the background, challenges, and architectural design of a big‑data OLAP platform that integrates Apache Kylin with a BI system, detailing pre‑computation strategies, cube construction, user authentication, storage engines, and query mechanisms to achieve sub‑second analytics on massive datasets.

Apache KylinData WarehouseHBase

0 likes · 11 min read

Design and Implementation of a Big Data OLAP Platform Based on Apache Kylin

Java Captain

Jan 23, 2021 · Databases

Introducing DBeaver: A Free Open‑Source Database Management Tool and Installation Guide

This article introduces DBeaver, a free open‑source, Java‑based database management and development tool that supports a wide range of databases via JDBC, outlines its rich features, provides installation instructions for Windows, macOS, and Linux, and walks through creating and using a database connection with screenshots.

DBeaverDatabase ManagementInstallation

0 likes · 5 min read

Introducing DBeaver: A Free Open‑Source Database Management Tool and Installation Guide

macrozheng

Jan 22, 2021 · Databases

Why Misplaced Double Quotes Turn MySQL Updates Into Zeroes

A developer’s production update accidentally set every row’s source_name to 0 because misplaced double‑quotation marks altered the SQL semantics, and the article explains how MySQL interprets such malformed statements and how to recover the data.

Database DebuggingQuotation MarksSQL

0 likes · 6 min read

Why Misplaced Double Quotes Turn MySQL Updates Into Zeroes

Big Data Technology & Architecture

Jan 20, 2021 · Databases

An Overview of ClickHouse: Features, Architecture, and Benchmarks

ClickHouse is an open‑source column‑oriented OLAP database developed by Yandex that offers real‑time queries, high performance compared to many traditional databases, a rich set of features, and a modular architecture including columns, data types, blocks, parsers, functions, and various table engines.

ClickHouseColumnar DatabaseOLAP

0 likes · 9 min read

An Overview of ClickHouse: Features, Architecture, and Benchmarks

Aikesheng Open Source Community

Jan 20, 2021 · Databases

Understanding MySQL Prefix Indexes and Their Optimization

This article explains the concept, creation, and performance benefits of MySQL prefix indexes, demonstrates how to choose an optimal prefix length using selectivity calculations, and presents practical techniques for handling both prefix and suffix search patterns.

Index SelectivityMySQLSQL

0 likes · 12 min read

Understanding MySQL Prefix Indexes and Their Optimization

Java Architect Essentials

Jan 19, 2021 · Databases

Explore DBeaver: The Free Open‑Source Database Management Tool for All Platforms

This article introduces DBeaver, a Java‑based, cross‑platform, open‑source database client that supports a wide range of JDBC and non‑JDBC data sources, outlines its key features, provides installation steps for Windows, macOS, and Linux, and shows how to create and use database connections.

Cross‑PlatformDBeaverJDBC

0 likes · 6 min read

Explore DBeaver: The Free Open‑Source Database Management Tool for All Platforms

Java Captain

Jan 19, 2021 · Databases

Why Using SELECT * Is Inefficient in MySQL and How Proper Indexing Improves Performance

The article explains why SELECT * slows down MySQL queries by increasing parsing cost, network traffic, and preventing index covering, and demonstrates how explicit column selection and well‑designed composite indexes can dramatically reduce I/O and improve query speed.

Database PerformanceIndex OptimizationMySQL

0 likes · 10 min read

Why Using SELECT * Is Inefficient in MySQL and How Proper Indexing Improves Performance

MaGe Linux Operations

Jan 15, 2021 · Databases

Why ORDER BY with LIMIT Returns Unexpected Row Order in MySQL

When you combine ORDER BY with LIMIT in MySQL, the result set may appear in a different order than expected, especially if the ordered column contains duplicate values, and understanding the optimizer's behavior and adding deterministic columns can resolve this issue.

LIMITMySQLOrder By

0 likes · 6 min read

Why ORDER BY with LIMIT Returns Unexpected Row Order in MySQL

ITPUB

Jan 15, 2021 · Databases

Why MySQL Sometimes Skips Indexes: A Deep Dive into B+Tree Structures and Optimizer Decisions

This article explains the data structures behind MySQL indexes, demonstrates how B+Tree indexes are built, and shows why the optimizer may choose full‑table scans over index scans in various scenarios such as pattern matching, OR conditions, type conversion, and NULL handling.

B+TreeMySQLSQL

0 likes · 14 min read

Why MySQL Sometimes Skips Indexes: A Deep Dive into B+Tree Structures and Optimizer Decisions

Practical DevOps Architecture

Jan 15, 2021 · Databases

MySQL Backup and Restore Guide: Full, Partial, and Table-Level Operations

This article explains how to list MySQL databases, perform full, multiple‑database, single‑database, and table‑specific backups using mysqldump, and restore them correctly, highlighting the differences when using the --databases option and common pitfalls.

MySQLSQLbackup

0 likes · 4 min read

MySQL Backup and Restore Guide: Full, Partial, and Table-Level Operations

Big Data Technology & Architecture

Jan 14, 2021 · Databases

ClickHouse Overview: Architecture, Performance, Core Concepts, and Enterprise Use Cases

This article provides a comprehensive introduction to ClickHouse, an open‑source column‑oriented OLAP database, covering its high‑performance benchmarks, core architectural components, query processing model, deployment patterns, Java client usage, and real‑world implementations at large enterprises.

ClickHouseColumnar DatabaseOLAP

0 likes · 28 min read

ClickHouse Overview: Architecture, Performance, Core Concepts, and Enterprise Use Cases

Top Architect

Jan 14, 2021 · Databases

Introducing DBeaver: A Free Open‑Source Universal Database Management Tool and Installation Guide

This article introduces DBeaver, a free open‑source, Java‑based universal database management and development tool, outlines its rich features, supported databases, and provides step‑by‑step installation and connection setup instructions for Windows, macOS, and Linux environments.

Cross‑PlatformDBeaverDatabase Management

0 likes · 5 min read

Selected Java Interview Questions

Jan 13, 2021 · Databases

Understanding Unexpected Zero Updates in MySQL Due to Misplaced Quotes

The article explains how incorrectly placed quotation marks in MySQL UPDATE statements can cause expressions like "str_col=\"xxx\" = \"yyy\"" to evaluate to zero, leading to unintended data overwrites and highlights the importance of testing SQL in safe environments.

BinlogData RecoveryMySQL

0 likes · 5 min read

Understanding Unexpected Zero Updates in MySQL Due to Misplaced Quotes

Didi Tech

Jan 12, 2021 · Big Data

Upgrading DiDi Real‑time Computing Engine from Flink 1.4 to Flink 1.10: Challenges, Optimizations, and Lessons Learned

DiDi upgraded its massive real‑time computing engine from Flink 1.4.2 to Flink 1.10, implementing a transparent migration across 1500 machines, adding native DDL, binary rows, MiniBatch, improved scheduling and window functions, and establishing a rigorous testing pipeline that achieved 99.9 % compatibility while preventing OOM issues.

FlinkPerformanceOptimizationRealTimeComputing

0 likes · 11 min read

Upgrading DiDi Real‑time Computing Engine from Flink 1.4 to Flink 1.10: Challenges, Optimizations, and Lessons Learned

Python Programming Learning Circle

Jan 12, 2021 · Databases

Differences Between count(1), count(*), and count(column) in SQL

This article explains the functional and performance differences among SQL count(1), count(*), and count(column) expressions, including how they handle NULL values and when each method is most efficient, illustrated with a MySQL example.

COUNTPerformanceSQL

0 likes · 5 min read

Differences Between count(1), count(*), and count(column) in SQL

Aikesheng Open Source Community

Jan 12, 2021 · Databases

How to Quickly Find Missing Auto‑Increment Primary Key Values in MySQL

This article explains several efficient methods—including shell scripts, generated series tables, JSON functions, and MySQL 8.0 recursive CTEs—to quickly locate missing auto‑increment primary key values in a MySQL table, comparing their performance and suitability.

CTEMySQLPrimary Key

0 likes · 12 min read

How to Quickly Find Missing Auto‑Increment Primary Key Values in MySQL

Code Ape Tech Column

Jan 12, 2021 · Backend Development

How to Build a High‑Performance Search API with SQL and Redis Caching

This article walks through three progressively better implementations for a complex e‑commerce search API—starting with a monolithic SQL query, then splitting the query and adding indexes, and finally using Redis sets and sorted sets to cache filter results, handle pagination, and achieve production‑grade performance.

PerformanceRedisSQL

0 likes · 8 min read

How to Build a High‑Performance Search API with SQL and Redis Caching

Practical DevOps Architecture

Jan 10, 2021 · Databases

Configuring MySQL GTID-Based Replication: Concepts, Setup, and Testing

This guide explains MySQL GTID concepts, how to enable GTID-based replication, configure the server, create replication users, initialize a slave, and verify replication using command-line examples and configuration steps, including transaction commit and rollback testing.

GTIDMySQLSQL

0 likes · 7 min read

Configuring MySQL GTID-Based Replication: Concepts, Setup, and Testing

Big Data Technology & Architecture

Jan 10, 2021 · Big Data

Integrating Apache Flink 1.12 with Hive: Configuration, Catalog, Planner, and UDF Usage

This guide explains how to integrate Flink 1.12 with Hive using HiveCatalog, covering required dependencies, Blink planner configuration, SQL dialect switching, Hive UDF support, temporal table joins, and provides complete code snippets for a streaming‑batch unified data warehouse solution.

Blink PlannerFlinkHive

0 likes · 16 min read

Integrating Apache Flink 1.12 with Hive: Configuration, Catalog, Planner, and UDF Usage

Java Interview Crash Guide

Jan 10, 2021 · Databases

Boost MySQL Query Speed: Practical SQL Optimization Tips for 2021

This article explains why SQL performance is critical for fast‑response web services, presents database‑agnostic optimization techniques—such as preferring EXISTS over IN, using JOINs, avoiding unnecessary ORDER BY, leveraging UNION ALL, and applying indexes—to dramatically reduce query latency and resource consumption.

IndexesMySQLPerformance

0 likes · 15 min read

Boost MySQL Query Speed: Practical SQL Optimization Tips for 2021