mysql5.5.6配置文件_参照MySQL 5.5配置文件修改MySQL 5.6配置文件

MySQL> status;

--------------

mysql  Ver 14.14 Distrib 5.6.10, for Linux (i686) using  EditLine wrapper

Connection id:  1

Current database:

Current user:  root@localhost

SSL:    Not in use

Current pager:  stdout

Using outfile:  ''

Using delimiter:  ;

Server version:  5.6.10 Source distribution

Protocol version:  10

Connection:  Localhost via UNIX socket

Server characterset:  utf8

Db    characterset:  utf8

Client characterset:  utf8

Conn.  characterset:  utf8

UNIX socket:  /tmp/mysql.sock

Uptime:    5 sec

Threads: 1  Questions: 5  Slow queries: 0  Opens: 67  Flush tables: 1  Open tables: 60  Queries per second avg: 1.000

--------------

mysql>

其他配置项更改大体可以参照mysql5.5配置项修改

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

key_buffer_size=16M

max_allowed_packet=8M

innodb_buffer_pool_size = 2G

skip-name-resolve

back_log = 50

max_connections = 1000

max_connect_errors = 100

table_open_cache = 2048

binlog_cache_size = 1M

max_heap_table_size = 64M

read_buffer_size = 2M

read_rnd_buffer_size = 16M

thread_cache_size = 8

thread_concurrency = 8

query_cache_size = 64M

query_cache_limit = 2M

ft_min_word_len = 4

thread_stack = 192K

tmp_table_size = 64M

binlog_format=mixed

innodb_additional_mem_pool_size = 16M

innodb_write_io_threads = 8

innodb_read_io_threads = 4

innodb_thread_concurrency = 16

innodb_flush_log_at_trx_commit = 1

innodb_log_buffer_size = 8M

innodb_log_file_size = 256M

innodb_log_files_in_group = 3

innodb_max_dirty_pages_pct = 90

innodb_lock_wait_timeout = 30

其中innodb_read_io_threads 改成6或者8都不能正常启动改成4可以。

innodb_lock_wait_timeout使用默认的120不能正常启动