MYSQL日志报错，在线等高手指点

lyxls

FreeBSD 6.2 + apache-2.0.59+php5-5.2.3_1+mysql-server-5.0.45

mysql.cnf配置：

1. [mysqld]
   
2. bind-address    = 127.0.0.1
   
3. port            = 3306
   
4. socket          = /tmp/mysql.sock
   
5. skip-locking
   
6. skip-innodb
   
7. skip-bdb
   
8. skip-name-resolve
   
9. 
   
10. set-variable = key_buffer=768M
    
11. set-variable = max_allowed_packet=4M
    
12. set-variable = table_cache=2048
    
13. set-variable = thread_cache=64
    
14. set-variable = join_buffer_size=32M
    
15. set-variable = sort_buffer=4M
    
16. set-variable = record_buffer=32M
    
17. set-variable = max_connections=200
    
18. set-variable = wait_timeout=120
    
19. set-variable = interactive_timeout=120
    
20. set-variable = max_connect_errors=50000
    
21. set-variable = long_query_time=1
    
22. set-variable = max_heap_table_size=256M
    
23. set-variable = tmp_table_size=128M
    
24. #set-variable = tmp_table_size=512M
    
25. set-variable = thread_concurrency=4
    
26. set-variable = myisam_sort_buffer_size=128M
    
27. query_cache_size = 32M

复制代码

MYSQL日志报错：

1. 070829 12:39:37 [Note] /usr/local/libexec/mysqld: ready for connections.
   
2. Version: '5.0.45-log'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.0.45
   
3. 070829 12:42:38 [ERROR] /usr/local/libexec/mysqld: Got error 12 from storage engine
   
4. 070829 12:42:38 [ERROR] /usr/local/libexec/mysqld: Sort aborted
   
5. 070829 12:47:39 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 22960 bytes)
   
6. 070829 12:52:39 [ERROR] /usr/local/libexec/mysqld: Got error 12 from storage engine
   
7. 070829 12:52:39 [ERROR] /usr/local/libexec/mysqld: Sort aborted

复制代码

[ 本帖最后由 lyxls 于 2007-8-29 13:11 编辑 ]

yejr

perror 12
OS error code  12:  Not enough space

问题很明显

lyxls

原来是my.cnf优化得过头了，用自带的large或huge就没问题了，似乎这些参数有关联，不能乱调的