Should I set "peformance_schema" on or off?

electric

• October 16, 2020 03:04

After installation of cpanel I checked the /etc/my.cnf and I see that: peformance_schema = 0 Should I set this ON? Will it greatly impact mysql performance? (There are about 750 accounts on the server with a few hundred databases.) Thanks.

• 

  vacancy

  • October 16, 2020 08:45

  performance_schema is not a performance setting, it is about statistics and data collection. Whether it is turned on or off has no direct effect on performance, but if it is turned on, mysql consumes more memory. It is good that it is closed if there is no specific purpose.

  0
• 

  cPanelLauren

  • October 16, 2020 15:05

  Let us know if you have any further questions in regard to this @electric

  0

Please sign in to leave a comment.