Re: Redhat crash - help needed

2003-12-29 Thread Dan Goodes
ng a local group/user for mysql, but to no avail - so long as the "group" line contains "ldap" in nsswitch.conf, mysql falls over). -Dan On Mon, 29 Dec 2003, Dan Goodes wrote: > Hi folks, > > just compiled up mysql-4.0.17.tar.gz on a (stock, basic install) RHEL

Redhat crash - help needed

2003-12-28 Thread Dan Goodes
Hi folks, just compiled up mysql-4.0.17.tar.gz on a (stock, basic install) RHEL3 system, and get similar symptoms to something I experienced a while ago with RH9. that is... it compiles fine, but wont start. The ./configure options are: ./configure '--prefix=/opt/local/stow/mysql-4.0.17' '--with

Re: Hanging processes in MySQL 3.23.53

2003-10-27 Thread Dan Goodes
problem that I couldn't sovle by inspection, as > everything that gets written to syslog goes straight into a MySQL database! > :-) Of course, InnoDB having it's own logs helps quite a lot. > > On Tue, 28 Oct 2003 03:26 pm, Dan Goodes wrote: > > Hi Chris, > > >

Re: Hanging processes in MySQL 3.23.53

2003-10-27 Thread Dan Goodes
omes undone). I also should note that the database is being written to almost-constantly (it's being used as an apache logger process via mod_log_sql). -dan On Tue, 28 Oct 2003, Chris Nolan wrote: > Which platform are you using? Which FS? > > Regards, > > Chris > >

Hanging processes in MySQL 3.23.53

2003-10-27 Thread Dan Goodes
Hi folks, I have a bit of a problem. I'm running 3.23.53 which I've compiled up from source (because the RPMs are not an option for me). I have a process that does a fairly large select statement every 10 minutes - up until a few days ago it was all find and dandy. A few days ago I did a massi

RE: FAQ hosting site (was "Re: An Idea")

2003-01-01 Thread Dan Goodes
ent: Wednesday, January 01, 2003 4:12 PM > > Subject: Re: FAQ hosting site (was "Re: An Idea") > > > > > > > -BEGIN PGP SIGNED MESSAGE- > > > Hash: SHA1 > > > > > > Stefan, et al -- > > > > > > ...and

Re: No descending index ?

2002-12-16 Thread Dan Goodes
ual) >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.

Re: query question

2002-10-16 Thread Dan Goodes
Hi, Try SELECT distinct substring(name, 1, 1) from names; That should work :) -Dan On Wed, 16 Oct 2002, Kevin wrote: > Hello, > > I have a table with a list of names. I need to get a distinct list of the > names by first letter, as follows: > > John > Mary > Mark > Tom > > the query shoul

Further info for my problem

2002-10-07 Thread Dan Goodes
erstand some of that - threads, segfaults, and printfs. Thats about it. Incidentally, this is being built exactly the same way as a mysql-3.23.51 installation on RH7.2, that has been running and successfully driving a web site for the last couple of months (not long after 3.23.51 came out). --

Problems with RH8 doing a source install

2002-10-07 Thread Dan Goodes
, and that I like to have control over where my data is stored). Hope someone has suggestions for a solution. -- Regards, Dan Goodes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li