DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) InnoDB in MySQL 3

Info Catalog (mysql.info.gz) InnoDB contact information (mysql.info.gz) InnoDB (mysql.info.gz) InnoDB configuration 
 
 15.3 `InnoDB' in MySQL 3.23
 ===========================
 
 Beginning with MySQL 4.0, `InnoDB' is enabled by default, so the
 following information applies only to MySQL 3.23.
 
 `InnoDB' tables are included in the MySQL source distribution starting
 from 3.23.34a and are activated in the MySQL-Max binaries of the 3.23
 series.  For Windows, the MySQL-Max binaries are included in the
 standard distribution.
 
 If you have downloaded a binary version of MySQL that includes support
 for `InnoDB', simply follow the instructions of the MySQL manual for
 installing a binary version of MySQL. If you have MySQL 3.23 installed,
 the simplest way to install MySQL-Max is to replace the executable
 `mysqld' server with the corresponding executable from the MySQL-Max
 distribution.  MySQL and MySQL-Max differ only in the server executable.
 See  Installing binary and  `mysqld-max' mysqld-max.
 
 To compile the MySQL source code with `InnoDB' support, download MySQL
 3.23.34a or newer from `http://www.mysql.com/' and configure MySQL with
 the `--with-innodb' option.   Installing source.
 
 To use `InnoDB' tables with MySQL 3.23, you must specify configuration
 parameters in the `[mysqld]' section of the `my.cnf' option file.  On
 Windows, you can use `my.ini' instead. If you do not configure `InnoDB'
 in the option file, `InnoDB' will not start. (From MySQL 4.0 on,
 `InnoDB' uses default parameters if you do not specify any.  However,
 to get best performance, it is still recommended that you use
 parameters appropriate for your system, as discussed in  `InnoDB'
 configuration InnoDB configuration.)
 
 In MySQL 3.23, you must specify at the minimum an
 `innodb_data_file_path' value to configure the `InnoDB' data files. For
 example, to configure `InnoDB' to use a single 500MB data file, place
 the following setting in the `[mysqld]' section of your option file:
 
      [mysqld]
      innodb_data_file_path=ibdata1:500M
 
 `InnoDB' will create the `ibdata1' file in the MySQL data directory by
 default. To specify the location explicitly, specify an
 `innodb_data_home_dir' setting.   `InnoDB' configuration InnoDB
 configuration.
Info Catalog (mysql.info.gz) InnoDB contact information (mysql.info.gz) InnoDB (mysql.info.gz) InnoDB configuration
automatically generated byinfo2html