Koozali.org: home of the SME Server

Mysql57 editing my.conf

Offline jameswilson

  • *
  • 790
  • +0/-0
    • Security Warehouse, trade security equipment
Mysql57 editing my.conf
« 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

Offline ReetP

  • *
  • 3,871
  • +5/-0
Re: Mysql57 editing my.conf
« Reply #1 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.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline jameswilson

  • *
  • 790
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Mysql57 editing my.conf
« Reply #2 on: May 10, 2024, 12:03:44 AM »
ah thanks Reetp

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

Thanks

Offline ReetP

  • *
  • 3,871
  • +5/-0
Re: Mysql57 editing my.conf
« Reply #3 on: May 10, 2024, 12:33:03 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

...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline jameswilson

  • *
  • 790
  • +0/-0
    • Security Warehouse, trade security equipment
Re: Mysql57 editing my.conf
« Reply #4 on: May 10, 2024, 12:51:12 AM »
Ok done and migrated the db.
Ill start a new post regarding mariadb105

Cheers Reetp

Offline Jean-Philippe Pialasse

  • *
  • 2,844
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Mysql57 editing my.conf
« Reply #5 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