Bug #68860 innodb raw device
Submitted: 3 Apr 2013 20:20 Modified: 5 Apr 2013 18:18
Reporter: woonhak kang Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6.10 OS:Linux (Ubuntu 12.04)
Assigned to: CPU Architecture:Any
Tags: innodb, raw, raw device

[3 Apr 2013 20:20] woonhak kang
When I use raw device storage in innodb,
we simply add 'raw' like following lines in config file.


innodb includes in MySQL 5.6.10,
open_or_create_data_files() function check data file path is regular file or not.

Especially srv_file_check_mode(),
it deosn't check current file is raw and return fail
because the path is not a regular file. (because it is device file, S_ISREG() reutn false)

Therefore, I think that we should check current file is device file and raw device is set in config file.
Then return true.

How to repeat:
set 'raw' symbol end of innodb_data_file_path.
It return OS_FILE_TYPE_UNKNOWN, because the file is special file.

Suggested fix:
change os_file_get_status() to chceck current setting is raw and the path is device file.

currently, I change it like following lines.
(only check current file is blk device handle this is regular file)

} else if (S_ISREG(statinfo.st_mode)) {

  } else if (S_ISREG(statinfo.st_mode) || S_ISBLK(statinfo.st_mode) ) {
[5 Apr 2013 18:18] Sinisa Milivojevic
Please, follow the instructions precisely as in our manual:

When you create a new data file, put the keyword newraw immediately after the data file size in innodb_data_file_path. The partition must be at least as large as the size that you specify. Note that 1MB in InnoDB is 1024 × 1024 bytes, whereas 1MB in disk specifications usually means 1,000,000 bytes.