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
|
WL#10128: Add defaults column to optimizer cost tables
ALTER TABLE mysql.server_cost DROP COLUMN default_value;
ALTER TABLE mysql.engine_cost DROP COLUMN default_value;
# restart:--upgrade=FORCE
SELECT * FROM mysql.server_cost;
cost_name cost_value last_update comment default_value
disk_temptable_create_cost NULL # NULL 20
disk_temptable_row_cost NULL # NULL 0.5
key_compare_cost NULL # NULL 0.05
memory_temptable_create_cost NULL # NULL 1
memory_temptable_row_cost NULL # NULL 0.1
row_evaluate_cost NULL # NULL 0.1
SELECT * FROM mysql.engine_cost;
engine_name device_type cost_name cost_value last_update comment default_value
default 0 io_block_read_cost NULL # NULL 1
default 0 memory_block_read_cost NULL # NULL 0.25
# Default values after upgrade should be equal to fresh server
include/assert.inc [Default values after upgrade should be equal to fresh server.]
# restart:--upgrade=FORCE
SELECT * FROM mysql.server_cost;
cost_name cost_value last_update comment default_value
disk_temptable_create_cost NULL # NULL 20
disk_temptable_row_cost NULL # NULL 0.5
key_compare_cost NULL # NULL 0.05
memory_temptable_create_cost NULL # NULL 1
memory_temptable_row_cost NULL # NULL 0.1
row_evaluate_cost NULL # NULL 0.1
SELECT * FROM mysql.engine_cost;
engine_name device_type cost_name cost_value last_update comment default_value
default 0 io_block_read_cost NULL # NULL 1
default 0 memory_block_read_cost NULL # NULL 0.25
# Default values after upgrade should be equal to fresh server
include/assert.inc [Default values after upgrade should be equal to fresh server.]
|
