Hi Guys,
I am trying to create table outside data directory like this, but i got error ;
mysql> create table tempo2 (id int (11)) DATA DIRECTORY='/storage/mysql';
ERROR 1030 (HY000): Got error -1 from storage engine
and in MySQL error logs :
Error: Write to file ./bigdata/tempo2.isl failed at offset 0.
InnoDB: 33 bytes should have been written, only 0 were written.
InnoDB: Operating system error number 22.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 22 means 'Invalid argument'.
InnoDB: Some operating system error numbers are described at
InnoDB:
http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
I have changed mysql tmp directory to different paths, also set variables innodb_use_native_aio=OFF, but error is same.
I am using Percona server 5.6.27-76.0 , i am also trying it on Oracle mysql 5.6.27 but i facing same error.
Could someone suggest on this ?
Devrishi Shandilya