Koozali.org: home of the SME Server

Contribs.org Forums => Koozali SME Server 10.x Contribs => Topic started by: jameswilson on May 09, 2024, 01:17:27 AM

Title: Mysql57 editing my.conf
Post by: jameswilson on May 09, 2024, 01:17:27 AM

Hi all
edited some buffer settings etc on a previous sme9 server but cant see how to do it on sme10

I see i can edit settings in phpmyadmin but assume and doubt these are permanant etc, also some are read only
WHats the method for altering setting on this contrib please.


Thanks
James

Title: Re: Mysql57 editing my.conf
Post by: ReetP on May 09, 2024, 09:34:15 AM

You never edit server settings in phpmyadmin.

They are set by the server via a template as usual.

NB If you read the wiki you would see mysql57 is already EOL.

Maria 10.x might be a better bet.

Either way, to see where there are settings we can check the config entry eg "mysql57-mysqld" and you can search for it like this:

Code: [Select]

grep -rn mysql57 /etc/e-smith/templates

I don't have this installed so can't say specifically what to modify.

Title: Re: Mysql57 editing my.conf
Post by: jameswilson on May 10, 2024, 12:03:44 AM

ah thanks Reetp

So i should install the mariadb one and move to that first?

Thanks

Title: Re: Mysql57 editing my.conf
Post by: ReetP on May 10, 2024, 12:33:03 AM

Quote from: jameswilson on May 10, 2024, 12:03:44 AM

ah thanks Reetp

So i should install the mariadb one and move to that first?

I'd start at Maria 10.5

See Extra Repos

https://wiki.koozali.org/Category:Contrib
https://wiki.koozali.org/Mariadb105

Title: Re: Mysql57 editing my.conf
Post by: jameswilson on May 10, 2024, 12:51:12 AM

Ok done and migrated the db.
Ill start a new post regarding mariadb105

Cheers Reetp

Title: Re: Mysql57 editing my.conf
Post by: Jean-Philippe Pialasse on May 10, 2024, 01:37:25 PM

for answer to those who will see this later :
we use a common /etc/my.cnf file for all server running. 
mariadb and mysql are able to parse the file depending on their version

[mysql] content is read by all

[mariadb10.5] only by mariadb 10.5.


so you can adjust either the  content of templates via variables or via new custom templates, or with corect placement only for one version