Skip to content

Instantly share code, notes, and snippets.

@sintret
Last active August 1, 2023 03:39
Show Gist options
  • Save sintret/e75ab36c78dbe8efda1afba37e5a3798 to your computer and use it in GitHub Desktop.
Save sintret/e75ab36c78dbe8efda1afba37e5a3798 to your computer and use it in GitHub Desktop.
# Example MariaDB config file for large systems.
#
# This is for a large system with memory = 512M where the system runs mainly
# MariaDB.
#
# MariaDB programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, do:
# 'my_print_defaults --help' and see what is printed under
# Default options are read from the following files in the given order:
# More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MariaDB clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MariaDB server
[mysqld]
datadir=C:/Program Files/MariaDB 10.10/data
port=3306
key_buffer_size = 512M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
innodb_buffer_pool_size = 4096M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 1024M
innodb_log_buffer_size = 128M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_page_size=64k
[client]
port=3306
plugin-dir=C:\Program Files\MariaDB 10.10/lib/plugin
[mariadb]
log_error=mariadb.err
@sintret
Copy link
Author

sintret commented Aug 1, 2023

Solution ...

[mysqld]
datadir=C:/Program Files/MariaDB 11.0/data
port=3306
innodb_buffer_pool_size=2033M
max_allowed_packet = 256M
innodb_log_file_size = 512M

innodb_strict_mode = 0
[client]
port=3306
plugin-dir=C:\Program Files\MariaDB 11.0/lib/plugin

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment