Dyntex.net Support Centre: MySQL Reference Manual p.506

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

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

506 MySQL Technical Reference for Version 4.0.3 7.5 InnoDB Tables 7.5.1 InnoDB Tables Overview InnoDB provides MySQL with a transaction-safe (ACID compliant) table handler with com- mit, rollback, and crash recovery capabilities. InnoDB does locking on row level and also provides an Oracle-style consistent non-locking read in SELECTs. These features increase multiuser concurrency and performance. There is no need for lock escalation in InnoDB, because row level locks in InnoDB t in very small space. InnoDB tables support FOREIGN KEY constraints as the rst table type in MySQL. InnoDB has been designed for maximum performance when processing large data volumes. Its CPU eciency is probably not matched by any other disk-based relational database engine. Technically, InnoDB is a complete database backend placed under MySQL. InnoDB has its own buer pool for caching data and indexes in main memory. InnoDB stores its tables and indexes in a tablespace, which may consist of several les. This is dierent from, for example, MyISAM tables where each table is stored as a separate le. InnoDB tables can be of any size also on those operating systems where le-size is limited to 2 GB. You can nd the latest information about InnoDB at http://www.innodb.com/. The most up-to-date version of the InnoDB manual is always placed there, and you can also order commercial licenses and support for InnoDB. InnoDB is currently (October 2001) used in production at several large database sites requiring high performance. The famous Internet news site Slashdot.org runs on InnoDB. Mytrix, Inc. stores over 1 TB of data in InnoDB, and another site handles an average load of 800 inserts/updates per second in InnoDB. InnoDB tables are included in the MySQL source distribution starting from 3.23.34a and are activated in the MySQL -Max binary. For Windows the -Max binaries are contained 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 already have MySQL-3.23 installed, then the simplest way to install MySQL -Max is to replace the server executable `mysqld' with the corresponding executable in the - Max distribution. MySQL and MySQL -Max dier only in the server executable. See Section 2.2.7 [Installing binary], page 77. See Section 4.7.5 [mysqld-max], page 285. To compile MySQL with InnoDB support, download MySQL-3.23.34a or newer version from http://www.mysql.com/ and congure MySQL with the --with-innodb option. See the MySQL manual about installing a MySQL source distribution. See Section 2.3 [Installing source], page 80. cd /path/to/source/of/mysql-3.23.37 ./configure --with-innodb To use InnoDB you have to specify InnoDB startup options in your `my.cnf' or `my.ini' le. The minimal way to modify it is to add to the [mysqld] section the line

MySQL Reference Manual

Our Partners

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

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