From 518a621adf75a55cad471f82d926842f3bcbf997 Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 14 Oct 2000 03:16:35 +0300 Subject: Fix of LEFT JOIN optimizer bug, problem with key cache on Windows and a lot of portability issues. Docs/manual.texi: Changed FOREIGN KEY to FOREIGN KEY constraint client/mysqladmin.c: Don't flush MASTER or SLAVE on refresh configure.in: Fix for hpux 11.0 extra/perror.c: New error message include/my_pthread.h: Portability fix for windows myisam/mi_locking.c: Ensure that locking doesn't interfere with pread/pwrite on windows myisam/sort.c: checked with purecover mysys/mf_tempfile.c: Fix for windows mysys/my_lock.c: Ensure that locking doesn't interfere with pread/pwrite on windows mysys/my_winthread.c: Portability fix sql-bench/Results/ATIS-mysql-NT_4.0: New benchmark runs sql-bench/Results/RUN-mysql-NT_4.0: New benchmark runs sql-bench/Results/alter-table-mysql-NT_4.0: New benchmark runs sql-bench/Results/big-tables-mysql-NT_4.0: New benchmark runs sql-bench/Results/connect-mysql-NT_4.0: New benchmark runs sql-bench/Results/create-mysql-NT_4.0: New benchmark runs sql-bench/Results/insert-mysql-NT_4.0: New benchmark runs sql-bench/Results/select-mysql-NT_4.0: New benchmark runs sql-bench/Results/wisconsin-mysql-NT_4.0: New benchmark runs sql-bench/crash-me.sh: Fixed things for PostgreSQL sql-bench/limits/mysql-3.23.cfg: Update for new crash-me sql-bench/limits/mysql.cfg: Update for new crash-me sql-bench/print-limit-table: Fixed position for alter table rename sql-bench/test-insert.sh: Fix for PostgreSQL sql/field.cc: Fix for default values in CREATE ... SELECT sql/field.h: Fix for default values in CREATE ... SELECT sql/log.cc: Fixed typo sql/log_event.cc: Portability fix sql/mysqlbinlog.cc: Portability fix sql/mysqld.cc: Don't turn of concurrent insert with --skip-new or --safe sql/sql_base.cc: Portability fix sql/sql_class.cc: Portability fix sql/sql_class.h: Portability fix sql/sql_parse.cc: Fix for --log-slow-queries sql/sql_repl.cc: Portability fixes sql/sql_select.cc: Fixed optimizer bug for LEFT JOIN sql/sql_select.h: Fixed optimizer bug for LEFT JOIN sql/sql_table.cc: Fix for default values in CREATE ... SELECT sql/sql_yacc.yy: Added optional AS to: CREATE TABLE foo [ AS ] SELECT ... --- sql-bench/Results/RUN-mysql-NT_4.0 | 139 +++++++++++++++++++------------------ 1 file changed, 73 insertions(+), 66 deletions(-) (limited to 'sql-bench/Results/RUN-mysql-NT_4.0') diff --git a/sql-bench/Results/RUN-mysql-NT_4.0 b/sql-bench/Results/RUN-mysql-NT_4.0 index a21bc3c1158..e1908bc04b0 100644 --- a/sql-bench/Results/RUN-mysql-NT_4.0 +++ b/sql-bench/Results/RUN-mysql-NT_4.0 @@ -1,79 +1,86 @@ Benchmark DBD suite: 2.9 -Date of test: 2000-09-27 2:14:34 +Date of test: 2000-10-13 13:16:20 Running tests on: Windows NT Version 4.0 Arguments: Comments: 2x Pentium III XEON 450MHZ, 512M Limits from: -Server version: MySQL 3.23.25 beta +Server version: MySQL 3.23.26 gamma -alter-table: Total time: 2334 wallclock secs ( 0.75 usr 0.48 sys + 0.00 cusr 0.00 csys = 0.00 CPU) -ATIS: Total time: 69 wallclock secs (23.89 usr 9.98 sys + 0.00 cusr 0.00 csys = 0.00 CPU) -big-tables: Total time: 80 wallclock secs (17.56 usr 18.45 sys + 0.00 cusr 0.00 csys = 0.00 CPU) -connect: Total time: 183 wallclock secs (59.48 usr 50.92 sys + 0.00 cusr 0.00 csys = 0.00 CPU) -create: Failed (output/create-mysql-NT_4.0) -insert: Total time: 5829 wallclock secs (581.28 usr 317.09 sys + 0.00 cusr 0.00 csys = 0.00 CPU) -select: Total time: 2397 wallclock secs (317.05 usr 117.49 sys + 0.00 cusr 0.00 csys = 0.00 CPU) -wisconsin: Total time: 28 wallclock secs ( 8.19 usr 5.31 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +alter-table: Total time: 2663 wallclock secs ( 0.73 usr 0.64 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +ATIS: Total time: 69 wallclock secs (23.45 usr 11.27 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +big-tables: Total time: 80 wallclock secs (17.59 usr 18.69 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +connect: Total time: 178 wallclock secs (57.88 usr 48.91 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +create: Total time: 848 wallclock secs (14.42 usr 10.19 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +insert: Total time: 5599 wallclock secs (584.97 usr 320.95 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +select: Total time: 2294 wallclock secs (316.44 usr 121.50 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +wisconsin: Total time: 28 wallclock secs ( 8.39 usr 5.59 sys + 0.00 cusr 0.00 csys = 0.00 CPU) -Of 8 tests, 1 tests didn't work +All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests -alter_table_add 1242.00 0.42 0.17 0.00 992 -alter_table_drop 1042.00 0.25 0.25 0.00 496 -connect 32.00 10.92 11.08 0.00 10000 -connect+select_1_row 38.00 12.33 12.44 0.00 10000 -connect+select_simple 37.00 12.31 11.61 0.00 10000 -count 39.00 0.06 0.02 0.00 100 -count_distinct 97.00 0.97 0.36 0.00 1000 -count_distinct_big 1209.00 225.82 83.41 0.00 1020 -count_distinct_group 144.00 2.70 0.98 0.00 1000 -count_distinct_group_on_key 54.00 0.61 0.23 0.00 1000 -count_distinct_group_on_key_parts 144.00 2.44 1.28 0.00 1000 -count_group_on_key_parts 47.00 2.34 0.75 0.00 1000 -count_on_key 438.00 22.47 8.91 0.00 50100 -create_index 26.00 0.00 0.00 0.00 8 -create_table 0.00 0.00 0.02 0.00 31 -delete_all 22.00 0.00 0.00 0.00 12 -delete_all_many_keys 1498.00 0.02 0.01 0.00 1 +alter_table_add 1433.00 0.45 0.34 0.00 992 +alter_table_drop 1177.00 0.17 0.14 0.00 496 +connect 33.00 11.66 10.31 0.00 10000 +connect+select_1_row 38.00 12.94 12.19 0.00 10000 +connect+select_simple 38.00 12.14 12.00 0.00 10000 +count 34.00 0.11 0.03 0.00 100 +count_distinct 74.00 0.95 0.28 0.00 1000 +count_distinct_big 1191.00 227.87 86.22 0.00 1020 +count_distinct_group 149.00 2.50 1.00 0.00 1000 +count_distinct_group_on_key 40.00 0.63 0.27 0.00 1000 +count_distinct_group_on_key_parts 149.00 2.95 1.06 0.00 1000 +count_group_on_key_parts 41.00 2.72 0.84 0.00 1000 +count_on_key 407.00 20.91 9.02 0.00 50100 +create+drop 124.00 3.22 2.39 0.00 10000 +create_MANY_tables 213.00 2.77 1.67 0.00 10000 +create_index 27.00 0.00 0.00 0.00 8 +create_key+drop 159.00 5.92 2.61 0.00 10000 +create_table 1.00 0.02 0.02 0.00 31 +delete_all 22.00 0.00 0.02 0.00 12 +delete_all_many_keys 1422.00 0.00 0.00 0.00 1 delete_big 0.00 0.00 0.00 0.00 1 -delete_big_many_keys 1498.00 0.02 0.01 0.00 128 -delete_key 7.00 0.97 1.25 0.00 10000 -drop_index 24.00 0.00 0.02 0.00 8 +delete_big_many_keys 1422.00 0.00 0.00 0.00 128 +delete_key 7.00 0.97 1.36 0.00 10000 +drop_index 25.00 0.00 0.02 0.00 8 drop_table 0.00 0.00 0.00 0.00 28 -insert 234.00 34.55 46.33 0.00 350768 -insert_duplicates 59.00 6.50 10.52 0.00 300000 -insert_key 1593.00 14.31 14.47 0.00 100000 -insert_many_fields 22.00 0.52 0.42 0.00 2000 -min_max 20.00 0.05 0.03 0.00 60 -min_max_on_key 211.00 37.06 13.64 0.00 85000 -multiple_value_insert 9.00 2.51 0.24 0.00 100000 -order_by 99.00 63.39 25.81 0.00 10 -order_by_key 89.00 63.61 25.09 0.00 10 -outer_join 120.00 0.00 0.00 0.00 10 -outer_join_found 106.00 0.01 0.00 0.00 10 -outer_join_not_found 55.00 0.00 0.00 0.00 500 +drop_table_when_MANY_tables 159.00 1.22 1.27 0.00 10000 +insert 252.00 34.77 46.66 0.00 350768 +insert_duplicates 59.00 8.11 13.67 0.00 100000 +insert_key 1447.00 13.78 13.42 0.00 100000 +insert_many_fields 22.00 0.55 0.35 0.00 2000 +insert_select_1_key 8.00 0.00 0.00 0.00 1 +insert_select_2_keys 13.00 0.00 0.00 0.00 1 +min_max 18.00 0.11 0.02 0.00 60 +min_max_on_key 192.00 36.01 14.60 0.00 85000 +multiple_value_insert 9.00 2.34 0.26 0.00 100000 +order_by 98.00 63.58 25.14 0.00 10 +order_by_key 90.00 64.05 25.08 0.00 10 +outer_join 118.00 0.01 0.00 0.00 10 +outer_join_found 105.00 0.00 0.00 0.00 10 +outer_join_not_found 56.00 0.00 0.00 0.00 500 outer_join_on_key 40.00 0.00 0.00 0.00 10 -select_1_row 5.00 1.13 1.70 0.00 10000 -select_2_rows 6.00 0.97 1.97 0.00 10000 -select_big 144.00 84.41 33.61 0.00 10080 -select_column+column 6.00 1.06 1.67 0.00 10000 -select_diff_key 123.00 0.39 0.08 0.00 500 -select_distinct 17.00 4.75 1.78 0.00 800 -select_group 61.00 3.29 1.15 0.00 2911 -select_join 22.00 13.38 5.28 0.00 200 -select_key 193.00 92.27 38.89 0.00 200000 -select_key2 202.00 93.95 37.08 0.00 200000 -select_key_prefix 198.00 91.75 40.53 0.00 200000 -select_many_fields 55.00 17.05 18.03 0.00 2000 -select_range 187.00 27.56 9.31 0.00 410 -select_range_key2 29.00 10.02 3.90 0.00 25010 -select_range_prefix 28.00 10.74 3.92 0.00 25010 -select_simple 4.00 0.86 1.70 0.00 10000 -select_simple_join 4.00 1.75 0.53 0.00 500 -update_big 64.00 0.00 0.00 0.00 500 -update_of_key 541.00 4.83 6.56 0.00 756 -update_of_key_big 34.00 0.08 0.05 0.00 501 -update_with_key 185.00 24.97 40.99 0.00 100000 -wisc_benchmark 9.00 5.80 1.64 0.00 114 -TOTALS 12412.00 1008.17 519.72 0.00 1845595 +select_1_row 5.00 0.78 1.78 0.00 10000 +select_2_rows 6.00 0.91 2.11 0.00 10000 +select_big 138.00 81.45 32.88 0.00 10080 +select_column+column 6.00 1.00 1.72 0.00 10000 +select_diff_key 124.00 0.41 0.09 0.00 500 +select_distinct 17.00 4.36 2.64 0.00 800 +select_group 56.00 3.22 1.16 0.00 2911 +select_group_when_MANY_tables 193.00 1.28 2.25 0.00 10000 +select_join 23.00 13.31 5.59 0.00 200 +select_key 196.00 96.84 36.63 0.00 200000 +select_key2 203.00 92.92 39.80 0.00 200000 +select_key_prefix 201.00 91.41 40.78 0.00 200000 +select_many_fields 56.00 17.03 18.35 0.00 2000 +select_range 189.00 26.94 9.30 0.00 410 +select_range_key2 30.00 10.56 3.72 0.00 25010 +select_range_prefix 26.00 9.81 4.36 0.00 25010 +select_simple 4.00 1.05 1.67 0.00 10000 +select_simple_join 3.00 1.56 0.66 0.00 500 +update_big 62.00 0.00 0.00 0.00 10 +update_of_key 492.00 4.46 7.55 0.00 50256 +update_of_key_big 33.00 0.06 0.03 0.00 501 +update_with_key 188.00 25.03 40.83 0.00 300000 +wisc_benchmark 9.00 5.80 1.47 0.00 114 +TOTALS 13172.00 1023.62 537.63 0.00 1944607 -- cgit v1.2.1