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: 525

Filed under:
|
|
|
|

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

Related posts about mysql

Related posts about startup