BestHub
Sign in
Tagged articles

SQL

2820 articles · Page 22 of 29
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 16, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting

This article provides a thorough overview of MySQL performance tuning, covering proper table design according to the three normal forms, various index types and their creation, partitioning strategies, read/write separation, storage engine selection, and practical SQL tips for improving query efficiency.

IndexingMySQLPartitioning
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting
JavaEdge
JavaEdge
Jul 15, 2020 · Databases

Understanding MySQL Transaction Isolation Levels and Best Practices

This article explains MySQL transaction isolation concepts, the four standard isolation levels, their effects on dirty, non‑repeatable, and phantom reads, practical configuration steps, when to use repeatable read, how InnoDB implements isolation, and tips for avoiding long transactions and planning backups.

InnoDBMySQLSQL
0 likes · 8 min read
Understanding MySQL Transaction Isolation Levels and Best Practices
ITPUB
ITPUB
Jul 15, 2020 · Databases

Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization

This guide compiles essential MySQL optimization techniques—including index cardinality, function indexes, EXPLAIN usage, covering indexes, ICP, slow‑query log analysis, online schema changes, and common SQL pitfalls—to help developers efficiently tune database performance.

EXPLAINIndexesMySQL
0 likes · 19 min read
Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization
dbaplus Community
dbaplus Community
Jul 12, 2020 · Databases

Automating Oracle SQL Review with SOAR: A Step‑by‑Step Guide

To streamline Oracle SQL script reviews, this guide shows how to adapt the open‑source SOAR tool—originally built for MySQL—by defining custom rules, installing Go and Git, compiling the source, and integrating a web UI, enabling automated, 90% coverage of Oracle SQL checks.

OracleSOARSQL
0 likes · 8 min read
Automating Oracle SQL Review with SOAR: A Step‑by‑Step Guide
Java Captain
Java Captain
Jul 12, 2020 · Databases

Optimizing Existence Checks: Replace COUNT(*) with SELECT 1 LIMIT 1

The article explains why using COUNT(*) to test record existence is inefficient and demonstrates an optimized approach that replaces COUNT(*) with SELECT 1 LIMIT 1 in SQL and a corresponding null‑check in Java, improving database performance especially when many rows match the condition.

JavaOptimizationPerformance
0 likes · 3 min read
Optimizing Existence Checks: Replace COUNT(*) with SELECT 1 LIMIT 1
AntTech
AntTech
Jul 10, 2020 · Artificial Intelligence

SQLFlow: End‑to‑End AI Workflow Construction Using SQL

SQLFlow is an open‑source system that lets users describe and execute end‑to‑end AI tasks—including data extraction, preprocessing, model training, evaluation, prediction, and explanation—entirely with SQL, simplifying workflow construction across multiple databases and machine‑learning engines while supporting scalable execution on Kubernetes.

AI workflowKubernetesSQL
0 likes · 19 min read
SQLFlow: End‑to‑End AI Workflow Construction Using SQL
FunTester
FunTester
Jul 9, 2020 · Backend Development

Multithreaded Test Case Execution and Database Standards

The article shares practical experiences on running test cases concurrently using Java multithreading and a custom thread pool, and outlines MySQL database naming, null handling, and schema design guidelines, including full code examples for the case runner and thread pool implementation.

Database DesignJavaMultithreading
0 likes · 7 min read
Multithreaded Test Case Execution and Database Standards
Big Data Technology Architecture
Big Data Technology Architecture
Jul 8, 2020 · Big Data

Apache Flink 1.11.0 Release: New Features and Optimizations

Apache Flink 1.11.0 introduces a suite of major enhancements—including unaligned checkpoints, a unified source interface, CDC support in Table API/SQL, performance‑boosted PyFlink, a new application deployment mode, and numerous UI, Docker, and catalog improvements—aimed at increasing usability, scalability, and integration across streaming and batch workloads.

FlinkSQLSource Interface
0 likes · 18 min read
Apache Flink 1.11.0 Release: New Features and Optimizations
Java Backend Technology
Java Backend Technology
Jul 7, 2020 · Databases

Why Your SQL Queries Are Slow: 10 Hidden Factors and How to Fix Them

This article analyzes the various system‑level and database‑level reasons why SELECT, UPDATE, INSERT, or DELETE statements become slow, covering network issues, OS and hardware constraints, MySQL configuration, indexing, execution plans, and query design, and offers practical mitigation strategies.

MySQLSQLSlow Query
0 likes · 18 min read
Why Your SQL Queries Are Slow: 10 Hidden Factors and How to Fix Them
JavaEdge
JavaEdge
Jul 4, 2020 · Databases

How MySQL Executes a Query: From Connection to Execution Engine

This article explains MySQL’s internal workflow, covering the Server layer components, Storage Engine layer, connection handling, query cache behavior, lexical and syntax parsing, optimization decisions, and execution steps, including tips for long‑connection management and common pitfalls.

Connection ManagementDatabase InternalsMySQL
0 likes · 9 min read
How MySQL Executes a Query: From Connection to Execution Engine
dbaplus Community
dbaplus Community
Jul 4, 2020 · Databases

Mastering Oracle 19c Hot Clone: A Complete Step‑by‑Step Guide

This article explains the background of Oracle 19c hot clone, lists the prerequisites, details the three‑phase cloning process, provides exhaustive local, remote, subset and refreshable PDB scenarios with exact SQL commands, highlights common errors and their solutions, and concludes with best‑practice recommendations.

Hot CloneOraclePdb
0 likes · 21 min read
Mastering Oracle 19c Hot Clone: A Complete Step‑by‑Step Guide
Youzan Coder
Youzan Coder
Jul 1, 2020 · Big Data

Mastering HiveCube: Efficient Multi‑Dimensional Aggregation with Grouping Sets

This article explains how HiveCube can replace traditional development for multi‑dimensional aggregation in a data‑warehouse, covering background, theory of cube, with‑cube/rollup/grouping‑sets syntax, grouping_id handling, practical implementation tips, performance tuning, and a comparison with conventional methods.

Big DataCubeData Warehouse
0 likes · 19 min read
Mastering HiveCube: Efficient Multi‑Dimensional Aggregation with Grouping Sets
DataFunTalk
DataFunTalk
Jun 30, 2020 · Big Data

Flink Real‑Time Data Warehouse Practices at Shopee Singapore Data Team

This article details Shopee Singapore Data Team’s implementation of a Flink‑based real‑time data warehouse, covering background challenges, layered architecture integrating Kafka, HBase, Druid, Hive, streaming pipelines, job management, monitoring, and future plans to expand Flink SQL support.

Data WarehouseFlinkReal-time
0 likes · 15 min read
Flink Real‑Time Data Warehouse Practices at Shopee Singapore Data Team
Java High-Performance Architecture
Java High-Performance Architecture
Jun 30, 2020 · Databases

Mastering SQL: The 6-Step Process Behind Every SELECT Query

This article walks through the complete lifecycle of a SQL SELECT statement—using simple Citizen and City tables—to illustrate the six processing stages (FROM/JOIN, WHERE, GROUP BY, HAVING, SELECT, ORDER BY/LIMIT), showing how each clause transforms the data step by step.

Database FundamentalsQuery ExecutionRelational Databases
0 likes · 5 min read
Mastering SQL: The 6-Step Process Behind Every SELECT Query
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 26, 2020 · Databases

Understanding MySQL Query Execution Process and Optimization

This article explains how MySQL processes a SELECT statement—from client request, cache check, parsing, optimization, and execution—to return results, using a sample User table, a detailed query example, and a step‑by‑step walkthrough of the parser, optimizer, and executor components.

Execution PlanMySQLQuery Optimization
0 likes · 9 min read
Understanding MySQL Query Execution Process and Optimization
Java Captain
Java Captain
Jun 23, 2020 · Databases

SQL Basics: Concepts, Syntax, and Common Commands

This article provides a concise overview of relational database fundamentals, covering key terminology, the structure of SQL statements, essential DDL/DML/TCL/DCL commands, query operators, joins, subqueries, functions, indexing, constraints, transactions, permissions, stored procedures, cursors, and triggers, with practical code examples throughout.

DDLDMLSQL
0 likes · 30 min read
SQL Basics: Concepts, Syntax, and Common Commands
Programmer DD
Programmer DD
Jun 23, 2020 · Databases

Master MySQL Basics: Schemas, Data Types, and Full CRUD Guide

This article provides a comprehensive MySQL tutorial covering schema concepts, data types, service control, database creation, table manipulation, and complete CRUD operations with practical command‑line examples and code snippets for beginners and intermediate users.

CRUDCommandsData Types
0 likes · 15 min read
Master MySQL Basics: Schemas, Data Types, and Full CRUD Guide
Java Captain
Java Captain
Jun 21, 2020 · Databases

Why Using SELECT * Is Inefficient in MySQL and How Indexes Improve Performance

Although many developers hear the advice to avoid using SELECT * in SQL, this article delves into the underlying reasons—such as increased parsing cost, unnecessary data transfer, extra I/O, and loss of covering-index optimization—while also explaining index concepts and best practices for MySQL performance.

Database PerformanceIndex OptimizationMySQL
0 likes · 10 min read
Why Using SELECT * Is Inefficient in MySQL and How Indexes Improve Performance
FunTester
FunTester
Jun 20, 2020 · Backend Development

Mastering MySQL CASE WHEN and MyBatis Dynamic Queries for Test Case Search

This article walks through building complex test‑case search queries using MySQL CASE WHEN, FIND_IN_SET, and MyBatis dynamic SQL, demonstrates converting asynchronous data fetches to synchronous calls with CountDownLatch in Spring, and provides complete Java bean and configuration examples.

JavaMyBatisMySQL
0 likes · 9 min read
Mastering MySQL CASE WHEN and MyBatis Dynamic Queries for Test Case Search
Java Backend Technology
Java Backend Technology
Jun 20, 2020 · Databases

What’s the Real Execution Order of SQL Queries? A Visual Guide

Although most SQL statements begin with SELECT, the actual execution follows a specific order—WHERE, GROUP BY, HAVING, then SELECT—illustrated by a diagram that also clarifies common misconceptions about filtering window functions, column aliases, and how databases may reorder operations for optimization.

LINQOptimizationPandas
0 likes · 6 min read
What’s the Real Execution Order of SQL Queries? A Visual Guide
ITPUB
ITPUB
Jun 19, 2020 · Databases

Mastering SQL Analytic Functions: Windows, PARTITION, ROWS vs RANGE Explained

This guide explains how SQL analytic (window) functions work, covering the concepts of current row, logical and physical windows, PARTITION, ORDER BY, the differences between ROWS and RANGE, window clause variations, and their advantages and drawbacks.

Analytic FunctionsDatabasesOracle
0 likes · 12 min read
Mastering SQL Analytic Functions: Windows, PARTITION, ROWS vs RANGE Explained
FunTester
FunTester
Jun 18, 2020 · Backend Development

How to Read a Map from MySQL with MyBatis and Resolve ClassCastException

This article walks through extracting service‑host mappings from MySQL using MyBatis, handling a Long‑to‑String conversion error, and demonstrates an insert‑select SQL pattern that requires column aliases to avoid duplicate‑column errors, complete with XML and Java code examples.

Data MappingJavaMyBatis
0 likes · 6 min read
How to Read a Map from MySQL with MyBatis and Resolve ClassCastException
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 17, 2020 · Databases

How to Safely Rename a MySQL Database

This article explains several reliable techniques for renaming a MySQL database—including full export/import with mysqldump, bulk table‑rename operations, and legacy binlog‑based approaches—while providing concrete command‑line examples, performance measurements, and step‑by‑step instructions for each method.

Database RenameMigrationMySQL
0 likes · 9 min read
How to Safely Rename a MySQL Database
MaGe Linux Operations
MaGe Linux Operations
Jun 16, 2020 · Databases

How to Benchmark MySQL Performance with mysqlslap and Sysbench

This guide explains how to use MySQL's built‑in mysqlslap tool and the third‑party sysbench utility to simulate concurrent client loads, adjust server settings, run read/write and I/O tests, and interpret the resulting performance metrics for database optimization.

IO testingMySQLSQL
0 likes · 14 min read
How to Benchmark MySQL Performance with mysqlslap and Sysbench
Top Architect
Top Architect
Jun 16, 2020 · Databases

Performance Evaluation of Multi-Table Joins in MySQL and Oracle with Large Datasets

This article investigates the Alibaba Java Development Manual's recommendation against joining more than three tables by experimentally evaluating multi-table join performance in MySQL and Oracle using massive synthetic datasets, analyzing query execution times, indexing effects, and providing data generation scripts and detailed results.

Data GenerationMySQLOracle
0 likes · 13 min read
Performance Evaluation of Multi-Table Joins in MySQL and Oracle with Large Datasets
FunTester
FunTester
Jun 16, 2020 · Backend Development

Managing Test User Module Data with MyBatis XML and Java Bean

The article details how to handle test user module data by converting ID fields to strings, validating optional parameters, and configuring complex MyBatis XML mappings alongside a Java bean, illustrating the full workflow from requirements to implementation and testing.

JavaMyBatisSQL
0 likes · 6 min read
Managing Test User Module Data with MyBatis XML and Java Bean
ITPUB
ITPUB
Jun 15, 2020 · Databases

Why Does Alibaba's Java Manual Ban Joins Over Three Tables? A Deep Performance Dive

This article investigates Alibaba's recommendation against joining more than three MySQL tables by designing experiments with synthetic data, measuring query performance on MySQL and Oracle, analyzing index impact, and providing full DDL and data‑generation scripts to explain the rule's practical limits.

Data GenerationJOINMySQL
0 likes · 11 min read
Why Does Alibaba's Java Manual Ban Joins Over Three Tables? A Deep Performance Dive
ITPUB
ITPUB
Jun 13, 2020 · Databases

Why Does Alibaba Recommend No More Than Three Table Joins? MySQL vs Oracle Performance Test

The article investigates the Alibaba Java development manual's rule that joins involving more than three tables are prohibited, by designing massive MySQL and Oracle experiments, generating billions of rows, measuring query times, analyzing indexing effects, and concluding that the rule is MySQL‑specific and driven by large‑scale performance limits.

Join PerformanceMySQLOracle
0 likes · 11 min read
Why Does Alibaba Recommend No More Than Three Table Joins? MySQL vs Oracle Performance Test
Beike Product & Technology
Beike Product & Technology
Jun 12, 2020 · Big Data

Design and Implementation of SQL on Streaming (SQL 1.0 → SQL 2.0) in a Real‑Time Computing Platform

This article describes the evolution of a real‑time computing platform from SQL 1.0 built on Spark Structured Streaming to SQL 2.0 powered by Flink‑SQL, covering dynamic tables, continuous queries, dimension‑table joins, cache optimization, DDL extensions, platformization, operational challenges and future roadmap.

Big DataData EngineeringDimension Table
0 likes · 19 min read
Design and Implementation of SQL on Streaming (SQL 1.0 → SQL 2.0) in a Real‑Time Computing Platform
ITPUB
ITPUB
Jun 10, 2020 · Databases

When Should You Use Foreign Keys? Benefits, Risks, and Performance Impact

This article explains what foreign keys are, how they enforce referential integrity in relational databases, the different actions (RESTRICT, CASCADE, SET NULL), their performance overhead demonstrated by benchmarks, and practical guidelines for simulating or using foreign keys in high‑concurrency applications.

CascadingDatabase DesignForeign Key
0 likes · 14 min read
When Should You Use Foreign Keys? Benefits, Risks, and Performance Impact
DataFunTalk
DataFunTalk
Jun 7, 2020 · Databases

ByteKV: Design and Implementation of a Strongly Consistent Range-Partitioned KV Store

ByteKV is a C++-based, strongly consistent, range-partitioned key‑value storage system built by ByteDance, featuring a multi‑Raft consensus layer, custom storage engines (RocksDB and BlockDB), automatic partition splitting/merging, load balancing, distributed transactions, and a SQL table layer for rich data models.

ConsensusKey-Value StorePartitioning
0 likes · 47 min read
ByteKV: Design and Implementation of a Strongly Consistent Range-Partitioned KV Store
Selected Java Interview Questions
Selected Java Interview Questions
Jun 6, 2020 · Backend Development

Java Backend Interview Preparation Guide: Frameworks, Distributed Systems, and Performance Optimization

This article provides a comprehensive guide for Java backend interview preparation, covering essential framework experience, distributed technology basics, database performance tuning, core Java concepts, Linux log troubleshooting, and how to showcase practical project experience to stand out to interviewers.

SQLdistributed-systemsframeworks
0 likes · 13 min read
Java Backend Interview Preparation Guide: Frameworks, Distributed Systems, and Performance Optimization
Architects Research Society
Architects Research Society
Jun 2, 2020 · Databases

Understanding Database Isolation Levels and Dirty Reads

This article explains the concepts of isolation levels, dirty reads, and phantom reads across various relational and NoSQL databases, describing how each system implements or lacks transaction isolation and the practical impact on data consistency and performance.

NoSQLSQLTransaction
0 likes · 17 min read
Understanding Database Isolation Levels and Dirty Reads
macrozheng
macrozheng
Jun 1, 2020 · Databases

Master DataGrip: Essential Tips for Efficient MySQL & MongoDB Management

This guide walks you through downloading DataGrip, configuring its appearance, creating MySQL and MongoDB data sources, managing tables, applying powerful SQL editing shortcuts, and leveraging export and execution‑plan features to write higher‑quality database code.

DataGripDatabase ToolsMongoDB
0 likes · 7 min read
Master DataGrip: Essential Tips for Efficient MySQL & MongoDB Management
Java Backend Technology
Java Backend Technology
May 28, 2020 · Databases

When Stored Procedures Turn Into a Maintenance Nightmare

An engineer recounts a real‑world challenge of reusing existing SQL stored procedures to check a user's job, certification, and disclosure status, explores why inserting results into temporary tables can cause maintenance headaches, and concludes that moving business logic out of the database often yields cleaner, more maintainable code.

Code ReuseDatabase DesignPerformance
0 likes · 6 min read
When Stored Procedures Turn Into a Maintenance Nightmare
ITPUB
ITPUB
May 26, 2020 · Databases

40 Proven Oracle SQL Optimization Tips to Supercharge Query Performance

This guide walks through Oracle SQL execution steps, optimizer selection, table access methods, shared SQL caching, join order, index usage, query rewriting techniques, hint usage, and dozens of practical tips that together dramatically improve database performance while avoiding common pitfalls.

OptimizationOraclePerformance
0 likes · 25 min read
40 Proven Oracle SQL Optimization Tips to Supercharge Query Performance
Programmer DD
Programmer DD
May 26, 2020 · Databases

Why Reusing Stored Procedures Can Be a Pitfall: Lessons from Real Projects

The article examines the drawbacks of reusing stored procedures for business logic, illustrates maintenance challenges with example code, and argues that moving simple existence checks to the database while keeping complex logic in application code yields better readability, extensibility, and performance.

Code ReuseDatabase DesignSQL
0 likes · 6 min read
Why Reusing Stored Procedures Can Be a Pitfall: Lessons from Real Projects
Laravel Tech Community
Laravel Tech Community
May 25, 2020 · Databases

What’s New in SQLite 3.32.0? Key Features and Enhancements Explained

SQLite 3.32.0, the latest release of the world’s most widely used database engine, introduces approximate ANALYZE support, a bytecode virtual table, new SQL functions, expanded parameter limits, numerous CLI enhancements, and behavior changes that align the LIKE operator with PostgreSQL, offering developers richer functionality and improved compatibility.

CLI EnhancementsSQLSQLite
0 likes · 3 min read
What’s New in SQLite 3.32.0? Key Features and Enhancements Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
May 18, 2020 · Databases

Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)

This article explains the MySQL group_replication_consistency parameter, describes its five possible values, demonstrates the three most common consistency modes (EVENTUAL, BEFORE, AFTER) with practical multi‑node examples, and discusses their advantages, drawbacks, and impact on query latency and data integrity.

Group ReplicationMySQLSQL
0 likes · 13 min read
Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)
Programmer DD
Programmer DD
May 16, 2020 · Databases

Master Elasticsearch SQL: From Basic Queries to Advanced DSL Translations

This article walks through using Elasticsearch SQL to query data, covering installation, loading sample datasets, describing index schemas, executing simple and complex SQL queries with functions, converting SQL to Elasticsearch DSL, reindexing, alias management, and performance considerations, all illustrated with code snippets.

@DataElasticsearchKibana
0 likes · 15 min read
Master Elasticsearch SQL: From Basic Queries to Advanced DSL Translations
Top Architect
Top Architect
May 14, 2020 · Databases

Why Using Stored Procedures for Simple Boolean Checks Can Be Problematic

The article discusses a real‑world scenario where a developer tried to reuse existing stored procedures to determine the presence of Job, Certification, and Disclosure records, explores various T‑SQL techniques such as temporary tables and output parameters, and concludes that stored procedures are often unsuitable for simple boolean logic due to maintenance and reuse challenges.

C++Code ReusePerformance
0 likes · 6 min read
Why Using Stored Procedures for Simple Boolean Checks Can Be Problematic
Programmer DD
Programmer DD
May 12, 2020 · Backend Development

How to Integrate Dataway with Spring Boot for Zero‑Code API Configuration

This tutorial walks through integrating Dataway into a Spring Boot project, covering dependency setup, Dataway configuration, database table creation, data source integration, Hasor module registration, enabling Hasor, running the application, accessing the UI, and creating APIs using SQL or DataQL, all without writing custom code.

API ConfigurationDataQLDataway
0 likes · 14 min read
How to Integrate Dataway with Spring Boot for Zero‑Code API Configuration
Laravel Tech Community
Laravel Tech Community
Apr 30, 2020 · Databases

Essential MySQL FAQ: Core Concepts, Features, and Best Practices

This comprehensive MySQL FAQ covers its definition, implementation language, key features, differences from SQL, storage engines, data types, triggers, security tips, performance considerations, and practical queries such as retrieving the N‑th highest salary, providing a solid reference for developers and DBAs.

MySQLPerformanceSQL
0 likes · 14 min read
Essential MySQL FAQ: Core Concepts, Features, and Best Practices
ITPUB
ITPUB
Apr 25, 2020 · Databases

Master Oracle Database: Startup, Shutdown, Users, Tablespaces, Indexes, Views, and Partitions

This comprehensive guide walks you through essential Oracle database administration tasks—including starting and stopping the database, managing listeners, creating and altering tablespaces, handling users and privileges, controlling transactions, building indexes, defining views and materialized views, working with sequences, synonyms, and partitioned tables—complete with commands, examples, and best‑practice tips.

AdministrationOraclePartition
0 likes · 21 min read
Master Oracle Database: Startup, Shutdown, Users, Tablespaces, Indexes, Views, and Partitions
Amap Tech
Amap Tech
Apr 24, 2020 · Backend Development

Introducing the Java Development Manual (Taishan Edition): Unified Error Codes, Leap‑Year Pitfalls, SQL Alias, Code‑Style Tips, and Ternary‑Operator NPE Issues

The new Java Development Manual (Taishan Edition) adds 34 rules and revises 90 descriptions, introduces a unified five‑character error‑code scheme, warns about stream‑toMap and ternary‑operator null‑pointer traps, highlights leap‑year and SQL alias bugs, and recommends readability tweaks such as blank lines after returns.

Code styleError CodesJava
0 likes · 8 min read
Introducing the Java Development Manual (Taishan Edition): Unified Error Codes, Leap‑Year Pitfalls, SQL Alias, Code‑Style Tips, and Ternary‑Operator NPE Issues
Java Backend Technology
Java Backend Technology
Apr 23, 2020 · Databases

Why MySQL LIMIT Can Reverse ORDER BY in LEFT JOIN Queries

The author discovers a puzzling MySQL bug where moving the LIMIT clause outside a nested SELECT causes the final result set to be ordered incorrectly, explains how ORDER BY inside subqueries is ignored during LEFT JOIN processing, and recommends placing ORDER BY and LIMIT at the outermost query level.

JOINLIMITMySQL
0 likes · 5 min read
Why MySQL LIMIT Can Reverse ORDER BY in LEFT JOIN Queries
Programmer DD
Programmer DD
Apr 23, 2020 · Databases

How INSERT INTO SELECT Nearly Crashed a MySQL DB – Lessons & Fix

An engineer’s attempt to migrate millions of orders using INSERT INTO SELECT caused massive table locking, payment failures, and system alerts, but by analyzing the locking behavior and adding an index on the timestamp column, the migration succeeded efficiently, illustrating the importance of proper indexing for large‑scale data moves.

INSERT INTO SELECTIndexingLocking
0 likes · 7 min read
How INSERT INTO SELECT Nearly Crashed a MySQL DB – Lessons & Fix
Laravel Tech Community
Laravel Tech Community
Apr 22, 2020 · Backend Development

Laravel Log Quick Reference and SQL Query Logging Guide

This article provides a concise Laravel Log quick reference, detailing the seven RFC‑5424 log levels, usage examples, how to retrieve the Monolog instance, add listeners, and enable and fetch SQL query logs, followed by motivational reflections on perseverance and growth.

LaravelLoggingMonolog
0 likes · 2 min read
Laravel Log Quick Reference and SQL Query Logging Guide
ITPUB
ITPUB
Apr 22, 2020 · Databases

Master Oracle Database Essentials: Startup, Users, Tablespaces, Indexes & More

This guide walks through essential Oracle Database administration tasks, covering how to start and shut down the database and listener, create and manage tablespaces, users, and permissions, control transactions, build and maintain indexes, views, materialized views, sequences, synonyms, and partitioned tables, with command examples and best‑practice tips.

Database AdministrationIndexesOracle
0 likes · 21 min read
Master Oracle Database Essentials: Startup, Users, Tablespaces, Indexes & More
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 20, 2020 · Databases

Understanding and Managing Undo Tablespaces in MySQL 8.0

This article explains the concept of MySQL Undo Log, traces its evolution from version 5.5 to 8.0, and provides step‑by‑step instructions with examples for creating, viewing, configuring, deleting, and moving undo tablespaces, highlighting the new parameters and defaults introduced in MySQL 8.0.

InnoDBMySQLSQL
0 likes · 9 min read
Understanding and Managing Undo Tablespaces in MySQL 8.0
21CTO
21CTO
Apr 18, 2020 · Databases

How to Import FIFA18 Player Data from CSV into MySQL with Python

This step‑by‑step guide shows how to download the FIFA 18 player dataset from GitHub, create a MySQL database and table, read the CSV with Python’s csv.DictReader, generate INSERT statements, batch‑load the data efficiently, and query Argentine players, illustrating a complete end‑to‑end data‑import workflow.

CSVFIFA18MySQL
0 likes · 12 min read
How to Import FIFA18 Player Data from CSV into MySQL with Python
Architects Research Society
Architects Research Society
Apr 16, 2020 · Operations

Understanding SCADA Systems: Architecture, Evolution, and Modern Applications

SCADA (Supervisory Control and Data Acquisition) systems are essential industrial automation platforms that monitor and control processes across sectors such as energy, manufacturing, and water treatment, featuring sensor‑to‑PLC/RTU data flow, HMI interfaces, SQL integration, and modern web‑based capabilities exemplified by Ignition software.

HMIIgnitionSCADA
0 likes · 6 min read
Understanding SCADA Systems: Architecture, Evolution, and Modern Applications
Programmer DD
Programmer DD
Apr 14, 2020 · Databases

Understanding InnoDB Storage Architecture and MySQL Partitioning Strategies

This article explains InnoDB's logical storage hierarchy of tablespaces, segments, extents, and pages, then details MySQL's partitioning concepts, types, creation syntax, and performance considerations, providing practical examples and guidance for effective database design.

Database ArchitectureInnoDBMySQL
0 likes · 8 min read
Understanding InnoDB Storage Architecture and MySQL Partitioning Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 13, 2020 · Databases

How DBLE Implements MySQL View Functionality

This article explains how DBLE, a PaaS middleware, implements MySQL view capabilities by first describing MySQL view concepts and the MERGE and TEMPTABLE algorithms, then detailing DBLE's push‑down and non‑push‑down approaches, the criteria for each, and providing illustrative diagrams.

DBLEDatabase MiddlewareMySQL
0 likes · 5 min read
How DBLE Implements MySQL View Functionality
Liangxu Linux
Liangxu Linux
Apr 12, 2020 · Databases

Essential MySQL Performance Tuning Tools and How to Use Them

This guide introduces four open‑source MySQL tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run each tool, and shows how to interpret their AWR‑style reports for concrete performance and security improvements.

Database ToolsMySQLOptimization
0 likes · 9 min read
Essential MySQL Performance Tuning Tools and How to Use Them
Sohu Tech Products
Sohu Tech Products
Apr 8, 2020 · Fundamentals

Building an IntelliJ Plugin to Convert MySQL DDL into Python ORM Models Using Lexical Analysis

This article explains how to create a JetBrains IntelliJ plugin that parses MySQL DDL statements, performs lexical analysis to extract table and column information, and automatically generates corresponding Python ORM model classes, illustrating the underlying state‑machine lexer, recursive parsing logic, and sample code.

DDLIntelliJ PluginORM
0 likes · 9 min read
Building an IntelliJ Plugin to Convert MySQL DDL into Python ORM Models Using Lexical Analysis
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 3, 2020 · Databases

Understanding B+ Tree Indexes in MySQL

This article explains why B+ trees are the dominant data structure for MySQL indexes, compares them with hash tables, linked lists, and skip lists, and details page splits, merges, and how index values map to row records, helping readers master high‑frequency interview questions.

B+TreeData StructuresMySQL
0 likes · 14 min read
Understanding B+ Tree Indexes in MySQL
Qunar Tech Salon
Qunar Tech Salon
Apr 2, 2020 · Databases

30 Practical SQL Optimization Tips with Examples

This article presents thirty actionable SQL performance recommendations—including selecting specific columns, using LIMIT, avoiding OR and functions in WHERE clauses, proper indexing, batch inserts, and query planning—each illustrated with clear examples and explanations to help developers write faster, more efficient queries.

IndexingMySQLOptimization
0 likes · 19 min read
30 Practical SQL Optimization Tips with Examples