• unknown's avatar
    Added support for key_block_size for key and table level (WL#602) · d50ae165
    unknown authored
    Added support for key_block_size to MyISAM.
    Simplify interface to 'new Key' to make it easier to add new key options.
    mysqld option --new is used to define where key options are printed.
    (In 5.3 we should move all key options to after key part definition to avoid problem with reserved names)
    Fixed some compiler warnings and a memory leak in ssl
    
    
    include/my_base.h:
      Added flag to check if block size for key was secified
    include/my_sys.h:
      Added new support function to round up to a power of two
    include/myisam.h:
      Rename block_size -> block_size_index to avoid confusion with 'block_size'
    include/violite.h:
      Added function to free memory after new_VioSSLAcceptorFd
      (Will rename all vio_ssl functions in a future changeset)
    mysql-test/mysql-test-run.pl:
      Don't print port number info when we use --extern
    mysql-test/r/myisam.result:
      Added test for key_block_size
    mysql-test/t/myisam.test:
      Added test for key_block_size
    mysys/mf_keycache.c:
      Simplify code
    mysys/my_bit.c:
      Added new support function to round up to a power of two
    sql/ha_myisam.cc:
      Tell MyISAM to use the specified key_block_size
      MyISAM also updates the global key_block_size from the used values.
    sql/handler.cc:
      Added 'default_key_create_info' to be used as 'dummy' argument to 'new Key'
    sql/handler.h:
      Added KEY_CREATE_INFO, to be used as for general options for KEY's
    sql/item_func.h:
      Removed compiler warning
    sql/lex.h:
      Added new symbol
    sql/mysqld.cc:
      Fixed memory leak in ssl (new_VioSSLAcceptorFd)
    sql/sql_class.h:
      Change 'new Key' to use KEY_CREATE_INFO instead of 'algoritm', parser, key_page_size.
      This makes it easier to add new key options in the future.
    sql/sql_lex.h:
      Added key create options
    sql/sql_parse.cc:
      Use new interface to 'new Key'
    sql/sql_show.cc:
      Added support for key_block_size
      If --new is used, key options are printed after the key part definition.
    sql/sql_table.cc:
      Use new interface to 'new Key'
      Add support for key_block_size
    sql/sql_yacc.yy:
      Add support for key_block_size
      Allow key options before and after key_parts (In future they should be always after the key_part defintion)
      Use new interface to 'new Key'
    sql/structs.h:
      Added block_size to keys
    sql/table.cc:
      Remmeber and read key_block_size for table and key level
    sql/table.h:
      Added default key_block_size for table
    sql/unireg.cc:
      Remember key_block_size for key
    storage/myisam/ft_eval.c:
      Set block_length to 0 to get default key page size
    storage/myisam/ft_test1.c:
      Set block_length to 0 to get default key page size
    storage/myisam/mi_check.c:
      block_size -> block_size_index
    storage/myisam/mi_create.c:
      Added support for block size per key.
      Block size is rounded up to next power of two and enforced between MIN and MAX KEY_BLOCK_LENGTH.
      Align start of key block to start at an even offset of max_key_block_length to ensure key cache works good if all key pages are of same size.
    storage/myisam/mi_open.c:
      block_size -> block_size_index
    storage/myisam/mi_page.c:
      block_size -> block_size_index
    storage/myisam/mi_test1.c:
      Set block_length to 0 to get default key page size
    storage/myisam/mi_test2.c:
      Set block_length to 0 to get default key page size
    storage/myisam/mi_test3.c:
      Set block_length to 0 to get default key page size
    storage/myisam/myisamdef.h:
      block_size -> block_size_index to avoid confusion with 'block_size' in MySQL
      Added block_size as argument to MI_BLOCK_SIZE
      Added missing prototypes to get rid of compiler warnings
    storage/myisam/myisampack.c:
      Removed compiler warning
      block_size -> block_size_index
    vio/viosslfactories.c:
      Fixed memory leak in ssl (new_VioSSLAcceptorFd)
    mysql-test/r/myisam-system.result:
      New BitKeeper file ``mysql-test/r/myisam-system.result''
    mysql-test/t/myisam-system.test:
      New BitKeeper file ``mysql-test/t/myisam-system.test''
    d50ae165
handler.cc 90.5 KB