Posts in category: Server

By default, standard MySQL configurations presume the hosting machine having at least 8GB RAM. If the MySQL hosting machine having RAM lower than 8GB, the MySQL configuration parameters must be adjust to prevent memory over use; otherwise, the MySQL service will go down or be crashed from time to time. Please refer to the following sample settings for /etc/mysql/my.cnf for a VPS machine only having 1GB memory.

$ cat /etc/mysql/my.cnf
 #
 The MySQL database server configuration file.
 #
 You can copy this to one of:
 - "/etc/mysql/my.cnf" to set global options,
 - "~/.my.cnf" to set user-specific options.
  
 One can use all long options that the program supports.
 Run program with --help to get a list of available options and with
 --print-defaults to see which it would actually understand and use.
 #
 For explanations see
 http://dev.mysql.com/doc/mysql/en/server-system-variables.html
 #
 * IMPORTANT: Additional settings that can override those from this file!
 The files must end with '.cnf', otherwise they'll be ignored.
 #
 [mysqld]
 innodb_buffer_pool_size=5M
 innodb_log_buffer_size=256K
 query_cache_size=0
 max_connections=10
 key_buffer_size=1M
 thread_cache_size=0
 host_cache_size=0
 innodb_ft_cache_size=1600000
 innodb_ft_total_cache_size=32000000
 per thread or per operation settings
 thread_stack=131072
 sort_buffer_size=32K
 read_buffer_size=8K
 read_rnd_buffer_size=8K
 max_heap_table_size=16K
 tmp_table_size=1K
 bulk_insert_buffer_size=0
 join_buffer_size=128
 net_buffer_length=1K
 innodb_sort_buffer_size=64K
 settings that relate to the binary log (if enabled)
 binlog_cache_size=4K
 binlog_stmt_cache_size=4K
 !includedir /etc/mysql/conf.d/
 !includedir /etc/mysql/mysql.conf.d/