How to Purge Query Analyzer Data in MySQL Enterprise Monitor ? (Doc ID 1986628.1)

Last updated on JUNE 15, 2016

Applies to:

MySQL Enterprise Monitor - Version 3.0 and later
Information in this document applies to any platform.

Goal

Query Analyzer (mem__quan database) related tables' datafile are taking a large amont of space.
After changing the Data Purge Behavior section of the Global Settings page from 12 months to 4 weeks, the Query Analyzer related ibd files are still taking a large amount of space.

This document will introduce how to reclaim space from deleted rows in the table.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms