From 61c0d64fea84b88d45641aad65f0aaa4b5868836 Mon Sep 17 00:00:00 2001 From: Frank Brehm Date: Wed, 6 Sep 2017 07:29:13 +0200 Subject: [PATCH] committing changes in /etc after emerge run Package changes: +kde-apps/akonadi-17.04.3-r1 --- xdg/akonadi.categories | 7 ++ xdg/akonadi.renamecategories | 7 ++ xdg/akonadi/mysql-global-mobile.conf | 104 +++++++++++++++++++++++++++ xdg/akonadi/mysql-global.conf | 104 +++++++++++++++++++++++++++ 4 files changed, 222 insertions(+) create mode 100644 xdg/akonadi.categories create mode 100644 xdg/akonadi.renamecategories create mode 100644 xdg/akonadi/mysql-global-mobile.conf create mode 100644 xdg/akonadi/mysql-global.conf diff --git a/xdg/akonadi.categories b/xdg/akonadi.categories new file mode 100644 index 00000000..64c6e17d --- /dev/null +++ b/xdg/akonadi.categories @@ -0,0 +1,7 @@ +org.kde.pim.akonadiagentserver akonadi (Akonadi Agent Server) +org.kde.pim.akonadiserver akonadi (Akonadi Server) +org.kde.pim.akonadiagentbase akonadi (Akonadi AgentBase Library) +org.kde.pim.akonadiwidgets akonadi (Akonadi Widget Library) +org.kde.pim.akonadiprivate akonadi (Akonadi Private Library) +org.kde.pim.akonadicore akonadi (Akonadi Core Library) +org.kde.pim.akonadictl akonadi (Akonadi Control) diff --git a/xdg/akonadi.renamecategories b/xdg/akonadi.renamecategories new file mode 100644 index 00000000..ebab8587 --- /dev/null +++ b/xdg/akonadi.renamecategories @@ -0,0 +1,7 @@ +log_akonadiagentserver org.kde.pim.akonadiagentserver +log_akonadiserver org.kde.pim.akonadiserver +akonadiagentbase_log org.kde.pim.akonadiagentbase +akonadiwidgets_log org.kde.pim.akonadiwidgets +akonadiprivate_log org.kde.pim.akonadiprivate +log_akonadicore org.kde.pim.akonadicore +log_akonadictl org.kde.pim.akonadictl diff --git a/xdg/akonadi/mysql-global-mobile.conf b/xdg/akonadi/mysql-global-mobile.conf new file mode 100644 index 00000000..bdaa6e2d --- /dev/null +++ b/xdg/akonadi/mysql-global-mobile.conf @@ -0,0 +1,104 @@ +# +# Global Akonadi MySQL server settings, +# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf +# +# Based on advice by Kris Köhntopp +# +[mysqld] + +# 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 + +# DEBUGGING: +# 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 +# +# mesure database size and adjust innodb_buffer_pool_size +# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema"); + +# NOTES: +# Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables) + +#expire_logs_days=3 + +#sync_bin_log=0 + +# Use UTF-8 encoding for tables +character_set_server=utf8 +collation_server=utf8_general_ci + +# use InnoDB for transactions and better crash recovery +default_storage_engine=innodb + +# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:1M) +# Deprecated in MySQL >= 5.6.3 +innodb_additional_mem_pool_size=1M + +# memory buffer InnoDB uses to cache data and indexes of its tables (default:128M) +# Larger values means less I/O +innodb_buffer_pool_size=8M + +# Create a .ibd file for each table (default:0) +innodb_file_per_table=1 + +# Write out the log buffer to the log file at each commit (default:1) +innodb_flush_log_at_trx_commit=2 + +# Buffer size used to write to the log files on disk (default:1M for builtin, 8M for plugin) +# larger values means less I/O +innodb_log_buffer_size=1M + +# Size of each log file in a log group (default:5M) larger means less I/O but more time for recovery. +innodb_log_file_size=2M + +# # error log file name, relative to datadir (default:hostname.err) +log_error=mysql.err + +# print warnings and connection errors (default:1) +log_warnings=2 + +# Convert table named to lowercase +lower_case_table_names=1 + +# Maximum size of one packet or any generated/intermediate string. (default:1M) +max_allowed_packet=32M + +# Maximum simultaneous connections allowed (default:100) +max_connections=256 + +# The two options below make no sense with prepared statements and/or transactions +# (make sense when having the same query multiple times) + +# Memory allocated for caching query results (default:0 (disabled)) +query_cache_size=0 + +# Do not cache results (default:1) +query_cache_type=0 + +# Do not use the privileges mechanisms +skip_grant_tables + +# Do not listen for TCP/IP connections at all +skip_networking + +# The number of open tables for all threads. (default:64) +table_open_cache=200 + +# How many threads the server should cache for reuse (default:0) +thread_cache_size=3 + +# wait 365d before dropping the DB connection (default:8h) +wait_timeout=31536000 + +# We use InnoDB, so don't let MyISAM eat up memory +key_buffer_size=16K + +[client] +default-character-set=utf8 diff --git a/xdg/akonadi/mysql-global.conf b/xdg/akonadi/mysql-global.conf new file mode 100644 index 00000000..ab4a4a1e --- /dev/null +++ b/xdg/akonadi/mysql-global.conf @@ -0,0 +1,104 @@ +# +# Global Akonadi MySQL server settings, +# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf +# +# Based on advice by Kris Köhntopp +# +[mysqld] + +# 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 + +# DEBUGGING: +# 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 +# +# mesure database size and adjust innodb_buffer_pool_size +# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema"); + +# NOTES: +# Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables) + +#expire_logs_days=3 + +#sync_bin_log=0 + +# Use UTF-8 encoding for tables +character_set_server=utf8 +collation_server=utf8_general_ci + +# use InnoDB for transactions and better crash recovery +default_storage_engine=innodb + +# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:8M) +# Deprecated in MySQL >= 5.6.3, removed in 5.7 (works in MariaDB) +# innodb_additional_mem_pool_size=8M + +# memory buffer InnoDB uses to cache data and indexes of its tables (default:128M) +# Larger values means less I/O +innodb_buffer_pool_size=128M + +# Create a .ibd file for each table (default:0) +innodb_file_per_table=1 + +# Write out the log buffer to the log file at each commit (default:1) +innodb_flush_log_at_trx_commit=2 + +# Buffer size used to write to the log files on disk (default:1M for builtin, 8M for plugin) +# larger values means less I/O +innodb_log_buffer_size=1M + +# Size of each log file in a log group (default:5M) larger means less I/O but more time for recovery. +innodb_log_file_size=64M + +# # error log file name, relative to datadir (default:hostname.err) +log_error=mysql.err + +# print warnings and connection errors (default:1) +log_warnings=2 + +# Convert table named to lowercase +lower_case_table_names=1 + +# Maximum size of one packet or any generated/intermediate string. (default:1M) +max_allowed_packet=32M + +# Maximum simultaneous connections allowed (default:100) +max_connections=256 + +# The two options below make no sense with prepared statements and/or transactions +# (make sense when having the same query multiple times) + +# Memory allocated for caching query results (default:0 (disabled)) +query_cache_size=0 + +# Do not cache results (default:1) +query_cache_type=0 + +# Do not use the privileges mechanisms +skip_grant_tables + +# Do not listen for TCP/IP connections at all +skip_networking + +# The number of open tables for all threads. (default:64) +table_open_cache=200 + +# How many threads the server should cache for reuse (default:0) +thread_cache_size=3 + +# wait 365d before dropping the DB connection (default:8h) +wait_timeout=31536000 + +# We use InnoDB, so don't let MyISAM eat up memory +key_buffer_size=16K + +[client] +default-character-set=utf8 -- 2.39.5