Simple to solve mysql occupy too much resources

In Linux, the situation is often used VBB forum system, there slow, mysql suspended animation, sleep process too much and so on. Lead to dozens of users, put the system buttoned up.
In fact, this is the mysql configuration issues, the default linux, mysql configuration is my-large.cnf configuration, the configuration for large servers. A high memory, such as 2G, 4G memory, suitable for use, while the general 512M memory will not work. It will occupy 512M memory to save the system mysql process, these processes long-term heap quality, does not release, resulting in a slow system. So, the configuration changed to my-small.cnf, small configuration on it. Its configuration is as follows:
# Example mysql config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld deamon
# does not use much resources.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir / my.cnf to set server-specific options (in this
# installation this directory is / var / lib / mysql) or
# ~ / .my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.
# The following options will be passed to all MySQL clients
[client]
#password = your password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer = 16K
set-variable = max_allowed_packet = 1M
set-variable = thread_stack = 64K
set-variable = table_cache = 4
set-variable = sort_buffer = 64K
set-variable = net_buffer_length = 2K
server-id = 1
# Uncomment the following if you want to log updates
# log-bin
# Uncomment the following if you are NOT using BDB tables
# skip-bdb
# 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
# set-variable = innodb_buffer_pool_size = 16M
# set-variable = innodb_additional_mem_pool_size = 2M
# Set .._ log_file_size to 25% of buffer pool size
# set-variable = innodb_log_file_size = 5M
# set-variable = innodb_log_buffer_size = 8M
# innodb_flush_log_at_trx_commit = 1
# set-variable = innodb_lock_wait_timeout = 50
[mysqldump]
quick
set-variable = max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
# safe-updates
[isamchk]
set-variable = key_buffer = 8M
set-variable = sort_buffer = 8M
[myisamchk]
set-variable = key_buffer = 8M
set-variable = sort_buffer = 8M
[mysqlhotcopy]
interactive-timeout
The above configuration is enough for your system running at high speed mysql, sleep process, was quickly recovered, does not take up resources, which is very suitable for small servers. The general personal hosting server is also very suitable.