scherepanov icon

my.cnf

scherepanov | PRO | 11/06/21 11:57:51 PM UTC | 0 ⭐ | 13380 👁️ | Never ⏰ | []
INI file |

0 B

|

None

|

0 👍

/

0 👎

[mysqld]
default-authentication-plugin = mysql_native_password
max_allowed_packet          = 512M
thread_stack                = 192K
thread_cache_size           = 8
interactive_timeout         = 300
wait_timeout                = 900
sort_buffer_size            = 16M
read_rnd_buffer_size        = 16M
read_buffer_size            = 16M
join_buffer_size            = 16M
key_buffer_size             = 256M
tmp_table_size              = 256M
max_heap_table_size         = 256M
#binlog_expire_logs_seconds = 3600
query_cache_type            = 1
query_cache_size            = 10M
query_cache_limit=256K      = 256K
 
innodb_doublewrite              = 0
innodb_file_per_table           = 1
innodb_thread_concurrency       = 8
innodb_lock_wait_timeout        = 300
innodb_log_files_in_group       = 2
innodb_log_file_size            = 512M
innodb_log_buffer_size          = 64M
innodb_flush_log_at_trx_commit  = 2
innodb_buffer_pool_size         = 512M
innodb_buffer_pool_instances    = 8
expire_logs_days                = 5
innodb_flush_method            = O_DIRECT
innodb_flush_log_at_trx_commit  = 1

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎