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 ------------------------------------------------------------------------ livelock's Profile: http://forums.slimdevices.com/member.php?userid=10284 View this thread: http://forums.slimdevices.com/showthread.php?t=32867 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
