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 ...

1 files changed, 10 insertions, 10 deletions

diff --git a/sql-bench/Results/connect-mysql-NT_4.0 b/sql-bench/Results/connect-mysql-NT_4.0
index 9725018829a..b98cc6603f1 100644
--- a/sql-bench/Results/connect-mysql-NT_4.0
+++ b/sql-bench/Results/connect-mysql-NT_4.0
@@ -1,30 +1,30 @@
-Testing server 'MySQL 3.23.25 beta' at 2000-09-27  2:55:59

+Testing server 'MySQL 3.23.26 gamma' at 2000-10-13 14:03:13

 

 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): 32 wallclock secs (10.92 usr 11.08 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Time to connect (10000): 33 wallclock secs (11.66 usr 10.31 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

 

 Test connect/simple select/disconnect

-Time for connect+select_simple (10000): 37 wallclock secs (12.31 usr 11.61 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Time for connect+select_simple (10000): 38 wallclock secs (12.14 usr 12.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

 

 Test simple select

-Time for select_simple (10000):  4 wallclock secs ( 0.86 usr  1.70 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Time for select_simple (10000):  4 wallclock secs ( 1.05 usr  1.67 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): 38 wallclock secs (12.33 usr 12.44 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Time to connect+select_1_row (10000): 38 wallclock secs (12.94 usr 12.19 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

 

 Testing select 1 row from table

-Time to select_1_row (10000):  5 wallclock secs ( 1.13 usr  1.70 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Time to select_1_row (10000):  5 wallclock secs ( 0.78 usr  1.78 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

 

 Testing select 2 rows from table

-Time to select_2_rows (10000):  6 wallclock secs ( 0.97 usr  1.97 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Time to select_2_rows (10000):  6 wallclock secs ( 0.91 usr  2.11 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

 

 Test select with aritmetic (+)

-Time for select_column+column (10000):  6 wallclock secs ( 1.06 usr  1.67 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Time for select_column+column (10000):  6 wallclock secs ( 1.00 usr  1.72 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

 

 Testing retrieval of big records (65000 bytes)

-Time to select_big (10000): 55 wallclock secs (19.89 usr  8.75 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Time to select_big (10000): 48 wallclock secs (17.38 usr  7.11 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

 

-Total time: 183 wallclock secs (59.48 usr 50.92 sys +  0.00 cusr  0.00 csys =  0.00 CPU)

+Total time: 178 wallclock secs (57.88 usr 48.91 sys +  0.00 cusr  0.00 csys =  0.00 CPU)