What else is in the my.cnf file? For instance, when I run `mysqld
--print-defaults` on my system I see this:
mysqld would have been started with the following arguments:
--basedir=/path/to/mysql-4.0 --datadir=/path/to/mysql-4.0/data
--port=1032 --socket=/path/to/mysql-4.0/mysql.sock --user=username
--log=/path/to/mysql-4.0/logs/this.log
--log-slow-queries=/path/to/mysql-4.0/logs/this-slow.log
--log-error=/path/to/mysql-4.0/logs/this-err.log --log-long-format
--tmpdir=/path/to/mysql-4.0/tmp
Each of those parameters is an option set in the my.cnf file. So I'd
imagine that if you have anything at all in the [mysqld] group in the
file you'd be seeing them in the --print-defaults output.
If there are no objections from your sysadmin, I suggest moving your
my.cnf file from /etc/mysql straight into /etc. Either that or into the
default datadir for your installation. Both should work better for you
(but the /etc/my.cnf location would be a sure-thing).
Cheers,
--V
[EMAIL PROTECTED] wrote:
The output of mysqld --print-defaults is blank, so that means it should be
looking for my.cnf in the default location, which is /etc/mysql/my.cnf,
right? I am indeed editing the file in that location.
Ryan
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=4;
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]
