If my fs use 4k block size, mysql use 16k page size. But which block size to choose for fio test?
3
-
What is the goal of the test? Disk performance for MySQL? Are you comparing two filesystems? Two hardwares? Something else?– Rick JamesCommented Aug 28, 2020 at 0: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.– ogbofjnrCommented Aug 28, 2020 at 0: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: mysql.rjweb.org/doc.php/mysql_analysis#slow_queries_and_slowlog– Rick JamesCommented Aug 28, 2020 at 0:44
Add a comment
|
1 Answer
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.
