← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB 10.1 uses huge amount of memory onWndows


My Windows installation does not have virtual memory as I turned it off (I
don't need it as I have sufficient physical memory not to have it). I have
now set InnoDB buffer size to 1G for MySQL 5.6  5.7 as well as Maria DB
10.0 and 10.1. That is more than enough for my needs. The MariaDB instances
now show total allocated memory ~2.5 G (5.5. and 10.0) and  ~1.5 G (10.1).
The MySQL instances ~1.5 G.

-- Peter

On Sat, Nov 22, 2014 at 11:33 AM, Reindl Harald <h.reindl@xxxxxxxxxxxxx>

> Am 22.11.2014 um 11:08 schrieb Peter Laursen:
>> On a side-remark (if someone is interested) the numbers displayed in
>> Task Manager for the VM running SuSE with MariaDB 10.0.9 must be
>> incorrect (ther is a full OS runnnig and with a lot of server programs -
>> LDAP, Apache etc. etc.).  It seems that Windows does not get true
>> information  from the VM process. Also when task manager displays 19-20
>> GB of memory use in total, Windows will start complaining that it is
>> about to run of of memory and programs should be closed  So it seems
>> that around 10 GB memory used by VMs are unaccounted for when it happens.
> windows has alsao the concept of virtual, shared and real memory and thes
> same problem as unix telling how how much an application is using because
> that mix
> the real problem of that thtead is that you *must not* compare two
> mysql/mariadb installations until you made 100% sure they are using the
> same buffer and cache configuration and have the same dataaset and uptime
> _______________________________________________
> 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

Attachment: 1g.jpg
Description: JPEG image

Follow ups