美文网首页
Mysql配置

Mysql配置

作者: 丛轶群 | 来源:发表于2021-06-15 10:22 被阅读0次

    [client]

    #password = root

    port = 3306

    socket = /tmp/mysql.sock

    [mysqld]

    event_scheduler = on

    innodb_file_per_table = 1

    port = 3306

    socket = /tmp/mysql.sock

    datadir = /www/server/data

    default_storage_engine = InnoDB

    skip-external-locking

    key_buffer_size = 512M

    max_allowed_packet = 100G

    table_open_cache = 2048

    sort_buffer_size = 8M

    net_buffer_length = 4K

    read_buffer_size = 8M

    read_rnd_buffer_size = 256K

    myisam_sort_buffer_size = 128M

    thread_cache_size = 256

    query_cache_size = 256M

    tmp_table_size = 256M

    #skip-name-resolve

    max_connections = 500

    max_connect_errors = 100

    open_files_limit = 65535

    log-bin=mysql-bin

    binlog_format=mixed

    server-id = 1

    expire_logs_days = 3

    slow_query_log=1

    slow-query-log-file=/www/server/data/mysql-slow.log

    long_query_time=3

    #log_queries_not_using_indexes=on

    innodb_data_home_dir = /www/server/data

    innodb_data_file_path = ibdata1:10M:autoextend

    innodb_log_group_home_dir = /www/server/data

    innodb_buffer_pool_size = 2048M

    innodb_log_file_size = 1024M

    innodb_log_buffer_size = 256M

    innodb_flush_log_at_trx_commit = 1

    innodb_lock_wait_timeout = 50

    innodb_max_dirty_pages_pct = 90

    innodb_read_io_threads = 8

    innodb_write_io_threads = 8

    [mysqldump]

    quick

    max_allowed_packet = 500M

    [mysql]

    no-auto-rehash

    [myisamchk]

    key_buffer_size = 512M

    sort_buffer_size = 8M

    read_buffer = 2M

    write_buffer = 2M

    [mysqlhotcopy]

    interactive-timeout

    相关文章

      网友评论

          本文标题:Mysql配置

          本文链接:https://www.haomeiwen.com/subject/yzxzeltx.html