MySQL:MyISAM 有表空间吗？

Question

我可以使用在 MySQL 5.1.30 上运行的 MyISAM 表创建表空间吗？

Answer 1

表空间(在 MySQL 5.1 中)仅支持 NDB 和 NDBCLUSTER，参见 http://dev.mysql.com/doc/refman/5.1/en/create-tablespace.html :

The ENGINE parameter determines the storage engine which uses this tablespace, with engine_name being the name of the storage engine. In MySQL 5.1, engine_name must be one of the values NDB or NDBCLUSTER.

但是你可以告诉MySQL MyISAM 使用哪个数据目录和索引目录，参见。 http://dev.mysql.com/doc/refman/5.1/en/create-table.html :

By using DATA DIRECTORY='directory' or INDEX DIRECTORY='directory' you can specify where the MyISAM storage engine should put a table's data file and index file. The directory must be the full path name to the directory, not a relative path.