Temp table / join problem, just keeps saying copy to tmp...

Hi all. I'm having trouble this a process that just keeps running. To view this process I'm using the msql SHOW PROCESSLIST command. Here's the message I'm seeing: 38 | bb50 | localhost | bb50 | Query | 197 | Copying to tmp table | select a.pk1,a.sos_id_pk2, a.name, count(q.pk1)

Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup

Hello, I am running MySQL 4.0.5b 64 bits on a Solaris 2.8. The server used has 8 CPUs. MySQL DB has access (and menage) in that system 2DBs. The first DB is only is accessed only through SELECTS and the second one has been used for UPDATES and INSERTS. Initially I was running a process that

Re: 3.23.54 compile error

I reply to myself... I've tried to build mysql-3.23.54 from rpm sources. [...] error: Bad exit status from /var/tmp/rpm-tmp.34718 (%build) Any hint? Maybe a newer libtool is required? Got a clean compile with libtool-1.4-8 and automake-1.5-1. Now I'll test it.

Re: 3.23.54 compile error

Maybe I'm paranoid I reply to myself... I've tried to build mysql-3.23.54 from rpm sources. [...] error: Bad exit status from /var/tmp/rpm-tmp.34718 (%build) Any hint? Maybe a newer libtool is required? Got a clean compile with libtool-1.4-8 and automake-1.5-1. Now I'll test it.

[MySQL] InnoDB Lock status

I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My

RE: BEGINNER: in mysql, better to do 1 table for one relationship, even with a one to one relation ?

I would really prefer a little variation of the third way you mention: 1) table person personID primary int 11 autoincrement 2) table car carID primary int 11 autoincrement 3) table relation_person_car personID int 11 carID int 11 PRIMARY KEY (personID,carID) Adolfo -Original

RE: Field type conversion question

I would suggest having EmpTable (PRIMARY KEY=empID) EventsTable (PRIMARY KEY=eventID) AttendantsTable (PRIMARY KEY=[empID,eventID]) From there you can build queries to find persons who attended an event or which events a person went to. Adolfo -Original Message- From: Brad

Re: load data local infile

try adding these line to your my.cnf file (mysql config file) [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Thursday, December 12, 2002, at 09:52 AM, Yuyi Guo wrote: Hi: I am using mysql v4_0_5 both clinet and server. I cannot get load data local infile to work after many

Re: load data local infile

Thanks, it works after we recomplied it the enable-local-infile. By default, it is truned off. Cheers, yuyi Rich Allen wrote: try adding these line to your my.cnf file (mysql config file) [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Thursday, December 12, 2002, at 09:52 AM, Yuyi

<    1   2