MySQL (1038, ‘Out of sort memory, consider increasing server sort buffer size‘)
2023-09-14 09:14:20 时间
查看sort_buffer_size
show variables like '%sort_buffer_size%';
Variable_name Value
innodb_sort_buffer_size 1048576
myisam_sort_buffer_size 262144
sort_buffer_size 868352
解决方案
mysql> SET GLOBAL sort_buffer_size = 1024*1024; #等号后面要改的 选择自己需求的大小
相关文章
- Mysql:is not allowed to connect to this MySQL server
- 【Mysql】character-set-server参数
- 用Navicat连接mysql报错:2003-Can't connect to MySql server on '10.100.0.109'(10039)
- navicat异常 - 1130-host ... is not allowed to connect to this MySql server
- Mybatis+mysql动态分页查询数据案例——条件类(HouseCondition)
- Mysql: 强制走索引:mysql between 日期索引 索引问题-日期索引使用
- XtraBackup出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)--续
- Starting MySQL... ERROR! The server quit without updating PID file (/mydata/data/t1.pid).
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (
- Mysql:Error Code 1235,This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME 错误解决
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- piap.excel 微软 时间戳转换mssql sql server文件时间戳转换unix 导入mysql
- Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)
- 已解决pymysql.err.OperationalError:(2003 ”Can‘t cornect to MySQL server on ‘localhost‘ ([WinError 10061
- Mysql连接报错:1130-host ... is not allowed to connect to this MySql server如何处理
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server
- MySQL缺失mysql_config文件
- Django (2006, 'MySQL server has gone away') 本地重现与解决
- MySQL 报错:ERROR 1137 (HY000): Can't reopen table: 'tempId'
- MySQL远程连接报错2003-cant connection to mysql server on ‘IP’(10061 unknown error)
- Mysql安装多台mysql