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

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

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 in the

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 CPU

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. The

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 filesystem yields ~ 25

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 with

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 work. Dumping

[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

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 slow