当前位置:网站首页>错误代码: 1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current
错误代码: 1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current
2022-08-11 09:34:00 【qykhhr】
修改 my.ini 文件为文后内容
根据自己 MySQL 安装目录来设置
basedir=“D:/mysql-5.7.38-winx64/”
datadir=“D:/mysql-5.7.38-winx64/data/”
关闭严格模式
innodb_strict_mode=0
日期相关的配置
sql_mode=NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
导入完成后再给这两个配置注释掉
[mysqld]
innodb_strict_mode=0
sql_mode=NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
basedir="D:/mysql-5.7.38-winx64/"
datadir="D:/mysql-5.7.38-winx64/data/"
port=3306
max_allowed_packet = 5000M
key_buffer_size= 3840M
sort_buffer_size = 32M
read_buffer_size = 32M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 256M
thread_cache_size = 32
query_cache_size = 256M
interactive_timeout=1814400
wait_timeout=1814400
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
边栏推荐
- 如何在移动钱包中搭建一个小程序应用商店
- 基于卷积的神经网络系统,卷积神经网络毕业论文
- 谁能解答?从mysql的binlog读取数据到kafka,但是数据类型有Insert,updata,
- 1.3版本自定义TrainOneStepCell报错
- Typora and basic Markdown syntax
- Data middle platform program analysis and development direction
- Segmentation Learning (loss and Evaluation)
- WordpressCMS主题开发01-首页制作
- Primavera Unifier -AEM 表单设计器要点
- Simple strokes on the Internet
猜你喜欢
保证金监控中心保证期货开户和交易记录
【剑指offer】左旋字符串,替换空格,还有类题!!!
基于 VIVADO 的 AM 调制解调(3)仿真验证
Software custom development - the advantages of enterprise custom development of app software
深度神经网络与人脑神经网络哪些区域有一定联系?
Audio and video + AI, Zhongguancun Kejin helps a bank explore a new development path | Case study
Contrastive Learning Series (3)-----SimCLR
前几天,小灰去贵州了
分割学习(loss and Evaluation)
WordpressCMS主题开发02-制作顶部header.php和footer.php
随机推荐
基于PSO在满足可靠性的基础上实现费用最优MATLAB仿真(含完整matlab代码)
collect awr
淘宝/天猫获得淘宝app商品详情原数据 API
tar 命令使用
halcon实例
神经网络图怎么分析,画神经网络结构图
网络模型(U-net,U-net++, U-net+++)
Array, string, date notes [Blue Bridge Cup]
最强大脑(2)
Simple strokes on the Internet
Continuous Integration/Continuous Deployment (2) Jenkins & SonarQube
前几天,小灰去贵州了
HDRP Custom Pass Shader Get world coordinates and near clipping plane coordinates
关于ts中的指针问题call,bind, apply
Simple interaction between server and client
QTableWidget 使用方法
pycharm cancel msyql expression highlighting
关于ts的一些泛型关键字用法
idea插件自动填充setter
安装ES7.x集群