Inspired by Baron's earlier post, here is one I hear quite frequently -
"If you enable innodb_file_per_table, each table is it's own .ibd file. You can then relocate the heavy hit tables to a different location and create symlinks to the original location."
There are a few things wrong with this advice:
- InnoDB does not support these symlinks. If you run an ALTER TABLE command, what you will find is that a new temporary table is created (in the …