setting max_allowed_packet dynamically problem
I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? LS
Re: setting max_allowed_packet dynamically problem
In the last episode (Nov 03), List Man said: I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? SET GLOBAL changes the server's default runtime value. Any new connections will get that value, but existing connections will not change. When the server restarts, it will fall back to whatever you have set in my.cnf, or the default value if you don't have anything in my.cnf. -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: setting max_allowed_packet dynamically problem
If you changed the value in the .cnf and restarting the server did not pick up he change, I would hazard a guess that the .cnf file you edited is not the one your server is reading. Check your paths and make sure you are editing the correct file. MySL never rewrites it's own config files to reflect manually changed values. On Thu, Nov 3, 2011 at 4:37 PM, List Man list@bluejeantime.com wrote: I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? LS -- - michael dykman - mdyk...@gmail.com May the Source be with you.
Re: setting max_allowed_packet dynamically problem
Thanks for the explanation. LS On Nov 3, 2011, at 4:41 PM, Dan Nelson wrote: In the last episode (Nov 03), List Man said: I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? SET GLOBAL changes the server's default runtime value. Any new connections will get that value, but existing connections will not change. When the server restarts, it will fall back to whatever you have set in my.cnf, or the default value if you don't have anything in my.cnf. -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=list@bluejeantime.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: setting max_allowed_packet dynamically problem
All the previous hints are correct. I would also add: the arithmetic is only good for command line settings, something like: max_allowed_packet = 16*1024*1024 is not valid in the my.cnf max_allowed_packet = 16M is the way to go in the my.cnf Cheers Claudio 2011/11/3 Michael Dykman mdyk...@gmail.com If you changed the value in the .cnf and restarting the server did not pick up he change, I would hazard a guess that the .cnf file you edited is not the one your server is reading. Check your paths and make sure you are editing the correct file. MySL never rewrites it's own config files to reflect manually changed values. On Thu, Nov 3, 2011 at 4:37 PM, List Man list@bluejeantime.com wrote: I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? LS -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- Claudio
Re: setting max_allowed_packet dynamically problem
Hi there, Could anybody suggest me to understand on which conf file (my.cnf) my server is readiing. how could I find that? On Fri, Nov 4, 2011 at 2:28 AM, Claudio Nanni claudio.na...@gmail.comwrote: All the previous hints are correct. I would also add: the arithmetic is only good for command line settings, something like: max_allowed_packet = 16*1024*1024 is not valid in the my.cnf max_allowed_packet = 16M is the way to go in the my.cnf Cheers Claudio 2011/11/3 Michael Dykman mdyk...@gmail.com If you changed the value in the .cnf and restarting the server did not pick up he change, I would hazard a guess that the .cnf file you edited is not the one your server is reading. Check your paths and make sure you are editing the correct file. MySL never rewrites it's own config files to reflect manually changed values. On Thu, Nov 3, 2011 at 4:37 PM, List Man list@bluejeantime.com wrote: I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? LS -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- Claudio
Re: setting max_allowed_packet dynamically problem
You can find which my.cnf your server is reading by using : mysql --help which displays something like this: Default options are read from the following files in the given order: C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf D:\Program Files\MySQL\M ySQL Server 5.5\my.ini D:\Program Files\MySQL\MySQL Server 5.5\my.cnf The following groups are read: mysql client On 11/4/2011 12:41 PM, Satendra wrote: Hi there, Could anybody suggest me to understand on which conf file (my.cnf) my server is readiing. how could I find that? On Fri, Nov 4, 2011 at 2:28 AM, Claudio Nanniclaudio.na...@gmail.comwrote: All the previous hints are correct. I would also add: the arithmetic is only good for command line settings, something like: max_allowed_packet = 16*1024*1024 is not valid in the my.cnf max_allowed_packet = 16M is the way to go in the my.cnf Cheers Claudio 2011/11/3 Michael Dykmanmdyk...@gmail.com If you changed the value in the .cnf and restarting the server did not pick up he change, I would hazard a guess that the .cnf file you edited is not the one your server is reading. Check your paths and make sure you are editing the correct file. MySL never rewrites it's own config files to reflect manually changed values. On Thu, Nov 3, 2011 at 4:37 PM, List Manlist@bluejeantime.com wrote: I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? LS -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: setting max_allowed_packet dynamically problem
http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150 On Nov 4, 2011 5:41 AM, Satendra stdra...@gmail.com wrote: Hi there, Could anybody suggest me to understand on which conf file (my.cnf) my server is readiing. how could I find that? On Fri, Nov 4, 2011 at 2:28 AM, Claudio Nanni claudio.na...@gmail.comwrote: All the previous hints are correct. I would also add: the arithmetic is only good for command line settings, something like: max_allowed_packet = 16*1024*1024 is not valid in the my.cnf max_allowed_packet = 16M is the way to go in the my.cnf Cheers Claudio 2011/11/3 Michael Dykman mdyk...@gmail.com If you changed the value in the .cnf and restarting the server did not pick up he change, I would hazard a guess that the .cnf file you edited is not the one your server is reading. Check your paths and make sure you are editing the correct file. MySL never rewrites it's own config files to reflect manually changed values. On Thu, Nov 3, 2011 at 4:37 PM, List Man list@bluejeantime.com wrote: I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configuration file (my.cnf) and restarted the server and the variable stayed the same. Does anyone have any ideas? LS -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- Claudio