<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    Chapter 4:  Database Administration 285 no endspace, not_always Don't store endspace and don't do end space compression for all values. no endspace, no empty Don't store endspace.  Don't store empty values. table-lookup The column was converted to an ENUM. zerofill(n) The most signi cant n bytes in the value are always 0 and are not stored. no zeros Don't store zeros. always zero 0 values are stored in 1 bit. Huff tree   The Hu man tree associated with the eld. Bits The number of bits used in the Hu man tree. After you have run pack_isam/myisampack you must run isamchk/myisamchk to re-create the index.  At this time you can also sort the index blocks and create statistics needed for the MySQL optimiser to work more eciently: myisamchk -rq --analyze --sort-index table_name.MYI isamchk -rq --analyze --sort-index table_name.ISM After you have installed the packed table into the MySQL database directory you should do mysqladmin flush-tables to force mysqld to start using the new table. If you want to unpack a packed table, you can do this with the --unpack option to isamchk or myisamchk. 4.7.5  mysqld-max, An Extended mysqld Server mysqld-max is the MySQL server (mysqld) con gured with the following con gure options: Option Comment {with-server-sux=-max Add  a  sux  to  the  mysqld  version string. {with-innodb Support for InnoDB tables. {with-bdb Support for Berkeley DB (BDB) tables CFLAGS=-DUSE SYMDIR  Symbolic links support for Windows. You can nd the MySQL-max binaries at http://www.mysql.com/downloads/mysql-max-3. The Windows MySQL binary distributions includes both the standard mysqld.exe binary and the  mysqld-max.exe  binary.   http://www.mysql.com/downloads/mysql-3.23.html. See Section 2.1.2 [Windows installation], page 66. Note that as InnoDB and Berkeley DB are not available for all platforms, some of the Max binaries  may  not  have  support  for  both  of  these.   You  can  check  which  table  types  are supported by doing the following query:
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide