==================================== Environment: ==================================== model name : AMD Sempron(tm) Processor 2600+ cpu MHz : 1607.824 cache size : 128 KB ==================================== xfree compilation (debian/rules binary): ==================================== Physical machine without xen: real: 90m8.975s user: 51m45.384s sys: 40m51.278s Virtual xen domain: real: 98m35.681s user: 52m49.00s sys: 41m6.620s ==================================== Apache benchmark ==================================== apache 1.3 (default config), I create file: lab02:/var/www# dd if=/dev/urandom of=test.mp3 count=2048 2048+0 rekord� wczytanych 2048+0 rekord� zapisanych 1048576 bytes transferred in 0,294043 seconds (3566062 bytes/sec) lab02:/var/www# next ab test Physical machine without xen: Concurrency Level: 50 Time taken for tests: 91.256688 seconds Complete requests: 1000 Failed requests: 0 Write errors: 0 Total transferred: 1073128548 bytes HTML transferred: 1072847952 bytes Requests per second: 10.96 [#/sec] (mean) Time per request: 4562.835 [ms] (mean) Time per request: 91.257 [ms] (mean, across all concurrent requests) Transfer rate: 11483.84 [Kbytes/sec] received Virtual xen domain: Concurrency Level: 50 Time taken for tests: 109.71549 seconds Complete requests: 1000 Failed requests: 0 Write errors: 0 Total transferred: 1051454745 bytes HTML transferred: 1051181530 bytes Requests per second: 9.17 [#/sec] (mean) Time per request: 5453.577 [ms] (mean) Time per request: 109.072 [ms] (mean, across all concurrent requests) Transfer rate: 9414.10 [Kbytes/sec] received ==================================== Wydajność tomcata jsp: ==================================== http://lab02.hq.eo.pl:8080/jsp-examples/jsp2/jspattribute/jspattribute.jsp http://xen_06.hq.eo.pl:8080/jsp-examples/jsp2/jspattribute/jspattribute.jsp Physical machine without xen: ab -n 1000 -c 50 http://lab02.hq.eo.pl:8080/servlets-examples/servlet/RequestInfoExample Concurrency Level: 50 Time taken for tests: 0.896621 seconds Complete requests: 1000 Failed requests: 0 Write errors: 0 Total transferred: 861000 bytes HTML transferred: 694000 bytes Requests per second: 1115.30 [#/sec] (mean) Time per request: 44.831 [ms] (mean) Time per request: 0.897 [ms] (mean, across all concurrent requests) Transfer rate: 936.85 [Kbytes/sec] received Virtual xen domain: ab -n 1000 -c 50 http://xen_06.hq.eo.pl:8080/servlets-examples/servlet/RequestInfoExample Concurrency Level: 50 Time taken for tests: 1.343357 seconds Complete requests: 1000 Failed requests: 0 Write errors: 0 Total transferred: 861000 bytes HTML transferred: 694000 bytes Requests per second: 744.40 [#/sec] (mean) Time per request: 67.168 [ms] (mean) Time per request: 1.343 [ms] (mean, across all concurrent requests) Transfer rate: 625.30 [Kbytes/sec] received ==================================== Wydajność tomcata servlet: ==================================== http://lab02.hq.eo.pl:8080/servlets-examples/servlet/RequestInfoExample http://xen_06.hq.eo.pl:8080/servlets-examples/servlet/RequestInfoExample Physical machine without xen: ab -n 1000 -c 50 http://lab02.hq.eo.pl:8080/servlets-examples/servlet/RequestInfoExample Concurrency Level: 50 Time taken for tests: 0.890387 seconds Complete requests: 1000 Failed requests: 0 Write errors: 0 Total transferred: 861000 bytes HTML transferred: 694000 bytes Requests per second: 1123.11 [#/sec] (mean) Time per request: 44.519 [ms] (mean) Time per request: 0.890 [ms] (mean, across all concurrent requests) Transfer rate: 943.41 [Kbytes/sec] received Virtual xen domain: ab -n 1000 -c 50 http://xen_06.hq.eo.pl:8080/servlets-examples/servlet/RequestInfoExample Concurrency Level: 50 Time taken for tests: 1.355204 seconds Complete requests: 1000 Failed requests: 0 Write errors: 0 Total transferred: 861000 bytes HTML transferred: 694000 bytes Requests per second: 737.90 [#/sec] (mean) Time per request: 67.760 [ms] (mean) Time per request: 1.355 [ms] (mean, across all concurrent requests) Transfer rate: 619.83 [Kbytes/sec] received ==================================== Database, MySQL: ==================================== Physical machine without xen: alter-table: Total time: 26 wallclock secs ( 0.04 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.04 CPU) ATIS: Total time: 8 wallclock secs ( 5.89 usr 1.18 sys + 0.00 cusr 0.00 csys = 7.07 CPU) big-tables: Total time: 9 wallclock secs ( 3.37 usr 2.27 sys + 0.00 cusr 0.00 csys = 5.64 CPU) connect: Total time: 94 wallclock secs (33.80 usr 10.41 sys + 0.00 cusr 0.00 csys = 44.21 CPU) create: Total time: 234 wallclock secs ( 3.60 usr 0.63 sys + 0.00 cusr 0.00 csys = 4.23 CPU) insert: Total time: 1356 wallclock secs (424.01 usr 62.06 sys + 0.00 cusr 0.00 csys = 486.07 CPU) select: Total time: 74 wallclock secs (29.56 usr 4.06 sys + 0.00 cusr 0.00 csys = 33.62 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 9 wallclock secs ( 2.50 usr 0.86 sys + 0.00 cusr 0.00 csys = 3.36 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 10.00 0.02 0.00 0.02 100 alter_table_drop 11.00 0.01 0.00 0.01 91 connect 7.00 4.64 0.57 5.21 10000 connect+select_1_row 10.00 5.46 0.70 6.16 10000 connect+select_simple 8.00 4.92 0.68 5.60 10000 count 12.00 0.03 0.00 0.03 100 count_distinct 0.00 0.11 0.02 0.13 1000 count_distinct_2 0.00 0.11 0.02 0.13 1000 count_distinct_big 8.00 5.38 1.10 6.48 120 count_distinct_group 1.00 0.64 0.09 0.73 1000 count_distinct_group_on_key 0.00 0.15 0.02 0.17 1000 count_distinct_group_on_key_parts 1.00 0.65 0.10 0.75 1000 count_distinct_key_prefix 1.00 0.11 0.01 0.12 1000 count_group_on_key_parts 0.00 0.63 0.09 0.72 1000 count_on_key 17.00 5.14 0.49 5.63 50100 creat1+drop 71.00 0.77 0.08 0.85 10000 create_MANY_tables 84.00 1.29 0.16 1.45 10000 create_index 3.00 0.00 0.00 0.00 8 create_key+drop 72.00 0.45 0.13 0.58 10000 create_table 0.00 0.00 0.01 0.01 31 delete_all_many_keys 68.00 0.01 0.00 0.01 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 68.00 0.01 0.00 0.01 128 delete_key 1.00 0.24 0.07 0.31 10000 delete_range 5.00 0.00 0.00 0.00 12 drop_index 2.00 0.00 0.00 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 3.00 0.52 0.11 0.63 10000 insert 62.00 10.33 2.15 12.48 350768 insert_duplicates 12.00 0.95 0.24 1.19 100000 insert_key 211.00 8.65 1.33 9.98 100000 insert_many_fields 3.00 0.27 0.04 0.31 2000 insert_select_1_key 2.00 0.00 0.00 0.00 1 insert_select_2_keys 2.00 0.00 0.00 0.00 1 min_max 3.00 0.01 0.00 0.01 60 min_max_on_key 15.00 9.43 0.94 10.37 85000 multiple_value_insert 1.00 0.25 0.00 0.25 100000 once_prepared_select 33.00 5.00 1.06 6.06 100000 order_by_big 32.00 15.61 3.24 18.85 10 order_by_big_key 23.00 15.98 3.55 19.53 10 order_by_big_key2 21.00 15.68 3.37 19.05 10 order_by_big_key_desc 22.00 16.03 3.65 19.68 10 order_by_big_key_diff 31.00 15.60 3.03 18.63 10 order_by_big_key_prefix 22.00 15.67 3.56 19.23 10 order_by_key2_diff 2.00 1.43 0.22 1.65 500 order_by_key_prefix 2.00 0.78 0.11 0.89 500 order_by_range 2.00 0.77 0.12 0.89 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 2.00 0.00 0.00 0.00 10 outer_join_not_found 1.00 0.00 0.00 0.00 500 outer_join_on_key 2.00 0.00 0.00 0.00 10 prepared_select 47.00 18.04 1.72 19.76 100000 select_1_row 12.00 2.70 1.47 4.17 100000 select_1_row_cache 5.00 1.73 1.29 3.02 100000 select_2_rows 16.00 3.47 1.70 5.17 100000 select_big 21.00 15.79 3.35 19.14 80 select_big_str 11.00 4.92 0.99 5.91 10000 select_cache 1.00 0.90 0.12 1.02 10000 select_cache2 36.00 2.25 0.18 2.43 10000 select_column+column 15.00 2.93 1.27 4.20 100000 select_diff_key 53.00 0.15 0.01 0.16 500 select_distinct 2.00 1.15 0.23 1.38 800 select_group 2.00 0.75 0.14 0.89 2911 select_group_when_MANY_tables 4.00 0.56 0.15 0.71 10000 select_join 1.00 0.33 0.06 0.39 100 select_key 79.00 39.96 4.41 44.37 200000 select_key2 84.00 40.47 4.55 45.02 200000 select_key2_return_key 78.00 38.48 4.03 42.51 200000 select_key2_return_prim 83.00 39.69 4.32 44.01 200000 select_key_prefix 84.00 40.15 4.52 44.67 200000 select_key_prefix_join 3.00 3.00 0.62 3.62 100 select_key_return_key 74.00 38.31 3.75 42.06 200000 select_many_fields 6.00 3.09 2.23 5.32 2000 select_range 9.00 6.01 1.01 7.02 410 select_range_key2 3.00 2.42 0.31 2.73 25010 select_range_prefix 2.00 2.45 0.29 2.74 25010 select_simple 5.00 1.73 0.98 2.71 100000 select_simple_cache 5.00 1.30 0.76 2.06 100000 select_simple_join 0.00 0.39 0.06 0.45 500 update_big 16.00 0.00 0.00 0.00 10 update_of_key 16.00 2.25 0.44 2.69 50000 update_of_key_big 9.00 0.02 0.00 0.02 501 update_of_primary_key_many_keys 46.00 0.01 0.00 0.01 256 update_with_key 52.00 10.28 2.32 12.60 300000 update_with_key_prefix 16.00 5.23 1.38 6.61 100000 wisc_benchmark 3.00 1.50 0.64 2.14 114 TOTALS 1870.00 496.14 80.36 576.50 3425950 Virtual xen domain: alter-table: Total time: 14 wallclock secs ( 0.04 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.05 CPU) ATIS: Total time: 10 wallclock secs ( 7.21 usr 0.88 sys + 0.00 cusr 0.00 csys = 8.09 CPU) big-tables: Total time: 10 wallclock secs ( 3.74 usr 1.83 sys + 0.00 cusr 0.00 csys = 5.57 CPU) connect: Total time: 121 wallclock secs (44.69 usr 12.37 sys + 0.00 cusr 0.00 csys = 57.06 CPU) create: Total time: 310 wallclock secs ( 1.39 usr 0.49 sys + 0.00 cusr 0.00 csys = 1.88 CPU) insert: Total time: 1343 wallclock secs (506.68 usr 76.88 sys + 0.00 cusr 0.00 csys = 583.56 CPU) select: Total time: 93 wallclock secs (39.86 usr 4.98 sys + 0.00 cusr 0.00 csys = 44.84 CPU) transactions: Test skipped because the database doesn't support transactions wisconsin: Total time: 10 wallclock secs ( 3.15 usr 0.64 sys + 0.00 cusr 0.00 csys = 3.79 CPU) All 9 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 6.00 0.01 0.00 0.01 100 alter_table_drop 6.00 0.00 0.00 0.00 91 connect 10.00 5.81 0.65 6.46 10000 connect+select_1_row 13.00 5.79 0.90 6.69 10000 connect+select_simple 12.00 6.15 0.98 7.13 10000 count 13.00 0.00 0.00 0.00 100 count_distinct 1.00 0.18 0.03 0.21 1000 count_distinct_2 0.00 0.23 0.02 0.25 1000 count_distinct_big 8.00 5.93 0.90 6.83 120 count_distinct_group 1.00 0.78 0.11 0.89 1000 count_distinct_group_on_key 0.00 0.22 0.00 0.22 1000 count_distinct_group_on_key_parts 1.00 0.81 0.10 0.91 1000 count_distinct_key_prefix 0.00 0.15 0.06 0.21 1000 count_group_on_key_parts 1.00 0.78 0.07 0.85 1000 count_on_key 25.00 8.62 0.72 9.34 50100 create+drop 100.00 0.00 0.00 0.00 10000 create_MANY_tables 101.00 0.00 0.00 0.00 10000 create_index 1.00 0.00 0.00 0.00 8 create_key+drop 101.00 0.00 0.00 0.00 10000 create_table 1.00 0.00 0.00 0.00 31 delete_all_many_keys 41.00 0.01 0.01 0.02 1 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 41.00 0.01 0.01 0.02 128 delete_key 2.00 0.40 0.12 0.52 10000 delete_range 4.00 0.01 0.00 0.01 12 drop_index 1.00 0.01 0.00 0.01 8 drop_table 0.00 0.00 0.00 0.00 28 drop_table_when_MANY_tables 4.00 0.77 0.22 0.99 10000 insert 79.00 17.46 5.28 22.74 350768 insert_duplicates 17.00 4.46 1.14 5.60 100000 insert_key 102.00 9.86 2.30 12.16 100000 insert_many_fields 4.00 0.27 0.04 0.31 2000 insert_select_1_key 1.00 0.00 0.00 0.00 1 insert_select_2_keys 2.00 0.00 0.00 0.00 1 min_max 4.00 0.02 0.00 0.02 60 min_max_on_key 22.00 13.96 1.53 15.49 85000 multiple_value_insert 1.00 0.26 0.03 0.29 100000 once_prepared_select 38.00 10.31 2.48 12.79 100000 order_by_big 28.00 17.67 2.52 20.19 10 order_by_big_key 24.00 18.08 2.55 20.63 10 order_by_big_key2 22.00 17.69 2.55 20.24 10 order_by_big_key_desc 25.00 18.22 2.72 20.94 10 order_by_big_key_diff 28.00 17.85 2.32 20.17 10 order_by_big_key_prefix 23.00 17.50 2.69 20.19 10 order_by_key2_diff 2.00 1.56 0.17 1.73 500 order_by_key_prefix 2.00 0.82 0.15 0.97 500 order_by_range 2.00 0.90 0.13 1.03 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 2.00 0.00 0.00 0.00 10 outer_join_not_found 1.00 0.00 0.00 0.00 500 outer_join_on_key 2.00 0.00 0.00 0.00 10 prepared_select 54.00 22.47 2.84 25.31 100000 select_1_row 17.00 4.68 1.85 6.53 100000 select_1_row_cache 5.00 2.29 1.25 3.54 100000 select_2_rows 23.00 5.76 2.01 7.77 100000 select_big 23.00 17.60 2.81 20.41 80 select_big_str 11.00 5.20 1.15 6.35 10000 select_cache 3.00 1.51 0.27 1.78 10000 select_cache2 38.00 2.06 0.31 2.37 10000 select_column+column 21.00 5.13 1.62 6.75 100000 select_diff_key 53.00 0.19 0.06 0.25 500 select_distinct 2.00 1.33 0.14 1.47 800 select_group 2.00 0.95 0.15 1.10 2911 select_group_when_MANY_tables 4.00 0.62 0.27 0.89 10000 select_join 0.00 0.38 0.05 0.43 100 select_key 92.00 45.86 5.92 51.78 200000 select_key2 97.00 45.73 5.86 51.59 200000 select_key2_return_key 93.00 45.69 5.84 51.53 200000 select_key2_return_prim 95.00 46.34 5.86 52.20 200000 select_key_prefix 96.00 46.47 6.00 52.47 200000 select_key_prefix_join 4.00 3.43 0.37 3.80 100 select_key_return_key 89.00 44.77 5.33 50.10 200000 select_many_fields 6.00 3.47 1.79 5.26 2000 select_range 10.00 6.77 0.93 7.70 410 select_range_key2 5.00 3.19 0.37 3.56 25010 select_range_prefix 4.00 3.12 0.35 3.47 25010 select_simple 4.00 2.06 1.01 3.07 100000 select_simple_cache 5.00 1.82 0.95 2.77 100000 select_simple_join 1.00 0.46 0.05 0.51 500 update_big 10.00 0.00 0.00 0.00 10 update_of_key 19.00 2.83 1.05 3.88 50000 update_of_key_big 7.00 0.03 0.00 0.03 501 update_of_primary_key_many_keys 30.00 0.04 0.00 0.04 256 update_with_key 69.00 13.87 5.11 18.98 300000 insert_key 102.00 9.86 2.30 12.16 100000 insert_many_fields 4.00 0.27 0.04 0.31 2000 insert_select_1_key 1.00 0.00 0.00 0.00 1 insert_select_2_keys 2.00 0.00 0.00 0.00 1 min_max 4.00 0.02 0.00 0.02 60 min_max_on_key 22.00 13.96 1.53 15.49 85000 multiple_value_insert 1.00 0.26 0.03 0.29 100000 once_prepared_select 38.00 10.31 2.48 12.79 100000 order_by_big 28.00 17.67 2.52 20.19 10 order_by_big_key 24.00 18.08 2.55 20.63 10 order_by_big_key2 22.00 17.69 2.55 20.24 10 order_by_big_key_desc 25.00 18.22 2.72 20.94 10 order_by_big_key_diff 28.00 17.85 2.32 20.17 10 order_by_big_key_prefix 23.00 17.50 2.69 20.19 10 order_by_key2_diff 2.00 1.56 0.17 1.73 500 order_by_key_prefix 2.00 0.82 0.15 0.97 500 order_by_range 2.00 0.90 0.13 1.03 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 2.00 0.00 0.00 0.00 10 outer_join_not_found 1.00 0.00 0.00 0.00 500 outer_join_on_key 2.00 0.00 0.00 0.00 10 prepared_select 54.00 22.47 2.84 25.31 100000 select_1_row 17.00 4.68 1.85 6.53 100000 select_1_row_cache 5.00 2.29 1.25 3.54 100000 select_2_rows 23.00 5.76 2.01 7.77 100000 select_big 23.00 17.60 2.81 20.41 80 select_big_str 11.00 5.20 1.15 6.35 10000 select_cache 3.00 1.51 0.27 1.78 10000 select_cache2 38.00 2.06 0.31 2.37 10000 select_column+column 21.00 5.13 1.62 6.75 100000 select_diff_key 53.00 0.19 0.06 0.25 500 select_distinct 2.00 1.33 0.14 1.47 800 select_group 2.00 0.95 0.15 1.10 2911 select_group_when_MANY_tables 4.00 0.62 0.27 0.89 10000 select_join 0.00 0.38 0.05 0.43 100 select_key 92.00 45.86 5.92 51.78 200000 select_key2 97.00 45.73 5.86 51.59 200000 select_key2_return_key 93.00 45.69 5.84 51.53 200000 select_key2_return_prim 95.00 46.34 5.86 52.20 200000 select_key_prefix 96.00 46.47 6.00 52.47 200000 select_key_prefix_join 4.00 3.43 0.37 3.80 100 select_key_return_key 89.00 44.77 5.33 50.10 200000 select_many_fields 6.00 3.47 1.79 5.26 2000 select_range 10.00 6.77 0.93 7.70 410 select_range_key2 5.00 3.19 0.37 3.56 25010 select_range_prefix 4.00 3.12 0.35 3.47 25010 select_simple 4.00 2.06 1.01 3.07 100000 select_simple_cache 5.00 1.82 0.95 2.77 100000 select_simple_join 1.00 0.46 0.05 0.51 500 update_big 10.00 0.00 0.00 0.00 10 update_of_key 19.00 2.83 1.05 3.88 50000 update_of_key_big 7.00 0.03 0.00 0.03 501 update_of_primary_key_many_keys 30.00 0.04 0.00 0.04 256 update_with_key 69.00 13.87 5.11 18.98 300000 insert_key 102.00 9.86 2.30 12.16 100000 insert_many_fields 4.00 0.27 0.04 0.31 2000 insert_select_1_key 1.00 0.00 0.00 0.00 1 insert_select_2_keys 2.00 0.00 0.00 0.00 1 min_max 4.00 0.02 0.00 0.02 60 min_max_on_key 22.00 13.96 1.53 15.49 85000 multiple_value_insert 1.00 0.26 0.03 0.29 100000 once_prepared_select 38.00 10.31 2.48 12.79 100000 order_by_big 28.00 17.67 2.52 20.19 10 order_by_big_key 24.00 18.08 2.55 20.63 10 order_by_big_key2 22.00 17.69 2.55 20.24 10 order_by_big_key_desc 25.00 18.22 2.72 20.94 10 order_by_big_key_diff 28.00 17.85 2.32 20.17 10 order_by_big_key_prefix 23.00 17.50 2.69 20.19 10 order_by_key2_diff 2.00 1.56 0.17 1.73 500 order_by_key_prefix 2.00 0.82 0.15 0.97 500 order_by_range 2.00 0.90 0.13 1.03 500 outer_join 2.00 0.00 0.00 0.00 10 outer_join_found 2.00 0.00 0.00 0.00 10 outer_join_not_found 1.00 0.00 0.00 0.00 500 outer_join_on_key 2.00 0.00 0.00 0.00 10 prepared_select 54.00 22.47 2.84 25.31 100000 select_1_row 17.00 4.68 1.85 6.53 100000 select_1_row_cache 5.00 2.29 1.25 3.54 100000 select_2_rows 23.00 5.76 2.01 7.77 100000 select_big 23.00 17.60 2.81 20.41 80 select_big_str 11.00 5.20 1.15 6.35 10000 select_cache 3.00 1.51 0.27 1.78 10000 select_cache2 38.00 2.06 0.31 2.37 10000 select_column+column 21.00 5.13 1.62 6.75 100000 select_diff_key 53.00 0.19 0.06 0.25 500 select_distinct 2.00 1.33 0.14 1.47 800 select_group 2.00 0.95 0.15 1.10 2911 select_group_when_MANY_tables 4.00 0.62 0.27 0.89 10000 select_join 0.00 0.38 0.05 0.43 100 select_key 92.00 45.86 5.92 51.78 200000 select_key2 97.00 45.73 5.86 51.59 200000 select_key2_return_key 93.00 45.69 5.84 51.53 200000 select_key2_return_prim 95.00 46.34 5.86 52.20 200000 select_key_prefix 96.00 46.47 6.00 52.47 200000 select_key_prefix_join 4.00 3.43 0.37 3.80 100 select_key_return_key 89.00 44.77 5.33 50.10 200000 select_many_fields 6.00 3.47 1.79 5.26 2000 select_range 10.00 6.77 0.93 7.70 410 select_range_key2 5.00 3.19 0.37 3.56 25010 select_range_prefix 4.00 3.12 0.35 3.47 25010 select_simple 4.00 2.06 1.01 3.07 100000 select_simple_cache 5.00 1.82 0.95 2.77 100000 select_simple_join 1.00 0.46 0.05 0.51 500 update_big 10.00 0.00 0.00 0.00 10 update_of_key 19.00 2.83 1.05 3.88 50000 update_of_key_big 7.00 0.03 0.00 0.03 501 update_of_primary_key_many_keys 30.00 0.04 0.00 0.04 256 update_with_key 69.00 13.87 5.11 18.98 300000 update_with_key_prefix 22.00 7.81 1.83 9.64 100000 wisc_benchmark 2.00 1.67 0.18 1.85 114 TOTALS 1943.00 599.16 97.08 696.24 3425950 ==================================== Database, postgresql: ==================================== Physical machine without xen: alter-table: Total time: 3 wallclock secs ( 0.50 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.54 CPU) ATIS: Failed (output/ATIS-Pg-Linux_2.6.11_eo_lab_k7_i686) big-tables: Total time: 68 wallclock secs ( 3.80 usr 0.16 sys + 0.00 cusr 0.00 csys = 3.96 CPU) connect: Total time: 427 wallclock secs (152.65 usr 15.53 sys + 0.00 cusr 0.00 csys = 168.18 CPU) create: Total time: 450 wallclock secs (14.90 usr 1.12 sys + 0.00 cusr 0.00 csys = 16.02 CPU) insert: Total time: 8711 wallclock secs (670.56 usr 47.00 sys + 0.00 cusr 0.00 csys = 717.56 CPU) select: Total time: 748 wallclock secs (50.52 usr 3.07 sys + 0.00 cusr 0.00 csys = 53.59 CPU) transactions: Total time: 60 wallclock secs (20.22 usr 1.85 sys + 0.00 cusr 0.00 csys = 22.07 CPU) wisconsin: Total time: 34 wallclock secs ( 9.60 usr 1.04 sys + 0.00 cusr 0.00 csys = 10.64 CPU) Of 9 tests, 1 tests didn't work Totals per operation: Operation seconds usr sys cpu tests alter_table_add 2.00 0.28 0.03 0.31 992 connect 33.00 6.34 1.28 7.62 10000 connect+select_1_row 48.00 8.95 1.50 10.45 10000 connect+select_simple 40.00 8.88 1.56 10.44 10000 count 19.00 0.03 0.00 0.03 100 count_distinct 14.00 0.23 0.03 0.26 1000 count_distinct_2 22.00 0.27 0.02 0.29 1000 count_distinct_big 128.00 5.53 0.03 5.56 120 count_distinct_group 90.00 0.80 0.04 0.84 1000 count_distinct_group_on_key 29.00 0.27 0.03 0.30 1000 count_distinct_group_on_key_parts 90.00 0.81 0.02 0.83 1000 count_distinct_key_prefix 56.00 0.28 0.03 0.31 1000 count_group_on_key_parts 9.00 0.77 0.01 0.78 1000 count_on_key 188.00 11.53 0.97 12.50 50100 create+drop 251.00 4.94 0.42 5.36 10000 create_MANY_tables 85.00 1.72 0.15 1.87 5000 create_index 0.00 0.00 0.00 0.00 8 create_key+drop 86.00 5.92 0.36 6.28 10000 create_table 0.00 0.00 0.00 0.00 3 delete_all_many_keys 13.00 0.02 0.00 0.02 1 delete_autocommit 9.00 2.38 0.19 2.57 10000 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 10.00 0.02 0.00 0.02 128 delete_commit 5.00 2.31 0.19 2.50 10000 delete_key 20.00 2.11 0.17 2.28 10000 delete_range 10.00 0.01 0.00 0.01 12 delete_rollback 5.00 2.25 0.29 2.54 100 drop_index 0.00 0.00 0.00 0.00 8 drop_table_when_MANY_tables 23.00 1.08 0.10 1.18 5000 insert 324.00 77.13 6.06 83.19 341000 insert_autocommit 9.00 2.34 0.20 2.54 10000 insert_commit 5.00 2.18 0.23 2.41 10000 insert_duplicates 83.00 22.70 2.30 25.00 100000 insert_key 1953.00 25.79 1.92 27.71 100000 insert_many_fields 27.00 0.51 0.05 0.56 2000 insert_rollback 5.00 2.27 0.16 2.43 100 insert_select_1_key 7.00 0.00 0.00 0.00 1 insert_select_2_keys 10.00 0.00 0.00 0.00 1 min_max 6.00 0.01 0.01 0.02 60 min_max_on_key 57.00 19.01 1.54 20.55 85000 once_prepared_select 29.00 8.49 0.95 9.44 100000 order_by_big 39.00 15.20 0.11 15.31 10 order_by_big_key 42.00 17.50 0.21 17.71 10 order_by_big_key2 37.00 15.19 0.12 15.31 10 order_by_big_key_desc 43.00 17.47 0.24 17.71 10 order_by_big_key_diff 39.00 15.19 0.14 15.33 10 order_by_big_key_prefix 38.00 15.13 0.12 15.25 10 order_by_key2_diff 2.00 1.37 0.01 1.38 500 order_by_key_prefix 2.00 0.78 0.02 0.80 500 order_by_range 1.00 0.75 0.03 0.78 500 outer_join 67.00 0.00 0.00 0.00 10 outer_join_found 24.00 0.01 0.00 0.01 10 outer_join_not_found 68.00 0.00 0.00 0.00 500 outer_join_on_key 58.00 0.00 0.00 0.00 10 prepared_select 62.00 22.49 1.68 24.17 100000 select_1_row 51.00 20.64 1.80 22.44 100000 select_1_row_cache 49.00 21.10 1.60 22.70 100000 select_2_rows 51.00 20.73 1.60 22.33 100000 select_big 22.00 15.36 0.14 15.50 80 select_big_str 17.00 5.58 1.38 6.96 10000 select_cache 82.00 2.24 0.17 2.41 10000 select_cache2 82.00 2.24 0.16 2.40 10000 select_column+column 60.00 21.61 1.74 23.35 100000 select_diff_key 0.00 0.13 0.01 0.14 500 select_group 68.00 0.04 0.00 0.04 111 select_group_when_MANY_tables 5.00 1.24 0.09 1.33 5000 select_key 135.00 47.84 4.09 51.93 200000 select_key2 129.00 47.94 4.09 52.03 200000 select_key2_return_key 126.00 47.47 4.12 51.59 200000 select_key2_return_prim 129.00 48.26 4.07 52.33 200000 select_key_prefix 129.00 47.82 4.24 52.06 200000 select_key_return_key 133.00 47.63 4.04 51.67 200000 select_many_fields 41.00 3.29 0.11 3.40 2000 select_range 25.00 7.49 0.10 7.59 410 select_range_key2 19.00 4.67 0.27 4.94 25010 select_range_prefix 23.00 4.71 0.29 5.00 25010 select_simple 39.00 19.50 1.61 21.11 100000 select_simple_cache 39.00 19.32 1.46 20.78 100000 update_autocommit 10.00 2.24 0.18 2.42 10000 update_big 291.00 0.01 0.00 0.01 10 update_commit 6.00 2.10 0.22 2.32 10000 update_of_key 112.00 10.61 0.80 11.41 50000 update_of_key_big 60.00 0.12 0.01 0.13 501 update_of_primary_key_many_keys 3707.00 0.06 0.01 0.07 256 update_rollback 6.00 2.13 0.19 2.32 100 update_with_key 366.00 62.80 4.81 67.61 300000 update_with_key_prefix 120.00 24.86 2.30 27.16 100000 wisc_benchmark 5.00 2.45 0.42 2.87 114 TOTALS 10459.00 913.47 69.64 983.11 3357927 Virtual xen domain: alter-table: Total time: 3 wallclock secs ( 0.47 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.51 CPU) ATIS: Failed (output/ATIS-Pg-Linux_2.6.12.6_xenU_i686) big-tables: Total time: 72 wallclock secs ( 4.60 usr 0.14 sys + 0.00 cusr 0.00 csys = 4.74 CPU) connect: Total time: 522 wallclock secs (175.24 usr 22.06 sys + 0.00 cusr 0.00 csys = 197.30 CPU) create: Failed (output/create-Pg-Linux_2.6.12.6_xenU_i686) insert: Total time: 7069 wallclock secs (756.65 usr 64.60 sys + 0.00 cusr 0.00 csys = 821.25 CPU) select: Total time: 698 wallclock secs (57.15 usr 4.35 sys + 0.00 cusr 0.00 csys = 61.50 CPU) transactions: Total time: 63 wallclock secs (23.77 usr 2.88 sys + 0.00 cusr 0.00 csys = 26.65 CPU) wisconsin: Total time: 31 wallclock secs ( 7.48 usr 0.60 sys + 0.00 cusr 0.00 csys = 8.08 CPU) Of 9 tests, 2 tests didn't work Totals per operation: Operation seconds usr sys cpu tests alter_table_add 2.00 0.30 0.03 0.33 992 connect 44.00 6.92 2.20 9.12 10000 connect+select_1_row 64.00 9.38 2.09 11.47 10000 connect+select_simple 53.00 9.60 2.24 11.84 10000 count 18.00 0.00 0.00 0.00 100 count_distinct 14.00 0.28 0.02 0.30 1000 count_distinct_2 23.00 0.34 0.03 0.37 1000 count_distinct_big 50.00 6.33 0.11 6.44 120 count_distinct_group 90.00 1.03 0.04 1.07 1000 count_distinct_group_on_key 23.00 0.29 0.05 0.34 1000 count_distinct_group_on_key_parts 91.00 0.80 0.02 0.82 1000 count_distinct_key_prefix 23.00 0.35 0.03 0.38 1000 count_group_on_key_parts 10.00 0.80 0.05 0.85 1000 count_on_key 161.00 12.86 1.17 14.03 50100 create_index 0.00 0.00 0.00 0.00 8 create_table 0.00 0.00 0.00 0.00 3 delete_all_many_keys 2.00 0.01 0.00 0.01 1 delete_autocommit 9.00 2.67 0.31 2.98 10000 delete_big 0.00 0.00 0.00 0.00 1 delete_big_many_keys 2.00 0.01 0.00 0.01 128 delete_commit 6.00 2.55 0.26 2.81 10000 delete_key 11.00 2.37 0.21 2.58 10000 delete_range 5.00 0.00 0.00 0.00 12 delete_rollback 6.00 2.47 0.31 2.78 100 drop_index 0.00 0.01 0.00 0.01 8 insert 288.00 69.83 6.56 76.39 341000 insert_autocommit 9.00 3.34 0.26 3.60 10000 insert_commit 5.00 2.52 0.35 2.87 10000 insert_duplicates 80.00 24.86 2.77 27.63 100000 insert_key 1135.00 27.39 2.90 30.29 100000 insert_many_fields 28.00 0.56 0.02 0.58 2000 insert_rollback 5.00 2.59 0.41 3.00 100 insert_select_1_key 6.00 0.00 0.00 0.00 1 insert_select_2_keys 12.00 0.00 0.00 0.00 1 min_max 6.00 0.01 0.00 0.01 60 min_max_on_key 64.00 21.76 2.23 23.99 85000 once_prepared_select 35.00 11.31 1.70 13.01 100000 order_by_big 42.00 17.28 0.35 17.63 10 order_by_big_key 46.00 19.38 0.60 19.98 10 order_by_big_key2 41.00 17.61 0.30 17.91 10 order_by_big_key_desc 47.00 19.52 0.57 20.09 10 order_by_big_key_diff 41.00 17.30 0.36 17.66 10 order_by_big_key_prefix 41.00 17.28 0.32 17.60 10 order_by_key2_diff 2.00 1.52 0.00 1.52 500 order_by_key_prefix 2.00 0.94 0.00 0.94 500 order_by_range 1.00 0.81 0.04 0.85 500 outer_join 67.00 0.00 0.00 0.00 10 outer_join_found 20.00 0.00 0.00 0.00 10 outer_join_not_found 66.00 0.00 0.00 0.00 500 outer_join_on_key 57.00 0.01 0.00 0.01 10 prepared_select 70.00 25.03 2.52 27.55 100000 select_1_row 59.00 23.64 2.25 25.89 100000 select_1_row_cache 59.00 24.09 2.30 26.39 100000 select_2_rows 60.00 24.07 2.45 26.52 100000 select_big 25.00 17.46 0.34 17.80 80 select_big_str 19.00 6.50 1.82 8.32 10000 select_cache 82.00 2.56 0.24 2.80 10000 select_cache2 81.00 2.34 0.28 2.62 10000 select_column+column 69.00 25.52 2.03 27.55 100000 select_diff_key 1.00 0.15 0.00 0.15 500 select_group 58.00 0.03 0.00 0.03 111 select_key 151.00 53.16 5.36 58.52 200000 select_key2 145.00 55.19 5.56 60.75 200000 select_key2_return_key 142.00 52.55 5.63 58.18 200000 select_key2_return_prim 143.00 53.61 5.67 59.28 200000 select_key_prefix 144.00 52.13 5.71 57.84 200000 select_key_return_key 148.00 52.99 5.69 58.68 200000 select_many_fields 44.00 4.04 0.12 4.16 2000 select_range 27.00 8.32 0.13 8.45 410 select_range_key2 24.00 5.53 0.47 6.00 25010 select_range_prefix 23.00 5.10 0.40 5.50 25010 select_simple 47.00 22.86 2.37 25.23 100000 select_simple_cache 48.00 22.66 2.31 24.97 100000 update_autocommit 10.00 2.81 0.26 3.07 10000 update_big 333.00 0.00 0.00 0.00 10 update_commit 6.00 2.46 0.33 2.79 10000 update_of_key 78.00 9.70 0.92 10.62 50000 update_of_key_big 38.00 0.13 0.00 0.13 501 update_of_primary_key_many_keys 2977.00 0.06 0.02 0.08 256 update_rollback 7.00 2.35 0.38 2.73 100 update_with_key 334.00 74.85 7.16 82.01 300000 update_with_key_prefix 109.00 45.47 2.63 48.10 100000 wisc_benchmark 4.00 2.64 0.11 2.75 114 TOTALS 8418.00 1015.19 94.37 1109.56 3322927