I’m using docker for Percona, and docker for mysql too.But when I try to install the plugin, the “query_response_time.so’” does not exist.
Example:
INSTALL PLUGIN QUERY_RESPONSE_TIME_WRITE SONAME ‘query_response_time.so’;
Response:[HY000][1126] Can’t open shared library ‘/usr/lib/mysql/plugin/query_response_time.so’ (errno: 2 /usr/lib/mysql/plugin/query_response_time.so: cannot open shared object file: No such file or directory)
And effectivity the “query_response_time.so’” file don’t exists into the path “/usr/lib/mysql/plugin/”
The mysql version installed in the docker is: mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL)
I
guess the only thing I need to have is the file “query_response_time.so” to
able to copy inside the path “/usr/lib/mysql/plugin/” to able to
install the plugin as it mentioned in the page
Any one could you send me the file “query_response_time.so” or how can I get it ?RegardsGabriel
Note from the manual: Changed in Percona Server 8.0 — Percona Server 8.0 Documentation
The QUERY_RESPONSE_TIME plugins have been removed from Percona Server for MySQL 8.0 as the Performance Schema of MySQL 8.0
provides histogram data for statement execution time.
Ok, can you send me the order of the steps to add this metrics, so I could see the QAN correctly pls?
Marking this ‘solved’.
Please see comments on this post