<< 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
    236 MySQL Technical Reference for Version 4.0.3 --character-sets-dir=... Directory where character sets are stored. --set-character-set=name Change the character set used by the index -t or --tmpdir=path Path  for  storing  temporary   les.   If  this  is  not  set,  myisamchk  will  use  the environment variable TMPDIR for this. -q or --quick Faster repair by not modifying the data le.  One can give a second -q to force myisamchk  to modify the original data le in case of duplicate keys -u or --unpack Unpack le packed with myisampack. 4.4.6.5  Other Options for myisamchk Other actions that myisamchk can do, besides repair and check tables: -a or --analyze Analyse the distribution of keys.  This improves join performance by enabling the join optimiser to better choose in which order it should join the tables and which keys it should use:  myisamchk --describe --verbose table_name'  or using SHOW KEYS in MySQL. -d or --description Prints some information about table. -A or --set-auto-increment[=value] Force  AUTO_INCREMENT  to  start  at  this  or  higher  value.   If  no  value  is  given, then sets the next AUTO_INCREMENT value to the highest used value for the auto key + 1. -S or --sort-index Sort the index tree blocks in high-low order.  This will optimise seeks and will make table scanning by key faster. -R or --sort-records=# Sorts records according to an index.  This makes your data much more localised and may speed up ranged  SELECT  and  ORDER BY  operations on this index.  (It may  be  very  slow  to  do  a  sort  the   rst  time!)   To   nd  out  a  table's  index numbers, use SHOW INDEX, which shows a table's indexes in the same order that myisamchk  sees them.  Indexes are numbered beginning with 1. 4.4.6.6  myisamchk Memory Usage Memory allocation is important when you run myisamchk.  myisamchk uses no more memory than you specify with the -O options.  If you are going to use myisamchk on very large les,
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

    SpiritHost - web hosting for spiritual and education sites
    SpiritHit.com - Religious and Spiritual Portal

    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