- 论坛徽章:
- 0
|
我输入如下命令:
mysql> create tablespace wttb add datafile '/var/lib/mysql/wttb.dbf' engine=innodb;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show variables like 'in%file%';
+---------------------------+------------------------+
| Variable_name | Value |
+---------------------------+------------------------+
| init_file | |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_log_file_size | 2097152 |
| innodb_log_files_in_group | 2 |
| innodb_open_files | 300 |
但是我在/var/lib/mysql下面也看不到。。
PS:还重启过了,也没效果。 |
|