At 01:23 PM 3/14/2001 +0100, René Tegel wrote:
>you chowned mysql.cnf to owner/group mysql ?
I hadn't, but mysql is reading some other options properly from my
/etc/my.cnf file.
Actually, I did some more searching and I found this command:
/usr/libexec/mysqld --print-defaults
It seems to show the options that will be used and it is picking up my
options if I put them under [mysqld]. What was confusing me is that the ps
output for safe_mysqld was not mentioning the options, but it wouldn't have
to. I guess I just wanted some feedback that my options were being used
and the above provides that.
So, my solution is, these lines in /etc/my.cnf:
[mysqld]
skip-networking
myisam-recover=BACKUP,FORCE
log-slow-queries=/var/lib/mysql/home-slow.log
delay-key-write-for-all-tables
and use:
/usr/libexec/mysqld --print-defaults
to check if they being set properly... my output looks like:
/usr/libexec/mysqld would have been started with the following arguments:
--datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock
--skip-networking --myisam-recover=BACKUP,FORCE
--log-slow-queries=/var/lib/mysql/home-slow.log
--delay-key-write-for-all-tables
Thanks,
-bill
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php