解決 mysql innodb 效能問題方法之一

可以用 Using Per-Table Tablespaces : http://dev.mysql.com/doc/refman/5.1/en/multiple-tablespaces.html Store each InnoDB table and its indexes in its own file. This feature is called “multiple tablespaces” because in effect each table has its own tablespace. Using multiple tablespaces can be beneficial to users…