What were you trying to do that didn't work?

When using pcp-pmda-mysql in PCP, I am getting the following deprecation warning:

WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.

What is the impact of this issue to you?

No impact so far, just the warning in pmda-mysql log files. However the PMDA needs an update to avoid issues in the future.

Please provide the package NVR for which the bug is seen:

pcp-6.3.7-5.el9

How reproducible is this bug?:

Always

Steps to reproduce

1. Use the pcp-pmda-mysql to monitor a MySQL database; or run pcp-testsuite to test the pmda
2. The issue can be seen when running the pcp-testsuite using this command:

   cd /var/lib/pcp/testsuite && ./check 000 -g pmda.mysql
   

1. Once the run of the pmda.mysql is done, check the pmda logfile:

   grep WARN /var/log/pcp/pmcd/mysql*
   

Expected results

No warning is reported

Actual results

Deprecation warning is reported