Metricbeat used or create mysql connections

Dear Elastic Team,

Would like to know how many that metricbeats us or create connection for our mysql for example, based on what?

With regards,
Yasin D

Hi @yasin, I probably didn't understand your question correctly. Please let me know if that's the case.

When using mysql metricbeat module to collect data, one or more host DSN need to be specified under hosts and then if you have username and password for the DSN, you need to specify those in mysql.yml as well. Please see more details here https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-mysql.html#_module_specific_configuration_notes_5

Dear Kaiyan,

Thank you for your reply. We wanted to avoid the "To many Connections"
So we wanted to know how many that metricbeats will use from our open connection.

By looking at the code, seems like each metricset in mysql metricbeat module opens its own connection to the database. Here is the part metricbeat mysql module calls for open connection: https://github.com/elastic/beats/blob/master/metricbeat/module/mysql/mysql.go#L103

1 Like

Dear Kalyan,

Would like to thank you for answering the question, it was very clear.

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.