BestHub
Sign in
Tagged articles
2769 articles
Page 23 of 28
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 15, 2020 · Databases

MySQL 5.7 Monitoring and Troubleshooting Guide: Connections, Long Transactions, Metadata Locks, and More

This guide provides a comprehensive overview of MySQL 5.7 monitoring techniques, covering connection parameters, long‑running transactions, metadata lock tracing, lock‑wait analysis, global read locks, memory usage, partitioned tables, database size summaries, table update status, primary key and index considerations, storage engine distribution, and real‑time load metrics.

mysqlsqltroubleshooting
0 likes · 6 min read
MySQL 5.7 Monitoring and Troubleshooting Guide: Connections, Long Transactions, Metadata Locks, and More
dbaplus Community
dbaplus Community
Jan 14, 2020 · Big Data

How OPPO Built a Real‑Time Data Warehouse with Flink SQL

This article details{32-64 words} OPPO's evolution from an offline data warehouse to a real‑time platform, describing the business scale, data‑mid platform architecture, migration strategy using Flink SQL, extensions like AthenaX, and practical use cases such as real‑time ETL, CTR calculation, and tag import.

ETLFlinkStreaming
0 likes · 18 min read
How OPPO Built a Real‑Time Data Warehouse with Flink SQL
Efficient Ops
Efficient Ops
Jan 2, 2020 · Operations

When a Database Outage Turns Into a Comedy of Errors: A Real‑World Ops Tale

A chaotic incident‑response story shows how a DBA and SA scramble through VPN glitches, broken jump servers, log hunting, ad‑hoc config tweaks, unexpected bugs, security scans, and frantic firefighting to finally restore a production system, highlighting the messy reality of modern operations.

DevOpsdatabasesql
0 likes · 4 min read
When a Database Outage Turns Into a Comedy of Errors: A Real‑World Ops Tale
macrozheng
macrozheng
Dec 31, 2019 · Databases

10 Common MySQL Index Pitfalls and How to Fix Them

This article analyzes ten typical situations that cause MySQL indexes to become ineffective—such as OR conditions, missing quotes, leading wildcards in LIKE, composite‑index ordering, built‑in functions, arithmetic operations, inequality operators, NULL checks, charset mismatches, and optimizer choices—and provides concrete examples, visual explanations, and practical solutions to restore index usage.

Database Performancemysqlsql
0 likes · 11 min read
10 Common MySQL Index Pitfalls and How to Fix Them
Architecture Digest
Architecture Digest
Dec 28, 2019 · Databases

Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps

This article provides a thorough overview of MySQL optimization, covering the underlying philosophy, risk considerations, participants, optimization scope across hardware, system, application, and database layers, practical tools, command‑line techniques, and detailed tuning recommendations for both system and database parameters.

Database OptimizationHardwareLinux
0 likes · 9 min read
Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps
ITPUB
ITPUB
Dec 17, 2019 · Databases

Mastering LEFT JOIN: Common Pitfalls and Practical Solutions

This article explains the fundamentals of LEFT JOIN in SQL, illustrates one‑to‑one, one‑to‑many, and many‑to‑many scenarios, compares ON versus WHERE conditions, and provides concrete MySQL and Hive examples with code snippets and visual diagrams to avoid common mistakes.

Join TypesLEFT JOINdatabase
0 likes · 14 min read
Mastering LEFT JOIN: Common Pitfalls and Practical Solutions
dbaplus Community
dbaplus Community
Dec 15, 2019 · Databases

10 MySQL Techniques to Sort Custom Role Levels (Make 2 > 3)

This article tackles the challenge of ordering hard‑coded role levels in a MySQL table by presenting ten distinct SQL solutions—including adding a helper column, using FIELD, FIND_IN_SET, CASE, subqueries, UNION, hash‑based formulas, and custom arithmetic—so that a "vice‑manager" (level 2) can be ranked above a "manager" (level 3).

Custom OrderSortingdatabase
0 likes · 10 min read
10 MySQL Techniques to Sort Custom Role Levels (Make 2 > 3)
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 14, 2019 · Databases

MySQL Logical Architecture, Query Process, and Performance Optimization

This article explains MySQL's three‑layer logical architecture, the end‑to‑end query execution flow—including client/server protocol, query cache, parsing, cost‑based optimization, execution engine, and result delivery—followed by practical performance‑tuning advice on schema design, data types, index creation, and specific query optimizations such as COUNT(), JOINs, LIMIT pagination, and UNION handling.

Database Performanceindexingmysql
0 likes · 34 min read
MySQL Logical Architecture, Query Process, and Performance Optimization
21CTO
21CTO
Dec 12, 2019 · Databases

Why Does Alibaba’s Java Handbook Ban Joins Over Three Tables? A Deep MySQL & Oracle Performance Test

This article investigates the claim from Alibaba's Java Development Manual that joining more than three tables should be avoided, by setting up a MySQL 5.7 environment, generating massive synthetic data, executing multi‑table join queries, analyzing execution times, and comparing the results with Oracle, ultimately revealing the practical limits of MySQL joins on large data sets.

Data GenerationDatabase OptimizationJoin Performance
0 likes · 12 min read
Why Does Alibaba’s Java Handbook Ban Joins Over Three Tables? A Deep MySQL & Oracle Performance Test
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 12, 2019 · Databases

Analyzing MySQL Binary Log Events with the infobin Tool

This article introduces the open‑source infobin utility for parsing MySQL binary logs, explains how it detects long‑running and large transactions, measures event generation speed, aggregates per‑table DML events, and demonstrates its usage with sample commands and output, offering a faster alternative to mysqlbinlog.

binary logdatabase analysisinfobin
0 likes · 11 min read
Analyzing MySQL Binary Log Events with the infobin Tool
ITPUB
ITPUB
Dec 9, 2019 · Fundamentals

Master Date Operations in pandas and SQL: Retrieval, Conversion, and Calculation

This tutorial walks through loading order data into pandas and SQL, then demonstrates how to retrieve current dates, extract date components, convert between readable dates and Unix timestamps, transform between 10‑digit and 8‑digit date formats, and perform date arithmetic using pandas, MySQL, and Hive.

data-processingdate handlingdatetime
0 likes · 16 min read
Master Date Operations in pandas and SQL: Retrieval, Conversion, and Calculation
Architecture Digest
Architecture Digest
Dec 6, 2019 · Databases

Understanding InnoDB Index Structures: B+ Trees, Covering Indexes, and Best Practices

This article explains how MySQL InnoDB implements indexes with B+ trees, describes primary and secondary (clustered and non‑clustered) indexes, the concepts of row lookup, covering indexes, composite indexes, the left‑most prefix rule, index push‑down, and provides practical guidelines for creating and maintaining efficient indexes.

B+TreeDatabase OptimizationInnoDB
0 likes · 10 min read
Understanding InnoDB Index Structures: B+ Trees, Covering Indexes, and Best Practices
ITPUB
ITPUB
Dec 4, 2019 · Databases

Essential SQL Server Commands: From Basic CRUD to Advanced Replication and Automation

This comprehensive guide covers fundamental SQL Server operations such as creating databases, tables, indexes, and views, advanced techniques like set operators, subqueries, and linked servers, plus step‑by‑step instructions for replication, backup, compression, and automated synchronization using stored procedures and SQL Agent jobs.

Linked ServerReplicationSQL Server
0 likes · 27 min read
Essential SQL Server Commands: From Basic CRUD to Advanced Replication and Automation
Java Backend Technology
Java Backend Technology
Dec 2, 2019 · Backend Development

Master MyBatis: Common Pitfalls, Tips, and Best Practices

This article compiles a comprehensive guide to MyBatis, covering typical mistakes such as misuse of # vs $, handling of dates and null values, multi‑parameter strategies, XML escaping, dynamic SQL pitfalls, and a balanced list of its advantages and disadvantages for Java developers.

MyBatisORMTips
0 likes · 22 min read
Master MyBatis: Common Pitfalls, Tips, and Best Practices
Java High-Performance Architecture
Java High-Performance Architecture
Nov 28, 2019 · Databases

How MySQL 8’s Hash Join Boosts Query Performance

Learn how MySQL 8’s hash join algorithm works by building an in‑memory hash table from the smaller table, probing the larger table for matches, and handling oversized tables through disk‑based chunk files, offering a more efficient alternative to traditional nested‑loop joins.

Hash JoinJoin Algorithmsmysql
0 likes · 5 min read
How MySQL 8’s Hash Join Boosts Query Performance
Big Data Technology & Architecture
Big Data Technology & Architecture
Nov 26, 2019 · Big Data

Understanding Flink SQL Window Functions: Types, Implementation, and Emit Triggers

This article provides a comprehensive overview of Flink SQL window functions, detailing time‑based window types, their underlying implementation in the StreamExecGroupWindowAggregate operator, the processing flow of WindowOperator, timer handling, emit/trigger strategies, and practical code examples for Tumble, Hop, and Session windows.

Big DataEmitFlink
0 likes · 20 min read
Understanding Flink SQL Window Functions: Types, Implementation, and Emit Triggers
Xianyu Technology
Xianyu Technology
Nov 21, 2019 · Big Data

Event-Driven Rule Engine for User Growth at Xianyu

To accelerate growth on Xianyu’s 20 million‑DAU platform, the team built an event‑driven rule engine with a SQL‑like DSL that translates user‑behavior streams into real‑time Flink/Blink queries, cutting rule development from four days to half a day and achieving sub‑5‑second processing latency.

Big DataDSLEvent Stream
0 likes · 9 min read
Event-Driven Rule Engine for User Growth at Xianyu
DevOps Cloud Academy
DevOps Cloud Academy
Nov 20, 2019 · Databases

Introducing Soar: Features, Usage Scenarios, and Practical Examples for SQL Optimization

This article introduces the open‑source SQL optimization tool Soar, explains its core features, configuration methods, heuristic rules, multiple report formats, syntax checking, SQL rewrite capabilities, EXPLAIN analysis, markdown‑to‑HTML conversion, and how to clean up test artifacts, providing concrete command‑line examples throughout.

Command-lineDatabase OptimizationHeuristic Rules
0 likes · 8 min read
Introducing Soar: Features, Usage Scenarios, and Practical Examples for SQL Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 19, 2019 · Databases

Understanding Hash Join in MySQL 8.0.18

This article explains how MySQL 8.0.18 introduces the hash join algorithm, describes its build and probe phases, disk‑overflow handling, usage instructions, optimizer switches, performance comparisons with block nested loops, and current limitations, providing code examples and practical guidance.

Hash JoinJoin Algorithmsmysql
0 likes · 9 min read
Understanding Hash Join in MySQL 8.0.18
ITPUB
ITPUB
Nov 18, 2019 · Databases

Master Oracle Data Pump: expdp & impdp Commands, Parameters, and Troubleshooting

This guide provides a comprehensive overview of Oracle Data Pump utilities, detailing how to create directories, use expdp and impdp commands for exporting and importing schemas, tables, and full databases, explaining key parameters, interactive mode, and common error resolutions.

Data PumpOracledatabase migration
0 likes · 17 min read
Master Oracle Data Pump: expdp & impdp Commands, Parameters, and Troubleshooting
FunTester
FunTester
Nov 16, 2019 · Backend Development

Using Groovy and Gradle for Configuration Synchronization and Database Integration

This article explains how Groovy, combined with Gradle, can serve as a native application server to synchronize environment‑specific property files with a MySQL registry, demonstrating practical build‑script configuration, file‑system traversal, and Groovy‑SQL database operations for robust CI/CD workflows.

Build AutomationConfiguration ManagementGradle
0 likes · 9 min read
Using Groovy and Gradle for Configuration Synchronization and Database Integration
Big Data Technology & Architecture
Big Data Technology & Architecture
Nov 13, 2019 · Databases

ClickHouse Engines: Use Cases, Syntax, and Limitations

This article provides a comprehensive overview of ClickHouse, covering its typical application scenarios, inherent limitations, common SQL syntax, default values, data types, materialized and expression columns, and detailed explanations of its various storage engines such as TinyLog, Log, Memory, Merge, Distributed, Null, Buffer, Set, MergeTree, ReplacingMergeTree, SummingMergeTree, AggregatingMergeTree, and CollapsingMergeTree, accompanied by practical code examples.

Big DataDatabase EnginesMergeTree
0 likes · 25 min read
ClickHouse Engines: Use Cases, Syntax, and Limitations
ITPUB
ITPUB
Nov 4, 2019 · Databases

Overcoming 50 Common PostgreSQL‑Oracle Migration Pitfalls in Financial Systems

This article details more than fifty practical issues encountered when migrating financial applications from Oracle to PostgreSQL—including character sets, comment syntax, numeric precision, VARCHAR handling, sequence limits, type casting, operator overloading, and connectivity—while offering concrete solutions, code examples, and performance tips.

Oracledatabase migrationfinancial systems
0 likes · 16 min read
Overcoming 50 Common PostgreSQL‑Oracle Migration Pitfalls in Financial Systems
Tech Musings
Tech Musings
Oct 31, 2019 · Databases

Master MySQL Tricks: Upserts, Ignoring Errors, Joins, Pagination & More

This guide explores advanced MySQL techniques—including ON DUPLICATE KEY UPDATE for upserts, INSERT IGNORE to bypass errors, replacing subqueries with JOINs, handling LEFT JOIN pitfalls, efficient pagination strategies, multi‑table UPDATE/DELETE via JOIN, and the nuances of COUNT(*) versus COUNT(1).

Database OptimizationJOINUpsert
0 likes · 12 min read
Master MySQL Tricks: Upserts, Ignoring Errors, Joins, Pagination & More
Programmer DD
Programmer DD
Oct 29, 2019 · Backend Development

Mastering JDBC: Essential Interfaces, Methods, and Best Practices

This article explains JDBC fundamentals, detailing its core interfaces such as Driver, Connection, Statement, PreparedStatement, and CallableStatement, outlines transaction isolation levels, common methods, ResultSet handling, and emphasizes the importance of mastering JDBC for effective use of Java ORM frameworks.

JDBCORMbackend-development
0 likes · 6 min read
Mastering JDBC: Essential Interfaces, Methods, and Best Practices
Java Captain
Java Captain
Oct 28, 2019 · Databases

Understanding the Execution Order of SQL Queries

The article explains that SQL queries are not executed in the order written—SELECT is evaluated fifth after FROM, WHERE, GROUP BY, and HAVING—illustrates this logical sequence with diagrams, discusses alias handling, optimizer reordering, and shows comparable patterns in LINQ, pandas, and dplyr.

Query Executiondatabasesoptimization
0 likes · 6 min read
Understanding the Execution Order of SQL Queries
ITPUB
ITPUB
Oct 20, 2019 · Artificial Intelligence

How NL2SQL Is Revolutionizing Database Queries: Past, Present, and Future

NL2SQL converts natural language questions into executable SQL, bridging the gap between users and databases; the article reviews its value, historical roots, academic positioning, major datasets, current models, challenges, and future directions, highlighting its potential to reshape data interaction across industries.

AIDatasetsNL2SQL
0 likes · 16 min read
How NL2SQL Is Revolutionizing Database Queries: Past, Present, and Future
Big Data Technology Architecture
Big Data Technology Architecture
Oct 15, 2019 · Big Data

Introduction to Apache Kylin: A Fast Big Data OLAP Engine

Apache Kylin is an open‑source, Hadoop‑based OLAP engine that provides sub‑second, multi‑dimensional SQL queries on massive datasets, with features such as cube pre‑computation, real‑time analytics, and seamless BI tool integration, and its latest v2.6.4 release adds numerous fixes and improvements.

Apache KylinBI IntegrationHadoop
0 likes · 4 min read
Introduction to Apache Kylin: A Fast Big Data OLAP Engine
ITPUB
ITPUB
Oct 14, 2019 · Databases

Why Oracle Throws Mysterious Errors and How to Fix Them

The article shares a database expert’s experience with three types of Oracle bugs—internal errors, slow execution plans, and incorrect results—explains why they occur, offers concrete fixes such as patching and session parameters, and outlines essential skills for reliable SQL development.

Database BugsOracleoptimization
0 likes · 9 min read
Why Oracle Throws Mysterious Errors and How to Fix Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 14, 2019 · Databases

Analyzing MySQL InnoDB Thread Concurrency Issues and Their Resolution

This article examines a MySQL performance problem where frequent requests become unresponsive, analyzes processlist, system I/O/CPU metrics, and pstack traces to identify InnoDB thread concurrency and concurrency tickets as the root cause, then explains the relevant parameters, configuration guidelines, and a simulated test to demonstrate the solution.

InnoDBdebuggingmysql
0 likes · 25 min read
Analyzing MySQL InnoDB Thread Concurrency Issues and Their Resolution
Programmer DD
Programmer DD
Oct 11, 2019 · Databases

Understanding MySQL Transaction Isolation Levels: ACID, Tests, and Practical Guide

This article explains the concept of database transactions, the ACID properties, details MySQL’s four isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—and provides step‑by‑step command‑line experiments demonstrating phenomena such as dirty reads, non‑repeatable reads, phantom reads, and serialization effects.

ACIDIsolation Levelmysql
0 likes · 9 min read
Understanding MySQL Transaction Isolation Levels: ACID, Tests, and Practical Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 9, 2019 · Databases

Guide to MySQL InnoDB Tablespace Encryption: Overview, Configuration, Key Management, Import/Export, Backup and Restore

This article provides a comprehensive guide to MySQL InnoDB tablespace encryption, covering its architecture, supported plugins, configuration steps, key rotation, limitations, encrypted table operations, import/export procedures, and backup/restore methods using mysqlbackup and innobackupex.

BackupInnoDBRestore
0 likes · 17 min read
Guide to MySQL InnoDB Tablespace Encryption: Overview, Configuration, Key Management, Import/Export, Backup and Restore
HomeTech
HomeTech
Oct 9, 2019 · Big Data

Design and Implementation of a Flink‑Based Real‑Time Data Platform at Autohome

This article describes how Autohome migrated its real‑time analytics from Storm to a Flink‑SQL platform, detailing the architectural design, development and operational advantages, practical use cases such as recommendation metrics, and future plans for ecosystem expansion and open‑source release.

FlinkReal-time Streamingdata-warehouse
0 likes · 12 min read
Design and Implementation of a Flink‑Based Real‑Time Data Platform at Autohome
Big Data Technology & Architecture
Big Data Technology & Architecture
Oct 3, 2019 · Big Data

Data Development Interview Tips and Career Guidance

This article offers practical advice for data development job interviews, explaining why Java is essential, comparing Java and Python, outlining required backend framework knowledge, discussing the role of SQL and data warehousing, and addressing work‑life concerns such as overtime and company size choices.

Big DataPythoncareer advice
0 likes · 4 min read
Data Development Interview Tips and Career Guidance
NetEase Game Operations Platform
NetEase Game Operations Platform
Sep 28, 2019 · Databases

Introducing mycli: A Feature‑Rich MySQL Command‑Line Client

This article introduces mycli, a Python‑based MySQL command‑line client that offers easy installation via pip, advanced auto‑completion, high‑risk operation confirmations, customizable syntax highlighting, output paging, command bookmarking, logging, multiline editing, flexible credential handling, and additional features such as SSL support and query looping.

Database ToolsMyCLIauto-completion
0 likes · 9 min read
Introducing mycli: A Feature‑Rich MySQL Command‑Line Client
Xueersi Online School Tech Team
Xueersi Online School Tech Team
Sep 27, 2019 · Big Data

Design Principles and Architecture of Apache Kylin for Sub‑Second OLAP Queries

This article explains how Apache Kylin, an open‑source distributed analytics engine built on Hadoop/Spark, achieves sub‑second OLAP query performance through pre‑computed cubes, a layered cuboid generation algorithm, bitmap‑based distinct counting, dimension optimization techniques, and tight integration with HBase for storage and fast SQL querying.

Apache KylinBig DataCube
0 likes · 15 min read
Design Principles and Architecture of Apache Kylin for Sub‑Second OLAP Queries
ITPUB
ITPUB
Sep 27, 2019 · Artificial Intelligence

How Didi and Ant Financial Co‑Built SQLFlow to Bring AI to Data Analysts

The article describes how Didi's data science team partnered with Ant Financial to open‑source SQLFlow, a tool that translates SQL into Python for AI model training and inference, enabling analysts to use familiar SQL to run deep‑learning, XGBoost, and clustering models across diverse business scenarios.

AIData ScienceSQLFlow
0 likes · 9 min read
How Didi and Ant Financial Co‑Built SQLFlow to Bring AI to Data Analysts
Programmer DD
Programmer DD
Sep 27, 2019 · Databases

How to Use MySQL User Variables for Cumulative Daily User Counts

This article explains how to calculate cumulative daily user totals in MySQL using user-defined variables, demonstrates the necessary SQL queries, compares them with a Java‑style algorithm, and highlights important considerations such as variable initialization and practical pitfalls.

cumulative sumdaily active usersdatabase
0 likes · 6 min read
How to Use MySQL User Variables for Cumulative Daily User Counts
ITPUB
ITPUB
Sep 19, 2019 · Databases

Why Hash Join Beats Nested Loop in MySQL 8.0 – Faster Queries & New EXPLAIN ANALYZE

MySQL 8.0 introduces Hash Join for dramatically faster large‑dataset queries, supports in‑memory and spill‑to‑disk processing, can replace Block Nested‑Loop joins, and adds EXPLAIN ANALYZE with detailed runtime statistics and tree‑style output, highlighting the platform’s rapid evolution.

Database PerformanceEXPLAIN ANALYZEHash Join
0 likes · 3 min read
Why Hash Join Beats Nested Loop in MySQL 8.0 – Faster Queries & New EXPLAIN ANALYZE
21CTO
21CTO
Sep 17, 2019 · Databases

Which Databases Dominated 2019? Rankings, Trends, and Management Insights

This article examines the most popular open‑source and commercial database systems in 2019, presents DB‑Engines rankings, explores single versus hybrid strategies, highlights popular SQL‑NoSQL combos, and identifies the most time‑consuming DBA tasks and key performance metrics.

NoSQLcommercialdatabases
0 likes · 7 min read
Which Databases Dominated 2019? Rankings, Trends, and Management Insights
FunTester
FunTester
Sep 12, 2019 · Backend Development

Scraping HTML Tables with Java Regex and Generating SQL Inserts

The article walks through a Java solution for extracting multilingual data from an HTML table using regular expressions, handling spacing and encoding issues, splitting fields, and constructing INSERT statements to populate a country_code database table.

BackendData ExtractionWeb Scraping
0 likes · 6 min read
Scraping HTML Tables with Java Regex and Generating SQL Inserts
dbaplus Community
dbaplus Community
Sep 7, 2019 · Databases

How to Streamline DBA Code Reviews and Reclaim Your Weekends

A busy DBA can reduce weekend firefights by automating SQL code formatting, detecting injection risks, assessing performance impact, and fostering a collaborative review culture with developers through testing frameworks and knowledge‑sharing sessions.

Code reviewDatabase Administrationautomation
0 likes · 7 min read
How to Streamline DBA Code Reviews and Reclaim Your Weekends
DataFunTalk
DataFunTalk
Sep 5, 2019 · Big Data

Apache Beam Architecture Principles and Practical Application

This article introduces Apache Beam as a unified programming model for batch and streaming data processing, explains its architecture, core components, advantages, extensibility, and demonstrates practical usage with KafkaIO, BeamSQL, and AIoT scenarios across multiple runners.

Apache BeamKafkaStreaming
0 likes · 16 min read
Apache Beam Architecture Principles and Practical Application
Architect's Tech Stack
Architect's Tech Stack
Sep 3, 2019 · Databases

Practical MySQL Slow Query Optimization: Case Studies and Techniques

This article presents a step‑by‑step analysis of several real‑world MySQL slow‑query problems, demonstrates how to reproduce the issues, examines execution plans, applies concrete optimizations such as removing function calls, adjusting date comparisons, adding bigint indexes, and explains the impact of different EXPLAIN types on performance.

database indexingexplainmysql
0 likes · 12 min read
Practical MySQL Slow Query Optimization: Case Studies and Techniques
Efficient Ops
Efficient Ops
Sep 2, 2019 · Databases

Master MySQL Optimization: Strategies, Tools, and Best Practices

This comprehensive guide explains MySQL optimization philosophy, required participants, key dimensions, essential tools, step‑by‑step tuning procedures, hardware and system tuning, and detailed MySQL and InnoDB parameter settings to improve performance and reliability.

Database Optimizationmysqlperformance tuning
0 likes · 18 min read
Master MySQL Optimization: Strategies, Tools, and Best Practices
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 2, 2019 · Databases

Apache Phoenix Tutorial: Quick Start, Data Types, DML, Indexes, Salted Tables, and Advanced Features

This comprehensive guide introduces Apache Phoenix as an HBase SQL layer, covering quick‑start steps, supported data types, DML syntax, salted tables to prevent hotspots, various secondary index types, bulk‑load methods, auto‑increment IDs, dynamic columns, pagination, query plan analysis, and data migration techniques.

Apache PhoenixData MigrationHBase
0 likes · 33 min read
Apache Phoenix Tutorial: Quick Start, Data Types, DML, Indexes, Salted Tables, and Advanced Features
dbaplus Community
dbaplus Community
Aug 29, 2019 · Databases

Inside PostgreSQL: How Queries Are Parsed, Optimized, and Executed

This article walks through PostgreSQL’s query processing pipeline—from parsing SQL into relational algebra, through semantic analysis, query rewriting, optimization techniques like sub‑query elimination and join ordering, to the executor’s sequential scan algorithm—illustrating each step with code snippets and diagrams.

Database OptimizerQuery ProcessingRelational Algebra
0 likes · 14 min read
Inside PostgreSQL: How Queries Are Parsed, Optimized, and Executed
Big Data Technology Architecture
Big Data Technology Architecture
Aug 29, 2019 · Databases

19 Common MySQL Optimization Techniques

This article presents nineteen practical MySQL optimization methods—including using EXPLAIN, limiting IN clause size, specifying columns in SELECT, proper use of LIMIT, avoiding costly ORDER BY RAND(), choosing between IN and EXISTS, leveraging full‑text indexes, and applying join and index best practices—to improve query performance and reduce resource consumption.

databaseindexesmysql
0 likes · 11 min read
19 Common MySQL Optimization Techniques
Liangxu Linux
Liangxu Linux
Aug 27, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

This guide compiles nineteen practical MySQL optimization tips—from using EXPLAIN and avoiding costly IN clauses to leveraging full‑text indexes, proper pagination, and join strategies—providing concrete SQL examples and actionable advice to improve query performance and reduce resource consumption.

Query Tuningindexingmysql
0 likes · 11 min read
19 Essential MySQL Optimization Techniques Every Developer Should Know
360 Tech Engineering
360 Tech Engineering
Aug 27, 2019 · Databases

Quicksql: A Unified Cross‑Data‑Source SQL Query Engine

Quicksql is an open‑source, cross‑data‑source SQL engine built on Apache Calcite that provides a unified, safe, and fast SQL interface, enabling users to query heterogeneous storage systems such as Hive, MySQL, Elasticsearch, and Druid through command‑line, API, or JDBC connections.

Apache CalciteData IntegrationUnified Query Engine
0 likes · 6 min read
Quicksql: A Unified Cross‑Data‑Source SQL Query Engine
macrozheng
macrozheng
Aug 16, 2019 · Databases

Designing Home Page Recommendation Tables: SQL Schemas Explained

This article details the database table structures used for managing various homepage recommendation features—including brand, new product, popular product, subject, and advertisement tables—providing full MySQL DDL statements, field descriptions, and visual examples of both admin and mobile interfaces.

Database designbackend-developmenthome page
0 likes · 6 min read
Designing Home Page Recommendation Tables: SQL Schemas Explained
Efficient Ops
Efficient Ops
Aug 15, 2019 · Fundamentals

Master SQL SELECT: 10 Steps to Understand Execution Order and Joins

This comprehensive guide explains how SQL's declarative nature, the mismatch between syntax and execution order, table references, various join types, derived tables, GROUP BY behavior, and key keywords like DISTINCT, UNION, ORDER BY, and OFFSET work together to help readers master SELECT statements.

Database FundamentalsJoinsQuery Execution
0 likes · 20 min read
Master SQL SELECT: 10 Steps to Understand Execution Order and Joins
DevOps Cloud Academy
DevOps Cloud Academy
Aug 13, 2019 · Databases

Step‑by‑Step Guide to Installing Oracle 12c Database on Linux

This article provides a comprehensive, ordered tutorial for preparing the environment, configuring the root and oracle users, adjusting kernel and system limits, and finally installing and initializing Oracle 12c on a Linux server using detailed command‑line instructions.

Database InstallationLinuxOracle
0 likes · 5 min read
Step‑by‑Step Guide to Installing Oracle 12c Database on Linux
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 12, 2019 · Big Data

Spark SQL Parameter Tuning and Performance Optimization (Spark 2.3.2)

This article explains how to troubleshoot and tune Spark SQL configuration parameters—covering exception‑related settings such as spark.sql.hive.convertMetastoreParquet, file‑ignore options, and partition verification, as well as performance‑focused tweaks like broadcast join thresholds, adaptive execution, and parquet schema merging—while providing a comprehensive parameter reference table.

Big DataHive MigrationParameter Tuning
0 likes · 23 min read
Spark SQL Parameter Tuning and Performance Optimization (Spark 2.3.2)
macrozheng
macrozheng
Aug 9, 2019 · Databases

Mastering Coupon System Design: Database Schemas and UI Integration

This article provides a comprehensive walkthrough of the coupon feature's database tables—including definitions for coupons, coupon history, product relations, and category relations—along with screenshots of both admin and mobile interfaces that illustrate how these tables are used in an e‑commerce system.

Coupondatabase schemae‑commerce
0 likes · 6 min read
Mastering Coupon System Design: Database Schemas and UI Integration
Java Captain
Java Captain
Aug 7, 2019 · Databases

Practical Guide to Group, Join, and CASE WHEN Queries in SQL

This article provides a beginner‑friendly, step‑by‑step tutorial on common SQL operations—including GROUP BY aggregation, JOIN types, CASE WHEN expressions, and useful built‑in functions—illustrated with clear examples, typical pitfalls, and ready‑to‑use code snippets.

CASE WHENDatabase tutorialGROUP BY
0 likes · 10 min read
Practical Guide to Group, Join, and CASE WHEN Queries in SQL
21CTO
21CTO
Aug 6, 2019 · Databases

Why SQL Is Making a Comeback: From NoSQL’s Rise to the New Data Era

This article explores the resurgence of SQL, tracing its historical roots, the rise and limitations of NoSQL, and how modern cloud and NewSQL solutions are re‑establishing SQL as the universal interface for data storage, processing, and analysis.

NewSQLNoSQLdata engineering
0 likes · 14 min read
Why SQL Is Making a Comeback: From NoSQL’s Rise to the New Data Era
Programmer DD
Programmer DD
Aug 5, 2019 · Databases

Master MySQL Optimization: Practical Strategies to Boost Performance and Stability

This guide walks you through MySQL's query process, the philosophy and risks of optimization, the key participants, core dimensions such as hardware, system, schema and SQL, essential diagnostic tools, emergency and regular tuning steps, system‑level monitoring, kernel and user limits, as well as detailed MySQL and InnoDB configuration parameters for achieving high performance and reliability.

Database OptimizationSystem Administrationmysql
0 likes · 15 min read
Master MySQL Optimization: Practical Strategies to Boost Performance and Stability
Architects' Tech Alliance
Architects' Tech Alliance
Aug 4, 2019 · Databases

How Relational Databases Work: Architecture, Query Processing, and Transaction Management

This article explains the inner workings of relational databases, covering their architecture, indexing, time‑complexity analysis, query optimization, merge sort, client and query managers, caching strategies, transaction handling, ACID properties, concurrency control, and lock management.

Database ArchitectureRelational Databasesindexing
0 likes · 14 min read
How Relational Databases Work: Architecture, Query Processing, and Transaction Management
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2019 · Databases

Using MySQL 8.0 CLONE Plugin to Create Instance Replicas

This article explains how the MySQL 8.0 CLONE plugin simplifies creating reliable replica instances by installing the plugin, granting necessary privileges, executing the CLONE SQL statement, monitoring progress via performance_schema, and verifying successful completion of all clone stages.

Database ReplicationInnoDBPerformance Schema
0 likes · 12 min read
Using MySQL 8.0 CLONE Plugin to Create Instance Replicas
ITPUB
ITPUB
Jul 25, 2019 · Databases

Master Oracle Database: Create, Backup, Restore, and Manage Tables & Data

This guide provides step‑by‑step Oracle commands for creating and dropping databases, performing full and selective backups, restoring data locally or remotely, managing tables—including creation, deletion, renaming, column alterations, primary keys, indexes, and views—as well as querying, inserting, updating, deleting, and copying data efficiently.

BackupOracleRestore
0 likes · 8 min read
Master Oracle Database: Create, Backup, Restore, and Manage Tables & Data
macrozheng
macrozheng
Jul 25, 2019 · Databases

Mastering Order Return Database Design: Schemas, Statuses, and UI Flow

This article provides a comprehensive walkthrough of the order return and return‑reason database tables, detailing each field, status codes, and the corresponding admin and mobile UI screens that illustrate how the return process works in an e‑commerce system.

database schemae‑commerceorder return
0 likes · 7 min read
Mastering Order Return Database Design: Schemas, Statuses, and UI Flow
macrozheng
macrozheng
Jul 18, 2019 · Databases

Unlocking Order Management: Complete Database Schema for E‑Commerce Orders

This article provides a detailed analysis of the order-related database tables—including orders, order items, operation history, and order settings—along with their fields, data types, and meanings, and showcases how these tables are presented in both admin and mobile interfaces of an e‑commerce system.

Database designOrder Managementbackend-development
0 likes · 9 min read
Unlocking Order Management: Complete Database Schema for E‑Commerce Orders
macrozheng
macrozheng
Jul 16, 2019 · Backend Development

Unlocking E‑Commerce Product Management: Deep Dive into Database Schemas

This article walks through the core database tables that power product editing, SKU management, tiered pricing, full‑reduction discounts, member pricing, product reviews, verification records, and operation logs in an e‑commerce system, complete with SQL definitions and UI screenshots.

Database designbackend-developmentsql
0 likes · 14 min read
Unlocking E‑Commerce Product Management: Deep Dive into Database Schemas