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@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.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
-- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation