Merge InnoDB-3.23.52d

Fixed bug in automatic repair of MyISAM tables where table cache was not locked properly

Removed Heikki's patch for handling this.

Added option --host to mysqlhotcopy

  In HP-UX-10.20, but not in HP-UX-11.0, the return value of pthread_mutex_trylock is inverted

Use MYSQL_CONFIG_NAME instead of "my" as the configuration file name.

This should fix some possible table cache corruptions when doing
OPTIMIZE or REPAIR table when other threads are opening new tables.

(Merge of code from 4.0)

  Remove the complex typecast used to convert a HP-UX pthread struct to os_thread_id_t; the typecast seemed to work wrong in gcc-3.1 on HP-UX-10.20

into geopard.online.bg:/storage/bk/mysql-3.23

to 3.23

  Merge InnoDB-3.23.52c
ha_innobase.cc:
  Test the ref length sanity also in the production version

Added back 'static inline', as not having this caused more problems than having it
Fixed wrong arguments to printf()

Removed some compiler warnings regarding 'static' from InnoDB

  Merge InnoDB-3.23.52c; improve AUTO-INC algorithm with SHOW TABLE STATUS; new checksum in log

 - overhauled the RPM spec file (more macros, package descriptions)

  Since MySQL commits the stmt always at the end of an INSERT, it is enough to release auto-inc lock at innobase_commit and innobase_rollback; add also more comments to code

  procinfo -> proc_info to make ha_innobase.cc to compile, add more comments about ref

Merge of ha_innobase.cc from 4.0; This fixes that MySQL doesn't allocate too big buffers when sorting innobase rows
Changed name of variables
NO_FOREIGN_KEY_CHECKS -> FOREIGN_KEY_CHECKS
RELAXED_UNIQUE_CHECKS -> UNIQUE_CHECKS
to avoid confusion with 'not...' variables.
Write name of adminstrator command to slow log.
Added mysqldumpslow to RPM

  Backport the AIX crash fix changes from 4.0

  Add diagnostic code to track a probable table corruption reported by a user

into sergbook.mysql.com:/usr/home/serg/Abk/mysql

bugfix: uniques did not contributed to MYI tot_length estimation, which resulted in "Index file full" error on huge SELECT DISTINCT's

  Make the typecast trick pthread_t -> os_thread_id_t safer, but a full fix needs usage of appropriate Posix functions

into hundin.mysql.fi:/home/heikki/mysql3

  Fix a bug in the storage of the SQL NULL value in 64-bit computers: the value code must fit in 32 bits

  Move the assertion in foreign keys to the right place

  Revert the test changes to wait for a full push of new auto-inc algorithm