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

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?
Read More

QuickPwn Release Allows Fast Jailbreak Of iPhone Firmware Update 2.0.2

That's right, hot off the blog presses QuickPwn has been updated by the iphone-dev.org team and now allows you to Jailbreak your iPhones 2.0.2 firmware. The new 2.0.2 firmware that was released on Monday supposedly fixes some "bugs", however the bugs aren't mentioned anywhere.
Here is the updated QuickPwn for Windows, wrapped by Poorlad’s GUI. It contains our new bundles for 2.0.2 and we’ve added support for version 2.0 devices which means you can QuickPwn and jailbreak the device if it is running 2.0, 2.0.1 or 2.0.2. Remember this is still beta software, so usual rules apply, no complaints ifanything goes wrong and use the tool at at your own risk! Download here! SHA1 = 8e1ed2ce9e7e473d38a9dc7824a384a9ac34d7d0

Read the full article at blog.iphone-dev.org
Download the new QuickPwn 1.2.0 with the new 2.0.2 bundle.

Thanks for another successful Jailbreak!
Read More