Server System Variables
474
Option Sets Variable
Yes,
myisam_data_pointer_size
[473]
Variable Name
myisam_data_pointer_size
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values (<= 5.0.5)
Type
numeric
Default
4
Range
2 .. 8
Permitted Values (>= 5.0.6)
Type
numeric
Default
6
Range
2 .. 7
The default pointer size in bytes, to be used by
CREATE TABLE
for
MyISAM
tables when no
MAX_ROWS
option is specified. This variable cannot be less than 2 or larger than 7. The default value
is 6 (4 before MySQL 5.0.6). See
Section C.5.2.12, “
The table is full
”
.
•
myisam_max_extra_sort_file_size
[474]
(DEPRECATED)
This variable is unused as of MySQL 5.0.6.
•
myisam_max_sort_file_size
[474]
Command-Line Format
--myisam_max_sort_file_size=#
Option-File Format
myisam_max_sort_file_size
Option Sets Variable
Yes,
myisam_max_sort_file_size
[474]
Variable Name
myisam_max_sort_file_size
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Platform
Bit Size
32
Type
numeric
Default
2147483648
Permitted Values
Platform
Bit Size
64
Type
numeric
Default
9223372036854775807
The maximum size of the temporary file that MySQL is permitted to use while re-creating a
MyISAM
index (during
REPAIR TABLE
,
ALTER TABLE
, or
LOAD DATA INFILE
). If the file size would be
larger than this value, the index is created using the key cache instead, which is slower. The value is
given in bytes.
The default value is 2GB. If
MyISAM
index files exceed this size and disk space is available,
increasing the value may help performance. The space must be available in the file system
containing the directory where the original index file is located.
•
myisam_mmap_size
[474]
Содержание 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 ...