1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
<?php
/**
* The MyISAM storage engine
*/
declare(strict_types=1);
namespace PhpMyAdmin\Engines;
use PhpMyAdmin\StorageEngine;
use function __;
/**
* The MyISAM storage engine
*/
class Myisam extends StorageEngine
{
/**
* Returns array with variable names dedicated to MyISAM storage engine
*
* @return array variable names
*/
public function getVariables()
{
return [
'myisam_data_pointer_size' => [
'title' => __('Data pointer size'),
'desc' => __(
'The default pointer size in bytes, to be used by CREATE TABLE '
. 'for MyISAM tables when no MAX_ROWS option is specified.'
),
'type' => StorageEngine::DETAILS_TYPE_SIZE,
],
'myisam_recover_options' => [
'title' => __('Automatic recovery mode'),
'desc' => __(
'The mode for automatic recovery of crashed MyISAM tables, as '
. 'set via the --myisam-recover server startup option.'
),
],
'myisam_max_sort_file_size' => [
'title' => __('Maximum size for temporary sort files'),
'desc' => __(
'The maximum size of the temporary file MySQL is allowed to use '
. 'while re-creating a MyISAM index (during REPAIR TABLE, ALTER '
. 'TABLE, or LOAD DATA INFILE).'
),
'type' => StorageEngine::DETAILS_TYPE_SIZE,
],
'myisam_max_extra_sort_file_size' => [
'title' => __('Maximum size for temporary files on index creation'),
'desc' => __(
'If the temporary file used for fast MyISAM index creation '
. 'would be larger than using the key cache by the amount '
. 'specified here, prefer the key cache method.'
),
'type' => StorageEngine::DETAILS_TYPE_SIZE,
],
'myisam_repair_threads' => [
'title' => __('Repair threads'),
'desc' => __(
'If this value is greater than 1, MyISAM table indexes are '
. 'created in parallel (each index in its own thread) during '
. 'the repair by sorting process.'
),
'type' => StorageEngine::DETAILS_TYPE_NUMERIC,
],
'myisam_sort_buffer_size' => [
'title' => __('Sort buffer size'),
'desc' => __(
'The buffer that is allocated when sorting MyISAM indexes '
. 'during a REPAIR TABLE or when creating indexes with CREATE '
. 'INDEX or ALTER TABLE.'
),
'type' => StorageEngine::DETAILS_TYPE_SIZE,
],
'myisam_stats_method' => [],
'delay_key_write' => [],
'bulk_insert_buffer_size' => ['type' => StorageEngine::DETAILS_TYPE_SIZE],
'skip_external_locking' => [],
];
}
}
|
