| 4 |
- |
1 |
#
|
|
|
2 |
# Global Akonadi MySQL server settings,
|
|
|
3 |
# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
|
|
|
4 |
#
|
|
|
5 |
# Based on advice by Kris Köhntopp <kris@mysql.com>
|
|
|
6 |
#
|
|
|
7 |
[mysqld]
|
|
|
8 |
skip_grant_tables
|
|
|
9 |
skip_networking
|
|
|
10 |
|
|
|
11 |
# strict query parsing/interpretation
|
|
|
12 |
# TODO: make Akonadi work with those settings enabled
|
|
|
13 |
#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
|
|
|
14 |
#sql_mode=strict_trans_tables
|
|
|
15 |
|
|
|
16 |
# use InnoDB for transactions and better crash recovery
|
|
|
17 |
default_storage_engine=innodb
|
|
|
18 |
# case-insensitive table names, avoids trouble on windows
|
|
|
19 |
lower_case_table_names=1
|
|
|
20 |
character_set_server=latin1
|
|
|
21 |
collation_server=latin1_general_ci
|
|
|
22 |
table_cache=200
|
|
|
23 |
thread_cache_size=3
|
|
|
24 |
log_bin=mysql-bin
|
|
|
25 |
expire_logs_days=3
|
|
|
26 |
#sync_bin_log=0
|
|
|
27 |
# error log file name, relative to datadir
|
|
|
28 |
log_error=mysql.err
|
|
|
29 |
log_warnings=2
|
|
|
30 |
# log all queries, useful for debugging but generates an enormous amount of data
|
|
|
31 |
#log=mysql.full
|
|
|
32 |
# log queries slower than n seconds, log file name relative to datadir
|
|
|
33 |
log_slow_queries=mysql.slow
|
|
|
34 |
long_query_time=1
|
|
|
35 |
# log queries not using indices, debug only, disable for production use
|
|
|
36 |
log_queries_not_using_indexes=1
|
|
|
37 |
# maximum blob size
|
|
|
38 |
max_allowed_packet=32M
|
|
|
39 |
max_connections=256
|
|
|
40 |
# makes sense when having the same query multiple times
|
|
|
41 |
# makes no sense with prepared statements and/or transactions
|
|
|
42 |
query_cache_type=0
|
|
|
43 |
query_cache_size=0
|
|
|
44 |
|
|
|
45 |
innodb_file_per_table=1
|
|
|
46 |
innodb_log_buffer_size=1M
|
|
|
47 |
innodb_additional_mem_pool_size=1M
|
|
|
48 |
# messure database size and adjust
|
|
|
49 |
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
|
|
|
50 |
innodb_buffer_pool_size=80M
|
|
|
51 |
# 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)
|
|
|
52 |
innodb_log_file_size=8M
|
|
|
53 |
innodb_flush_log_at_trx_commit=2
|
|
|
54 |
|