How to change max_allowed_packet value in mysql?
来源:互联网 发布:linux用yum安装svn 编辑:程序博客网 时间:2024/05/29 13:26
If you set it in the cnf(it may be my.ini file) you will likely need to restart the server. Optionally, that is a dynamic variable and can be SET GLOBAL or SET SESSION from the command line as well.So just do as follows. mysql>show variables like’max_allowed_packet’; mysql>set global max_allowed_packet=67108864;mysql>exit; Note: If you don't use global or use session,after execute exit command,max_allowed_packet value will be still 1048576.
- How to change max_allowed_packet value in mysql?
- How to change max_allowed_packet value in mysql?
- How to change mysql default data directory in Ubuntu
- How to Change default MySQL Data Directory in Linux111
- How to change the timeout in FXCop
- How to change screen resolution in redhat
- How to change MAC address in Linux
- How to Change Login User in SharePoint2013?
- how to change file names in matlab
- MYSQL 异常 You can change this value on the server by setting the max_allowed_packet' variable
- Mysql You can change this value on the server by setting the max_allowed_packet' variable. 异常
- 解决Mysql You can change this value on the server by setting the max_allowed_packet' variable. 异常
- How to Change The Bootsplash In Ubuntu 8.10
- How to change default form name "aspnetForm" in Beta 2
- How to Change Timezone in your Linux System
- How to: Change color of rows in GridView on mouseover
- How to change MAC address in windows 7
- How to change the character case in ksh?
- 对 ThreadPool 的理解
- position 绝对定位的问题
- DS5000 红皮书 (Redbook) 笔记 2/4
- c++中explicit关键字的含义和用法!
- Ant的配置使用入门
- How to change max_allowed_packet value in mysql?
- DS5000 红皮书 (Redbook) 笔记 3/4
- JRockit 性能优化参数汇总
- 基于无线传输的数据采集盒设计
- DS5000 红皮书 (Redbook) 笔记 4/4
- WPF学习之开篇(揭开WPF的炫紫外衣)
- 关于MPlayer在播放时提示找不到/dev/dsp问题
- hi
- tar.bz2 解压命令