[Comm] low memory mysql setup (was: KDE-4.4 для 5.1)

[Michael Shigorin]

On Thu, Apr 22, 2010 at 04:25:51PM +0400, Sergey V Turchin wrote:
> Потребление пямяти несколько увеличилось из-за mysql

Кстати, ему аппетит можно и приубавить (attached).
Либо собрать отдельный левый микро-mysql и его заточить.

-- 
 ---- WBR, Michael Shigorin <mike на altlinux.ru>
  ------ Linux.Kiev http://www.linux.kiev.ua/
----------- следующая часть -----------
[mysqld]
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# FIXME! bdb maybe work on x86/Linux and amd64/Linux
#skip-bdb
#bind-address = 127.0.0.1 
chroot=/var/lib/mysql
datadir=/db
bdb-logdir=/log
#log=/log/queries
pid-file=/mysqld.pid
skip-locking
skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql

## http://paragasu.wordpress.com/2008/12/02/very-low-memory-mysql-5-mycnf-configuration/
# Set internal buffers, caches and stacks very low
key_buffer = 16K
max_allowed_packet = 800K
table_cache = 1
sort_buffer_size = 16K
read_buffer_size = 16K
read_rnd_buffer_size = 1K
net_buffer_length = 1K
thread_stack = 16K

# Skip Berkley and Inno DB types
skip-bdb
skip-innodb

skip-networking
server-id = 1

# Set the query cache low
query_cache_limit = 1048576
query_cache_size = 1048576
query_cache_type = 1

# Set various memory limits very low, disable memory-hogging extras
[mysqldump]
quick
max_allowed_packet = 16K

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 16K
sort_buffer_size = 16K

[myisamchk]
key_buffer = 16K
sort_buffer_size = 16K

[mysqlhotcopy]
interactive-timeout