<< 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 233 myisamchk: warning: 1 clients is using or hasn't closed the table properly This  means  that  you  are  trying  to  check  a  table  that  has  been  updated  by  the  another program (like the  mysqld  server) that hasn't yet closed the le or that has died without closing the le properly. If you mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and ensure that no one is using the tables while you are running myisamchk.  In MySQL Version 3.23 the easiest way to avoid this problem is to use CHECK TABLE instead of myisamchk to check tables. 4.4.6.2  General Options for myisamchk myisamchk supports the following options. -# or --debug=debug_options Output debug log.  The debug_options string often is 'd:t:o,filename'. -? or --help Display a help message and exit. -O var=option, --set-variable var=option Set the value of a variable.  The possible variables and their default values for myisamchk can be examined with myisamchk --help: Variable Value key bu er size 523264 read bu er size 262136 write bu er size 262136 sort bu er size 2097144 sort key blocks 16 decode bits 9 sort_buffer_size  is used when the keys are repaired by sorting keys, which is the normal case when you use --recover. key_buffer_size  is used when you are checking the table with  --extended- check or when the keys are repaired by inserting key row by row in to the table (like when doing normal inserts).  Repairing through the key bu er is used in the following cases:    If you use --safe-recover.    If the temporary les needed to sort the keys would be more than twice as big as when creating the key le directly.  This is often the case when you have big CHAR, VARCHAR or TEXT keys as the sort needs to store the whole keys during sorting.  If you have lots of temporary space and you can force myisamchk to repair by sorting you can use the --sort-recover option. Reparing through the key bu er takes much less disk space than using sorting, but is also much slower. If you want a faster repair, set the above variables to about 1/4 of your available memory.   You can  set  both variables to  big values,  as  only one  of the above bu ers will be used at a time.
     

    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