How's about max_binlog_cache_size or max_binlog_stmt_cache_size ? max_binlog_cache_size defaults to 18446744073709547520 Can it be more than available RAM ?
On Fri, Dec 30, 2016 at 9:55 AM, Reindl Harald <h.rei...@thelounge.net> wrote: > > > Am 30.12.2016 um 14:20 schrieb l vic: > >> and what should happen after reach it? >> a hard stop? >> Should use virt. memory/swap >> why don't you just configure your server to match your needs? >> I don't have control over the cluster and MariaDB instances share >> hardware with other services >> > > jesus christ fix your mail-client > > using virtual memory / swap is not the job of the application, it's the > job of the underlying operating system to swap out unused pages by LRU > algorithms - in most cases when your OS starts heavily swapping the game is > over and so you have to adjust the ressource consumation of your services > or just add physical memory > > "I don't have control over the cluster and MariaDB instances share" - when > you have no control at all you can't change anything, as long as you have > control of your "my.cnf" adjust caches and buffers as i told you that we > have mariadb instances which are consuming between 35 MB and many GB RAM - > depending on the size of the dataset, buffer-pool settings and so on > > > > On Wed, Dec 28, 2016 at 6:42 PM, Reindl Harald <h.rei...@thelounge.net >> <mailto:h.rei...@thelounge.net>> wrote: >> >> Am 28.12.2016 um 19:47 schrieb l vic: >> >> Is there some way to set hard limit for use of RAM by mariaDB >> server? >> >> >> and what should happen after reach it? >> a hard stop? >> >> why don't you just configure your server to match your needs? >> >> we have MariaDB instances between 35 MB and 10 GB RAM depending on >> the usecase - small instances with a small dataset don't need much >> caches and buffers, machine srunning dbmail need really large buffers >> > > _______________________________________________ > 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 >
_______________________________________________ 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
