← Back to team overview

maria-discuss team mailing list archive

Re: limiting memory use by mariadb?

 



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


Follow ups

References