andyg;570884 Wrote:
> KISS is right. I've just added an option to the Performance settings
> page called "Database Memory Config". Currently this only works for
> MySQL and uses Moonbase's config which is listed below. I expect in
> the future we can also include some SQLite settings when this option is
> enabled, once we determine what the best settings are.
>
> >
Code:
--------------------
> >
>
> # $Id$
> #
> # Squeezebox Server specific MySQL Server config.
> # High-memory configuration by Moonbase
> # http://forums.slimdevices.com/showthread.php?t=60682
>
> [mysqld]
> innodb
> skip-locking
> long_query_time = 2
> log_slow_queries
>
> # If you want to have user permissions - you need to setup a valid user, and
> # remove this line below.
> skip-grant-tables
>
> basedir = [% basedir %]
> datadir = [% datadir %]
> tmpdir = [% datadir %]
> language = [% language %]
> port = [% port %]
> socket = [% socket %]
> pid-file = [% pidFile %]
> log-error = [% errorLog %]
> innodb_fast_shutdown = 1
> max_connections = 4
> thread_concurrency = 4
> log-warnings = 0
> bind-address = [% bindAddress %]
> default-character-set = utf8
> default-collation = utf8_general_ci
> key_buffer = 16M
> max_allowed_packet = 1M
> table_cache = 64
> sort_buffer_size = 512K
> net_buffer_length = 8K
> read_buffer_size = 256K
> read_rnd_buffer_size = 512K
>
> # InnoDB settings
> # You can set .._buffer_pool_size up to 50 - 80 %
> # of RAM but beware of setting memory usage too high
> innodb_buffer_pool_size = 32M
> 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
>
> [client]
> socket = [% socket %]
>
--------------------
> >
This is slightly different from Moonbase's final my.tt recommendations,
where he used key_buffer_size instead of key_buffer etc....
Code:
--------------------
# Some tweaks by Moonbase, recommended for systems with 1GB+ RAM
# key_buffer: cache index blocks for MyISAM, temp disc tables for InnoDB
key_buffer_size = 16M
# sort_buffer_size: improve ORDER BY and GROUP BY
sort_buffer_size = 2M
# join_buffer_size: improve full JOINs (non-indexed)
join_buffer_size = 2M
# read_buffer_size: don't adjust too high, just for full scans
read_buffer_size = 512K
# read_rnd_buffer_size: really improve ORDER BY
read_rnd_buffer_size = 2M
--------------------
Is there any reason for this?
--
agonynine
------------------------------------------------------------------------
agonynine's Profile: http://forums.slimdevices.com/member.php?userid=39887
View this thread: http://forums.slimdevices.com/showthread.php?t=70371
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
