MySQL 5.0 Reference Manual
xi
13.7.1. Account Management Statements ................................................................. 1149
13.7.2. Table Maintenance Statements ..................................................................... 1162
13.7.3. User-Defined Function Statements ................................................................ 1169
13.7.4.
SET
Syntax .................................................................................................. 1170
13.7.5.
SHOW
Syntax ................................................................................................ 1173
13.7.6. Other Administrative Statements ................................................................... 1205
13.8. MySQL Utility Statements ....................................................................................... 1210
13.8.1.
DESCRIBE
Syntax ........................................................................................ 1210
13.8.2.
EXPLAIN
Syntax .......................................................................................... 1210
13.8.3.
HELP
Syntax ................................................................................................ 1211
13.8.4.
USE
Syntax .................................................................................................. 1213
14. Storage Engines ................................................................................................................ 1215
14.1. The
MyISAM
Storage Engine ................................................................................... 1218
14.1.1.
MyISAM
Startup Options ............................................................................... 1220
14.1.2. Space Needed for Keys ............................................................................... 1222
14.1.3.
MyISAM
Table Storage Formats .................................................................... 1222
14.1.4.
MyISAM
Table Problems .............................................................................. 1224
14.2. The
InnoDB
Storage Engine ................................................................................... 1226
14.2.1.
InnoDB
Configuration .................................................................................. 1226
14.2.2.
InnoDB
Startup Options and System Variables ............................................. 1234
14.2.3. Creating and Using
InnoDB
Tables .............................................................. 1254
14.2.4. Adding, Removing, or Resizing
InnoDB
Data and Log Files ........................... 1259
14.2.5. Backing Up and Recovering an
InnoDB
Database ......................................... 1261
14.2.6. Moving an
InnoDB
Database to Another Machine ......................................... 1264
14.2.7. The
InnoDB
Transaction Model and Locking ................................................. 1264
14.2.8.
InnoDB
Multi-Versioning .............................................................................. 1275
14.2.9.
InnoDB
Table and Index Structures .............................................................. 1276
14.2.10.
InnoDB
Disk I/O and File Space Management ............................................ 1279
14.2.11.
InnoDB
Error Handling .............................................................................. 1280
14.2.12.
InnoDB
Performance Tuning and Troubleshooting ....................................... 1284
14.2.13. Limits on
InnoDB
Tables ........................................................................... 1297
14.3. The
MERGE
Storage Engine ..................................................................................... 1300
14.3.1.
MERGE
Table Advantages and Disadvantages ............................................... 1302
14.3.2.
MERGE
Table Problems ................................................................................ 1303
14.4. The
MEMORY
(
HEAP
) Storage Engine ....................................................................... 1305
14.5. The
BDB
(
BerkeleyDB
) Storage Engine .................................................................. 1307
14.5.1. Operating Systems Supported by
BDB
.......................................................... 1308
14.5.2. Installing
BDB
............................................................................................... 1308
14.5.3.
BDB
Startup Options ..................................................................................... 1309
14.5.4. Characteristics of
BDB
Tables ....................................................................... 1310
14.5.5. Restrictions on
BDB
Tables ........................................................................... 1312
14.5.6. Errors That May Occur When Using
BDB
Tables ............................................ 1312
14.6. The
EXAMPLE
Storage Engine ................................................................................. 1313
14.7. The
FEDERATED
Storage Engine ............................................................................. 1313
14.7.1. Description of the
FEDERATED
Storage Engine .............................................. 1313
14.7.2. How to Use
FEDERATED
Tables ................................................................... 1314
14.7.3. Limitations of the
FEDERATED
Storage Engine ............................................... 1315
14.8. The
ARCHIVE
Storage Engine ................................................................................. 1316
14.9. The
CSV
Storage Engine ......................................................................................... 1317
14.10. The
BLACKHOLE
Storage Engine ........................................................................... 1318
15. High Availability and Scalability .......................................................................................... 1321
15.1. Oracle VM Template for MySQL Enterprise Edition ................................................... 1324
15.2. Overview of MySQL with DRBD/Pacemaker/Corosync/Oracle Linux ........................... 1324
15.3. Overview of MySQL with Windows Failover Clustering .............................................. 1327
15.4. Using MySQL within an Amazon EC2 Instance ........................................................ 1329
15.4.1. Setting Up MySQL on an EC2 AMI ............................................................... 1330
15.4.2. EC2 Instance Limitations .............................................................................. 1331
15.4.3. Deploying a MySQL Database Using EC2 ..................................................... 1331
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...