Skip to main content

7.0 Introduction

This chapter describes how to perform performance diagnostics and tuning for OceanBase Database.

Topics​

  • 7.1 Overview

  • 7.2 Principles of ODP SQL routing

  • 7.3 Manage OceanBase Database connections

  • 7.4 Perform analysis based on SQL monitoring views

  • 7.5 Read and manage SQL execution plans in OceanBase Database

  • 7.6 Common SQL tuning methods

  • 7.7 Typical scenarios and troubleshooting logic for SQL performance issues

  • 7.8 Use SQL Diagnoser to diagnose and analyze SQL performance issues

  • 7.9 Use obdiag for diagnostics and analytics

Contact us​

You can contact us in the following ways:

Note

You can click here to learn the supporting course of this tutorial — From Beginner to Pro: A Guide for DBAs (in Chinese).

Loading...