Jump to content
  • 0

MySQL Init


Powell

Question

1 answer to this question

Recommended Posts

  • 0
[mysqld]
skip-name-resolve
datadir=C:/Program Files/MariaDB 10.0/data
port=xxxx
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
key_buffer = 16M
max_allowed_packet = 2M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 128M
log_error = "mysql_error.log"
table_cache = 64
thread_cache = 16
query_cache_size = 64M
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 32M
innodb_log_file_size = 256M
innodb_log_buffer_size = 10M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
[client]
port=xxxx

mine is also on an SSD

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
  • Discord

×
×
  • Create New...