Does Metricbeat have the ability to SHOW PROCESSLIST and output it ES currently?
MySQL module currently supports collecting status metrics, but not the process list,. You can open a new issue in github requesting the feature with more details about your use case if possible.