Not all of us has chance or money to play with a professional dedicated server or virtual private server (VPS) so a cheap plan with low memory (216 ~ 512 MBs) is a not bad plan in order to start building the business.
As a MySQL DBA or administrator of the server/vps, we should be aware of the MySQL performance to ensure it conserves as much as memory as possible. Below is an example of MySQL configuration file (usually located in /etc/my.cnf or /etc/mysql/my.cnf)
1 2 3 4 5 6 7 8 9 10 11 12 | [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 64K |
And if you don’t use the InnoDB storage engine feature, let disable it by adding the line below to the my.cnf. It will reduce significant your memory.
skip-innodb
Bonus: consider to know how to tune and optimize your MySQL performance with MySQLTuner
