Hello, I have resized my droplet to have 2gb of ram as opposed to 1gb. My site keeps going offline because the SQL server is limited with computing size. How do I increase how much memory the SQL database can use on the droplet or would it be best to migrate the sql database to a managed database.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Mysql memory usage is limited by the mysql config.
MySQLTuner: https://github.com/major/MySQLTuner-perl is a good tool which will help you to understand mysql resource usage and even limit as you need.
While you could limit mysql resource usage with mysql config changes, that may not guarantee that your application work well with mysql resource constrains you to implement.
So along with limiting mysql resource usage, you may have to use an additional support solution like a cache(Eg: Memcached) to reduce mysql queries which will help to reduce mysql resource usage as well.
Hi shehethey,
SQL Server will take up all the ram assigned to it,whether it use or not.If you have sufficient money,it’s better to buy managed database.
I have met resolve page allocation failures due to insufficient memory when sufficient memory is available.In this condition,If you get the error message,
Disallowing page allocations for database '*\<databaseName>*' due to insufficient memory in the resource pool '*\<resourcePoolName>*'.
in the error log when the available physical memory is sufficient to allocate the page, it may be due to a disabled Resource Governor. When the Resource Governor is disabled MEMORYBROKER_FOR_RESERVEinduces artificial memory pressure.
To resolve this you need to enable the Resource Governor.To resolve this,maybe Microsoft’s docs can help you.Go to see this page
If this cannot help you,please commit a new work-ticket for DO team’s help.
Have a nice day.
Shiroka
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
