Re: [zfs-discuss] Oracle DB sequential dump questions

2008-10-02 Thread Joerg Schilling
Louwtjie Burger <[EMAIL PROTECTED]> wrote: > Ta on the comments > > I'm going to use Jorg's 'star' to simulate some sequential backup workloads, > using different blocksizes and see what the system do. > > I'll save some output and post for people that might match the same config, > now or i

Re: [zfs-discuss] Oracle DB sequential dump questions

2008-10-02 Thread Louwtjie Burger
Ta on the comments I'm going to use Jorg's 'star' to simulate some sequential backup workloads, using different blocksizes and see what the system do. I'll save some output and post for people that might match the same config, now or in the future. To be clear though: (currently) #tar cvf

Re: [zfs-discuss] Oracle DB sequential dump questions

2008-10-02 Thread Adrian Saul
I would look at what size IOs you are doing in each case. I have been playing with a T5240 and got 400Mb/s read and 200Mb/s write speeds with iozone throughput tests on a 6 disk mirror pool, so the box and ZFS can certainly push data around - but that was using 128k blocks. You mention the disk

Re: [zfs-discuss] Oracle DB sequential dump questions

2008-10-01 Thread Boyd Adamson
Carson Gaspar <[EMAIL PROTECTED]> writes: > Joerg Schilling wrote: >> Carson Gaspar<[EMAIL PROTECTED]> wrote: >> >>> Louwtjie Burger wrote: Dumping a large file from memory using tar to LTO yields 44 MB/s ... I suspect the CPU cannot push more since it's a single thread doing all the

Re: [zfs-discuss] Oracle DB sequential dump questions

2008-10-01 Thread Joerg Schilling
Carson Gaspar <[EMAIL PROTECTED]> wrote: > Yes. Which is exactly what I was saying. The tar data might be more > compressible than the DB, thus be faster. Shall I draw you a picture, or > are you too busy shilling for star at every available opportunity? If you did never compare Sun tar speed w

Re: [zfs-discuss] Oracle DB sequential dump questions

2008-10-01 Thread Carson Gaspar
Joerg Schilling wrote: > Carson Gaspar<[EMAIL PROTECTED]> wrote: > >> Louwtjie Burger wrote: >>> Dumping a large file from memory using tar to LTO yields 44 MB/s ... I >>> suspect the CPU cannot push more since it's a single thread doing all the >>> work. >>> >>> Dumping oracle db files from fil

Re: [zfs-discuss] Oracle DB sequential dump questions

2008-10-01 Thread Joerg Schilling
Carson Gaspar <[EMAIL PROTECTED]> wrote: > Louwtjie Burger wrote: > > Dumping a large file from memory using tar to LTO yields 44 MB/s ... I > > suspect the CPU cannot push more since it's a single thread doing all the > > work. > > > > Dumping oracle db files from filesystem yields ~ 25 MB/s. T

Re: [zfs-discuss] Oracle DB sequential dump questions

2008-10-01 Thread Joerg Schilling
Louwtjie Burger <[EMAIL PROTECTED]> wrote: > Server: T5120 on 10 U5 > Storage: Internal 8 drives on SAS HW RAID (R5) > Oracle: ZFS fs, recordsize=8K and atime=off > Tape: LTO-4 (half height) on SAS interface. > > Dumping a large file from memory using tar to LTO yields 44 MB/s ... I > suspect the

Re: [zfs-discuss] Oracle DB sequential dump questions

2008-09-30 Thread Carson Gaspar
Louwtjie Burger wrote: > Dumping a large file from memory using tar to LTO yields 44 MB/s ... I > suspect the CPU cannot push more since it's a single thread doing all the > work. > > Dumping oracle db files from filesystem yields ~ 25 MB/s. The interesting bit > (apart from it being a rather sl

[zfs-discuss] Oracle DB sequential dump questions

2008-09-30 Thread Louwtjie Burger
Server: T5120 on 10 U5 Storage: Internal 8 drives on SAS HW RAID (R5) Oracle: ZFS fs, recordsize=8K and atime=off Tape: LTO-4 (half height) on SAS interface. Dumping a large file from memory using tar to LTO yields 44 MB/s ... I suspect the CPU cannot push more since it's a single thread doing al