Search code examples
mysqlwindows-8xampp

XAMPP's MYSQL uses over 400MB of RAM

I just installed a fresh copy of latest XAMPP and started Apache and MySQL. Checked the task manager and by default empty MySQL with no databases running eats up over 400MB of ram out of nowhere while not in use and when idling. E.g. it's stuck at 421.6MB.

So, just was wondering if this is supposed to be like that? Running on Win8 x64 Pro.

Solution

  • It's just not normal, it uses that much ram for nothing.. same on my system, with a DB with 4 tables and about ~30 records.

    To significantly(!) lower the RAM usage, just add the following line to your config under 

    [mysqld]
table_definition_cache = 200

    that should do the trick

    (atleast it did for me, running XAMPP 1.8.3-2 MySQL 5.6.14)