Not Found Tmp Storage Engine value in PMM?

Asuwini_P · January 3, 2023, 6:25am

Hi Everyone,

I am creating custom dashboard in PMM. I need to display the default_tmp_storage_engine value in the dashboard. Am not able to find the default_tmp_storage_engine metrics value in PMM.

MySQL version – 8.0.29
PMM version – 2

Vadim_Yalovets · January 3, 2023, 9:19am

Hi @Asuwini_P

Variables default_storage_engine, default_tmp_storage_engine are not provided as metrics or parameters.

github.com

percona/mysqld_exporter/blob/main/collector/global_variables.go

// Copyright 2018 The Prometheus Authors
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

// Scrape `SHOW GLOBAL VARIABLES`.

package collector

import (
	"context"
	"database/sql"

This file has been truncated. show original

Asuwini_P · January 6, 2023, 5:23am

Thanks for replying @Vadim_Yalovets

Means, the string value we can’t get it ? Even if we write a custom queries ? Is any possible way to get the string values to show in the PMM dashboard.

Vadim_Yalovets · January 6, 2023, 11:27am

String values can be shown as a metrics parameter.

It should be passed as a label in a custom query.

It can be shown by table element. You may check “MongoDB Versions” panel as an example on
“MongoDB ReplSet Summary” dashboard.
e.g.
Screenshot 2023-01-06 at 13.23.52

Asuwini_P · January 6, 2023, 11:57am

Thank you @Vadim_Yalovets, You save my day.

Topic		Replies	Views
How can i get MySQL config variable value in PMM? PMM 2.x	2	670	January 16, 2023
DB Uptime and Virtual CPU not showing on PMM Dashboard Percona Monitoring and Management (PMM) pmm , mysql	9	1022	July 7, 2022
MongoDB cluster not getting populated on PMM2 dashboard PMM 2.x mongodb-exporter	5	1104	January 24, 2023
MongoDB 7.0.5 no metrics in dashboard PMM 2.x	4	354	May 9, 2024
MySQL Query Performance Troubleshooting doesn't show queries PMM 2.x pmm , percona	6	633	October 9, 2024

Not Found Tmp Storage Engine value in PMM?

Related topics