mysql config for low memory vps

mysql_low.cnf

 [mysqld]
 # datadir = /var/lib/mysql
 max_connections = 100

 # wait_timeout = 180
 # connect_timeout = 180
 performance_schema = 0


 # Maximum allowed size for a single HEAP (in memory) table. This option
 # is a protection against the accidential creation of a very large HEAP
 # table which could otherwise use up all memory resources.
 max_heap_table_size = 32M
 key_buffer_size = 32M  ## 128M / 1G RAM

 # memory per connection
 sort_buffer_size = 2M
 read_buffer_size = 2M
 read_rnd_buffer_size = 2M
 join_buffer_size = 2M
 tmp_table_size = 16M

 # query cache
 query_cache_type = 1
 query_cache_size = 32M
 query_cache_limit = 512K

 innodb_additional_mem_pool_size = 8M
 innodb_autoextend_increment = 8M
 innodb_buffer_pool_instances = 1
 innodb_buffer_pool_size = 64M