summaryrefslogtreecommitdiff
path: root/sql-bench/Results-win32
diff options
context:
space:
mode:
Diffstat (limited to 'sql-bench/Results-win32')
-rw-r--r--sql-bench/Results-win32/ATIS-mysql-win9819
-rw-r--r--sql-bench/Results-win32/RUN-mysql-win9874
-rw-r--r--sql-bench/Results-win32/alter-table-mysql-win9816
-rw-r--r--sql-bench/Results-win32/big-tables-mysql-win9819
-rw-r--r--sql-bench/Results-win32/connect-mysql-win9827
-rw-r--r--sql-bench/Results-win32/create-mysql-win9818
-rw-r--r--sql-bench/Results-win32/insert-mysql-win9872
-rw-r--r--sql-bench/Results-win32/select-mysql-win9816
-rw-r--r--sql-bench/Results-win32/wisconsin-mysql-win9814
9 files changed, 0 insertions, 275 deletions
diff --git a/sql-bench/Results-win32/ATIS-mysql-win98 b/sql-bench/Results-win32/ATIS-mysql-win98
deleted file mode 100644
index 1febfa34bcb..00000000000
--- a/sql-bench/Results-win32/ATIS-mysql-win98
+++ /dev/null
@@ -1,19 +0,0 @@
-Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 2:22:09
-
-ATIS table test
-
-Creating tables
-Time for create_table (28): 7 wallclock secs ( 6.93 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Inserting data
-Time to insert (9768): 12 wallclock secs (11.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Retrieving data
-Time for select_simple_join (500): 7 wallclock secs ( 7.47 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_join (200): 51 wallclock secs (50.15 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_distinct (800): 33 wallclock secs (33.34 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_group (2800): 33 wallclock secs (33.61 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Removing tables
-Time to drop_table (28): 1 wallclock secs ( 0.06 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Total time: 144 wallclock secs (143.53 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/RUN-mysql-win98 b/sql-bench/Results-win32/RUN-mysql-win98
deleted file mode 100644
index 18ff522a929..00000000000
--- a/sql-bench/Results-win32/RUN-mysql-win98
+++ /dev/null
@@ -1,74 +0,0 @@
-Benchmark DBD suite: 2.7
-Date of test: 2000-03-15 1:51:13
-Running tests on: Windows 98 [Version 4.10.1998]
-Arguments:
-Comments: AMD K6, 400mz, 128M, 16M key_cache
-Limits from:
-Server version: MySQL 3.23.13a alpha
-
-alter-table: Total time: 1855 wallclock secs (1854.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-ATIS: Total time: 144 wallclock secs (143.53 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-big-tables: Total time: 151 wallclock secs (150.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-connect: Total time: 369 wallclock secs (368.94 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-create: Total time: 5141 wallclock secs (5140.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-insert: Estimated total time: 8358 wallclock secs (8356.07 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-select: Total time: 1294 wallclock secs (1293.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-wisconsin: Total time: 63 wallclock secs (62.40 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-All 8 test executed successfully
-Tests with estimated time have a + at end of line
-
-Totals per operation:
-Operation seconds usr sys cpu tests
-alter_table_add 1046 1046.38 0.00 0.00 992
-alter_table_drop 773 772.97 0.00 0.00 496
-connect 52 51.85 0.00 0.00 10000
-connect+select_1_row 72 71.95 0.00 0.00 10000
-connect+select_simple 67 66.90 0.00 0.00 10000
-count 55 54.87 0.00 0.00 100
-count_on_key 640 639.71 0.00 0.00 50100
-create+drop 1433 1433.28 0.00 0.00 10000
-create_MANY_tables 1510 1510.83 0.00 0.00 5000
-create_index 17 16.70 0.00 0.00 8
-create_key+drop 1457 1456.57 0.00 0.00 10000
-create_table 8 7.92 0.00 0.00 31
-delete_big 23 22.25 0.00 0.00 13
-delete_big_many_keys 112 112.11 0.00 0.00 2
-delete_key 0 0.82 0.00 0.00 500
-drop_index 17 16.64 0.00 0.00 8
-drop_table 1 0.06 0.00 0.00 28
-drop_table_when_MANY_tables 160 159.83 0.00 0.00 5000
-insert 510 508.11 0.00 0.00 350768
-insert_duplicates 91 91.06 0.00 0.00 300000
-insert_key 364 363.72 0.00 0.00 100000
-insert_many_fields 25 24.71 0.00 0.00 2000
-min_max 33 32.90 0.00 0.00 60
-min_max_on_key 339 339.56 0.00 0.00 73000
-multiple_value_insert 11 11.64 0.00 0.00 100000
-order_by 249 248.87 0.00 0.00 10
-order_by_key 175 174.66 0.00 0.00 10
-outer_join 146 145.66 0.00 0.00 10
-outer_join_found 144 144.40 0.00 0.00 10
-outer_join_not_found 606 605.55 0.00 0.00 500 +
-outer_join_on_key 63 63.33 0.00 0.00 10
-select_1_row 16 15.99 0.00 0.00 10000
-select_2_rows 19 18.89 0.00 0.00 10000
-select_big 304 306.16 0.00 0.00 10080
-select_diff_key 241 240.63 0.00 0.00 500
-select_distinct 33 33.34 0.00 0.00 800
-select_group 91 91.83 0.00 0.00 2911
-select_group_when_MANY_tables 581 580.46 0.00 0.00 5000
-select_join 51 50.15 0.00 0.00 200
-select_key 540 540.35 0.00 0.00 200000
-select_key_prefix 542 542.23 0.00 0.00 200000
-select_many_fields 124 124.24 0.00 0.00 2000
-select_range 423 423.21 0.00 0.00 25420
-select_range_prefix 66 66.62 0.00 0.00 25010
-select_simple 12 12.20 0.00 0.00 10000
-select_simple_join 7 7.47 0.00 0.00 500
-update_big 84 83.33 0.00 0.00 500
-update_of_key 59 59.21 0.00 0.00 756
-update_of_key_big 38 38.07 0.00 0.00 501
-update_with_key 432 432.20 0.00 0.00 100000
-wisc_benchmark 17 17.08 0.00 0.00 114
-TOTALS 13879 13879.47 0.00 0.00 1642948 +
diff --git a/sql-bench/Results-win32/alter-table-mysql-win98 b/sql-bench/Results-win32/alter-table-mysql-win98
deleted file mode 100644
index 922aa8906a9..00000000000
--- a/sql-bench/Results-win32/alter-table-mysql-win98
+++ /dev/null
@@ -1,16 +0,0 @@
-Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 1:51:14
-
-Testing of ALTER TABLE
-Testing with 1000 columns and 1000 rows in 20 steps
-Insert data into the table
-Time for insert (1000) 1 wallclock secs ( 1.09 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Time for alter_table_add (992): 1046 wallclock secs (1046.38 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Time for create_index (8): 17 wallclock secs (16.70 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Time for drop_index (8): 17 wallclock secs (16.64 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Time for alter_table_drop (496): 773 wallclock secs (772.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Total time: 1855 wallclock secs (1854.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/big-tables-mysql-win98 b/sql-bench/Results-win32/big-tables-mysql-win98
deleted file mode 100644
index dc57828441f..00000000000
--- a/sql-bench/Results-win32/big-tables-mysql-win98
+++ /dev/null
@@ -1,19 +0,0 @@
-Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 2:24:33
-
-Testing of some unusual tables
-All tests are done 1000 times with 1000 fields
-
-Testing table with 1000 fields
-Testing select * from table with 1 record
-Time to select_many_fields(1000): 55 wallclock secs (55.36 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing select all_fields from table with 1 record
-Time to select_many_fields(1000): 69 wallclock secs (68.88 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing insert VALUES()
-Time to insert_many_fields(1000): 6 wallclock secs ( 6.20 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing insert (all_fields) VALUES()
-Time to insert_many_fields(1000): 19 wallclock secs (18.51 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Total time: 151 wallclock secs (150.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/connect-mysql-win98 b/sql-bench/Results-win32/connect-mysql-win98
deleted file mode 100644
index cf0c35ddc8e..00000000000
--- a/sql-bench/Results-win32/connect-mysql-win98
+++ /dev/null
@@ -1,27 +0,0 @@
-Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 2:27:04
-
-Testing the speed of connecting to the server and sending of data
-All tests are done 10000 times
-
-Testing connection/disconnect
-Time to connect (10000): 52 wallclock secs (51.85 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Test connect/simple select/disconnect
-Time for connect+select_simple (10000): 67 wallclock secs (66.90 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Test simple select
-Time for select_simple (10000): 12 wallclock secs (12.20 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing connect/select 1 row from table/disconnect
-Time to connect+select_1_row (10000): 72 wallclock secs (71.95 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing select 1 row from table
-Time to select_1_row (10000): 16 wallclock secs (15.99 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing select 2 rows from table
-Time to select_2_rows (10000): 19 wallclock secs (18.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing retrieval of big records (65000 bytes)
-Time to select_big (10000): 130 wallclock secs (130.56 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Total time: 369 wallclock secs (368.94 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/create-mysql-win98 b/sql-bench/Results-win32/create-mysql-win98
deleted file mode 100644
index e0211664f23..00000000000
--- a/sql-bench/Results-win32/create-mysql-win98
+++ /dev/null
@@ -1,18 +0,0 @@
-Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 2:33:13
-
-Testing the speed of creating and droping tables
-Testing with 5000 tables and 10000 loop count
-
-Testing create of tables
-Time for create_MANY_tables (5000): 1510 wallclock secs (1510.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Accessing tables
-Time to select_group_when_MANY_tables (5000): 581 wallclock secs (580.46 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing drop
-Time for drop_table_when_MANY_tables (5000): 160 wallclock secs (159.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing create+drop
-Time for create+drop (10000): 1433 wallclock secs (1433.28 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for create_key+drop (10000): 1457 wallclock secs (1456.57 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Total time: 5141 wallclock secs (5140.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/insert-mysql-win98 b/sql-bench/Results-win32/insert-mysql-win98
deleted file mode 100644
index 12c85e60dee..00000000000
--- a/sql-bench/Results-win32/insert-mysql-win98
+++ /dev/null
@@ -1,72 +0,0 @@
-Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 3:59:00
-
-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
-Time for insert (300000): 438 wallclock secs (437.15 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing insert of duplicates
-Time for insert_duplicates (300000): 91 wallclock secs (91.06 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Retrieving data from the table
-Time for select_big (10:3000000): 173 wallclock secs (173.79 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for order_by_key (10:3000000): 175 wallclock secs (174.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for order_by (10:3000000): 249 wallclock secs (248.87 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_diff_key (500:1000): 241 wallclock secs (240.63 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_range_prefix (5010:42084): 33 wallclock secs (33.50 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_range (5010:42084): 34 wallclock secs (33.67 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_key_prefix (200000): 542 wallclock secs (542.23 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_key (200000): 540 wallclock secs (540.35 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Test of compares with simple ranges
-Time for select_range_prefix (20000:43500): 33 wallclock secs (33.12 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_range (20000:43500): 33 wallclock secs (33.45 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_group (111): 58 wallclock secs (58.22 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for min_max_on_key (3000): 7 wallclock secs ( 6.87 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for min_max (60): 33 wallclock secs (32.90 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for count_on_key (100): 52 wallclock secs (52.23 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for count (100): 55 wallclock secs (54.87 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing update of keys with functions
-Time for update_of_key (500): 1 wallclock secs ( 0.99 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for update_of_key_big (501): 38 wallclock secs (38.07 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing update with key
-Time for update_with_key (100000): 432 wallclock secs (432.20 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing update of all rows
-Time for update_big (500): 84 wallclock secs (83.33 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing left outer join
-Time for outer_join_on_key (10:10): 63 wallclock secs (63.33 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for outer_join (10:10): 146 wallclock secs (145.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for outer_join_found (10:10): 144 wallclock secs (144.40 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Note: Query took longer then time-limit: 600
-Estimating end time based on:
-75 queries in 74 loops of 500 loops took 606 seconds
-Estimated time for outer_join_not_found (500:506): 606 wallclock secs (605.55 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing delete
-Time for delete_key (500): 0 wallclock secs ( 0.82 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for delete_big (12): 22 wallclock secs (21.59 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Insert into table with 16 keys and with a primary key with 16 parts
-Time for insert_key (100000): 364 wallclock secs (363.72 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing update of keys
-Time for update_of_key (256): 58 wallclock secs (58.22 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Deleting everything from table
-Time for delete_big_many_keys (2): 112 wallclock secs (112.11 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Inserting 100000 rows with multiple values
-Time for multiple_value_insert (100000): 11 wallclock secs (11.64 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Time for drop table(1): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Estimated total time: 8358 wallclock secs (8356.07 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/select-mysql-win98 b/sql-bench/Results-win32/select-mysql-win98
deleted file mode 100644
index c028aaf9661..00000000000
--- a/sql-bench/Results-win32/select-mysql-win98
+++ /dev/null
@@ -1,16 +0,0 @@
-Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 5:20:12
-
-Testing the speed of selecting on keys that consist of many parts
-The test-table has 10000 rows and the test is done with 500 ranges.
-
-Creating table
-Inserting 10000 rows
-Time to insert (10000): 16 wallclock secs (15.32 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Testing big selects on the table
-Time for select_big (70:17207): 1 wallclock secs ( 1.81 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for select_range (410:1057904): 356 wallclock secs (356.09 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for min_max_on_key (70000): 332 wallclock secs (332.69 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time for count_on_key (50000): 588 wallclock secs (587.48 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Total time: 1294 wallclock secs (1293.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/wisconsin-mysql-win98 b/sql-bench/Results-win32/wisconsin-mysql-win98
deleted file mode 100644
index 71bb6b4f3de..00000000000
--- a/sql-bench/Results-win32/wisconsin-mysql-win98
+++ /dev/null
@@ -1,14 +0,0 @@
-Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 5:41:46
-
-Wisconsin benchmark test
-
-Time for create_table (3): 1 wallclock secs ( 0.99 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Inserting data
-Time to insert (31000): 44 wallclock secs (43.67 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-Time to delete_big (1): 1 wallclock secs ( 0.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Running actual benchmark
-Time for wisc_benchmark (114): 17 wallclock secs (17.08 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
-
-Total time: 63 wallclock secs (62.40 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
View Lorry Controller Status