Topic: Mysql57 editing my.conf

[jameswilson]

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

[ReetP]

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.

[jameswilson]

ah thanks Reetp

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

Thanks

[ReetP]

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

[jameswilson]

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

Cheers Reetp

[Jean-Philippe Pialasse]

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