MAX/MIN
in some scenariosSort Merge Join
does not show in order of Join Key in some scenariosuint
and int
in boundary conditionsIndexLookupExecutor
memoryADD INDEX
to greatly increase the speed in some scenariosGROUP BY
substatement is empty, to increase the speedJoin Reorder
optimization in the optimizer using STRAIGHT_JOIN
ADMIN SHOW DDL JOBS
ADMIN SHOW DDL JOB QUERIES
ADMIN RECOVER INDEX
for disaster recoveryADD INDEX
operation to reduce the impact on online businessSUM/AVG
lower_case_table_names
system variable in the configuration file, to support the OGG data synchronization tooltikv-ctl
raw_get/get/batch_get
by 30%scan lock
to avoid request timeoutDeleteRange
to speed up Region deletion