Re: my.cnf not read in 4.1.3

[V. M. Brasseur]

Are you sure that the server is using the my.cnf file which you are 
changing?  After making the change, what is the output of 
--print-defaults for mysqld?  If it's not as expected, odds are good 
that the server is getting its defaults from a different location.

--V
[EMAIL PROTECTED] wrote:
Hi all:
   I am running MySQL 4.1.3 under Debian.  I have the problem that my
options in my.cnf are not going into effect.  I want to increase
max_heap_table_size from the default of 16M to 400M (I have 4GB of
memory), but putting that line into my.cnf doesn't do anything.  (Yes
it is in the mysqld section of the file.)  Also I have tried doing a
set global max_heap_table_size=400000000;
in the mysql command line but it doesn't change the value either,
according to SHOW VARIABLES.
What am I doing wrong?
Regards,
Ryan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]