Hi Guys, We are in the process of using snapshots and zfs send/recv to copy terrabytes of database datafiles. Due to CoW not being very friendly to databases we have a LOT of fragmentation on the datafiles. This really slows down zfs send. Is it possible (or already done) to have zfs send/recv able to do a blockwise send/recv of a zpool/zfs dataset so that we can harness the speed of sequential I/O. This would also solve the uncompress/recompress nature of zfs send/recv. It''s probably easier said than done, however I hope it gets looked at :) Cheers David -- This message posted from opensolaris.org
Sorry, I just cannot tell how is this name related to Sun, IMHO. In my days and enterprise environments, lots of CoWs are stored in relational databases. I dunno where the hell you come from. best, z ----- Original Message ----- From: "David Shirley" <david.shirley at nec.com.au> To: <zfs-discuss at opensolaris.org> Sent: Wednesday, January 14, 2009 11:29 PM Subject: [zfs-discuss] zfs send and file fragmentation> Hi Guys, > > We are in the process of using snapshots and zfs send/recv to copy > terrabytes of database datafiles. > > Due to CoW not being very friendly to databases we have a LOT of > fragmentation on the datafiles. > > This really slows down zfs send. > > Is it possible (or already done) to have zfs send/recv able to do a > blockwise send/recv of a zpool/zfs dataset so that we can harness the > speed of sequential I/O. > > This would also solve the uncompress/recompress nature of zfs send/recv. > > It''s probably easier said than done, however I hope it gets looked at :) > > Cheers > David > -- > This message posted from opensolaris.org > _______________________________________________ > zfs-discuss mailing list > zfs-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
CoW = copy on write, a ZFS feature, which makes snapshots easier to maintain. However it also introduces file fragmentation in database datafiles.> Sorry, I just cannot tell how is this name related to > Sun, IMHO. > > In my days and enterprise environments, lots of CoWs > are stored in > relational databases. > I dunno where the hell you come from. > > best, > z >-- This message posted from opensolaris.org
Yes, that''s more like it. hahahahahahahaha, it''s all happy. chatting on, Sun folks. best, z ----- Original Message ----- From: "David Shirley" <david.shirley at nec.com.au> To: <zfs-discuss at opensolaris.org> Sent: Wednesday, January 14, 2009 11:44 PM Subject: Re: [zfs-discuss] zfs send and file fragmentation> CoW = copy on write, a ZFS feature, which makes snapshots easier to > maintain. > > However it also introduces file fragmentation in database datafiles. > >> Sorry, I just cannot tell how is this name related to >> Sun, IMHO. >> >> In my days and enterprise environments, lots of CoWs >> are stored in >> relational databases. >> I dunno where the hell you come from. >> >> best, >> z >> > -- > This message posted from opensolaris.org > _______________________________________________ > zfs-discuss mailing list > zfs-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
Ok, it''s also important, in many many cases, but not all - taking the problem into tomorrow is also not very good. IMHO, maybe all you smart open folks that know all about this and that, but dunno how to fix your darn email address to appear "zfs user" on the darn list discussion? do I have to spell this out to you? OMG, you Solaris mail server is too much for me, kicking my ass, you win chatting on, z open folks. best, z, at home [Daisy baby getting off late, you babies don''t understand!]
Open Folks, Did I give you the impression that only Sun folks can speak on the list discussion? Or did I give you the impression that you have to make the digital name as such and such to do this? No, that was not what I meant, if that would kill the open discussion. Someone, earlier, asked me a question offlist. "what is the difference between your Zhou style and the western style"? I think that was a question that asked to explain who I am and why I say things and do things in an unusual fashion. And I copied the list for my response. The server did not deliver. And in my religion, that act of copying the list can potentially help the list better understand me and be less fearful. It was a noble act and I am still wondering why that email did not get through. And therefore I question the integrity of the mail server, before I can understand its policy. I tested the mail server with another method, didn''t get through either. Some friends asked me to be really open. But can you folks take my real open state of mind? Now, users have questions, and are asking the list. No Sun folks are responding. I guess any worldwide users who know the answers should post some help then? Best, z ----- Original Message ----- From: "JZ" <jz at excelsioritsolutions.com> To: "David Shirley" <david.shirley at nec.com.au>; <zfs-discuss at opensolaris.org> Sent: Thursday, January 15, 2009 12:04 AM Subject: Re: [zfs-discuss] (no subject)> Ok, it''s also important, in many many cases, but not all - > taking the problem into tomorrow is also not very good. > > IMHO, maybe all you smart open folks that know all about this and that, > but > dunno how to fix your darn email address to appear "zfs user" on the darn > list discussion? > do I have to spell this out to you? > > OMG, > you Solaris mail server is too much for me, kicking my ass, you win > chatting on, z open folks. > > > > > best, > z, at home > > [Daisy baby getting off late, you babies don''t understand!] > > _______________________________________________ > zfs-discuss mailing list > zfs-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
Another Zhou approach is that - when there is a fight that needs to be fought, a Zhou will fight that fight, and walking into the battlefield in front of the troops - kind of like the western way of doing fighting in the earlier days best, z
Sorry, open folks, please, chatting on. This is why my help cannot be provided very often. Because the Zhou style of fighting is that ? Yes, if we have to step into the battle field, a Zhou will walk in front of the real troops, and say, kill me, if you dare, and I am so sure with my life on it, that you will not live beyond this fight. Folks, please, if you know how to read Chinese, just for this one word. ? A "?" does not need to be known, but cannot be challenged. Best, z