alter-table: Total time: 18 wallclock secs ( 0.03 usr 0.06 sys + 0.00 cusr 0.00 csys = 0.09 CPU)
ATIS: Total time: 19 wallclock secs ( 8.65 usr 8.40 sys + 0.00 cusr 0.00 csys = 17.05 CPU)
big-tables: Total time: 31 wallclock secs ( 6.74 usr 19.63 sys + 0.00 cusr 0.00 csys = 26.37 CPU)
connect: Total time: 172 wallclock secs (39.00 usr 53.37 sys + 0.00 cusr 0.00 csys = 92.37 CPU)
create: Total time: 109 wallclock secs ( 3.52 usr 2.45 sys + 0.00 cusr 0.00 csys = 5.97 CPU)
insert: Total time: 1345 wallclock secs (376.74 usr 339.12 sys + 0.00 cusr 0.00 csys = 715.86 CPU)
select: Total time: 125 wallclock secs (39.83 usr 32.29 sys + 0.00 cusr 0.00 csys = 72.12 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 10 wallclock secs ( 2.42 usr 2.61 sys + 0.00 cusr 0.00 csys = 5.03 CPU)
Here are the benchmarks for the unoptimized version:
alter-table: Total time: 20 wallclock secs ( 0.05 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.08 CPU)
ATIS: Total time: 20 wallclock secs ( 8.26 usr 9.26 sys + 0.00 cusr 0.00 csys = 17.52 CPU)
big-tables: Total time: 31 wallclock secs ( 6.91 usr 19.21 sys + 0.00 cusr 0.00 csys = 26.12 CPU)
connect: Total time: 167 wallclock secs (39.32 usr 52.16 sys + 0.00 cusr 0.00 csys = 91.48 CPU)
create: Total time: 110 wallclock secs ( 2.55 usr 2.49 sys + 0.00 cusr 0.00 csys = 5.04 CPU)
insert: Total time: 1307 wallclock secs (376.21 usr 328.16 sys + 0.00 cusr 0.00 csys = 704.37 CPU)
select: Total time: 136 wallclock secs (40.63 usr 30.53 sys + 0.00 cusr 0.00 csys = 71.16 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 11 wallclock secs ( 2.35 usr 2.75 sys + 0.00 cusr 0.00 csys = 5.10 CPU)
For additional reference, here are the same benchmarks that were run on the same machine, but using an Xserve RAID (two software raid mirrored RAID 5 arrays with three drives each) for the storage instead of the internal SATA drive:
Unoptimized, with Xserve RAID:
alter-table: Total time: 19 wallclock secs ( 0.05 usr 0.07 sys + 0.00 cusr 0.00 csys = 0.12 CPU)
ATIS: Total time: 19 wallclock secs ( 8.07 usr 9.16 sys + 0.00 cusr 0.00 csys = 17.23 CPU)
big-tables: Total time: 32 wallclock secs ( 6.61 usr 19.46 sys + 0.00 cusr 0.00 csys = 26.07 CPU)
connect: Total time: 165 wallclock secs (38.22 usr 50.03 sys + 0.00 cusr 0.00 csys = 88.25 CPU)
create: Total time: 106 wallclock secs ( 6.15 usr 3.01 sys + 0.00 cusr 0.00 csys = 9.16 CPU)
insert: Total time: 1284 wallclock secs (376.06 usr 325.79 sys + 0.00 cusr 0.00 csys = 701.85 CPU)
select: Total time: 133 wallclock secs (39.64 usr 29.83 sys + 0.00 cusr 0.00 csys = 69.47 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 10 wallclock secs ( 2.30 usr 2.74 sys + 0.00 cusr 0.00 csys = 5.04 CPU)
Optimized:
alter-table: Total time: 18 wallclock secs ( 0.03 usr 0.11 sys + 0.00 cusr 0.00 csys = 0.14 CPU)
ATIS: Total time: 19 wallclock secs ( 8.32 usr 9.05 sys + 0.00 cusr 0.00 csys = 17.37 CPU)
big-tables: Total time: 31 wallclock secs ( 6.65 usr 18.93 sys + 0.00 cusr 0.00 csys = 25.58 CPU)
connect: Total time: 167 wallclock secs (39.39 usr 50.78 sys + 0.00 cusr 0.00 csys = 90.17 CPU)
create: Total time: 109 wallclock secs ( 6.35 usr 3.04 sys + 0.00 cusr 0.00 csys = 9.39 CPU)
insert: Total time: 1314 wallclock secs (371.49 usr 333.26 sys + 0.00 cusr 0.00 csys = 704.75 CPU)
select: Total time: 124 wallclock secs (39.33 usr 30.75 sys + 0.00 cusr 0.00 csys = 70.08 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 11 wallclock secs ( 2.40 usr 2.61 sys + 0.00 cusr 0.00 csys = 5.01 CPU)
Either way, there didn't seem to be a whole lot of difference.
- Gabriel
On Nov 24, 2003, at 2:22 AM, Adam Goldstein wrote:
Any word on G5/64bit compiles of mysql?
I know I am not the only one wanting to know Does it work, and How to compile best for it.
or am I alone in the universe? -- Adam Goldstein White Wolf Networks http://whitewlf.net
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
