8.12.3 Optimizing Disk I/O Using Symbolic Links

The SHOW COLUMNS and The DESCRIBE statements use BLOB as the type for some columns, thus the temporary table used for the results is an on-disk table.

The tips in Section 8.5.7, “Optimizing InnoDB Disk I/O” help you get more I/O performance out of your existing storage configuration. This section describes ways to configure your storage devices when you can devote more and faster storage hardware to the database server.