Hello, you can even resize your Droplet to next possible size, if it is under your budget.

Please see our tutorial on how to resize Droplets:

https://www.digitalocean.com/community/tutorials/how-to-resize-your-droplets-on-digitalocean

Please note that once you resize to a larger disk, you will no longer be able to resize to a smaller plan. This is because there will be a disk mismatch and we do not currently support shrinking a virtual server’s disk.

If you think, the MySQL is consuming more memory or CPU, you can follow the below steps:

It does look beneficial to optimize your MySQL instance. MySQL configuration is a good place to start. This can be complicated, but, there are some easier methods that can be taken to get pretty good results. There is a binary available in the package manager called mysqltuner.

You can install it using a command such as: For Ubuntu/Debian:sudo apt-get install mysqltunerFor CentOS/Fedora:sudo yum install mysqltuner

For more information concerning using mysqltuner, you will want to read into:

https://github.com/major/MySQLTuner-perl

This can be a bit involved, and not everything may be suited for your end-goals, so you might want to speak with a MySQL developer or admin regarding changes.

Another area to look into would be any slow queries running via MySQL. To find these, you would want to enable the MySQL slow query log.

You can do this by adding the following line(s) to your /etc/my.cnf file:

[mysqld]slow-query-log = 1slow-query-log-file = /var/log/mysql-slow.loglongquerytime = 2log-queries-not-using-indexes

After doing that, restart you will need to restart your MySQL service. By doing that, it tells MySQL to log all queries taking longer than 2 seconds to /var/log/mysql-slow.log.

It also tells it to log all queries running without indexes. This way, you can find the problematic queries, and work towards improving those. A good resourceon optimizingqueriesis: https://dev.mysql.com/doc/refman/5.7/en/using-explain.html

Usually, by going through those two areas you can make MySQL run more efficiently. It is also generally recommended you review your tables and queries to optimize them as much as is possible.

Some links to assist with that can be found at: https://www.digitalocean.com/community/tutorials/how-to-optimize-queries-and-tables-in-mysql-and-mariadb-on-a-vpshttp://20bits.com/article/10-tips-for-optimizing-mysql-queries-that-dont-suckhttps://dev.mysql.com/doc/refman/5.7/en/using-explain.html

Cheers,
Sri Charan