java.sql.SQLException: Sort aborted

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

原创最新推荐文章于 2022-07-21 09:22:46 发布 · 2.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#buffer #thread #mysql #table #cache

sql 专栏收录该内容

22 篇文章

订阅专栏

本文介绍了解决MySQL启动时遇到的缓存配置问题，通过调整sort_buffer_size参数值从256K增加到32M，解决了数据库在启动过程中出现的sort aborted错误。

部署运行你感兴趣的模型镜像

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

您可能感兴趣的与本文相关的镜像