CREATE TABLE test_partition(
id INT NOT NULL,
name VARCHAR(16) NOT NULL,
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
partition by hash (id) partitions 3(
partition p0
data directory='D:/data'
index directory='D:/idx',
partition p1
data directory='E:/data'
index directory='E:/idx',
partition p2
data directory='F:/data'
index directory='F:/idx'
);如上,创建分区,插入数据,为何在相应的磁盘路径下找不到文件
+---------+------+----------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------+
| Warning | 1618 | <DATA DIRECTORY> option ignored |
| Warning | 1618 | <INDEX DIRECTORY> option ignored |
| Warning | 1618 | <DATA DIRECTORY> option ignored |
| Warning | 1618 | <INDEX DIRECTORY> option ignored |
| Warning | 1618 | <DATA DIRECTORY> option ignored |
| Warning | 1618 | <INDEX DIRECTORY> option ignored |
+---------+------+----------------------------------+
6 rows in set (0.00 sec)
/dev/sda4 103G 23G 75G 24% /data比如他说要分区到不同的磁盘上,那是不是路径写成
'/usr/local/data0/data'
'/usr/local/data0/index'
'/data/data1/data'
'/data/data1/index'