Tag

dump

0 views collected around this technical thread.

Aikesheng Open Source Community

Apr 27, 2023 · Databases

Diagnosing Freeze and Dump Issues in OceanBase Memstore

This article explains how to verify whether OceanBase's freeze mechanism and memstore dump processes are functioning correctly by querying internal tables, inspecting logs, and checking related metrics such as active_memstore_used, major_freeze_trigger, and MemTable reference counts.

Database AdministrationFreezeMemstore

0 likes · 14 min read

Diagnosing Freeze and Dump Issues in OceanBase Memstore

Aikesheng Open Source Community

Sep 18, 2020 · Databases

Safely Replaying Large MySQL Dump Files Using PV to Limit Production Impact

This article demonstrates how to create a test database, export data with mysqldump, and then replay a large SQL dump into a busy MySQL instance while throttling the import speed with the pv tool to keep CPU usage low and avoid disrupting ongoing business operations.

MySQLPVdata replay

0 likes · 2 min read

Safely Replaying Large MySQL Dump Files Using PV to Limit Production Impact