List:Cluster« Previous MessageNext Message »
From:Ph.D. Joseph E. Sacco Date:August 17 2004 1:38pm
Subject:Running sql-bench: take 2
View as plain text  
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 2Ph.D. Joseph E. Sacco17 Aug