java.sql.SQLException: Sort aborted

最新推荐文章于 2022-07-21 09:22:46 发布

partner4java

最新推荐文章于 2022-07-21 09:22:46 发布

阅读量2k

点赞数

分类专栏： sql 文章标签： buffer thread mysql table cache

本文链接：https://blog.csdn.net/partner4java/article/details/7490756

版权

sql 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

java.sql.SQLException: Sort aborted:

it was a problem with the cache configuration of the mysql

increasing the buffer to a value like this (it was really low, like 256K before) makes the tables load normally on startup

code:
1:	sort_buffer_size = 32M

# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. It is allocated per thread so be careful with
# large settings.
sort_buffer_size=256K