Re: [zfs-discuss] Oracle on ZFS vs. UFS

2006-05-19 Thread Daniel Rock
Richard Elling schrieb: On Fri, 2006-05-19 at 23:09 +0200, Daniel Rock wrote: (*) maxphys = 8388608 Pedantically, because ZFS does 128kByte I/Os. Setting maxphys > 128kBytes won't make any difference. I know, but with the default maxphys value of 56kByte on x86 a 128kByte request will be s

Re: [zfs-discuss] Oracle on ZFS vs. UFS

2006-05-19 Thread Daniel Rock
Bart Smaalders schrieb: How big is the database? After all the data has been loaded, all datafiles together 2.8GB, SGA 320MB. But I don't think size matters on this problem, since you can already see during the catalog creation phase that UFS is 2x faster. Since oracle writes in small blo

[zfs-discuss] tracking error to file

2006-05-19 Thread Gregory Shaw
In my testing, I've found the following error: zpool status -v pool: local state: ONLINE status: One or more devices has experienced an error resulting in data corruption. Applications may be affected. action: Restore the file in question if possible. Otherwise restore the ent

Re: [zfs-discuss] Oracle on ZFS vs. UFS

2006-05-19 Thread Bart Smaalders
Daniel Rock wrote: Hi, I'm preparing a personal TPC-H benchmark. The goal is not to measure or optimize the database performance, but to compare ZFS to UFS in similar configurations. At the moment I'm preparing the tests at home. The test setup is as follows: . Solaris snv_37 . 2 x AMD Opteron

[zfs-discuss] Re: Did Sol9 have a 1Tb limit on addressing IDE, does S10, would ZFS be impacted?

2006-05-19 Thread Anton B. Rang
Solaris 10 update 1 (1/06 release) supports SCSI disks larger than 2 TB. I believe that the same is true for IDE (as long as your controller supports 48-bit LBA). The initial release of Solaris 10 has a 2 TB limit for 64-bit kernels, 1 TB for 32-bit kernels (or so the documentation claims, tho

[zfs-discuss] Oracle on ZFS vs. UFS

2006-05-19 Thread Daniel Rock
Hi, I'm preparing a personal TPC-H benchmark. The goal is not to measure or optimize the database performance, but to compare ZFS to UFS in similar configurations. At the moment I'm preparing the tests at home. The test setup is as follows: . Solaris snv_37 . 2 x AMD Opteron 252 . 4 GB RAM . 2 x

[zfs-discuss] cksum errors after zpool online

2006-05-19 Thread Chris Gerhard
I've been playing with offlining an external USB disk as a way of having a backup of a laptop drive. However when I online the device and scrub it I always get cksum errors. So I just build a v880 in the lab with a mirrored zpool. I offlined 2 disks that form the mirror and then created a new f

Re: [zfs-discuss] ZFS recovery from a disk losing power

2006-05-19 Thread Richard Elling
On Thu, 2006-05-18 at 23:40 -0600, Sanjay Nadkarni wrote: > You had a file system on top of the mirror and there was some I/O > occurring to the mirror. The *only* time, SVM puts a device into > maintenance is when we receive an EIO from the underlying device. So, > in case a write occurred t

[zfs-discuss] Did Sol9 have a 1Tb limit on addressing IDE, does S10, would ZFS be impacted?

2006-05-19 Thread Alec Muffett
Hello All, Attached is a conversation I've had with an old friend / colleague / sysadmin (cc'ed) and it raises three questions for me. I would like to ask the panel, from the context as described below: Did Sol9 have a 1Tb limit on addressing IDE Does S10? Would ZFS

Re: Re[7]: [zfs-discuss] Re: Re: Due to 128KB limit in ZFS it can't saturate disks

2006-05-19 Thread Roch Bourbonnais - Performance Engineering
Robert Milkowski writes: > Hello Roch, > > Monday, May 15, 2006, 3:23:14 PM, you wrote: > > RBPE> The question put forth is whether the ZFS 128K blocksize is sufficient > RBPE> to saturate a regular disk. There is great body of evidence that shows > RBPE> that the bigger the write sizes a

Re: [zfs-discuss] Re: Re: zfs snapshot for backup, Quota

2006-05-19 Thread Darren J Moffat
Richard Elling wrote: Anyone who is really clever will easily get past a quota, especially at a university -- triple that probability for an engineering college. I studied Computing Science at Glasgow University (Scotland) the department policy was NOT to use disk quotas. This was on SunOS 4.