Configuring MySQL for Low Memory VPS

I’ve found the following configuration helps when you’re trying to squeeze out as much memory from a VPS as possible.

 

[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

# For low memory, Berkeley DB should not be used so keep skip-bdb uncommented unless required
skip-bdb

# For low memory, InnoDB should not be used so keep skip-innodb uncommented unless required
skip-innodb

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

 

0 Shares:
You May Also Like

QuickPwn release removes the need to do an iTunes restore!

The iphone-dev.org has created a new means of Jail Breaking your iPhone that doesn't require the need to create a modified .ipsw and process a full restore through iTunes. Its called QuickPwn.
News is just out of a new way to jailbreak your iPhone, and this time the tool is specifically designed to work "quickly and easily, without requiring a full restore." Quickpwn has been released as a beta, intended to complement the main PwnageTool.

FOSS Advertising Network Ad Bard

Ad Bard is a free advertising community for FOSS oriented websites and advertisers. A snippet from their about page
The Ad Bard Network aims to foster a friendly and useful advertising community for FOSS oriented websites and advertisers. As a fellow Ad Bard, you will help to ensure that the advertisements in our network remain useful, relevant, and non-obnoxious. Ad Bard members earn 80% of the price-per-click each time an advertisement is clicked on your website. Our advertising community is entirely built with free and open source software, with all involved algorithms and schemas freely available for public scrutiny.
Definitely a neat and good way for FOSS websites to generate revenue aside from donations. Ad Bard Website