System:
* PowerMac[silver] with dual G4 533-MHz CPU's, 1GB RAM, SCSI drives
* YDL-3.0.1
* gcc-3.2.2
* 12Aug04 BK source
* 2 replica, 2 db node cluster on 1 computer
[DB DEFAULT]
NoOfReplicas: 2
MaxNoOfConcurrentOperations: 100000
DataMemory: 160M
IndexMemory: 48M
TimeBetweenWatchDogCheck: 30000
TransactionDeadlockDetectionTimeout: 5000
======================================================================
I have managed to get 7 of 9 sql-bench tests to run, albiet slowly,
thanks to information provide by Mikael and Mangus.
Setup:
* System as shown above
* mysqld_safe --with-default-engine=ndb
* ./run-all-tests --create-options=type=ndb
--socket=/usr/local/mysql/var/mysql.sock
Results:
The results are summarized in the attached file.
Failures:
* test-insert
Testing server 'MySQL 4.1.4 beta/' at 2004-08-17 0:57:39
Testing the speed of inserting data into 1 table and do some selects on it.The tests are
done with a table that has 100000 rows.
Generating random keys
Creating tables
Inserting 100000 rows in order
Inserting 100000 rows in reverse order
Inserting 100000 rows in random order
Got temporary error 4010 'Node failure caused abort of transaction' from
ndbcluster at ./test-insert line 216.
* test-wisconsin
Testing server 'MySQL 4.1.4 beta/' at 2004-08-17 2:56:58
Wisconsin benchmark test
Time for create_table (3): 10 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00
csys = 0.00 CPU)
Inserting data
Time to insert (31000): 35 wallclock secs ( 2.20 usr 0.93 sys + 0.00
cusr 0.00 csys = 3.13 CPU)
Time to delete_big (1): 2 wallclock secs ( 0.00 usr 0.00 sys + 0.00
cusr 0.00 csys = 0.00 CPU)
Running the actual benchmark
Error occured with execute(select t.*,B.unique1 AS Bunique1,B.unique2 AS
Bunique2,B.two AS Btwo,B.four AS Bfour,B.ten AS Bten,B.twenty AS
Btwenty,B.hundred AS Bhundred,B.thousand AS Bthousand,B.twothousand AS
Btwothousand,B.fivethous AS Bfivethous,B.tenthous AS Btenthous,B.odd AS
Bodd,B.even AS Beven,B.stringu1 AS Bstringu1,B.stringu2 AS
Bstringu2,B.string4 AS Bstring4 from tenk1 t, Bprime B where t.unique2
= B.unique2)
-> Can't lock file (errno: 4009)
-Joseph
--
Joseph E. Sacco, Ph.D. <jsacco[at]earthlink[dot]net>
Benchmark DBD suite: 2.15
Date of test: 2004-08-16 15:01:11
Running tests on: Linux 2.4.25-ben1 ppc
Arguments: --create-options=type=ndb --socket=/usr/local/mysql/var/mysql.sock
Comments:
Limits from:
Server version: MySQL 4.1.4 beta/
Optimization: None
Hardware:
alter-table: Total time: 535 wallclock secs ( 0.02 usr 0.03 sys + 0.00 cusr 0.00 csys =
0.05 CPU)
ATIS: Total time: 922 wallclock secs (19.81 usr 3.74 sys + 0.00 cusr 0.00 csys = 23.55
CPU)
big-tables: Total time: 178 wallclock secs (23.97 usr 8.24 sys + 0.00 cusr 0.00 csys =
32.21 CPU)
connect: Total time: 846 wallclock secs (110.64 usr 35.51 sys + 0.00 cusr 0.00 csys =
146.15 CPU)
create: Total time: 33296 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys =
0.01 CPU)
insert: Failed (output/insert-mysql-Linux_2.4.25_ben1_ppc)
select: Estimated total time: 16104.4 wallclock secs (116.39 usr 15.65 sys + 0.00 cusr
0.00 csys = 132.04 CPU)
transactions: Total time: 108 wallclock secs ( 9.02 usr 3.26 sys + 0.00 cusr 0.00 csys
= 12.28 CPU)
wisconsin: Failed (output/wisconsin-mysql-Linux_2.4.25_ben1_ppc)
Of 9 tests, 2 tests didn't work
Tests with estimated time have a + at end of line
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 261.00 0.00 0.00 0.00 82
alter_table_drop 141.00 0.00 0.00 0.00 41
connect 21.00 17.69 1.19 18.88 10000
connect+select_1_row 60.00 19.87 2.18 22.05 10000
connect+select_simple 23.00 17.73 1.77 19.50 10000
count_distinct 192.00 0.81 0.03 0.84 1000
count_distinct_2 224.00 0.74 0.05 0.79 1000
count_distinct_big 39.00 16.05 3.56 19.61 100
count_distinct_group 241.00 2.41 0.38 2.79 1000
count_distinct_group_on_key 211.00 0.97 0.10 1.07 1000
count_distinct_group_on_key_parts 233.00 2.50 0.37 2.87 1000
count_distinct_key_prefix 179.00 0.83 0.06 0.89 1000
count_group_on_key_parts 209.00 2.32 0.38 2.70 1000
count_on_key 3293.15 28.44 3.18 31.62 50000 +
create+drop 21691.00 0.00 0.00 0.00 10000
create_MANY_tables 49.00 0.00 0.00 0.00 32
create_index 64.00 0.00 0.00 0.00 8
create_key+drop 11526.00 0.01 0.00 0.01 10000
create_table 49.00 0.00 0.00 0.00 28
delete_autocommit 13.00 0.81 0.30 1.11 10000
delete_commit 11.00 0.90 0.47 1.37 10000
delete_rollback 10.00 0.74 0.30 1.04 100
drop_index 65.00 0.00 0.00 0.00 8
drop_table 29.00 0.00 0.00 0.00 28
drop_table_when_MANY_tables 30.00 0.00 0.00 0.00 32
insert 26.00 2.17 0.71 2.88 19768
insert_autocommit 10.00 1.36 0.34 1.70 10000
insert_commit 11.00 1.26 0.30 1.56 10000
insert_many_fields 63.00 4.34 0.64 4.98 20000
insert_rollback 8.00 1.29 0.38 1.67 100
min_max_on_key 7338.22 40.05 4.40 44.44 70000 +
select_1_row 173.00 10.14 5.59 15.73 100000
select_1_row_cache 171.00 9.72 4.93 14.65 100000
select_2_rows 181.00 11.54 5.74 17.28 100000
select_big 5.00 0.29 0.07 0.36 70
select_cache 1910.00 6.30 0.54 6.84 10000
select_cache2 1910.00 6.29 0.54 6.83 10000
select_column+column 176.00 9.78 4.84 14.62 100000
select_distinct 129.00 3.78 0.54 4.32 800
select_group 306.00 3.02 0.36 3.38 2800
select_group_when_MANY_tables 0.00 0.00 0.00 0.00 32
select_join 42.00 1.11 0.28 1.39 100
select_key_prefix_join 325.00 9.42 1.96 11.38 100
select_many_fields 115.00 19.63 7.60 27.23 20000
select_range 102.00 7.40 1.60 9.00 410
select_simple 19.00 7.37 4.75 12.12 100000
select_simple_cache 19.00 6.79 4.52 11.31 100000
select_simple_join 28.00 1.30 0.29 1.59 500
update_autocommit 13.00 0.80 0.34 1.14 10000
update_commit 11.00 0.85 0.31 1.16 10000
update_rollback 11.00 1.01 0.52 1.53 100
TOTALS 51966.37 279.83 66.41 346.23 922239 ++
| Thread |
|---|
| • Running sql-bench: take 2 | Ph.D. Joseph E. Sacco | 17 Aug |
