MariaDB configuration settings

Re: MariaDB configuration settings

by Ken Task -
Number of replies: 1
Picture of Particularly helpful Moodlers

Please ... 'guru'???!!! More like 'guessed right 3 times in a row'!

Anyhooo ... 'rattled' my tree ... so a response ... kinda.

Chuckle ... see the config file is well commented ... even 'who to blame'? (not really).

The only reason for suggesting not sharing ... OP we do now know, copies and paste without checking docs for DB servers.

Some settings I had for MySQL 5.6 no longer needed in 5.7 ... and beyond.

Do have a suggestion for ya Rick (OP also if OP doesn't have 'command line avoidance syndrome') ... install MySQL Tuner on that server and let's see what it recommends. ;)

'SoS', Ken


Average of ratings: -
In reply to Ken Task

Re: MariaDB configuration settings

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
Yep, I need to still learn how to install MySQL Tuner, guru Ken! 😀

What my commenting shows is that I had to dig around quite a bit to determine what needed to go into this my.cnf file.

Actually, the way that I experimented was to make some changes and then run that "perspective.php" file.  I am sure that MySQL Tuner would be better.  I really haven't touched this my.cnf file for a few years.
Average of ratings: -