|
When trying to set innodb_tmpdir at runtime the server prevents me from setting it to a path that is within the data directory:
mysql> SET GLOBAL innodb_tmpdir="/usr/local/mysql/data/my-tmpdir";
|
ERROR 1231 (42000): Variable 'innodb_tmpdir' can't be set to the value of '/usr/local/mysql/data/my-tmpdir'
|
|
mysql> SHOW WARNINGS;
|
| Level | Code | Message
|
| Warning | 1210 | InnoDB: Path Location should not be same as mysql data directory location.
|
| Error | 1231 | Variable 'innodb_tmpdir' can't be set to the value of '/usr/local/mysql-maria-10.1.19/var/my-tmpdir'
|
Setting it to exactly the same path as above is possible via the my.cnf option file though. mysqld will start up fine without any warnings, and when checking the innodb_tmpdir variable it is indeed showing /usr/local/mysql-maria-10.1.19/var/my-tmpdir as current value.
|