Have you verified what happens with other file systems (ext4, xfs) under exact identical circumstances? What ashift and recordsize did you use when creating your pool?
It sounds like InnoDB in latest MariaDB tries to auto-align FS block size (for which by default I would expect ZFS to report 128KB (unless you have the large block size enabled from the very recent versions). But InnoDB by default uses 16KB pages (which could result in on-disk block sizes of 1KB, 4KB or 8KB if you use Barracuda file format and enable compression). InnoDB page size can be increased at build time up to 64KB, which is still smaller than 128KB ZFS default block size). At a glance it looks like some runtime awareness of variable InnoDB page sizes may have been introduced, and now InnoDB emits a notification when FS block size is not what the current build/implementation. Does the warning go away if you set recordsize=16k on the file system where your database is stored? On Tue, Oct 6, 2015 at 12:46 PM, Serge Victor <[email protected]> wrote: > Hi, > the new mariadb 10.1 introduced some features, which are apparently not > compatible with zfs, at least with compressed zfs I use. > > The log says: > > InnoDB: Note: File system for file phpbb_sessions.ibd has file block > size 131072 not supported for page_size 16384 > InnoDB: Note: Using file block size 8192 for file phpbb_sessions.ibd > > The related code in mariadb looks like: > > struct statvfs fstat; > int err; > > err = fstatvfs(file, &fstat); > > if (err != 0) { > fprintf(stderr, "InnoDB: Warning: fstatvfs() failed on file > %s\n", name); > os_file_handle_error_no_exit(name, "fstatvfs()", FALSE, > __FILE__, __LINE__); > } else { > fblock_size = fstat.f_bsize; > } > > > Question: is there a reliable way to find out device's sector size? > > > cheers, > Serge > _______________________________________________ > developer mailing list > [email protected] > http://lists.open-zfs.org/mailman/listinfo/developer >
_______________________________________________ developer mailing list [email protected] http://lists.open-zfs.org/mailman/listinfo/developer
