2

I resized a digital ocean instance from 512mb to 16GB of ram, but my mysql only seems to use 1GB, even with hundreds of active users on the website (according to new relic).

What specific settings do I need to change to get the best performance from this larger instance?

Improve this question
2
  • 1
    Related: http://stackoverflow.com/questions/1178736/mysql-maximum-memory-usage Commented Aug 2, 2015 at 16:11
  • 1
    You might look in to replacing MySQL with MariaDB. It is a drop-in replacement that is a fork of MySQL, and is being developed by MySQL's original developers. Changeout is a snap, (actual drop-in replacement in every respect), and it has many performance and scalability improvements that MySQL does not. I've done this for 4 separate heavy-load implementations, and I've been very happy with it. You'll still want to look at Kenny's link, as many of the manual improvements still apply. Commented Aug 2, 2015 at 16:17
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.