MySQL 8.0 Release Notes
ON EMPTY, 229
ON ERROR, 229
one_or_all, 500
online DDL, 8, 82, 98, 116, 339, 383, 399, 421
only_full_group_by, 399
ONLY_FULL_GROUP_BY, 500
open files limit, 136
opening tables, 13
OpenSSL, 22, 53, 67, 82, 98, 116, 159, 174, 208, 229, 248, 271, 290, 315, 339,
360, 383, 399, 421, 475, 500
openssl_udf plugin, 67
open_files_limit, 248
operators, 339, 540
optimization, 315
OPTIMIZE PARTITION, 475
OPTIMIZE TABLE, 190, 360
optimizer, 116, 159, 190, 208, 229, 290, 339, 360, 383, 421, 455, 475, 500, 540
optimizer hints, 229, 290, 455, 500, 540
optimizer statistics, 248
optimizer trace, 98, 116, 159
optimizer_search_depth, 159
optimizer_switch, 208, 290, 455
optimizer_trace_max_mem_size, 421
optimizer_trace_offset, 399
options, 41, 53, 67, 82, 98, 116, 136, 190, 208, 229, 248, 271, 290, 315, 339,
360, 383, 399, 421, 455, 475, 500, 540
OR, 22, 116, 248
ORDER BY, 13, 17, 22, 33, 41, 53, 67, 82, 116, 136, 174, 190, 208, 229,
271, 290, 315, 339, 383, 421, 500
ORDER BY DESC, 22
ordered index scans, 33
original_commit_timestamp, 339, 475
os_event, 116
outer joins, 315, 339
outer references, 82, 229
OVER(), 8
P
Packaging, 8, 22, 67, 98, 190, 383, 421, 500
packaging, 8, 13, 17, 22, 33, 41, 53, 67, 82, 98, 116, 136, 159, 174,
190, 208, 229, 248, 271, 290, 315, 339, 339, 360, 383, 399, 421, 455, 475, 500,
540
PAD SPACE, 248
PAD SPACE collations, 290, 500
padding, 116
PAD_CHAR_TO_FULL_LENGTH, 360
page, 540
page allocation, 98
page cleaner, 540
page cleaner thread, 82, 290, 500
page compression, 82, 116, 174, 190, 399, 455, 475
page flushing, 159, 174, 190, 271, 455
page tracker, 229
page tracking, 82, 248, 315
parallel index read, 290, 339
parallel read, 174, 229, 248
parallel read threads, 190, 208
parallel scan, 116
597