1. innodb_flush_neighbors

When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily for disk seek operations) compared to flushing individual pages at different times. For table data stored on SSD, seek time is not a significant factor and you can disable this setting to spread out write operations.

大体就是说，如果用的是普通硬盘，innodb_flush_neighbors可以设置为1，刷新相邻页；如果是SSD，那可以设置为0，关闭该功能，分散写操作。