我用的一台server进行插入报错 24G内存 4核CPU
程序抛出的异常为:java.sql.SQLException: Unexpected eof found when reading file '/home/tmp/MYvFQFtT' (Errcode: 0)
我查看mysql的日志,错误信息为:100221 10:03:53 [ERROR] /usr/libexec/mysqld: Sort aborted
对应的my.cnf配置如下:
character-set-server = utf8
key_buffer = 3072M
max_allowed_packet = 512M
table_cache = 1024
query_cache_size = 1024M
sort_buffer_size = 3072M
read_buffer_size = 1024M
read_rnd_buffer_size = 1024M
myisam_sort_buffer_size = 1024M
net_buffer_length = 128M
open_files_limit = 10240
tmp_table_size=1024M
max_tmp_tables=100
thread_stack =512M
join_buffer_size=1024M
max_connections = 250
max_user_connections = 200
wait_timeout = 259200
interactive_timeout= 259200
net_read_timeout = 500
net_write_timeout = 600
是不是和我的配置有关 以前这种操作是不会报错的。最近修改了几个参数后就开始报错,但是我改回去依旧是同样的情况