http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION0001500000 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.com>wrote: > >> 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 >> > >
