Ad Widget

Collapse

how to gathering mysql max_connectin ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • artop0420
    Junior Member
    • Jan 2024
    • 1

    #1

    how to gathering mysql max_connectin ?

    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)
Working...