MySQL and PostgreSQL benchmarking

[Haidut <haidut@xxxxxxxxx>]

Hi,

Has anybody tried compiling and running any of the benchmark tools
available for MySQL or PostgreSQL? I have tried all of them and none
of the tools compiles under Dfly. I tried "super-smack", "sysbench",
"mybench", etc. All tools either failed to compile for some reason.
Bear in mind, by failing to compile I don't mean that a library was
missing. All the necessary libraries were installed, the "configure"
script ran fine and generated all the makefiles but make/gmake failed
to build the binaries. The same tools build fine on Linux. So any help
with running any open-source DB benchmark tools on Dfly will be highly
appreciated.
Thanks.


On 11/11/06, Ja'far Railton <jrailton@xxxxxxxxxxxx> wrote:
> ---------- Forwarded message ----------
> From: Ja'far Railton <ibn.richard@xxxxxxxxx>
> To: users@xxxxxxxxxxxxxxxxxxxxxxx
> Date: Sat, 4 Nov 2006 13:37:58 +0300
> Subject: mounting usb stick
> Hello
>
> I'm trying to do the above. Here's what happens:
>
>
> <<insert usb stick>>
>
> Nov  4 13:27:07 think kernel: umass0: SanDisk Corporation U3 Cruzer Micro, rev 2.00/0.10, addr 2
> Nov  4 13:27:08 think kernel: da0 at umass-sim0 bus 0 target 0 lun 0
> Nov  4 13:27:08 think kernel: da0: <SanDisk U3 Cruzer Micro 2.15> Removable Direct Access SCSI-2 device
> Nov  4 13:27:08 think kernel: da0: 1.000MB/s transfers
> Nov  4 13:27:08 think kernel: da0: 973MB (1994385 512 byte sectors: 64H 32S/T 973C)
> Nov  4 13:27:24 think su: jr0 to root on /dev/ttyv1
>
> try to mount it with:
>
>         mount_msdos /dev/da0s1 /mnt
>
> Nothing happens. No output.
>
> <<detach it>>
>
> Nov  4 13:28:04 think dhclient: send_packet: Address family not supported by protocol family
> Nov  4 13:28:13 think last message repeated 2 times
> Nov  4 13:28:17 think kernel: umass0: at uhub0 port 1 (addr 2) disconnected
> Nov  4 13:28:17 think kernel: umass0: state 6 waiting for idle
> Nov  4 13:28:17 think kernel: umass0: BBB reset failed, IOERROR
> Nov  4 13:28:17 think kernel: umass0: BBB bulk-in clear stall failed, IOERROR
> Nov  4 13:28:17 think kernel: umass0: BBB bulk-out clear stall failed, IOERROR
> Nov  4 13:28:17 think kernel: (cd1:umass-sim0:0:0:1): got CAM status 0x39
> Nov  4 13:28:17 think kernel: (cd1:umass-sim0:0:0:1): fatal error, failed to attach to device
> Nov  4 13:28:17 think kernel: (cd1:umass-sim0:0:0:1): lost device
> Nov  4 13:28:17 think kernel: (cd1:umass-sim0:0:0:1): removing device entry
> Nov  4 13:28:17 think kernel: (cd1:umass-sim0:0:0:1): removing changer entry
> Nov  4 13:28:17 think kernel: cd: cdevsw removed
> Nov  4 13:28:18 think kernel: (da0:umass-sim0:0:0:0): lost device
> Nov  4 13:28:18 think kernel: (da0:umass-sim0:0:0:0): removing device entry
> Nov  4 13:28:18 think kernel: da: cdevsw removed
> Nov  4 13:28:18 think kernel: pass: cdevsw removed
> Nov  4 13:28:18 think kernel: pass: cdevsw removed
> Nov  4 13:28:18 think kernel: umass0: detached
> Nov  4 13:28:22 think dhclient: send_packet: Address family not supported by protocol family
> Nov  4 13:28:54 think last message repeated 2 times
>
> Can anyone suggest anything?
> TIA
>
> -jr