2

If my fs use 4k block size, mysql use 16k page size. But which block size to choose for fio test?

ogbofjnr
  • 161
  • 1
  • 7
  • What is the goal of the test? Disk performance for MySQL? Are you comparing two filesystems? Two hardwares? Something else? – Rick James Aug 28 '20 at 00:22
  • Yes, the goal is disk performance for mysql. We have a performance issue on stages, guess it is disk issue, need to correctly compare environments. But other than that, I want to understand this parameter in general and how does it relates to fs blocks and mysql blocks. – ogbofjnr Aug 28 '20 at 00:40
  • Use 16KB. But excessive I/O can _often_ be fixed by improving the indexes and/or reformulating queries. Start by identifying the naughty queries: http://mysql.rjweb.org/doc.php/mysql_analysis#slow_queries_and_slowlog – Rick James Aug 28 '20 at 00:44

1 Answers1

1

If you are testing for a vague indication of MySQL InnoDB I/O performance - 16KB.

If you are looking into storage stack tuning, you should probably start with tuning storage alignment.

Gordan Bobić
  • 936
  • 4
  • 10