BestHub
Sign in
Tagged articles

SQL

2900 articles · Page 19 of 29
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.

JavaMetric SystemSQL
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.

MySQLOptimizationSQL
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.

SQLcost optimizationdistributed databases
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 ErrorsMySQLQuotation 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.

MySQLPerformance OptimizationSQL
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.

Data ModelingETLSQL
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.

MySQLPerformance OptimizationQuery Tuning
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 problemMySQLSQL
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 RetentionSQL
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.

FlinkSQLiceberg
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.

MySQLSQLUpdate
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.

InspectionMySQLReplication
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.

JavaNacosRedis
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 IndexMySQL
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.

Database DebuggingMySQLQuote 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 EngineMySQL
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 JOINMySQL
0 likes · 14 min read
Understanding LEFT JOIN, Common Pitfalls, and Practical Solutions in SQL
Aikesheng Open Source Community
Aikesheng Open Source Community
May 14, 2021 · Databases

Understanding and Managing MySQL User Password Expiration

This article explains the MySQL password expiration mechanism, introduces the relevant columns in the mysql.user table, demonstrates how to set passwords to never expire, expire after a specific interval, or expire immediately, and shows how to configure the global default_password_lifetime variable.

Database SecurityMySQLSQL
0 likes · 10 min read
Understanding and Managing MySQL User Password Expiration
Tech Musings
Tech Musings
May 14, 2021 · Databases

How to Diagnose and Fix MySQL Deadlocks Using Locks and Indexes

This article explains why MySQL deadlocks occur in a test module, details table and row lock mechanisms, reproduces the deadlock scenario with two sessions, analyzes lock logs, and provides a solution by adding a composite index to prevent the conflict.

InnoDBLockMySQL
0 likes · 19 min read
How to Diagnose and Fix MySQL Deadlocks Using Locks and Indexes
ITPUB
ITPUB
May 14, 2021 · Big Data

How AnalyticDB Powers Petabyte-Scale Consumer Analytics in Alibaba’s Data Bank

The article details how Alibaba’s Data Bank leverages AnalyticDB’s cold‑hot tiered storage, high‑throughput real‑time writes, and low‑latency OLAP capabilities to handle petabyte‑scale consumer data, support flexible AIPL analysis, crowd profiling, and rapid audience selection while cutting costs and ensuring elasticity during peak events.

AnalyticDBCold-Hot StorageOLAP
0 likes · 14 min read
How AnalyticDB Powers Petabyte-Scale Consumer Analytics in Alibaba’s Data Bank
Top Architect
Top Architect
May 13, 2021 · Databases

Understanding LEFT JOIN ON vs WHERE Conditions in SQL

The article explains why adding conditions after a LEFT JOIN using AND does not filter rows from the left table, contrasts ON and WHERE clauses, and demonstrates the behavior with SQL examples and step‑by‑step illustrations of intermediate result tables.

Join TypesLEFT JOINON clause
0 likes · 6 min read
Understanding LEFT JOIN ON vs WHERE Conditions in SQL
Aikesheng Open Source Community
Aikesheng Open Source Community
May 12, 2021 · Databases

Understanding MySQL Full-Text Indexes: Structure, Auxiliary Tables, Buffer Pool, and Transaction Handling

This article explains MySQL full-text (inverted) indexes, their underlying auxiliary tables, buffer pool configuration, document ID handling, and the special transaction semantics required for inserting and querying indexed data, providing practical SQL examples and performance considerations.

Database IndexingFull-Text IndexInnoDB
0 likes · 9 min read
Understanding MySQL Full-Text Indexes: Structure, Auxiliary Tables, Buffer Pool, and Transaction Handling
Code Ape Tech Column
Code Ape Tech Column
May 11, 2021 · Databases

How to Speed Up MySQL LIMIT Pagination for Millions of Rows

This article analyzes six MySQL pagination techniques, presents benchmark results showing how query time grows with offset, and offers practical index‑based optimizations—including covering indexes, subqueries, and composite index design—to make LIMIT pagination fast even on very large tables.

LIMITMySQLSQL
0 likes · 12 min read
How to Speed Up MySQL LIMIT Pagination for Millions of Rows
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 10, 2021 · Databases

MySQL Index Design Principles and Common Index Pitfalls

This article explains MySQL index fundamentals, covering primary and unique indexes, best practices for choosing indexed columns, handling functions and large fields, avoiding excessive or frequently updated indexes, and enumerates typical scenarios where indexes become ineffective.

MySQLSQLdatabase optimization
0 likes · 12 min read
MySQL Index Design Principles and Common Index Pitfalls
Programmer DD
Programmer DD
May 7, 2021 · Databases

Boost MySQL Pagination Performance: Real-World Tests and Optimizations

This article examines why full-table scans become slow on large MySQL tables, demonstrates various pagination techniques—including simple LIMIT, sub‑query, ID‑range, and IN‑clause methods—provides benchmark results for different record counts and offsets, and offers practical tips to dramatically speed up paginated queries.

MySQLQuery OptimizationSQL
0 likes · 10 min read
Boost MySQL Pagination Performance: Real-World Tests and Optimizations
DataFunTalk
DataFunTalk
May 2, 2021 · Big Data

Continuous Optimization and Practice of Flink at Kuaishou

This article presents Kuaishou's comprehensive engineering practices for improving Flink's stability, task startup latency, and SQL performance, including high‑availability Kafka connectors, fault‑recovery mechanisms, I/O reductions, asynchronous job upgrades, aggregation optimizations, and future resource‑utilization plans.

FlinkKafkaOptimization
0 likes · 10 min read
Continuous Optimization and Practice of Flink at Kuaishou
Laravel Tech Community
Laravel Tech Community
Apr 28, 2021 · Databases

Understanding and Analyzing MySQL Execution Plans

This article explains the three‑layer architecture of MySQL, how an execution plan is generated and interpreted, and provides a detailed walkthrough of the columns displayed by the EXPLAIN statement to help developers optimize their SQL queries.

EXPLAINMySQLQuery Optimization
0 likes · 8 min read
Understanding and Analyzing MySQL Execution Plans
Programmer DD
Programmer DD
Apr 26, 2021 · Databases

Why MySQL Subqueries Slow Down and How to Optimize Them

This article explains why MySQL subqueries often cause performance bottlenecks, describes the underlying execution mechanism, and presents practical optimization strategies—including semi‑join, materialization, and EXISTS—plus a real‑world case study showing how to rewrite a slow query into a fast join.

MySQLOptimizationSQL
0 likes · 7 min read
Why MySQL Subqueries Slow Down and How to Optimize Them
macrozheng
macrozheng
Apr 25, 2021 · Databases

10 Proven Ways to Prevent Dangerous SQL Mistakes in Production

This article outlines ten practical strategies—including avoiding chat tools for SQL, compressing statements, using SELECT COUNT, adding LIMIT, updating audit fields, logical deletion, table backups, temporary tables, fully qualified names, and careful column changes—to help developers, testers, and DBAs prevent costly database errors in production environments.

Data SafetySQLdatabase
0 likes · 15 min read
10 Proven Ways to Prevent Dangerous SQL Mistakes in Production
Architecture Digest
Architecture Digest
Apr 25, 2021 · Databases

MySQL Lock Types and Deadlock Analysis

This article explains MySQL's lock granularity (table, row, page), the different lock modes such as next‑key, gap and record locks, illustrates common deadlock scenarios with detailed SQL examples, and discusses InnoDB's deadlock prevention strategies and best‑practice solutions.

InnoDBLockMySQL
0 likes · 14 min read
MySQL Lock Types and Deadlock Analysis
Programmer DD
Programmer DD
Apr 24, 2021 · Databases

50 Essential SQL Performance Optimization Tips Every Developer Should Know

This article compiles 50 practical SQL performance optimization techniques—from indexing strategies and query rewriting to avoiding full table scans, using temporary tables, proper data types, and efficient backup methods—helping developers write faster, more scalable database queries.

MySQLSQLindexing
0 likes · 22 min read
50 Essential SQL Performance Optimization Tips Every Developer Should Know
Liangxu Linux
Liangxu Linux
Apr 22, 2021 · Databases

Why Developers Use ‘WHERE 1=1’ in SQL and How to Apply It Effectively

The article explains that inserting ‘WHERE 1=1’ in dynamically built SQL statements prevents syntax errors when appending additional conditions, illustrates its use with Java string concatenation examples, discusses performance considerations, and shows how to copy tables or duplicate structures using this technique.

Dynamic SQLSQLTable copy
0 likes · 3 min read
Why Developers Use ‘WHERE 1=1’ in SQL and How to Apply It Effectively
Selected Java Interview Questions
Selected Java Interview Questions
Apr 22, 2021 · Databases

Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts

This article explains the differences between DROP, DELETE, and TRUNCATE, recommends appropriate MySQL data types for monetary values, compares MyISAM and InnoDB storage engines, outlines transaction ACID properties, describes views, stored procedures versus triggers, indexes, UNION vs UNION ALL, and lists the main SQL language categories.

MySQLSQLStorage Engines
0 likes · 10 min read
Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts
Top Architect
Top Architect
Apr 21, 2021 · Databases

How Many Rows Can a Single InnoDB B+ Tree Store?

This article explains the storage units of InnoDB, calculates how many rows a B+‑tree leaf page can hold, derives the total record capacity for trees of different heights, and shows how to determine the actual B+‑tree height in a MySQL table using page metadata.

B+ TreeDatabase IndexingInnoDB
0 likes · 9 min read
How Many Rows Can a Single InnoDB B+ Tree Store?
Intelligent Backend & Architecture
Intelligent Backend & Architecture
Apr 21, 2021 · Databases

Unlocking MySQL: Core Features, Architecture, and Index Optimization Explained

This comprehensive guide explores MySQL’s origins, key characteristics, logical architecture, storage engines, transaction handling, concurrency control, and detailed indexing strategies, offering practical insights and best‑practice recommendations for developers and database administrators seeking to master MySQL performance and reliability.

MySQLSQLTransactions
0 likes · 41 min read
Unlocking MySQL: Core Features, Architecture, and Index Optimization Explained
Liangxu Linux
Liangxu Linux
Apr 20, 2021 · Databases

Master MySQL Indexes: From Fundamentals to B+ Tree Mechanics

This article explains the core principles of MySQL indexes, covering their essence, various types such as hash, binary, B‑tree and B+‑tree, the structure of primary key directories and index pages, clustered versus non‑clustered indexes, and the back‑table lookup process.

B+ TreeMySQLSQL
0 likes · 16 min read
Master MySQL Indexes: From Fundamentals to B+ Tree Mechanics
Laravel Tech Community
Laravel Tech Community
Apr 20, 2021 · Databases

Diagnosing and Increasing MySQL Max Connections

This guide explains how to identify MySQL max‑connection errors, check the current limit, and increase it using configuration files, global variables, source‑code changes, or mysqld_safe adjustments, with detailed commands and code examples for various MySQL versions.

Database ConfigurationMySQLSQL
0 likes · 4 min read
Diagnosing and Increasing MySQL Max Connections
Programmer DD
Programmer DD
Apr 17, 2021 · Databases

Why Your Oracle Indexes Aren’t Used and How to Fix It

This article explains common reasons why Oracle indexes may be ignored—such as column comparisons, NULL values, NOT conditions, wildcard placement, functions, data type conversions, arithmetic predicates, and special index types—and provides practical SQL examples and tips to ensure indexes are utilized for better query performance.

OracleSQL
0 likes · 8 min read
Why Your Oracle Indexes Aren’t Used and How to Fix It
MaGe Linux Operations
MaGe Linux Operations
Apr 15, 2021 · Databases

Unlock MySQL Query Performance: Deep Dive into Architecture, Optimizer, and Index Strategies

This article demystifies MySQL’s query execution by exploring its logical architecture, client‑server protocol, query cache, parsing, optimization, and execution engine, then offers practical indexing and performance‑tuning techniques—including B‑Tree fundamentals, covering indexes, and pagination tricks—to help developers write faster, more efficient SQL.

B+ TreeMySQLQuery Optimization
0 likes · 35 min read
Unlock MySQL Query Performance: Deep Dive into Architecture, Optimizer, and Index Strategies
Architect's Tech Stack
Architect's Tech Stack
Apr 14, 2021 · Databases

Why Using SELECT * Is Inefficient in MySQL and How to Optimize Queries

This article explains the multiple reasons why SELECT * slows down MySQL queries—including extra parsing, unnecessary data transfer, increased I/O, and loss of covering index optimization—while also covering index fundamentals, composite indexes, and practical tips for writing efficient SELECT statements.

MySQLSQLselect
0 likes · 9 min read
Why Using SELECT * Is Inefficient in MySQL and How to Optimize Queries
Programmer DD
Programmer DD
Apr 8, 2021 · Databases

Master SQL HAVING: Filter Groups Like a Pro

This article explains the purpose and proper use of the SQL HAVING clause, demonstrates how it works with GROUP BY to filter aggregated groups, shows examples for finding groups with specific counts, missing IDs, mode, median, and non‑NULL values, and clarifies best practices for query performance and semantics.

AggregationGROUP BYHAVING
0 likes · 13 min read
Master SQL HAVING: Filter Groups Like a Pro
Sohu Tech Products
Sohu Tech Products
Apr 7, 2021 · Big Data

Data Warehouse Architecture and Modeling with Alibaba MaxCompute and DataWorks

This tutorial explains how to select a technical architecture, design a three‑layer data warehouse (ODS, CDM, ADS), model tables and dimensions, choose storage strategies, handle slowly changing dimensions, synchronize data with DataWorks, and implement dimensional modeling and fact tables using Alibaba MaxCompute for big‑data analytics.

DataWorksMaxComputeSQL
0 likes · 32 min read
Data Warehouse Architecture and Modeling with Alibaba MaxCompute and DataWorks
Full-Stack Internet Architecture
Full-Stack Internet Architecture
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.

Dynamic SQLMyBatisMySQL
0 likes · 6 min read
Nine MyBatis SQL Tricks for SpringBoot Web Applications (MySQL Example)
Code Ape Tech Column
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.

OracleQuery OptimizationSQL
0 likes · 8 min read
Common Reasons Why Indexes Are Ignored in SQL Queries
Top Architect
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
Qunar Tech Salon
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
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.

DBAMySQLSQL
0 likes · 5 min read
10 Essential MySQL Development Rules Every DBA and Developer Should Follow
Full-Stack Internet Architecture
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.

DatabaseConcurrencyDistributedLockLockTable
0 likes · 13 min read
Implementing Distributed Read‑Write Locks with MySQL
Python Programming Learning Circle
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.

BitmapClickHouseSQL
0 likes · 18 min read
User Retention, Funnel, and Session Analysis in ClickHouse Using Bitmap and Retention Functions
Laravel Tech Community
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.

BinlogMySQLSQL
0 likes · 5 min read
Using MySQL Binlog for Data Recovery and Rollback
Architect's Tech Stack
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 DatabaseMySQL
0 likes · 8 min read
Introducing ClickHouse: Columnar Database Overview, MySQL Migration, Performance Comparison, and Practical Tips
Aikesheng Open Source Community
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.

Database IndexingJSONMulti-Value Index
0 likes · 13 min read
Understanding MySQL Multi-Value Indexes and Their Use Cases
Top Architect
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 QuerySQLWHERE clause
0 likes · 3 min read
Understanding the Use of WHERE 1=1 in Dynamic SQL
Selected Java Interview Questions
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.

BackendJavaMyBatis
0 likes · 22 min read
Understanding MyBatis: Concepts, Advantages, Disadvantages, Usage Scenarios, and Advanced Features