ActionOMS: Intelligent Performance Diagnosis for OceanBase Data Migration

The article introduces ActionOMS, a customized version of OceanBase Migration Service that adds automated performance and fault diagnosis, explains its architecture, showcases a real‑world case of Oracle‑to‑OceanBase synchronization, and demonstrates how the tool improves migration throughput and reduces latency.

ActionOMSData MigrationDatabase Synchronization

0 likes · 11 min read

ActionOMS: Intelligent Performance Diagnosis for OceanBase Data Migration

Alibaba Cloud Native

Oct 21, 2023 · Operations

How to Reveal Tracing Blind Spots with Continuous Profiling and Code Hotspots

This article explains the evolution of observability, outlines a step‑by‑step diagnosis workflow using metrics, logs and tracing, highlights the blind spots of traditional tracing, and demonstrates how Alibaba Cloud ARMS continuous profiling and code‑hotspot features can pinpoint slow call‑chain issues in Java applications.

APMContinuous ProfilingPerformance Diagnosis

0 likes · 14 min read

How to Reveal Tracing Blind Spots with Continuous Profiling and Code Hotspots

DataFunTalk

May 30, 2023 · Big Data

Optimizing Chart Query Performance in YouShu BI: Data Query Principles, Intelligent Caching, Query Merging, and Diagnostics

This article explains the data query fundamentals of YouShu BI charts, introduces intelligent caching design, describes query merging and various optimization techniques—including partition filters, value acceleration, and SQL generation—and outlines performance diagnosis methods to improve BI chart responsiveness.

BIBig DataChart Performance

0 likes · 16 min read

Optimizing Chart Query Performance in YouShu BI: Data Query Principles, Intelligent Caching, Query Merging, and Diagnostics

ITPUB

Feb 24, 2023 · Databases

How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned

Ctrip evaluated and extended OceanBase Migration Assessment tools, built a one‑click migration workflow, implemented comprehensive monitoring and automatic fault‑diagnosis pipelines, and addressed compatibility challenges such as .NET charset issues and Druid parser errors, ultimately achieving a smooth MySQL‑to‑OceanBase transition.

OceanBasePerformance Diagnosisdatabase migration

0 likes · 18 min read

How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned

Aikesheng Open Source Community

Oct 23, 2020 · Databases

Diagnosing Slow Master Commit Performance in MySQL Semi‑Synchronous Replication

This article explains how to identify which slave in a MySQL one‑master‑multiple‑slave semi‑synchronous setup is slowing the master’s commit performance by using debug logging and examining the error log for the last ACK server ID.

Performance DiagnosisSemi‑synchronous Replicationdatabases

0 likes · 3 min read

Diagnosing Slow Master Commit Performance in MySQL Semi‑Synchronous Replication

ITPUB

Jul 28, 2016 · Databases

Oracle SQL Tuning Essentials: Joins, Execution Plans, CBO vs RBO, Backup Tips

This guide provides comprehensive Oracle database interview questions and answers covering SQL tuning techniques such as join types, execution‑plan inspection, CBO vs RBO, heavy‑SQL identification, session tracing, index structures, binding variables, plan stability, memory settings, tablespace management, backup and recovery methods including RMAN and standby, as well as system performance diagnostics.

CBODatabase BackupOracle

0 likes · 19 min read

Oracle SQL Tuning Essentials: Joins, Execution Plans, CBO vs RBO, Backup Tips