SQL Review Guide

An online tool for DBA to generate the SQL review / DDL guideline.

Database Review Guide

Engine

  • Error

    Enforce InnoDB storage engine

    InnoDB is the default storage engine for MySQL that provides transaction support. It also provides better performance for high-concurrency and low-latency scenarios, and supports online data backup and recovery. It is the preferred choice for OLTP businesses. Suggestion error level: Error

Table

  • Error

    Enforce inclusion of primary key in a table

    In addition to carry business meaning, primary key are also beneficial for high-concurrency queries in MySQL. Various data synchronization, comparison, and rollback tools often require tables to have primary key. Suggestion error level: Error

  • Error

    Prohibit using foreign key constraints