Thanks for the suggestion, but no luck. Here's the explain output for,
in order, my original query, the 2-part query, and the explicit join
(note, not quite like my first post, I had "cleaned up" my tables to
simplify the situation):
mysql> explain SELECT * FROM accounts, transactions WHERE canon_
I have a performance/index usage problem, and I am hoping somebody can
tell me why this problem exists, and whether there is a better solution
than the workaround that I'm using now.
The problem: I have a table with a two column index, such as
CREATE TABLE transactions (
account_id INT NOT NULL
Ugh, I couldn't find the mailing list archives until I looked at the
bottom of my own message that got mailed back to me! I searched, found
out about the temporary table workaround for no unions, sorry for
bothering you all with a question that had been answered before. I'm
still eager for MySql t
Hi. I just finished a database that will be supporting another system,
and right now it is running on Postgres, but I was unhappy with that for
various reasons. I converted my data to mysql, and most things look
good: in the ways I care about, performance is much better, EXCEPT for
one issue which
l bar. Unknown
if this bug is present in the linux version, will check in the morning.
--
William M. Quarles
Giovanetti Research Group
Department of Physics
James Madison University
[EMAIL PROTECTED]
* This e-mail was sent using Mulberry, JMU's new official e-m
--On Wednesday, July 11, 2001 13:44 +0300 Sinisa Milivojevic
<[EMAIL PROTECTED]> wrote:
> William M. Quarles writes:
>>
>>
>> Not sure if this sent properly before, but when I try to unzip the
>> static pacakge, it says that it is not in gzip format.
>>
f/GUI/flvw/test'
make[1]: *** No rule to make target `../lib/libflvw.a', needed by
`testlist'. Stop.
make[1]: Leaving directory `/home/quarles/MySQL_stuff/GUI/flvw/test'
make: *** [all] Error 2
--
William M. Quarles
Vice Pres, Society of Physics Students
Jr. Warden, Canterb
-- Forwarded Message --
Date: Tuesday, July 03, 2001 1:03 PM -0400
From: "William M. Quarles" <[EMAIL PROTECTED]>
To: Rafael Marcus <[EMAIL PROTECTED]>
Subject: Re: Question
Yes, absolutely, those are fundamental commands. You probably have not set
up
27;s the time to do it.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list arch
e manual)
>>> 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.php
&g
-
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscrib
>> lot slower than I am ;-)
>>
>> --- Enclosed is a copy of the request I received.
>>
>> Return-Path: <[EMAIL PROTECTED]>
>> Received: (qmail 16974 invoked from network); 31 May 2001 02:21:54 -
>>
but unless they have corresponding rows in another table to
> actually give them privileges, they can't do anything.
>
> I don't have rows like that in my user table so they should be safe to
> delete.
>
>
>
, 2001 20:30 -0400 Philip Mak <[EMAIL PROTECTED]> wrote:
> On Tue, 12 Jun 2001, William M. Quarles wrote:
>
>> Which program?
>
> Here's what the /etc/my.cnf file on my system looks like:
>
> [client]
> port=3306
> socket=/home/mysql/mysql.sock
>
> [mysq
, too.
--On Tuesday, June 12, 2001 17:10 -0400 Jim Ziegler <[EMAIL PROTECTED]> wrote:
> On Tue, Jun 12, 2001 at 04:34:53PM -0400, William M. Quarles wrote:
>> I think we would need much more information than what you have given to
>> verify what is going wrong, but I am not the
Which program?
--On Tuesday, June 12, 2001 15:52 -0500 Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 4:34 PM -0400 6/12/01, William M. Quarles wrote:
>> I don't think that's what Dennis person wants to know, I think he
>> wants to know every single variabl
;3007 Quit
>3006 Binlog Dum
>
> What is wrong? Where do I get a better magician?
>
>
> -
> Before posting, please check:
> --
> Paul DuBois, [EMAIL PROTECTED]
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread,
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
inistrator' (i don't know anything about, if i'm in
a wrong way please make me know)
How can i make mySQL know that in the computer 'B' there is a new Database
to manage?.
-i want to know which instruction do i have to use to make this-
Well,
Thank you
William M.
QL no¡)
Thank you...
William M.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Before posting, please check:
http://www.mysq
21 matches
Mail list logo
