Should I set "peformance_schema" on or off?

electric

Well-Known Member
Nov 5, 2001
779
8
318
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

Well-Known Member
Sep 20, 2012
409
127
93
Turkey
cPanel Access Level
Root Administrator
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.
 
  • Like
Reactions: cPanelLauren