# Metricbeat used or create mysql connections

**URL:** <https://discuss.elastic.co/t/metricbeat-used-or-create-mysql-connections/182853>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [May 27, 2019, 7:46am UTC](https://discuss.elastic.co/t/metricbeat-used-or-create-mysql-connections/182853 "2019-05-27T07:46:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![yasin](https://avatars.discourse-cdn.com/v4/letter/y/9e8a1a/32.png) [@yasin](https://discuss.elastic.co/u/yasin)\
**Post date:** [May 27, 2019, 7:46am UTC](https://discuss.elastic.co/t/metricbeat-used-or-create-mysql-connections/182853/1 "2019-05-27T07:46:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Kaiyan\_Sheng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kaiyan_sheng/32/38247_2.png) [@Kaiyan\_Sheng](https://discuss.elastic.co/u/Kaiyan_Sheng)\
**Post date:** [May 28, 2019, 5:12pm UTC](https://discuss.elastic.co/t/metricbeat-used-or-create-mysql-connections/182853/2 "2019-05-28T17:12:47Z")

</div>

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](https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-mysql.html#_module_specific_configuration_notes_5)

---

<div class="post-metadata">

**Author:** ![yasin](https://avatars.discourse-cdn.com/v4/letter/y/9e8a1a/32.png) [@yasin](https://discuss.elastic.co/u/yasin)\
**Post date:** [May 29, 2019, 6:20am UTC](https://discuss.elastic.co/t/metricbeat-used-or-create-mysql-connections/182853/3 "2019-05-29T06:20:49Z")

</div>

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.

> <https://stackoverflow.com/questions/2453308/monitoring-used-connections-on-mysql-to-debug-too-many-connections>

---

<div class="post-metadata">

**Author:** ![Kaiyan\_Sheng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kaiyan_sheng/32/38247_2.png) [@Kaiyan\_Sheng](https://discuss.elastic.co/u/Kaiyan_Sheng)\
**Post date:** [May 30, 2019, 3:14pm UTC](https://discuss.elastic.co/t/metricbeat-used-or-create-mysql-connections/182853/4 "2019-05-30T15:14:26Z")

</div>

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](https://github.com/elastic/beats/blob/master/metricbeat/module/mysql/mysql.go#L103)

---

<div class="post-metadata">

**Author:** ![yasin](https://avatars.discourse-cdn.com/v4/letter/y/9e8a1a/32.png) [@yasin](https://discuss.elastic.co/u/yasin)\
**Post date:** [May 31, 2019, 6:07am UTC](https://discuss.elastic.co/t/metricbeat-used-or-create-mysql-connections/182853/5 "2019-05-31T06:07:33Z")

</div>

Dear Kalyan,

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 28, 2019, 6:07am UTC](https://discuss.elastic.co/t/metricbeat-used-or-create-mysql-connections/182853/6 "2019-06-28T06:07:34Z")

</div>

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