有关mysql的my.cnf文件优化

附件是我的 mycnf文件，但重启mysql的时候启动正常，但出现连续3行的提示错误，请看一下。谢谢

chown ：cannot access /etc/lib/myslq/r . no such file or directory

麻烦给看看。那里的问题。

我给大部分的东西都给注释了，但还是有问题。


[mysqld]
set-variable=max_connections=500
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

skip-networking
skip-innodb
skip-bdb
wait_timeout = 5
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

# [mysql]
# no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

# [isamchk]
# key_buffer = 256M
# sort_buffer_size = 256M
# read_buffer = 2M
# write_buffer = 2M

# [myisamchk]
# key_buffer = 256M
# sort_buffer_size = 256M
# read_buffer = 2M
# write_buffer = 2M

# [mysqlhotcopy]
# interactive-timeout

能说的再清楚点吗?哪三行错误啊...???

提示信息就是这样。我也不知道怎么描述。

chown ：cannot access /etc/lib/myslq/r . no such file or directory
看一下权限吧。

1. # Example MySQL config file for large systems.
   
2. #
   
3. # This is for a large system with memory = 512M where the system runs mainly
   
4. # MySQL.
   
5. #
   
6. # You can copy this file to
   
7. # /etc/my.cnf to set global options,
   
8. # mysql-data-dir/my.cnf to set server-specific options (in this
   
9. # installation this directory is /var/db/mysql) or
   
10. # ~/.my.cnf to set user-specific options.
    
11. #
    
12. # In this file, you can use all long options that a program supports.
    
13. # If you want to know which options a program supports, run the program
    
14. # with the "--help" option.
    
15. 
    
16. # The following options will be passed to all MySQL clients
    
17. 
    
18. [client]
    
19. #password        = your_password
    
20. port                = 3306
    
21. socket                = /tmp/mysql.sock
    
22. 
    
23. # Here follows entries for some specific programs
    
24. 
    
25. # The MySQL server
    
26. [mysqld]
    
27. port                = 3306
    
28. socket                = /tmp/mysql.sock
    
29. skip-locking
    
30. skip-innodb
    
31. skip-bdb
    
32. key_buffer = 512M
    
33. max_allowed_packet = 1M
    
34. table_cache = 512
    
35. sort_buffer_size = 2M
    
36. read_buffer_size = 2M
    
37. read_rnd_buffer_size = 4M
    
38. myisam_sort_buffer_size = 64M
    
39. thread_cache_size = 8
    
40. query_cache_size= 32M
    
41. wait_timeout = 5
    
42. skip-networking
    
43. max_connections=900
    
44. 
    
45. # Try number of CPU's*2 for thread_concurrency
    
46. thread_concurrency = 8
    
47. 
    
48. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
    
49. # if all processes that need to connect to mysqld run on the same host.
    
50. # All interaction with mysqld must be made via Unix sockets or named pipes.
    
51. # Note that using this option without enabling named pipes on Windows
    
52. # (via the "enable-named-pipe" option) will render mysqld useless!
    
53. #
    
54. #skip-networking
    
55. 
    
56. # Replication Master Server (default)
    
57. # binary logging is required for replication
    
58. #log-bin
    
59. 
    
60. # required unique id between 1 and 2^32 - 1
    
61. # defaults to 1 if master-host is not set
    
62. # but will not function as a master if omitted
    
63. 
    
64. server-id        = 1
    
65. 
    
66. # Replication Slave (comment out master section to use this)
    
67. #
    
68. # To configure this host as a replication slave, you can choose between
    
69. # two methods :
    
70. #
    
71. # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
    
72. #    the syntax is:
    
73. #
    
74. #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
    
75. #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
    
76. #
    
77. #    where you replace <host>, <user>, <password> by quoted strings and
    
78. #    <port> by the master's port number (3306 by default).
    
79. #
    
80. #    Example:
    
81. #
    
82. #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
    
83. #    MASTER_USER='joe', MASTER_PASSWORD='secret';
    
84. #
    
85. # OR
    
86. #
    
87. # 2) Set the variables below. However, in case you choose this method, then
    
88. #    start replication for the first time (even unsuccessfully, for example
    
89. #    if you mistyped the password in master-password and the slave fails to
    
90. #    connect), the slave will create a master.info file, and any later
    
91. #    change in this file to the variables' values below will be ignored and
    
92. #    overridden by the content of the master.info file, unless you shutdown
    
93. #    the slave server, delete master.info and restart the slaver server.
    
94. #    For that reason, you may want to leave the lines below untouched
    
95. #    (commented) and instead use CHANGE MASTER TO (see above)
    
96. #
    
97. # required unique id between 2 and 2^32 - 1
    
98. # (and different from the master)
    
99. # defaults to 2 if master-host is set
    
100. # but will not function as a slave if omitted
     
101. #server-id       = 2
     
102. #
     
103. # The replication master for this slave - required
     
104. #master-host     =   <hostname>
     
105. #
     
106. # The username the slave will use for authentication when connecting
     
107. # to the master - required
     
108. #master-user     =   <username>
     
109. #
     
110. # The password the slave will authenticate with when connecting to
     
111. # the master - required
     
112. #master-password =   <password>
     
113. #
     
114. # The port the master is listening on.
     
115. # optional - defaults to 3306
     
116. #master-port     =  <port>
     
117. #
     
118. # binary logging - not required for slaves, but recommended
     
119. #log-bin
     
120. 
     
121. # Point the following paths to different dedicated disks
     
122. tmpdir                = /tmp/               
     
123. #log-update         = /path-to-dedicated-directory/hostname
     
124. 
     
125. # Uncomment the following if you are using BDB tables
     
126. #bdb_cache_size = 64M
     
127. #bdb_max_lock = 100000
     
128. 
     
129. # Uncomment the following if you are using InnoDB tables
     
130. #innodb_data_home_dir = /var/db/mysql/
     
131. #innodb_data_file_path = ibdata1:10M:autoextend
     
132. #innodb_log_group_home_dir = /var/db/mysql/
     
133. #innodb_log_arch_dir = /var/db/mysql/
     
134. # You can set .._buffer_pool_size up to 50 - 80 %
     
135. # of RAM but beware of setting memory usage too high
     
136. #innodb_buffer_pool_size = 256M
     
137. #innodb_additional_mem_pool_size = 20M
     
138. # Set .._log_file_size to 25 % of buffer pool size
     
139. #innodb_log_file_size = 64M
     
140. #innodb_log_buffer_size = 8M
     
141. #innodb_flush_log_at_trx_commit = 1
     
142. #innodb_lock_wait_timeout = 50
     
143. 
     
144. [mysqldump]
     
145. quick
     
146. max_allowed_packet = 32M
     
147. 
     
148. [mysql]
     
149. no-auto-rehash
     
150. # Remove the next comment character if you are not familiar with SQL
     
151. #safe-updates
     
152. 
     
153. [isamchk]
     
154. key_buffer = 256M
     
155. sort_buffer_size = 256M
     
156. read_buffer = 2M
     
157. write_buffer = 2M
     
158. 
     
159. [myisamchk]
     
160. key_buffer = 256M
     
161. sort_buffer_size = 256M
     
162. read_buffer = 2M
     
163. write_buffer = 2M
     
164. 
     
165. [mysqlhotcopy]
     
166. interactive-timeout

复制代码

简洁，但是不想用。