Skip to content

Instantly share code, notes, and snippets.

@kayintveen
Created July 24, 2020 09:16
Show Gist options
  • Save kayintveen/516b7b66ca96a93113cc5828782e1e8d to your computer and use it in GitHub Desktop.
Save kayintveen/516b7b66ca96a93113cc5828782e1e8d to your computer and use it in GitHub Desktop.
My MySQL Configuration i currently use for Magento 2 development
[client]
user=root
password=root
host=localhost
[mysqld]
bind-address = 127.0.0.1
sql_mode="NO_ENGINE_SUBSTITUTION"
innodb_file_per_table=OFF
open_files_limit=999999
local_infile=ON
secure_file_priv=""
max_allowed_packet=1073741824
max_connections=100000
key_buffer_size=2G
innodb_buffer_pool_size=12G
query_cache_size=67108864
query_cache_type=1
query_cache_limit=4194304
table_open_cache=4096
innodb_buffer_pool_instances=24
innodb_sort_buffer_size=2G
sort_buffer_size=1G
innodb_flush_log_at_trx_commit=0
innodb_log_file_size=3G
interactive_timeout=3600
max_connect_errors=1000000
thread_cache_size=4096
[mysqld_safe]
open_files_limit=999999
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment