In the default template, you can import max_used_connection values, but i want to collect max_connections values.
How can you do that?
Zabbix 6.0.23 + MySQL by Zabbix agent 2(Template tooling version used: 0.41)
default template max_used_connection query -
$> show status like '%max_used%';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 16 |
+----------------------+-------+
1 row in set (0.000 sec)
i want query -
$> show variables like 'max_connections%';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| max_connections | 2000 |
+-----------------------+-------+
1 rows in set (0.000 sec)
How can you do that?
Zabbix 6.0.23 + MySQL by Zabbix agent 2(Template tooling version used: 0.41)
default template max_used_connection query -
$> show status like '%max_used%';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 16 |
+----------------------+-------+
1 row in set (0.000 sec)
i want query -
$> show variables like 'max_connections%';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| max_connections | 2000 |
+-----------------------+-------+
1 rows in set (0.000 sec)