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