Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in AWS by (19.1k points)

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 the 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 the MySQL server?

Appreciate the help.

1 Answer

0 votes
by (44.4k points)

Go to your MySQL config file (my.cnf) and change this setting.

key_buffer              = 8M 

max_connections         = 30 # Limit connections

query_cache_size        = 8M # If not enough, try 4M

query_cache_limit       = 512K

thread_stack            = 128K

Related questions

Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...