Attachment 4348 Details for Bug 23336 – mysql-global.conf

mysql-global.conf

mysql-global.conf (text/plain), 1.98 KB, created by Sergey V Turchin on 2010-04-14 18:44:44 MSD

(hide)

Description:

Filename:

MIME Type:

Creator: Sergey V Turchin

Created: 2010-04-14 18:44:44 MSD

Size: 1.98 KB

patch

obsolete

>#
># Global Akonadi MySQL server settings,
># These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
>#
># Based on advice by Kris KÃ¶hntopp <kris@mysql.com>
>#
>[mysqld]
>skip_grant_tables
>skip_networking
>
># strict query parsing/interpretation
># TODO: make Akonadi work with those settings enabled
>#sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
>#sql_mode=strict_trans_tables
>
># use InnoDB for transactions and better crash recovery
>default_storage_engine=innodb
># case-insensitive table names, avoids trouble on windows
>lower_case_table_names=1
>character_set_server=latin1
>collation_server=latin1_general_ci
>table_cache=200
>thread_cache_size=3
>log_bin=mysql-bin
>expire_logs_days=3
>#sync_bin_log=0
># error log file name, relative to datadir
>log_error=mysql.err
>log_warnings=2
># log all queries, useful for debugging but generates an enormous amount of data
>#log=mysql.full
># log queries slower than n seconds, log file name relative to datadir (for debugging only)
>#log_slow_queries=mysql.slow
>#long_query_time=1
># log queries not using indices, debug only, disable for production use
>#log_queries_not_using_indexes=1
># maximum blob size
>max_allowed_packet=32M
>max_connections=256
># makes sense when having the same query multiple times
># makes no sense with prepared statements and/or transactions
>query_cache_type=0
>query_cache_size=0
>
>innodb_file_per_table=1
>innodb_log_buffer_size=1M
>innodb_additional_mem_pool_size=1M
># messure database size and adjust
># SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
>innodb_buffer_pool_size=80M
># size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
>innodb_log_file_size=8M
>innodb_flush_log_at_trx_commit=2
>

Actions: View

Attachments on bug 23336: 4348