服务器my.cnf的配置如下:
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 key_buffer = 16M
31 max_allowed_packet = 1M
32 table_cache = 64
33 sort_buffer_size = 512K
34 net_buffer_length = 8K
35 read_buffer_size = 256K
36 read_rnd_buffer_size = 512K
37 myisam_sort_buffer_size = 8M
38
39 max_connections = 500
40
41 datadir = /opt/data/mysql
42
43 log-error = /opt/data/mysql/error.log
日志文件:
121 090624 08:23:50 mysqld started
122 InnoDB: No valid checkpoint found.
123 InnoDB: If this error appears when you are creating an InnoDB database,
124 InnoDB: the problem may be that during an earlier attempt you managed
125 InnoDB: to create the InnoDB data files, but log file creation failed.
126 InnoDB: If that is the case, please refer to
127 InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
128 090624 8:23:50 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
129 Version: '5.0.40' socket: '/tmp/mysql.sock' port: 3306 Source distribution