[receiver/mysq] Capture deletes and update across multiple tables

[atoulme]

Component(s)

No response

Is your feature request related to a problem? Please describe.

https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html reports:

Com_xxx

The Com_xxx statement counter variables indicate the number of times each xxx statement has been executed. There is one status variable for each type of statement. For example, Com_delete and Com_update count DELETE and UPDATE statements, respectively. Com_delete_multi and Com_update_multi are similar but apply to DELETE and UPDATE statements that use multiple-table syntax.

We do not currently track Com_delete_multi and Com_update_multi in the code.

Describe the solution you'd like

Add watching Com_delete_multi and Com_update_multi

Describe alternatives you've considered

No response

Additional context

No response

[github-actions]

Pinging code owners for receiver/mysql: @djaglowski. See Adding Labels via Comments if you do not have permissions to add labels yourself. For example, comment '/label priority:p2 -needs-triaged' to set the priority and remove the needs-triaged label.

[CodePrometheus]

@atoulme @djaglowski hello all, could I pull a request to help with adding these metrics?

[atoulme]

I can assign the issue to you and you can work on it, just bear in mind @djaglowski has final word as the codeowner of the component, but I don't think this is a controversial issue and we are always happy to have help. Thank you!