Work with tables in ADQM Control

The Tables page lists data tables of an ADQM cluster as a table with the following fields.

It is also possible to add more fields with additional information on ADQM tables — to do this, click Customize table and select the required fields in the drop-down list.

On the Tables page, you can get graphs to track the dynamics of changes in the Size and Row count metrics of ADQM tables (size of compressed data on disk and number of rows, respectively) over a selected period of time. Click the icon in the column of the corresponding metric — above the list of tables, ADQM Control will display a section with a graph built based on this metric of the ADQM table. You can add up to 8 graphs (inclusive) simultaneously.

To see values of metrics at some point in time, hover the mouse over the graph area.

To delete a graph, click the icon corresponding to the graph color in the table (for example, and in the image above) or the icon in the legend to the right of the graphs.

In the Table name, Database, Host, and Engine column headers, there are filters that you can use to select the necessary data on the Tables page. To set a filter, click the icon and enter a value you are looking for (a table/database/engine name or its part, or full names of hosts). The icon means that a filter is defined for the column. To reset all filters by columns, click .

Clicking on System filters opens a list of predefined filters that you can activate with the switch :

It is also possible to sort data on the Tables page by values ​​in any column of the table with the list of ADQM tables. To apply sorting by a column, click the icon or in its header.

Above the list of tables, there is a panel that shows the sorting (Sorted by) and filtering (System filters, Filtered by) conditions currently applied to data.

You can also view the list of the largest tables by data amount or the list of the most frequently queried tables in the ADQM cluster in the Top 10 tables section on the Dashboard page.

To open a separate page with detailed information about an ADQM table, click a table name in the Table name column.

At the top of the page that opens, there is information about the ADQM table: name, size of compressed data, host, number of rows, number of queries sent to the table, time of the last query, data size change, and engine.

This page also displays a table with the following fields that contain detailed information about each column of the selected ADQM table (to control the visibility of some fields, use the Customize table option).

You can filter data in this table by the Column name field (to set a filter, click in the column header) and sort by any column except Comment (use the icons and in column headers).

On this page, you can also build graphs to see how the size of compressed or uncompressed data in individual columns of an ADQM table changes over the selected time interval, or to analyze effect of applying data compression on the amount of disk space saved. To do this, use the icon in the Size, Uncompressed Size, or Compression column, respectively. The graph area can display up to 7 graphs by individual columns and one graph by the entire table size at a time.

From the Tables page (as well as from the page with ADQM table details), you can access the list of queries sent to a specific ADQM table for a selected time interval. To do this, click the icon in the Table name cell corresponding to the desired data table — this opens the Queries page with automatically configured filters by table name, database, and host.