Should I set "peformance_schema" on or off?

E

electric

Well-Known Member
Nov 5, 2001
790
11
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.
 
V

vacancy

Well-Known Member
Sep 20, 2012
576
232
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
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
A Should it be safe to migrate all accounts from MariaDB 10.3 to MySQL 8 in a shared hosting environment? Databases 5
icandoit Non latin file or image names? should it be avoided? Databases 1
U SOLVED should i disable strict mode? Databases 3
M MariaDB status should use systemd 'systemctl status' Databases 8
S Table is marked as crashed and should be repaired errors Databases 6
Similar threads
Should it be safe to migrate all accounts from MariaDB 10.3 to MySQL 8 in a shared hosting environment?
Non latin file or image names? should it be avoided?
SOLVED should i disable strict mode?
MariaDB status should use systemd 'systemctl status'
Table is marked as crashed and should be repaired errors
Top Bottom