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 <lvic4...@gmail.com> 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.lefr...@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 <lvic4...@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.lefr...@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 <lvic4...@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 > > > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation
_______________________________________________ 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
