Control Web Panel

WebPanel => MySQL => Topic started by: MMatyas on May 08, 2021, 01:08:47 PM

Title: Mysql Config Editor
Post by: MMatyas on May 08, 2021, 01:08:47 PM

Hi all
I want to change some settings on mysql
When I click MySQL Configuration, It only shows that it includes config filed under /etc/my.cnf.d

I want to change innodb_buffer_pool_size.
Which file  should I put the settings into from client.cnf ,enable_encryption.preset ,mysql-clients.cnf ,server.cnf ,tokudb.cnf

Title: Re: Mysql Config Editor
Post by: narin on May 09, 2021, 12:01:11 AM

You can modify the my.cnf file for the mysql configuration. Restart the mysql server for the changes to take effect.

Title: Re: Mysql Config Editor
Post by: MMatyas on May 09, 2021, 10:23:05 PM

In Cwp my.cnf contains only including codes
FOund where to put.
I made the changes  in /etc/my.cnf.d/server.cnf  under mysqld section and restart the mysql server

Title: Re: Mysql Config Editor
Post by: studio4host on May 12, 2021, 06:31:00 AM

info is on the wiki
http://wiki.centos-webpanel.com/configuration-files