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@mariadb.com> 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@gmail.com> 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@mariadb.com> 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@gmail.com> 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@lists.launchpad.net
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