E
E
Evgeny Romanenko2011-05-03 12:25:28
linux
Evgeny Romanenko, 2011-05-03 12:25:28

Optimal values(chunk, stride, stripe-width) for mysql?

Shake everyone!

# uname -srm 
Linux 2.6.18-238.el5PAE i686 
# cat /etc/issue 
CentOS release 5.6 (Final)

There are 4 SATA disks that will be combined into a software raid.
Can you advise the optimal value for creating an array (--chunk=?), as well as the stride and stripe-width values ​​when formatting.
I'm guessing to do so
#mdadm --create --verbose /dev/md2 --level=10  --chunk=32 --raid-devices=4 /dev/sd[a,b,c,d]4

Chunk size selected based on considerations
The default page size in InnoDB is 16 KB.
If you believe the scripttyts , then you need this
mkfs.ext4 -b 4096 -E stride=8 -E stripe-width=16 /dev/md2

But based on man mkfs.ext4 I would do this
mkfs.ext4 -b 4096 -E stride=16 -E stripe-width=32 /dev/md2

What do you think?
ps
while I'm testing ...
pps
my version wins a little when writing, in reading they are approximately equal.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
P
Puma Thailand, 2011-05-03
@opium

Leave everything by default, these are the most optimal settings and maximum optimization has been made for them in Linux raid.
At one time, on tests, xfs on a muscle showed itself better than ext3.

E
Evgeny Romanenko, 2011-05-04
@FessAectan

No one seems to have asked the question =)
I decided to follow man and wiki.centos.org/HowTos/Disk_Optimization
Chose the second option.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question