<< 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
    186 MySQL Technical Reference for Version 4.0.3 By specifying all of the above options is same as using {ansi.  With this option one  can  turn  on  only  needed  SQL  modes.   See  Section  1.7.2  [ANSI  mode], page 31. --temp-pool Using this option will cause most temporary les created to use a small set of names, rather than a unique name for each new le.  This is to work around a problem in the Linux kernel dealing with creating a bunch of new les with di erent names.  With the old behaviour, Linux seems to 'leak' memory, as it's being allocated to the directory entry cache instead of the disk cache. --transaction-isolation= { READ-UNCOMMITTED | READ-COMMITTED | REPEATABLE-READ | SERIALIZABLE } Sets the default transaction isolation level.  See Section 6.7.3 [SET TRANSAC- TION], page 485. -t, --tmpdir=path Path for temporary les.  It may be useful if your default /tmp directory resides on a partition too small to hold temporary tables. -u, --user= [user_name | userid] Run mysqld daemon as user user_name or userid (numeric).  This option is mandatory when starting mysqld as root. -V, --version Output version information and exit. -W, --log-warnings (Was --warnings) Print  out  warnings  like  Aborted connection...  to  the  `.err'   le.   See  Sec- tion A.2.9 [Communication errors], page 633. One can change most values for a running server with the SET command.  See Section 5.5.6 [SET OPTION], page 369. 4.1.2  `my.cnf' Option Files MySQL can, since Version 3.22, read default startup options for the server and for clients from option les. MySQL reads default options from the following les on Unix: Filename Purpose /etc/my.cnf Global options DATADIR/my.cnf Server-speci c options defaults-extra-file The    le   speci ed   with   {defaults-extra- le=# ~/.my.cnf User-speci c options DATADIR  is  the  MySQL  data  directory  (typically  `/usr/local/mysql/data'  for  a  binary installation or `/usr/local/var' for a source installation).  Note that this is the directory that was speci ed at con guration time, not the one speci ed with --datadir when mysqld
     

    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