Tagged articles
Foreign Keys
10 articles · Page 1 of 1
MySQL 9.6 shifts foreign‑key checks and cascade handling from the InnoDB storage engine to the SQL engine, eliminating hidden changes, improving binary‑log visibility, and delivering full‑log replication and analytics without sacrificing performance.
CDCForeign KeysMySQL
0 likes · 9 min read

Learn how to prevent six frequent MySQL problems—including index misuse, transaction isolation anomalies, inefficient pagination, charset and collation errors, risky foreign-key cascades, and misconfigured connection pools—through detailed explanations, code examples, and practical mitigation strategies.
CharsetConnection PoolDatabase Performance
0 likes · 22 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 KeysMySQLOMS
0 likes · 13 min read

This tutorial explains how to create a test database, define tables with foreign key constraints, populate them with appropriate random data using mysql_random_data_load, and work around a known bug that forces the foreign‑key sample size to 100 rows.
Foreign KeysMySQLPercona
0 likes · 3 min read

This article examines the role of foreign keys in relational databases, comparing their consistency guarantees and performance overhead with manual simulation approaches, and provides practical guidance on choosing RESTRICT, CASCADE, or no foreign‑key strategy in high‑concurrency applications.
CascadingForeign KeysSQL
0 likes · 15 min read

This tutorial walks you through using Navicat 12 to design, relate, and export a database schema for a mall permission management module, covering model opening, table creation, foreign‑key setup, auto‑layout, SQL export, and reverse engineering with clear screenshots.
Foreign KeysNavicatSQL Export
0 likes · 7 min read

This article explains the concept of ER tables, demonstrates how they are configured and used in the DBLE middleware with parent‑child relationships, shows a practical SELECT example and query plan analysis, and concludes with best‑practice recommendations for leveraging foreign‑key optimizations.
DBLEER tablesForeign Keys
0 likes · 5 min read

A GitHub engineer argues that database foreign keys should be avoided because they shift integrity responsibilities to the DB, incur performance overhead, and cause complications during online schema migrations, illustrating the points with parent‑child tables, gh‑ost, and pt‑online‑schema‑change tools.
Foreign Keysdatabasesgh-ost
0 likes · 4 min read

This article examines the benefits and drawbacks of database foreign key constraints, highlighting issues such as performance overhead, concurrency bottlenecks, scalability limitations, and increased operational complexity, and argues why handling relationships in the application layer is often preferable.
Foreign Keysdatabase designscalability
0 likes · 5 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 KeysMySQLPartitioning
0 likes · 34 min read
