Tagged articles
triggers
31 articles · Page 1 of 1
After two decades of causing trigger failures during cascaded foreign‑key updates, MySQL Bug #11472 was finally resolved in March 2026, ending a long‑running saga that sparked countless community jokes, developer debates, and detailed reproduction steps.
Bug #11472Database BugsInnoDB
0 likes · 13 min read

This guide explains MySQL stored procedures, functions, and triggers—from core concepts and syntax to practical examples, debugging techniques, real‑world use cases, and best‑practice recommendations for naming, error handling, transaction management, and performance monitoring.
database optimizationfunctionsmysql
0 likes · 12 min read

This article explains MySQL triggers, stored procedures, and user-defined functions using relatable analogies—a wallet for triggers, pre-made meals for procedures, and a custom calculator for functions—complete with syntax templates, practical code examples for automated data logging, batch revenue calculation, and tiered commission logic, plus a selection guide for choosing the right tool.
SQLautomated loggingdatabase programming
0 likes · 11 min read

This guide explains the background, terminology, pre‑conditions, detailed step‑by‑step procedures, and rollback plan for executing reverse incremental migration from MySQL to OceanBase, covering trigger and foreign‑key handling, OMS operations, data validation, and how to safely switch traffic back to MySQL.
Foreign KeysOMSOceanBase
0 likes · 13 min read


21CTOJul 1, 2025 · Databases
A two‑decade‑old MySQL bug (bug 11472) that prevents triggers from firing on cascading foreign‑key updates has remained unfixed, sparking community frustration, debates over ACID compliance, and a shift toward alternatives like PostgreSQL in modern applications.
ACIDDatabase BugPostgreSQL
0 likes · 5 min read

This article thoroughly explains how the Percona pt-osc tool performs online schema changes in MySQL, analyzes trigger design, deadlock scenarios, data‑consistency issues, and provides detailed test cases, operational tips, and best‑practice recommendations for safe usage.
DDLOnline Schema Changemysql
0 likes · 26 min read

Database testing ensures data integrity, security, and quality by validating data mapping, ACID properties, schema, triggers, stored procedures, and field constraints through both manual and automated methods, using SQL queries, CRUD operations, and specialized tools to verify that applications interact correctly with underlying databases.
ACIDDatabase TestingSQL
0 likes · 13 min read

This article compiles essential MySQL interview questions covering primary and candidate keys, date functions, trigger limits, index column counts, data copying techniques, core MySQL concepts, feature highlights, transaction ACID properties, heap versus clustered tables, numeric type differences, and objects creatable with CREATE statements.
Heap TableInterview questionsPrimary Key
0 likes · 9 min read

Citus 11.0 makes the entire extension open source, adds a non‑blocking shard rebalancer, enables automatic schema and metadata synchronization so distributed queries can run on any cluster node, and introduces trigger support on distributed tables, with clear upgrade steps and deprecation notes.
CitusMetadata SyncPostgreSQL
0 likes · 15 min read

This article explains how to use Tekton Trigger to automatically start PipelineRuns from GitLab webhook events, covering the core components, CRD definitions, installation steps, and detailed configurations of TriggerTemplate, TriggerBinding, EventListener, ServiceAccount, Ingress, and secret management, enabling fully automated CI/CD on Kubernetes.
CI/CDCloud NativeGitLab
0 likes · 20 min read


ITPUBMar 10, 2022 · Databases
This article explains why querying the most recent record for a specific device in massive time‑series tables can be painfully slow in PostgreSQL, demonstrates the impact of using only a timestamp index, and presents several indexing and query‑design strategies—including composite indexes, lateral joins, SkipScan, recursive CTEs, and logging tables with triggers—to dramatically improve performance.
PostgreSQLSQLTime-Series
0 likes · 22 min read

This article explores multiple MySQL techniques—triggers with a counter table, range partitioning, general tablespace limits, and application‑side buffering—to enforce a hard cap of 10,000 rows per table, discussing implementation steps, code examples, and the trade‑offs of each method.
Partitioningdatabase designmysql
0 likes · 11 min read


ITPUBAug 18, 2021 · Databases
This comprehensive guide covers fundamental SQL concepts, syntax, and terminology, then walks through CRUD operations, subqueries, joins, unions, functions, ordering, grouping, data definition, transaction control, permission management, stored procedures, cursors, and triggers, providing clear examples for each.
CRUDJoinsSQL
0 likes · 28 min read

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

This article extends the concepts introduced in Streaming 101 by deeply exploring data processing patterns for unbounded data, covering windowing, watermarks, triggers, accumulation modes, and their practical implications for building robust low‑latency streaming pipelines.
WatermarksWindowingaccumulation
0 likes · 14 min read

This article provides a thorough overview of relational database fundamentals, covering basic concepts, SQL syntax, DML and DDL commands, functions, joins, unions, grouping, ordering, transactions, permission management, stored procedures, cursors, and triggers, complete with illustrative code examples.
DDLDMLSQL
0 likes · 21 min read

This article provides an extensive overview of MySQL, covering database creation, renaming, and deletion, table creation and alteration, column and index management, data queries, inserts, updates, deletes, operator usage, view handling, functions, stored procedures, triggers, sequence generation, user management, and permission configuration, with practical examples and code snippets.
ProceduresSQLdatabase
0 likes · 38 min read

This article provides an in‑depth overview of MySQL, covering storage engine concepts, selecting appropriate data types, index design and usage, view creation, stored procedure syntax, variable handling, and trigger implementation, with practical examples and SQL code snippets to illustrate each topic.
data typesdatabasemysql
0 likes · 25 min read

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.
SQLSecuritydatabase
0 likes · 14 min read

This article explains the Google Dataflow model, covering its unified batch‑and‑stream architecture, windowing and triggering mechanisms, core primitives, time domains, and how these concepts form the foundation of modern big‑data stream processing systems.
DataflowGoogle CloudWindowing
0 likes · 13 min read

This article benchmarks four MySQL stored functions to show how unreachable (dead) code inside functions, procedures, and triggers inflates execution time, visualizes their system calls with performance_schema, and explains the resulting memory and trigger performance impacts.
BenchmarkDead Codemysql
0 likes · 7 min read

This article explores MySQL’s advanced capabilities—including partition tables, views, stored procedures, triggers, foreign‑key constraints, bind variables, user‑defined functions, and character‑set considerations—explaining their principles, usage patterns, performance impacts, and best‑practice recommendations for handling large‑scale data.
Foreign KeysPartitioningcharacter-set
0 likes · 34 min read

This article provides concise MySQL command examples for creating unique and full‑text indexes, multi‑column indexes, views, triggers, inserting data, pagination, transaction handling, character set configuration, and basic service management.
SQLindexesmysql
0 likes · 6 min read

This article explores MySQL’s advanced features—including partition tables, views, stored procedures, triggers, foreign key constraints, bind variables, user‑defined functions, and character set considerations—explaining their principles, usage patterns, performance implications, and practical tips for large‑scale data scenarios.
PartitioningUDFcharacter-set
0 likes · 35 min read


ITPUBJul 19, 2017 · Databases
This guide compares SQL Server and Oracle across ten key areas—including data types, date functions, default constraints, string concatenation, identity columns, conditional statements, CASE syntax, triggers, stored procedures, and user creation—providing concrete code examples for each difference.
Database SyntaxOracleSQL Server
0 likes · 8 min read


ITPUBJun 28, 2017 · Databases
During synchronization from MySQL 5.0 to 5.7, a slave worker raised a ‘duplicate primary’ error; the article examines binlog statements, auto‑increment values, and a problematic trigger, walks through various debugging attempts, and concludes that removing the trigger resolves the issue despite unclear root cause.
Duplicate Primarymysqlreplication
0 likes · 6 min read

This curated excerpt from the MySQL 5.7 FAQ provides concise answers on NDB Cluster versions and deployment, network and hardware requirements, memory sizing formulas, virtual machine support, common error causes, user management, replication setup and limitations, trigger behavior, and InnoDB tablespace encryption details, linking to official documentation for deeper reference.
FAQInnoDB EncryptionNDB Cluster
0 likes · 23 min read

This guide walks through MySQL fundamentals—including how to create, modify, and drop views, use triggers for automated actions, write and execute stored procedures and functions, design various index types, manage transactions, and apply best‑practice tips for optimal performance.
Transactionsfunctionsindexes
0 likes · 16 min read


ITPUBMay 4, 2016 · Databases
This article explains Oracle trigger fundamentals, syntax, and a series of practical examples—including preventing weekend updates, auto‑incrementing IDs, logging DML actions, aggregating department salaries, capturing deletions, view‑based inserts, salary change alerts, and tracking CREATE/DROP operations—complete with full SQL code snippets.
OraclePL/SQLSQL
0 likes · 12 min read


21CTOApr 29, 2016 · Databases
Uber’s Schemaless datastore, described in the Mezzanine project, replaces a single PostgreSQL node with a highly available, horizontally scalable MySQL‑backed key‑value store, detailing its architecture, data model, triggers, indexing, fault‑tolerance, and operational considerations for massive trip data.
DataStoreSchemalessUber
0 likes · 32 min read

This article explains how Uber engineered Schemaless, a highly available, horizontally scalable datastore built on MySQL that stores immutable JSON cells without a fixed schema, detailing its design goals, architecture, data model, trigger system, indexing strategy, and fault‑tolerant read/write mechanisms.
IndexingNoSQLScalable Datastore
0 likes · 32 min read
