After a scheduled partition balancing task is triggered, you can view its trigger history by querying a view.
View the trigger history of scheduled partition balancing tasks in the sys tenant
Log in to the
systenant of the cluster as therootuser.Note that you must specify the corresponding options in the following sample code based on your actual database configurations.
obclient -h10.xx.xx.xx -P2883 -uroot@sys#obdemo -p***** -AExecute the following statement to view the trigger history of the scheduled partition balancing task for a specified tenant.
The
CDB_SCHEDULER_JOB_RUN_DETAILSview displays the execution records of theSCHEDULED_TRIGGER_PARTITION_BALANCEjob of all tenants.obclient [oceanbase]> SELECT * FROM oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS WHERE TENANT_ID = 1002 AND JOB_NAME = 'SCHEDULED_TRIGGER_PARTITION_BALANCE'\GThe query result is as follows:
*************************** 1. row *************************** LOG_ID: 0 LOG_DATE: NULL OWNER: NULL JOB_NAME: SCHEDULED_TRIGGER_PARTITION_BALANCE JOB_SUBNAME: NULL STATUS: NULL CODE: -7124 REQ_START_DATE: NULL ACTUAL_START_DATE: NULL RUN_DURATION: NULL INSTANCE_ID: NULL SESSION_ID: NULL SLAVE_PID: NULL CPU_USED: NULL CREDENTIAL_OWNER: NULL CREDENTIAL_NAME: NULL DESTINATION_OWNER: NULL DESTINATION: NULL MESSAGE: partitions are already balanced, no need to trigger partition balance TENANT_ID: 1002 JOB: 11 TIME: 2024-06-14 00:00:00.124110 JOB_CLASS: DEFAULT_JOB_CLASS GMT_CREATE: 2024-06-14 00:00:00.124110 GMT_MODIFIED: 2024-06-14 00:00:00.124110 *************************** 2. row *************************** LOG_ID: 0 LOG_DATE: NULL OWNER: NULL JOB_NAME: SCHEDULED_TRIGGER_PARTITION_BALANCE JOB_SUBNAME: NULL STATUS: NULL CODE: 0 REQ_START_DATE: NULL ACTUAL_START_DATE: NULL RUN_DURATION: NULL INSTANCE_ID: NULL SESSION_ID: NULL SLAVE_PID: NULL CPU_USED: NULL CREDENTIAL_OWNER: NULL CREDENTIAL_NAME: NULL DESTINATION_OWNER: NULL DESTINATION: NULL MESSAGE: SUCCESS TENANT_ID: 1002 JOB: 11 TIME: 2024-06-14 17:00:00.143494 JOB_CLASS: DEFAULT_JOB_CLASS GMT_CREATE: 2024-06-14 17:00:00.143494 GMT_MODIFIED: 2024-06-14 17:00:00.143494 2 rows in setFor more information about the columns in the
CDB_SCHEDULER_JOB_RUN_DETAILSview, see CDB_SCHEDULER_JOB_RUN_DETAILS.
View the trigger history of scheduled partition balancing tasks in a user tenant
Log in to the cluster as the tenant administrator of a user tenant.
Note that you must specify the corresponding options in the following sample code based on your actual database configurations.
obclient -h10.xx.xx.xx -P2883 -uroot@mysql_tenant#obdemo -p***** -AExecute the following statement to view the trigger history of the scheduled partition balancing task for the current tenant.
The
DBA_SCHEDULER_JOB_RUN_DETAILSview displays the execution records of theSCHEDULED_TRIGGER_PARTITION_BALANCEjob of the current tenant.The statement is as follows:
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'SCHEDULED_TRIGGER_PARTITION_BALANCE'\GThe query result is as follows:
*************************** 1. row *************************** LOG_ID: 0 LOG_DATE: NULL OWNER: NULL JOB_NAME: SCHEDULED_TRIGGER_PARTITION_BALANCE JOB_SUBNAME: NULL STATUS: NULL CODE: -7124 REQ_START_DATE: NULL ACTUAL_START_DATE: NULL RUN_DURATION: NULL INSTANCE_ID: NULL SESSION_ID: NULL SLAVE_PID: NULL CPU_USED: NULL CREDENTIAL_OWNER: NULL CREDENTIAL_NAME: NULL DESTINATION_OWNER: NULL DESTINATION: NULL MESSAGE: partitions are already balanced, no need to trigger partition balance JOB: 11 TIME: 2024-06-14 00:00:00.124110 JOB_CLASS: DEFAULT_JOB_CLASS GMT_CREATE: 2024-06-14 00:00:00.124110 GMT_MODIFIED: 2024-06-14 00:00:00.124110 *************************** 2. row *************************** LOG_ID: 0 LOG_DATE: NULL OWNER: NULL JOB_NAME: SCHEDULED_TRIGGER_PARTITION_BALANCE JOB_SUBNAME: NULL STATUS: NULL CODE: 0 REQ_START_DATE: NULL ACTUAL_START_DATE: NULL RUN_DURATION: NULL INSTANCE_ID: NULL SESSION_ID: NULL SLAVE_PID: NULL CPU_USED: NULL CREDENTIAL_OWNER: NULL CREDENTIAL_NAME: NULL DESTINATION_OWNER: NULL DESTINATION: NULL MESSAGE: SUCCESS JOB: 11 TIME: 2024-06-14 17:00:00.143494 JOB_CLASS: DEFAULT_JOB_CLASS GMT_CREATE: 2024-06-14 17:00:00.143494 GMT_MODIFIED: 2024-06-14 17:00:00.143494 2 rows in setFor more information about the columns in the
DBA_SCHEDULER_JOB_RUN_DETAILSview, see DBA_SCHEDULER_JOB_RUN_DETAILS.