Percona Monitoring and Management (PMM) is a free and open-source monitoring tool for MySQL, PostgreSQL, MongoDB, and ProxySQL, and the servers they run on.
PMM helps you improve the performance of your database, simplify its management, and enhance its security. It's efficient, quick to set up, and easy to use.
I monitorMySQL version is: 5.7.24, using the Performance Schema pattern, which reads and analyzes data from the PERFORMANCE_SCHEMA library.
MySQL 5.5 begins with a new database: PERFORMANCE_SCHEMA, which is mainly used to collect database server performance parameters. Moreover, the storage engine of the library table is PERFORMANCE_SCHEMA, and users cannot create tables with a storage engine PERFORMANCE_SCHEMA. MySQL5.5 is off by default, and from MySQL 5.6 onwards, it is on by default.
The reason for the incomplete display is that MySQL has a default limit when storing text.Excess will be truncated, the default configuration is as follows:
solution
Needs to be modified on the MySQL server/etc/my.cnfThe configuration is as follows:
After the setup is completed, as shown below:
The above parameters must be configured on the server, and cannot be set by the set global command, otherwise the error will be as follows:
SQL Error [1238] [HY000]: Variable 'max_digest_length' is a read only variable
(End)
|
Posted on 11/22/2021 3:06:02 PM
|
|
|
|
Landlord|
Posted on 11/23/2021 5:02:25 PM
|
