← Back to team overview

maria-discuss team mailing list archive

Re: limiting memory use by mariadb?

 

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.reindl@xxxxxxxxxxxxx>
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.reindl@xxxxxxxxxxxxx
>> <mailto:h.reindl@xxxxxxxxxxxxx>> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References