My MySQL Configuration i currently use for Magento 2 development

my.cnf

    [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