<html lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>InnoDB 1.1 for MySQL 5.5 User’s Guide</title><link rel="stylesheet" href="mysql-html.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><meta name="description" content="
Beginning with MySQL version 5.1, it is possible to swap out one
version of the InnoDB storage engine and use another (the
plugin). This manual documents the latest InnoDB
plugin, version 1.1, which works with MySQL 5.5 and features
cutting-edge improvements in performance and scalability.
This User's Guide documents the procedures and features that are
specific to the InnoDB storage engine 1.1 for MySQL
5.5. It supplements the general
InnoDB
information in the MySQL Reference Manual.
Because InnoDB 1.1 is integrated with MySQL 5.5, it is generally
available (GA) and production-ready.
WARNING: Because the InnoDB storage engine
1.0 and above introduces a new file format, restrictions apply
to the use of a database created with the InnoDB storage engine 1.0
and above, with earlier versions of InnoDB, when using
mysqldump or MySQL replication and if you use
the older InnoDB Hot Backup product rather than the newer MySQL Enterprise Backup
product. See .
">
<script language="javascript" type="text/javascript">
function addOnload(theFunc)
{
var previous = window.onload;
if (typeof window.onload != 'function')
{
window.onload = theFunc;
}
else
{
window.onload = function()
{
previous();
theFunc();
}
}
}
addOnload(function()
{
var base = new Date(1321482556*1000);
var now = new Date();
var diff = ((now-base)/1000)/(24*3600);
if (diff > 90) {
var nodes = document.getElementsByClassName('titlepage');
nodes[0].innerHTML = '<p style="border: 5px #ff0000 solid; padding: 5px; margin 5px">' +
'This copy of the manual is more than 90 days old. We encourage you to download a ' +
'new version from <a href="http://dev.mysql.com">dev.mysql.com/doc</a>.</p>' + nodes[0].innerHTML;
}
});
</script>
<noscript></noscript>
</head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="book" lang="en"><div class="titlepage"><div><div><h1 class="title"><a name="innodb-5-5"></a>InnoDB 1.1 for MySQL 5.5 User’s Guide</h1></div><div><p class="releaseinfo">
This is the User’s Guide for the InnoDB storage engine
1.1 for MySQL 5.5, generated on
2011-11-16
(revision: 28048)
.
</p></div><div><div class="legalnotice"><a name="legalnotice"></a><p>
Copyright © 1997, 2011, Oracle and/or its affiliates. All
rights reserved.
</p><p>
This software and related documentation are provided under a license
agreement containing restrictions on use and disclosure and are
protected by intellectual property laws. Except as expressly
permitted in your license agreement or allowed by law, you may not
use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any
part, in any form, or by any means. Reverse engineering,
disassembly, or decompilation of this software, unless required by
law for interoperability, is prohibited.
</p><p>
The information contained herein is subject to change without notice
and is not warranted to be error-free. If you find any errors,
please report them to us in writing.
</p><p>
If this software or related documentation is delivered to the U.S.
Government or anyone licensing it on behalf of the U.S. Government,
the following notice is applicable:
</p><p>
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related
documentation and technical data delivered to U.S. Government
customers are "commercial computer software" or "commercial
technical data" pursuant to the applicable Federal Acquisition
Regulation and agency-specific supplemental regulations. As such,
the use, duplication, disclosure, modification, and adaptation shall
be subject to the restrictions and license terms set forth in the
applicable Government contract, and, to the extent applicable by the
terms of the Government contract, the additional rights set forth in
FAR 52.227-19, Commercial Computer Software License (December 2007).
Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
</p><p>
This software is developed for general use in a variety of
information management applications. It is not developed or intended
for use in any inherently dangerous applications, including
applications which may create a risk of personal injury. If you use
this software in dangerous applications, then you shall be
responsible to take all appropriate fail-safe, backup, redundancy,
and other measures to ensure the safe use of this software. Oracle
Corporation and its affiliates disclaim any liability for any
damages caused by use of this software in dangerous applications.
</p><p>
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. MySQL is a trademark of Oracle Corporation and/or its
affiliates, and shall not be used without Oracle's express written
authorization. Other names may be trademarks of their respective
owners.
</p><p>
This software and documentation may provide access to or information
on content, products, and services from third parties. Oracle
Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party
content, products, and services. Oracle Corporation and its
affiliates will not be responsible for any loss, costs, or damages
incurred due to your access to or use of third-party content,
products, or services.
</p><p>
This document in any form, software or printed matter, contains
proprietary information that is the exclusive property of Oracle.
Your access to and use of this material is subject to the terms and
conditions of your Oracle Software License and Service Agreement,
which has been executed and with which you agree to comply. This
document and information contained herein may not be disclosed,
copied, reproduced, or distributed to anyone outside Oracle without
prior written consent of Oracle or as specifically provided below.
This document is not part of your license agreement nor can it be
incorporated into any contractual agreement with Oracle or its
subsidiaries or affiliates.
</p><p>
This documentation is NOT distributed under a GPL license. Use of
this documentation is subject to the following terms:
</p><p>
You may create a printed copy of this documentation solely for your
own personal use. Conversion to other formats is allowed as long as
the actual content is not altered or edited in any way. You shall
not publish or distribute this documentation in any form or on any
media, except if you distribute the documentation in a manner
similar to how Oracle disseminates it (that is, electronically for
download on a Web site with the software) or on a CD-ROM or similar
medium, provided however that the documentation is disseminated
together with the software on the same medium. Any other use, such
as any dissemination of printed copies or use of this documentation,
in whole or in part, in another publication, requires the prior
written consent from an authorized representative of Oracle. Oracle
and/or its affiliates reserve any and all rights to this
documentation not expressly granted above.
</p><p>
For more in