Oracle 5.0, Справочное руководство

Страница: 1261 / 3232

InnoDB
Startup Options and System Variables
1241
•
innodb_fast_shutdown
Command-Line Format
--innodb_fast_shutdown[=#]
Option-File Format
innodb_fast_shutdown
Option Sets Variable Yes,
innodb_fast_shutdown
[1241]
Variable Name
innodb_fast_shutdown
Variable Scope Global
Dynamic Variable Yes
Permitted Values
Type
numeric
Default
1
Valid
Values
0
1
2
The
InnoDB
shutdown mode. By default, the value is 1, which causes a “fast” shutdown (the normal
type of shutdown). If the value is 0,
InnoDB
does a full purge and an insert buffer merge before a
shutdown. These operations can take minutes, or even hours in extreme cases. If the value is 1,
InnoDB
skips these operations at shutdown. If the value is 2,
InnoDB
will just flush its logs and then
shut down cold, as if MySQL had crashed; no committed transaction will be lost, but crash recovery
will be done at the next startup. The value of 2 can be used as of MySQL 5.0.5, except that it cannot
be used on NetWare.
•
innodb_file_io_threads
Command-Line Format
--innodb_file_io_threads=#
Option-File Format
innodb_file_io_threads
Option Sets Variable Yes,
innodb_file_io_threads
[1241]
Variable Name
innodb_file_io_threads
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
numeric
Default
4
Range
4 .. 64
The number of file I/O threads in
InnoDB
. Normally, this should be left at the default value of 4, but
disk I/O on Windows may benefit from a larger number. On Unix, increasing the number has no
effect;
InnoDB
always uses the default value.
•
innodb_file_per_table
Command-Line Format
--innodb_file_per_table
Option-File Format
innodb_file_per_table
Variable Name
innodb_file_per_table
Variable Scope Global
Dynamic Variable No
Permitted Values