mysql startup, shtudown and logging on osx
Posted
by Joelio
on Server Fault
See other posts from Server Fault
or by Joelio
Published on 2009-12-28T14:41:57Z
Indexed on
2010/04/02
2:03 UTC
Read the original article
Hit count: 557
Hi, I am trying to troubleshoot some mysql problems (I have a table I cant seem to delete or drop, it hangs forever)
I have 10.5.8 osx, I dont remember how/if I installed mysql, here is what I know:
it automatically starts on boot
the process looks like this: /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/Joels-New-Pro.local.pid _mysql 96 0.0 0.0 75884 684 ?? Ss Sat06PM 0:00.02 /bin/sh /usr/local/mysql/bin/mysqld_safe
when I run: /usr/local/mysql/libexec/mysqld --verbose --help
it says: /usr/local/mysql/libexec/mysqld Ver 5.0.45 for apple-darwin9.1.0 on i686 (Source distribution)
it seems to use my.cnf from /etc/my.cnf
Now here are my questions: I dont see anything in the startupitems that remotely looks like mysql
ls /Library/StartupItems/ BRESINKx86Monitoring ChmodBPF HP IO HP Trap Monitor Parallels ParallelsTransporter
1.) So how does it startup automatically?
2.) How do I start & stop this type of installation?
Also, looking at the config, the logs have no values:
/usr/local/mysql/libexec/mysqld --verbose --help|grep '^log'
log (No default value)
log-bin (No default value)
log-bin-index (No default value)
log-bin-trust-function-creators FALSE
log-bin-trust-routine-creators FALSE
log-error
log-isam myisam.log
log-queries-not-using-indexes FALSE
log-short-format FALSE
log-slave-updates FALSE
log-slow-admin-statements FALSE
log-slow-queries (No default value)
log-tc tc.log
log-tc-size 24576
log-update (No default value)
log-warnings 1
3.) Does that mean there is no logging enabled in mysetup?
thanks in advance! Joel
© Server Fault or respective owner