www.petefreitag.com Tutorials

MySQL DELAY_KEY_WRITE Option
Another performance option in MySQL is the DELAY_KEY_WRITE option. According to the MySQL documentation the option makes index updates faster because they are not flushed to disk until the table is closed.

MySQL Command Line Help
We tend to use MySQL from the interactive command line shell quite a bit (SSH to your db server and type the command mysql to start). We noticed today that there is a pretty extensive built in help system in this command.

MySQL Optimization Hints
Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.