Updated on 2025-09-04 GMT+08:00

Preparations

  • Confirm the service scenario characteristics.
    • Data size estimation (consider using partitioned tables for large data sizes)
    • Read/write ratio analysis (design the storage engine and indexes based on this ratio)
  • Check the environment.

    Check the track_counts and track_activities parameters.

  • Prepare tools.
    • Database client tool
    • Performance monitoring tool