21 lines
1.2 KiB
PHP
21 lines
1.2 KiB
PHP
--disable_query_log
|
|
--disable_result_log
|
|
if ($TENANT == 'mysql') {
|
|
let $use_spb_bk = query_get_value(select value from oceanbase.__tenant_virtual_session_variable where VARIABLE_NAME = 'optimizer_use_sql_plan_baselines',value, 1);
|
|
let $cap_spb_bk = query_get_value(select value from oceanbase.__tenant_virtual_session_variable where VARIABLE_NAME = 'optimizer_capture_sql_plan_baselines',value, 1);
|
|
set global optimizer_use_sql_plan_baselines = 'OFF';
|
|
set global optimizer_capture_sql_plan_baselines = 'OFF';
|
|
set session optimizer_use_sql_plan_baselines = 'OFF';
|
|
set session optimizer_capture_sql_plan_baselines = 'OFF';
|
|
}
|
|
if ($TENANT == 'oracle') {
|
|
let $use_spb_bk = query_get_value(select value from sys.TENANT_VIRTUAL_SESSION_VARIABLE where VARIABLE_NAME = 'optimizer_use_sql_plan_baselines',VALUE, 1);
|
|
let $cap_spb_bk = query_get_value(select value from sys.TENANT_VIRTUAL_SESSION_VARIABLE where VARIABLE_NAME = 'optimizer_capture_sql_plan_baselines',VALUE, 1);
|
|
set global optimizer_use_sql_plan_baselines = 'OFF';
|
|
set global optimizer_capture_sql_plan_baselines = 'OFF';
|
|
set session optimizer_use_sql_plan_baselines = 'OFF';
|
|
set session optimizer_capture_sql_plan_baselines = 'OFF';
|
|
}
|
|
--enable_result_log
|
|
--enable_query_log
|