http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150
On Nov 4, 2011 5:41 AM, "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 Na
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 F
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 wrote:
> All the previous hints are correct.
>
> I would also add: the arithmetic is only good for command line settings,
> som
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
> If you
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*10
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 refle
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
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 configur
