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