Seth Woolley's Man Viewer

mysqld(1) - mysqld - The MySQL server demon - man 1 mysqld

([section] manual, -k keyword, -K [section] search, -f whatis)
man plain no title

mysqld(1)                       MySQL database                       mysqld(1)

       mysqld - The MySQL server demon

       mysqld [OPTIONS]

       mysqld  [--ansi] [-b|--basedir=path] [--big-tables] [--bind-address=IP]
       [--character-sets-dir=path]     [--chroot=path]     [-h|--datadir=path]
       [--default-character-set=charset]           [--default-table-type=type]
       [--delay-key-write-for-all-tables] [--enable-locking]  [-T|--exit-info]
       [--flush]     [-?|--help]     [--init-file=file(1,n)]    [-L|--language=...]
       [-l|--log[=file(1,n)]]    [--log-isam[=file(1,n)]]    [--log-slow-queries[=file(1,n)]]
       [--log-update[=file(1,n)]]    [--log-long-format]   [--low-priority-updates]
       [--memlock] [ --myisam-recover [=option[,option...]]] where  option  is
       one   of   DEFAULT,   BACKUP,   FORCE   or  QUICK.]   [--pid-file=path]
       [-P|--port=...]  [-o|--old-protocol] [--one-thread] [-O|--set-variable-
       var=option]    [-Sg|--skip-grant-tables]    [--safe-mode]    [--secure]
       [--skip-concurrent-insert]  [--skip-delay-key-write]   [--skip-locking]
       [--skip-name-resolve]          [--skip-networking]         [--skip-new]
       [--skip-host-cache]   [--skip-show-database]   [--skip-thread-priority]
       [--socket=path] [-t|--tmpdir=path] [-u|--user=user_name] [-V|--version]

       --ansi Use ANSI SQL syntax instead of MySQL  syntax.  See  section  5.2
              Running MySQL in(1,8) ANSI Mode.

              Path  to  installation directory. All paths are usually resolved
              relative to this.

              Allow big result sets by saving all temporary sets on  file.  It
              solves most 'table full' errors, but also slows down the queries
              where in-memory tables  would  suffice.  Since  Version  3.23.2,
              MySQL is able to solve it automaticaly by using memory for small
              temporary tables and switching to disk tables where necessary.

              IP address to bind(2,n,1 builtins) to.

              Directory where character sets are. See section 10.1.1 The Char-
              acter Set Used for Data and Sorting.

              Chroot  mysqld  daemon during startup. Recommended security mea-
              sure. It will somewhat limit LOAD DATA  INFILE  and  SELECT  ...
              INTO OUTFILE though.

              Path to the database root.

              Set  the default character set. See section 10.1.1 The Character
              Set Used for Data and Sorting.

              Set the default table type for tables. See section 8 MySQL Table

              Don't flush(8,n) key buffers between writes for any MyISAM table. See
              Mysql Manual section 12.2.3 Tuning Server Parameters.

              Enable system locking.

              Print some debug info(1,5,n) at exit.

              Flush all changes to disk after each SQL command. Normally MySQL
              only  does a write(1,2) of all changes to disk after each SQL command
              and lets the operating system handle the syncing  to  disk.  See
              section 20.2 What to Do if(3,n) MySQL Keeps Crashing.

              Display short help and exit.

              Read SQL commands from this file(1,n) at startup.

              Client  error(8,n) messages in(1,8) given language. May be given as a full
              path. See Mysql Manual section 10.1 What Languages Are Supported
              by MySQL?.

              Log connections and queries to file.

              Log  all  ISAM/MyISAM  changes to file(1,n) (only used when debugging

              Log all queries that have taken more than  long_query_time  sec-
              onds  to execute to file. See Mysql Manual section 21.5 The Slow
              Query Log.

              Log updates to file.# where # is a unique number if(3,n)  not  given.
              See Mysql Manual section 21.3 The Update Log.

              Log  some  extra  information  to  update(7,n)  log. If you are using
              --log-slow-queries then queries that are not using  indexes  are
              logged to the slow query log.

              Table-modifying   operations  (INSERT/DELETE/UPDATE)  will  have
              lower priority than selects. It can also be done via  {INSERT  |
              REPLACE  | UPDATE | DELETE} LOW_PRIORITY ... to lower the prior-
              ity  of  only  one  query,  or  by  SET  OPTION   SQL_LOW_PRIOR-
              ITY_UPDATES=1  to  change  the priority in(1,8) one thread. See Mysql
              Manual section  12.2.9 Table Locking Issues.

              Lock the mysqld process in(1,8) memory. This works only if(3,n) your  sys-
              tem  supports  the  mlockall() system call. This may help if(3,n) you
              have a problem where the operating system is causing  mysqld  to
              swap on disk.

          --myisam-recover  [=option[,option...]]]  where  option  is  one  of
              If  this  option is used, mysqld will on open(2,3,n) check if(3,n) the table
              is marked as crashed or if(3,n) if(3,n) the table wasn't  closed  properly
              (The last option only works if(3,n) you are running with --skip-lock-
              ing). If this is the case mysqld will run check on the table. If
              the  table  was corrupted, mysqld will attempt to repair it. The
              following options affects how the  repair  works.   DEFAULT  The
              same  as  not  giving any option to --myisam-recover.  BACKUP If
              the data table was changed during recover, save a backup of  the
              `table_name.MYD'  data file(1,n) as `table_name-datetime.BAK'.  FORCE
              Run recover even if(3,n) we will loose more than  one  row  from  the
              .MYD  file.   QUICK  Don't  check the rows in(1,8) the table if(3,n) there
              isn't  any  delete  blocks.   Before  a  table  is   automaticly
              repaired, mysqld will add a note about this in(1,8) the error(8,n) log. If
              you want to be able to recover from  most  things  without  user
              intervention, you should use the options BACKUP,FORCE. This will
              force a repair of a table even if(3,n) some rows  would  be  deleted,
              but  it  will keep the old data file(1,n) as a backup so that you can
              later examine what happened.

              Path to pid file(1,n) used by mysqld_safe.

              Port number to listen(1,2,7) for TCP/IP connections.

              Use the 3.20 protocol  for  compatibility  with  some  very  old
              clients. See Mysql Manual section  4.17.3 Upgrading from Version
              3.20 to Version 3.21.

              Only use one thread (for debugging under Linux). See Mysql  Man-
              ual section  H.1 Debugging a MySQL server.

       -O| --set-variable var=option
              Give  a variable a value. --help lists variables. You can find a
              full description for all variables in(1,8) the SHOW VARIABLES section
              in(1,8) this manual. See Mysql Manual section  7.28.4 SHOW VARIABLES.
              The tuning server parameters section includes information of how
              to  optimize  these.  See  Mysql  Manual  section  12.2.3 Tuning
              Server Parameters.

              This option causes the server not to use the privilege system at
              all.  This gives everyone full access(2,5) to all databases! (You can
              tell a running server to start using the grant tables  again  by
              executing mysqladmin flush-privileges or mysqladmin reload.)

              Skip some optimize stages. Implies --skip-delay-key-write.

              IP  numbers  returned  by  the  gethostbyname()  system call are
              checked to make sure they resolve back to the original hostname.
              This makes it harder for someone on the outside to get access(2,5) by
              pretending to be another host. This option also adds some sanity
              checks  of  hostnames.  The  option  is turned off by default in(1,8)
              MySQL Version 3.21 because sometimes it takes  a  long  time(1,2,n)  to
              perform  backward  resolutions.  MySQL Version 3.22 caches host-
              names (unless --skip-host-cache is used)  and  has  this  option
              enabled by default.

              Turn  off  the  ability to select(2,7,2 select_tut) and insert at the same time(1,2,n) on
              MyISAM tables. (This is only to be used if(3,n) you  think  you  have
              found a bug in(1,8) this feature).

              Ignore the delay_key_write option for all tables. See Mysql Man-
              ual section  12.2.3 Tuning Server Parameters.

              Don't use system locking. To use isamchk or myisamchk  you  must
              shut  down  the server. See Mysql Manual section  1.6 How Stable
              Is MySQL?. Note that in(1,8) MySQL Version 3.23 you  can  use  REPAIR
              and CHECK to repair/check MyISAM tables.

              Hostnames  are not resolved. All Host column values in(1,8) the grant
              tables must be IP numbers or localhost.

              Don't listen(1,2,7) for TCP/IP connections at all. All interaction with
              mysqld must be made via Unix sockets. This option is highly rec-
              ommended for systems where only local requests are allowed. How-
              ever,   this   option   is   unsuitable  for  systems  that  use
              MIT-pthreads, because the MIT-pthreads package  doesn't  support
              Unix sockets.

              Don't    use    new,    possible    wrong    routines.   Implies

              Never use host(1,5) name cache for  faster  name-ip  resolution,  but
              query DNS server on every connect instead.

              Don't  allow  'SHOW  DATABASE'  commands,  unless  the  user has
              process privilege.

              Disable using thread priorities for faster response time.

              Socket file(1,n) to use for  local  connections  instead  of  default

              Path  for temporary files. It may be useful if(3,n) your default /tmp
              directory resides on a partition too  small  to  hold  temporary

              Run  mysqld  daemon  as user user_name. This option is mandatory
              when starting mysqld as root.

              Output version(1,3,5) information and exit.

       isamchk(1),  isamlog(1),   mysql(1),   mysqlaccess(1),   mysqladmin(1),
       mysqld_multi(1),    mysqld_safe(1),    mysqldump(1),   mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1,3)(1), replace(1)

       For more information please refer to the MySQL reference manual,  which
       may  already be installed locally and which is also available online at

       Please refer to to report bugs.

       Ver    1.0,    distribution    4.0.21    Michael    (Monty)    Widenius
       (,  MySQL  AB  (   This software
       comes  with  no  warranty.   Manual  page  by  L.   (Kill-9)   Pedersen
       (, Mercurmedia Data Model Architect / system developer

MySQL 4.0                      19 December 2000                      mysqld(1)

References for this manual (incoming links)