my.cnf文件mysql的配置文件

以下是mysql配置文件my.cnf的配置过程

一 打开my.cnf 文件 命令为： vi  my.cnf

二 添加以下参数进去：

1> skip-external-locking

2> skip-name-resolve

3> big_tables

4> local_infile = 0                                

5> character-set-server=utf8

6>datadir=/usr/local/mysql/data/

7>basedir=usr/local/mysql/

8> table_cache=16

9> max_connections = 200

10> wait_timeout = 28800

11> interactive_timeout = 28800

12> thread_cache= 30

13> thread_concurrency= 2

14> tmpdir= /usr/local/mysql/tmp/

15> key_buffer = 16M

16> net_retry_count= 10

17> connect_timeout= 10

18> net_read_timeout= 30

19> query_cache_type= 0

20> query_cache_limit = 8MB

21> query_cache_min_res_unit = 4KB

22> query_cache_size = 56M

23> net_write_timeout= 30

24> group_concat_max_len = 999999999

25> interactive-timeout

26> bulk_insert_buffer_size = 2M

27> myisam_sort_buffer_size = 8M

28> read_rnd_buffer_size= 512K

29> join_buffer_size = 64M

30> max_heap_table_size= 20M

31> tmp_table_size= 20M

32> skip-slave-start

33>default-storage-engine = innodb

34> innodb_data_home_dir =

35>innodb_data_file_path=/usr/local/mysql/data/ibdata1:200M;/usr/local/mysql/data/ibdata2:200M:autoextend

36>innodb_log_group_home_dir = /usr/local/mysql/data/

37>innodb_buffer_pool_size=2056M

38>innodb_additional_mem_pool_size=16M

39>innodb_locks_unsafe_for_binlog=1

40>innodb_log_files_in_group = 2

41> innodb_log_file_size=256M

42> innodb_log_buffer_size=32M

43> innodb_flush_log_at_trx_commit=2

44> innodb_lock_wait_timeout=50

45> innodb_rollback_on_timeout

46> innodb_checksums=0

47> innodb_support_xa=0

48> innodb_doublewrite=0

49> innodb_thread_concurrency  = 10

50>innodb_concurrency_tickets  = 100

51> transaction-isolation = REPEATABLE-READ 

二 需要修改的参数有：

1> sort_buffer_size = 16M

2> key_buffer_size= 256M

3>write_buffer = 1M

4> server-id=  1016

5> read_buffer_size= 2M

6> socket= /usr/local/mysql/tmp/mysql.sock

三 需要删除的参数有：

skip-locking

table_open_cache

binlog_format=mixed

net_buffer_length