$ bin/pg_test_fsync -f /data/m/my/data/mysql.ibd | |
5 seconds per test | |
O_DIRECT supported on this platform for open_datasync and open_sync. | |
Compare file sync methods using one 8kB write: | |
(in wal_sync_method preference order, except fdatasync is Linux's default) | |
open_datasync 435.834 ops/sec 2294 usecs/op | |
fdatasync 739.356 ops/sec 1353 usecs/op | |
fsync 275.887 ops/sec 3625 usecs/op | |
fsync_writethrough n/a | |
open_sync 289.213 ops/sec 3458 usecs/op | |
Compare file sync methods using two 8kB writes: | |
(in wal_sync_method preference order, except fdatasync is Linux's default) | |
open_datasync 215.263 ops/sec 4645 usecs/op | |
fdatasync 664.017 ops/sec 1506 usecs/op | |
fsync 298.834 ops/sec 3346 usecs/op | |
fsync_writethrough n/a | |
open_sync 168.928 ops/sec 5920 usecs/op | |
Compare open_sync with different write sizes: | |
(This is designed to compare the cost of writing 16kB in different write | |
open_sync sizes.) | |
1 * 16kB open_sync write 297.779 ops/sec 3358 usecs/op | |
2 * 8kB open_sync writes 159.258 ops/sec 6279 usecs/op | |
4 * 4kB open_sync writes 79.624 ops/sec 12559 usecs/op | |
8 * 2kB open_sync writes 37.313 ops/sec 26801 usecs/op | |
16 * 1kB open_sync writes 18.225 ops/sec 54871 usecs/op | |
Test if fsync on non-write file descriptor is honored: | |
(If the times are similar, fsync() can sync data written on a different | |
descriptor.) | |
write, fsync, close 291.049 ops/sec 3436 usecs/op | |
write, close, fsync 302.126 ops/sec 3310 usecs/op | |
Non-sync'ed 8kB writes: | |
write 253601.768 ops/sec 4 usecs/op |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment