maria-discuss team mailing list archive

[l vic <lvic4594@xxxxxxxxx>]

from documentation page:
Be sure the changes are under the [mysqld] section, not some other section
So, if I create mysqld section in /etc/mysql/conf.d/mysql_server.cnf and
specify new value, will it overwrite default value in my.cnf?

On Wed, Dec 28, 2016 at 2:26 PM, Guillaume Lefranc <
guillaume.lefranc@xxxxxxxxxxx> wrote:

> Yes, that's right. It's a conservative figure, the amount of memory used
> by InnoDB is basically innodb buffer pool + per-page overhead (1462 byte) +
> dictionary + adaptive hash index. Then there will be the per-connection
> buffers but as long as you keep connections low and don't mess around with
> temp tables, you should usually be fine with those.
>
> On Wed, Dec 28, 2016 at 8:16 PM l vic <lvic4594@xxxxxxxxx> wrote:
>
>> You mean innodb_buffer_pool_size to use 60% of RAM, correct?
>>
>> On Wed, Dec 28, 2016 at 2:12 PM, Guillaume Lefranc <
>> guillaume.lefranc@xxxxxxxxxxx> wrote:
>>
>> Well, in this case, I would take care not to set buffers too high so they
>> will not exceed the limit defined by Mesos - I do not think it warrants
>> using docker "--memory" option which would kill the service anyway...
>> If you run InnoDB, the calculation is a bit complex but you would be fine
>> with 60% of maximum RAM. There can be overhead with the dictionary if you
>> have many tables, but you can also limit that size.
>>
>> On Wed, Dec 28, 2016 at 8:04 PM l vic <lvic4594@xxxxxxxxx> wrote:
>>
>> Hi Guillaume,
>> Already do, kind of....
>> I run it (mariadb ) in docker, as Mesos task;
>> The problem: if memory use by mysqld exceeds limit allocated to mesos
>> task, we have oom and mesos kills container
>>
>>
>> On Wed, Dec 28, 2016 at 1:51 PM, Guillaume Lefranc <
>> guillaume.lefranc@xxxxxxxxxxx> wrote:
>>
>> Use linux control groups, or even simpler, run MariaDB with Docker (which
>> uses control groups as well):
>>
>> docker run --name mariadb -d -m 10G mariadb:10.1
>>
>> On Wed, Dec 28, 2016 at 7:48 PM l vic <lvic4594@xxxxxxxxx> wrote:
>>
>> Is there some way to set hard limit for use of RAM by mariaDB server?
>> Thanks,
>> -V
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>> --
>> Guillaume Lefranc
>> Remote DBA Services Manager
>> MariaDB Corporation
>>
>>
>> --
>> Guillaume Lefranc
>> Remote DBA Services Manager
>> MariaDB Corporation
>>
>>
>> --
> Guillaume Lefranc
> Remote DBA Services Manager
> MariaDB Corporation
>