Question: What would be the best block size for MySQL?

Hi @CharlesR,
The InnoDB engine within MySQL uses 16K page sizes. I’ve been using MySQL since 2008, and I’ve never seen anyone modify their filesystem to match that. InnoDB supports modifying its own page size to 4K to match the filesystem, but the gains you get from that are extremely small with todays modern SSDs and filesystems.

In the long run, the OS hardly matters. You won’t see night/day performance differences between running MySQL on RedHat vs Debian vs macOS vs CentOS vs Alma vs Rocky vs etc… I would say that most of Percona’s customers (or at least all the ones I deal with) run Ubuntu.

1 Like