Options for setting MySQL connection lifetime and other parameters

[sharathjag]

Would it be possible for exposing driver parameters in Database struct?

We would need to refined access mysql driver parameters to test our use-cases and are currently limited to using connection string.
Would it be possible to expose these settings.

Happy to create a PR.

[alex-dubrouski]

To provide more details. Actual applications may have different connection pool settings, and in many cases they have enabled connection recycling. Connection recycling might significantly distort throughput data if connection lifetime is short.
We need a way to explicitly set these settings that are available in Go SQL driver and document this feature for users, so they can simulate these scenarios.

[szkiba]

I've added it to the tasks, we'll investigate it.

[sharathjag]

thanks @szkiba
I have a draft https://github.com/grafana/xk6-sql/compare/main...sharathjag:xk6-sql:conn-options?expand=1
LMK what you think of the general direction. I can refine and create a PR

[sharathjag]

@szkiba any updates?

[szkiba]

@sharathjag sorry for delay.

FYI #122 it is almost done

[szkiba]

I hope #123 will solve this, I'll create a release soon

[sharathjag]

Thank you! Appreciate it