Stan Hoeppner put forth on 9/9/2010 10:23 PM:
> Brady Chang put forth on 9/9/2010 4:59 PM:
>> thanks guys for the feedback.
>> iostat shows balanced io between two filesystems.
> Can we please see the "iostat -x" output for the duration of the TPC-H
> run _only_?
What db engine are you using? Oracle, DB2, MySQL, or PostgreSQL?
Exactly how are you instructing it to split files between /data1 and /data2?
Are you instructing your db engine to split your transaction logs and db
files equally across both filesystems?
On which filesystem are you locating your database engine scratch space
Can you run xfs_bmap on the files on each filesystem to determine which
are the most fragmented? Doing this may/should produce the smoking gun.
At this point, I'm guessing you have transaction logs and db scratch
space allocated to /data2 which is causing the heavy fragmentation.
It would be instructive if you dropped /data2 out of the picture
entirely and ran the TPC-H benchy using only /data1. I'm sure you'll
see the fragmentation on /data1 in this case.
It seems clear your fragmentation issue is a database management issue,
not an XFS issue. Your answers to my questions should tell us which.