-
Speeding Up Bulk Inserts in MySQL
Speeding up bulk inserts in MySQL with multi-row INSERT statements, LOAD DATA, and wrapping batches in a single transaction.
-
Backing Up and Restoring MySQL Databases with mysqldump
Backing up and restoring MySQL databases with mysqldump, and why –single-transaction is essential for live production backups.
-
MySQL Transactions and ACID Properties Explained
MySQL transactions and the ACID properties explained with a real money-transfer example, and why the storage engine matters.