← Back to team overview

maria-discuss team mailing list archive

Re: Bundle more relevant cnf files in MariaDB package


Hi Monty,

> Haidong, if you can create a set of files to replace the current ones,
> we can quickly get them review and add this to the MariaDB distribution.

Yes, I've created a set of files. Please look over. I did use sample
files from http://datastrangler.com/windpipe/2011/02/24/custom-mysql-config-files-to-ensure-maximum-performance/
as template with slight modification (replication stuff removal,
sync_log 1, and XA line removal). I can initiate discussion with the
author to ask for permission and express appreciation. I came up
my-sample.cnf.sh myself.

Once I get your blessing or the blessing from people you designate, I
will push for a merge.

5 files are attached:

One is a generic my-sample.cnf.sh file.

The other 4 are my-small.cnf.sh, my-medium.cnf.sh, my-large.cnf.sh,
and my-huge.cnf.sh. Definition of small, medium, large, and huge can
be arbitrary, so I made a decision:

small: minimum of 4G memory
medium: minimum of 16G memory
large: minimum of 64G memory
huge: minimum of 128G memory

Now, one can argue the definition, but at this stage, I am tired of
it. If I were benevolent dictator of the universe, I would just use
the attached single, minimalist my-sample.cnf.sh.

For my-sample.cnf.sh, I've gone through the build, compile, and
testing phase, and can tell you it works.

Let me know what you think.

Haidong Ji

Attachment: my-sample.cnf.sh
Description: Bourne shell script

Attachment: my-small.cnf.sh
Description: Bourne shell script

Attachment: my-medium.cnf.sh
Description: Bourne shell script

Attachment: my-large.cnf.sh
Description: Bourne shell script

Attachment: my-huge.cnf.sh
Description: Bourne shell script

Follow ups