Best practices for handling slow queries-OceanBase

OceanBase Best Practices

master

Deploy
- Configuration guide for read-write splitting in AP scenarios
- Best practices for read-write splitting
Configure
- Recommended configurations in OLTP scenarios
- Recommended configurations in complex OLTP scenarios
- Recommended configurations in HTAP scenarios
- Recommended configurations in OLAP scenarios
- Recommended configurations for OBKV
Migrate
- Data transfer solutions in OceanBase Database
- Overview on data migration
- Best practices for importing data files to OceanBase Database
- Best practice for migrating data from other databases to OceanBase Database
- Massive data migration strategy
- Best practices for migrating from MyCat to OceanBase
Route
- ODP routing best practices
Table Design
- Best practices for table design and index optimization
- Best practices for creating indexes on large tables
- Best practices for database development
Develop
- Best practices for connecting Java applications to OceanBase Database
- Best practices for integrating Spark Catalog with OceanBase Database
- Best practices for optimizing batch DML performance
- Best practices for bulk data cleanup in OceanBase Database
Manage
- Best practices for resource throttling
- Best practices for data load balancing
- Best practices for security certification
- Best practices for access control
- Best practices for data encryption
Diagnose
- Best practices for log interpretation in common scenarios
- Best practices for end-to-end tracing
- Best practices for using obdiag to collect performance information
- Best practices for using obdiag to collect diagnostic information of parallel and slow SQL statements
- Best practices for troubleshooting OceanBase Database performance issues
Performance Tuning
- Best practices for handling slow queries
- Best practices for collecting statistics to generate an efficient execution plan
- Best practices for updating hotspot rows
- Best practices for optimizing LOB storage