UFS and ZFS write patterns [Update]

| | Comments (1) | TrackBacks (0)
As a followup to this article, I used a zfs volume and an ufs volume with an application doing the same work on both partitions (replicated sql engines).

Click on the still frame to download the video (4 MB, ISO MPEG 4 format):

stillframe_ufszfs.gif

Red pixels mean write operations, green pixels mean read operations. One pixel represents approx 10700 blocks or 5,3 MB. The disks have 140GB each.

Both hosts are running MySQL InnoDB databases and the application updates BOTH in the exact same manner (same INSERTs, SELECTs and UPDATEs).

The ZFS host does a "DELETE ..... WHERE ..." at 22:30 (10:30pm), the UFS host does that at 01:30am. Approx 3 million columns are deleted by these operations per database.

0 TrackBacks

Listed below are links to blogs that reference this entry: UFS and ZFS write patterns [Update].

TrackBack URL for this entry: http://southbrain.com/mt/mt-tb.cgi/49

1 Comments

Very interesting to watch, thanks! :)

Leave a comment

July 2012

Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        

About

This blog is owned by:

Pascal Gienger
Jägerstrasse 77
8406 Winterthur
Switzerland


Google+: Profile
YouTube Channel: pascalgienger