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@thelounge.net> wrote:
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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
