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

 


Did you like this article?


0 Shares:
You May Also Like

iriver’s UNIT2 detailed on teaser site

One of the sexist and functional MP3 devices I've seen yet. The iPod had its time, and even the smallest iPod is really sexy. But this is just over the top.
iriver's UNIT2 detailed on teaser site -

Filed under: , ,


Mmm, there's nothing like fragmented high-resolution photos of a lust-worthy device to get us salivating, and iriver's marketing department has done an exquisite job figuring that out. Shortly after unveiling the sexiest e-dictionary known to man, the much anticipated UNIT2 conglomerate received its own teaser site, complete with photos and a few extra details you should know. While it has yet to lose its mystique, we now know (officially, at least) that the base will act as a DVD player, TV tuner, access point, charging station, hard drive, and a speaker station. Aside from sporting an SD slot and USB connectivity, this beauty will handle music, movies, photos, eBooks, and WiFi streaming without breaking a sweat. Mechanically, you can expect an automatic sliding door, detachable display, slot-loaded CD / DVD deck, and a 78-key controller to manage the fun. No word yet on the price, but be sure to peek the additional photos below.

 

Read | Permalink | Email this | Comments


Office Depot Featured Gadget: Xbox 360 Platinum System Packs the power to bring games to life!

[EnGadget]

Selecting the Fastest Ubuntu 18 Mirror

Run the following commands. wget http://ftp.us.debian.org/debian/pool/main/n/netselect/netselect_0.3.ds1-28+b1_amd64.debdpkg -i netselect_0.3.ds1-28+b1_amd64.deb https://askubuntu.com/questions/39922/how-do-you-select-the-fastest-mirror-from-the-command-line Did you like this article?