D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
etc
/
Filename :
my.cnf
back
Copy
[mysql] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] user = mysql default-storage-engine = InnoDB socket = /var/lib/mysql/mysql.sock pid-file = /var/lib/mysql/mysql.pid key-buffer-size = 256M myisam-recover = FORCE,BACKUP max-allowed-packet = 256M max-connect-errors = 1000000 sql-mode = ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION sysdate-is-now = 1 innodb = FORCE innodb-strict-mode = 0 datadir = /var/lib/mysql tmpdir = /var/mysql_tmp tmp-table-size = 32M max-heap-table-size = 32M query-cache-type = 0 query-cache-size = 0 max-connections = 500 thread-cache-size = 10000 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 10240 max_sp_recursion_depth = 100 innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 128M innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 15561M log-error = /var/lib/mysql/mysql-error.log slow_query_log = 1 slow_query_log_file = /var/lib/mysql/mysql-slow.log tmp_table_size = 32M innodb_log_files_in_group = 2 innodb_old_blocks_time = 1000 myisam_recover = FORCE,BACKUP max_binlog_size = 100M max_heap_table_size = 32M innodb_strict_mode = 0 max_connect_errors = 1000000 innodb_buffer_pool_size = 15561M innodb_flush_method = O_DIRECT open_files_limit = 65535 max_allowed_packet = 25M log_error = /var/lib/mysql/mysql-error.log pid_file = /var/lib/mysql/mysql.pid max_connections = 512 default_storage_engine = InnoDB table_definition_cache = 4096 query_cache_type = 0 innodb_log_file_size = 128M sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION thread_stack = 192K bind_address = :: sysdate_is_now = 1 thread_cache_size = 10000 innodb_flush_log_at_trx_commit = 1 table_open_cache = 10240 innodb_io_capacity = 2000 innodb_file_per_table = 1 key_buffer_size = 256M