PDA

View Full Version : mysql configuration for slimserver on linkstation pro



livelock
2007-02-18, 08:29
I got a linkstation pro with 128MB and 400MHz ARM processor, what is the optimum configuration for mysql in order to give slimserver enough ressources? my current config is:

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
innodb
old_passwords = false # inserted by debconf
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
#skip-external-locking
skip-locking

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
skip-networking
#
# * Fine Tuning
#
key_buffer = 2M
max_allowed_packet = 1M
thread_stack = 128K
thread_cache_size = 3
innodb_fast_shutdown = 1
max_connections = 3
thread_concurrency = 3
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K

query_cache_limit = 1048576
query_cache_size = 16777216
query_cache_type = 1
#
log_bin = /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days = 10
max_binlog_size = 100M

skip-bdb
#skip-innodb

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[isamchk]
key_buffer = 16M

livelock
2007-02-18, 08:50
by setting skip-innodb I save more than 10MB RAM, why do we need ACID compliants transactions with slimserver?

livelock
2007-02-18, 09:11
ok, this did not work, I am getting a lot of errors now - but Mysql did not die

2007-02-18 16:02:09.4897 Select task failed: Carp::Clan::__ANON__(): Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.moodlogic_id, contributor.moodlogic_mixable, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 771.

livelock
2007-02-18, 11:13
Ok, mysql does die. I am stuck, I tried all kinds of settings, but mysqld dies all the time. in slimserver.log you see how often it happens

I am stuck here, maybe I try installing mysql 4.1 :(

livelock
2007-03-04, 15:10
I did it, the key issue was replacing mysql with a self-compiled binary (5.0.36)