Hi people,
Thanks to everybody for your great effort day by day to maintain this
great project...
Now..my problem.. :(
I'm experiencing some high fragmentations in one of my boxes, running
postgresql database.
Last Friday/Saturday I ran some extra maintenance to my postgres DB
(reindexing, analyze, vacuum full, etc.) due suddenly we started to have
very slow performance in our queries. This maintenance helped, but later
I ran xfs_db -r <partition> -c "frag -f" and the
fragmentation was still high (close to 90%) and xfs_fsr reduced it to 7%
after to complete 10 loops for all my file systems in /etc/mtab.
Today in the evening I took some statistics and fragmentations level was
64% !! :(
#xfs_db -r /dev/sdc1 -c "frag -f"
actual 2531, ideal 906, fragmentation factor 64.20%
Basic info:
-kernel 2.4.19 + xfs 1.2 + some extra patches
-postgres 7.2.3-1PGDG
#xfs_info /proj
meta-data=/proj isize=256 agcount=34, agsize=262144
blks
data = bsize=4096 blocks=8885945, imaxpct=25
= sunit=0 swidth=0 blks, unwritten=0
naming =version 2 bsize=4096
log =internal bsize=4096 blocks=1200 version=1
= sunit=0 blks
realtime =none extsz=65536 blocks=0, rtextents=0
-HW level
PE2650 PIII 1400 Mhz Dual CPU, 1Gb ram,
/proj is in RAID1 using Perc3/Di (Yes, I know this is a bad raid card,
but IMHO this is not causing the fragmentations)
Only postgres and a small mysql DB are using this partition.
Qs:
-Can I ran xfs_fsr daily instead weekly?
-DO you think if I update my kernel and recreate my partition, using
version 2 (or 3) I can mitigate my fragmentation level? (Risky task)
-Is really postgres the frag killer here (if any one of you is running
postgres and only the data is one paritition..)
Suggestions? They will be very well appreciated ..
Cheers,
--
Vene.-
Internet Securities, Inc. (trading as ISI Emerging Markets) is a Euromoney
Institutional Investor company.
________________________________________________________________________
This communication contains information which is confidential. It is for the
exclusive use of the intended recipient(s). If you are not the intended
recipient(s) please note any distribution, copying or use of this communication
or the information in it is strictly prohibited. If you have received this
communication in error please notify us by e-mail or bytelephone (as above) and
then delete the e-mail and all attachments and any copies thereof.
________________________________________________________________________
|