CODEWITHSUNDEEP
mysql
Peter
Peter

Reputation: 2260

How can I reduce Xampp mysqld memory usage

Well i've set myself to learn php and mysql, bought a book installed XAMPP inside a virtual machine. However i was thinking mysql wouldnt use that much memory, but it uses 500Mb. And i have not even created anything in it, i'm not sure if thats normal. I had choosen the Xampp light setup, since my only interest here is Php and mysql.

My goal is just to create a few simple databases with a web interface. And i'm at the first steps of learning php I'm not new to programming, i know a long list of computer languages However i am new to mysql and php appache.

Can someone tell me what to do to reduce memory of mysql ?. As currently i run into problems, the host running the virtual machine is not that heavy

Upvotes: 0

Views: 5923

Answers (3)

huvo
huvo

Reputation: 1

mysql in xampp 400mb cpu

You add in php.ini two line end :

[mysqld]

table_definition_cache = 400

I sure with you :) .

Upvotes: 0

Daniel W.
Daniel W.

Reputation: 32340

I think this is a bug in the (windows) installer of MySQL which could be also used in xampp.

http://bugs.mysql.com/bug.php?id=68287

Try looking for table_definition_cache in my.cnf and lower this to ~ 200

Upvotes: 1

Redaa
Redaa

Reputation: 1590

If you're not storing anything in it as you said, then the 500MB isn't for the 'MYSQL' process but it's for the whole XAMPP thing.

Long story short, this is the Mysql configuration file path :

/etc/mysql/my.cnf

in this file you can find : 

key_buffer              = 8M
max_connections         = 30
query_cache_size        = 8M
query_cache_limit       = 512K
thread_stack            = 128K

This is the MAXIMUM memory the Mysql is using.

Hope this helps.

Upvotes: 0

Related Questions