幸福

如人饮水,冷暖自知

Mysql Can't create more than max_prepared_stmt_coun

 

标题内容

2016/08/02 07:49:02 Error 1461: Can’t create more than max_prepared_stmt_count statements (current value: 16382)

panic: runtime error: invalid memory address or nil pointer dereference

[signal 0xb code=0x1 addr=0x0 pc=0x46c9af]

goroutine 1 [running]:

panic(0x662bc0, 0xc82000a100)

/usr/local/go/src/runtime/panic.go:481 +0x3e6

database/sql.(*Stmt).Exec(0x0, 0xc82098fd48, 0xf, 0xf, 0x0, 0x0, 0x0, 0x0)

/usr/local/go/src/database/sql/sql.go:1457 +0x3df

main.main()

/home/go/mch/order.go:83 +0x15af

exit status 2

 

 

mysql> show global status like '%stmt%’;

 

WX20170505-163809@2x.png

 

mysql> show global variables like '%stmt%';   

WX20170505-163835@2x.png

 

mysql> set global max_prepared_stmt_count=100000;


mysql> show global variables like '%stmt%’;   


WX20170505-163849@2x.png

 

 



去打赏

您的支持将鼓励我们继续创作!

[微信] 扫描二维码打赏

[支付宝] 扫描二维码打赏

点赞

发表评论

电子邮件地址不会被公开。 必填项已用*标注