Re: my.cnf not being found?
On Sun, 2006-06-04 at 23:28 +0100, Marcus Bointon wrote: > On the same OS X machine that's having prefpanel trouble with 5.0.22, > I find that mysql is not loading the values set in /etc/my.cnf. The > contents of the file is from another Mac that works just fine with > it. The file is world-readable. Should it be somewhere else? The location is correct. However mysqld looks for options in several files. For instance, it traverses the datadir, for my.cnf and home directory for .my.cnf. Then it merges defaults from all files read and attempts to start the server. So, it might be that you have another my.cnf, which is also processed. Try checking the option, which are actually read by the server with "mysqld --print-defaults". Petr > Marcus > -- > Marcus Bointon > Synchromedia Limited: Putting you in the picture > [EMAIL PROTECTED] | http://www.synchromedia.co.uk > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqlmanager logging?
On Fri, 2006-05-05 at 15:39 -0500, Duzenbury, Rich wrote: > [mysql.server] > use-manager > > [manager] > socket=/tmp/manager.sock > pid-file=/tmp/manager.pid > monitoring-interval=30 You don't have log option specified here. Try adding log=/var/lib/mysql/mysqlmanager.log Petr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlmanager logging?
As it was already advised, check the dir/log file permissions. Also, it might help if you post your my.cnf here. Petr On Wed, 2006-04-19 at 13:17 -0500, Duzenbury, Rich wrote: > MySQL 5.0.20 > > I've got two instances running with mysqlmanager. I'm not getting any > logging of any sort. > > mysqlmanager --help shows: > > - - > log /var/lib/mysql/mysqlmanager.log > pid-file /tmp/manager.pid > socket/tmp/manager.sock > bind-address (No default value) > port 2273 > password-file /etc/mysqlmanager.passwd > default-mysqld-path /usr/sbin/mysqld > monitoring-interval 10 > run-as-serviceFALSE > user (No default value) > wait-timeout 28800 > > I've also tried to set the --log option in the [manager] section of > /etc/my.cnf and restarted the server, to no avail. > > Do I have to run-as-service to get logging? > > Thanks for any help you can offer. > > Regards, > Rich > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Slow query log
On Wed, 2006-04-05 at 11:38 +0200, Mechain Marc wrote: > Is there a way to enable the Slow Query Log on the fly without having to > restart mysqld No. Petr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql compile error
Hi Ryan, Hmm, --without-server doesn't seem to work. Not sure what are you doing wrong, but as a workaround you could define F_TO_EOF to zero in open.c. Quoting sql/my_global.h: #define F_TO_EOF 0L /* Param to lockf() to lock rest of file */ And for linux it is zero (it's different for windows). The define should solve at least this particular compile failure. Petr On Wed, 2005-11-23 at 13:40 -0600, Ryan Stille wrote: > Making all in isam > make[2]: Entering directory `/usr/src/mysql-4.1.14/isam' > source='open.c' object='open.o' libtool=no \ > depfile='.deps/open.Po' tmpdepfile='.deps/open.TPo' \ > depmode=gcc /bin/sh ../depcomp \ > gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../include -I../include -O3 > -DDBUG_OFF-c open.c > open.c: In function `nisam_open': > open.c:136: `F_TO_EOF' undeclared (first use in this function) > open.c:136: (Each undeclared identifier is reported only once > open.c:136: for each function it appears in.) > make[2]: *** [open.o] Error 1 > make[2]: Leaving directory `/usr/src/mysql-4.1.14/isam' > make[1]: *** [all-recursive] Error 1 > make[1]: Leaving directory `/usr/src/mysql-4.1.14' > make: *** [all] Error 2 -- Petr Chardin, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: timestamp
Hi Ryan, On Wed, 2005-11-16 at 19:16 +0800, Ryan Escarez wrote: > is it possible to get the the given (unix)timestamp in milliseconds > since the epoch? No, it is not possible. However this is on the roadmap. This is also reported as Bug #8523: http://bugs.mysql.com/bug.php?id=8523 Regards, Petr -- Petr Chardin, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Timezone setting wrong?
> I've tried putting TZ = GMT and TZ = UTC into the my.cnf file but then > mysql won't even start. These should be set as environment variables, not as configuration options. You could also try setting time_zone system variable with set @@time_zone=GMT. Petr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Multiple my.cnf files
Hi Clyde, On Mon, 2005-08-15 at 19:56 -0400, Clyde Lewis wrote: > Does anyone have any experience using multiple my.cnf files on a single box? > If so, how is the my.cnf specified during startup and shutdown? Try starting mysqld with --defaults-file=/path/to/my.cnf > I need multiple my.cnf files to test ibbackup software because it does not > currently support using mysqld_multi. > CL Petr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-test-run --external?
Hello David, I think you are looking for --extern option of the test suite. I corrected the README file. The changes should be propagated to the public repository soon, but you could check the commit mail for more details right now: http://lists.mysql.com/internals/26266 Petr On Tue, 2005-06-21 at 13:40 -0700, David Sparks wrote: > According to the README, mysql-test-run supports an --external option: > > db1 mysql-test # grep -a1 external README > > If you want to run the test with a running MySQL server use the --external > option to mysql-test-run. > > > However it doesn't actually support it: > > db1 mysql-test # ./mysql-test-run --external > Unrecognized option: --external > > > How do I get the test suite to run with an existing DB? > > Cheers, > > ds > -- Petr Chardin, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: After upgrade to 5.03beta, mysqld won't start
Hi Jonh, > As I said, I couldn't find any error logs that seemed to relate (i.e, > had information newer than the upgrade and start failures). I looked > into the /etc/init.d/mysql script and tried running mysqlmanager > directly. It would not run because of errors. From another message in > this newsgroup, I saw that someone else was having similar problems and > that removing the items from the [mysql] section of my.conf took care of > them. That's what I did, and then the server started. From what I can > tell, this appears to be a bug because the [mysql] section should have > no affect on the server process and should not prevent mysqlmanager from > running. Yes, it is a bug in mysqlmanager and it is fixed in the source repository. Please upgrade to 5.0.4 when it is released. Petr -- Petr Chardin, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
