mysql

InnoDB basic intro

InnoDB default engine when creating table, SHOW ENGINE INNODB STATUS pro: DML operations follows ACID, can commit or rollback and has crash-recovery Row-level locking, consistent read increase performance primary key: fast lookups foreign key constraints crash recovery? The cleanup activities that occur when MySQL is started again after a crash. For InnoDB tables, changes from incomplete transactions are replayed using data from the redo log. Changes that were committed before
Read more