sintret · August 1, 2023 03:39 · sintret · Aug 1, 2023 · sintret · Aug 1, 2023
diff --git a/my.ini b/my.ini
 # 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
	# 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