Go操作Mysql报错Can't create more than max_prepared_stmt_count statements
来源:互联网 发布:wiffi转网络接口 编辑:程序博客网 时间:2024/05/17 04:44
第一次用Go操作Mysql,按照网上的教程插入数据的时候只能插入1W多,后面就报错Can’t create more than max_prepared_stmt_count statements
原因是因为每次db.Prepare()之后没有Close()掉,所以在伪并发的状态下,mysql的配置文件里有默认值就是1W多,所以就只能到1W多的数据
func insert(db *sql.DB,username string,password string){ stmt,err1 := db.Prepare("INSERT User set UserName=?,Password=?") defer stmt.Close() CheckErr(err1) _,err:= stmt.Exec(username,password) CheckErr(err)}
阅读全文
0 0
- Go操作Mysql报错Can't create more than max_prepared_stmt_count statements
- Can't create more than max_prepared_stmt_count statements
- mysql_stmt_prepare failed! error(1461)Can't create more than max_prepared_stmt_count statements (cur
- .9图片报错mergeDebugResources. xx.9.png Can't have more than one marked region along edge
- 报错can't create unix socket
- Android Studio针对.9图片报Can't have more than one mark
- mysql无法启动,报错 Can't start server: can't create PID file: No space left on device
- Can't create/write to file 'C:\WINDOWS\TEMP\...MYSQL报错解决方法
- Mysql报错:Result consisted of more than one row
- 报错 MYSQL --Subquery returns more than 1 row
- mysql 启动报错 /usr/local/mysql//libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid'
- mysql启动不了,报错“[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it”
- MySQL 诡异报错Can't create/write to file '/tmp/#sql_89b_0.MYI' (Errcode: 177 - File exists)
- mysql创建外键约束报错【Bug Fix】Error : Can't create table '#sql-534_185' (errno: 150)
- MySql错误记录:(外键重复)报错Can't create table 'usersys.#sql-618_1' (errno: 121)
- MySQL创建外键约束的报错Error : Can't create table '#sql-534_185' (errno: 150)
- ruby操作mysql数据库报错提示can't convert Fixnum into String解决方法
- mysql启动报can't create/write to file 'var/run/mysqld/mysqld.pid 错误解决办法
- 杨澜访谈录之探寻人工智能1(机器的逆袭)
- CURL-post请求
- keil5通过jlink向stm32f103烧写程序 出错
- 通讯录 c++ list版
- 文章标题
- Go操作Mysql报错Can't create more than max_prepared_stmt_count statements
- 关于面向对象的一些理解(1)
- Cpp_链表
- 网页的性能优化的小知识
- TCP握手与挥手
- Xutils请求网络数据
- 通过符号左右移动数据easyui
- shell学习(一)
- 基于Docker的TensorFlow机器学习框架搭建和实例源码解读