Converting between MySQL Date and Time Formats

MySQL\'s thorough and flexible date handling allows you to switch between internal and external date/time formats with relative ease.

MySQL Data Fragmentation - What, When and How

Database Journal: \"MySQL tables, including MyISAM and InnoDB, two of the most common types, experience fragmentation as data is inserted and deleted randomly. Fragmentation can leave large holes in your table, blocks which must be read when scanning the table. Optimizing your table can therefore make full table scans and range scans more efficient.\"