Attachment 9631 Details for Bug 40851 – mysql.conf

mysql.conf

mysql.conf (text/plain), 3.15 KB, created by Sergey V Turchin on 2021-09-03 13:40:28 MSK

(hide)

Description:

Filename:

MIME Type:

Creator: Sergey V Turchin

Created: 2021-09-03 13:40:28 MSK

Size: 3.15 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]
>
># 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 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=16M
>
># # error log file name, relative to datadir (default:hostname.err)
>log_error=mysql.err
>
># print warnings and connection errors (default:1)
>loose_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))
>loose_query_cache_size=0
>
># Do not cache results (default:1)
>loose_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

Actions: View

Attachments on bug 40851: 9631 | 9632