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

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

InnoDB
Startup Options and System Variables
1248
Variable Name
innodb_log_files_in_group
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
numeric
Default
2
Range
2 .. 100
The number of log files in the log group.
InnoDB
writes to the files in a circular fashion. The default
(and recommended) value is 2.
•
innodb_log_group_home_dir
Command-Line Format
--innodb_log_group_home_dir=path
Option-File Format
innodb_log_group_home_dir
Option Sets Variable Yes,
innodb_log_group_home_dir
[1248]
Variable Name
innodb_log_group_home_dir
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
file name
The directory path to the
InnoDB
log files. If you do not specify any
InnoDB
log variables, the default
is to create two files named
ib_logfile0
and
ib_logfile1
in the MySQL data directory. Their
size is given by the size of the
innodb_log_file_size
[1247] system variable.
•
innodb_max_dirty_pages_pct
Command-Line Format
--innodb_max_dirty_pages_pct=#
Option-File Format
innodb_max_dirty_pages_pct
Option Sets Variable Yes,
innodb_max_dirty_pages_pct
[1248]
Variable Name
innodb_max_dirty_pages_pct
Variable Scope Global
Dynamic Variable Yes
Permitted Values
Type
numeric
Default
90
Range
0 .. 100
This is an integer in the range from 0 to 100. The default value is 90. The main thread in
InnoDB
tries to write pages from the buffer pool so that the percentage of dirty (not yet written) pages will not
exceed this value.
•
innodb_max_purge_lag
Command-Line Format
--innodb_max_purge_lag=#
Option-File Format
innodb_max_purge_lag
Option Sets Variable Yes,
innodb_max_purge_lag
[1248]
Variable Name
innodb_max_purge_lag