I am studying the explanation on this page:
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
and I do not understand the following:
Server monitoring occurs continuously and unobtrusively with very little overhead. Activating the Performance Schema does not make the server unusable.
The parser is unchanged. There are no new keywords or statements.
can anyone help me give a simple explanation?
There is no change to your normal query SQL. This just enables performance data collection on the MySQL server.
See an example of the usage below:
https://www.ip2location.com/tutorials/lookup-ip-proxy-optimization-mysql