Mysql Table 'performance _ schema... solution,

Mysql Table 'performance _ schema... solution,

A mariadb 5.7 is set up in the test environment, and the jdbc driver is used.

<dependency>  <groupId>mysql</groupId>  <artifactId>mysql-connector-java</artifactId>  <version>5.1.34</version></dependency>

It works normally in the hibernate project.

A simple jdbc project was set up temporarily and an error was reported when connecting to the database:

Table 'performance_schema.session_variables' doesn't exist

I have no choice but to upgrade the MySQL driver to 5.1.36.

It is understood that:

MySQL 5.5 adds a storage engine named PERFORMANCE_SCHEMA, which is used to collect database server performance parameters. MySQL users cannot create a table named PERFORMANCE_SCHEMA with the storage engine: 1. provides detailed information about the process wait, including the lock, mutex variable, and file information. 2. saves historical event summary information to provide detailed judgment on MySQL server performance. 3. it is very easy to add or delete monitoring event points, and you can change the monitoring CYCLE of the mysql server at will, such as the information obtained through CYCLE and MICROSECOND, what are the possible causes of DBA performance degradation? The performance_schema function and the Performance function of some tables are easy to enable. in cnf, [mysqld] is added to ipvc_schema and the command to check whether the performance database is started: show variables like 'performance _ scheme'. If the returned value is ON, the performance database is enabled normally.

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!