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.lefr...@mariadb.com> 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 <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
