Raghav Raghav - 4 months ago 18
MySQL Question

Reducing memory consumption of mysql on ubuntu@aws micro instance

I have recently started on a PoC project.. wherein we are developing a small web app.
the initial setup is done on a micro instance from AWS. We are on rails+mysql stack.

after installing/running mysql, i see that about 500+ MB RAM has been consumed already. leaving quite less for rest of the systems (micro instances have barely 620 MB RAM)

Our app is fairly simple at this stage.. Can I do something to reduce the memory consumed by mysql server ??

appreciate help.

Answer

Try to Change this setting in mysql configuration file (my.cnf)

key_buffer              = 8M 
max_connections         = 30 # Limit connections
query_cache_size        = 8M # try 4m if not enough 
query_cache_limit       = 512K
thread_stack            = 128K

Hope that heps !