two-column indexes and joins with ranges

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

Re: two-column indexes and joins with ranges

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

Any workaround for no union operation?

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

GUI Bug

. 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-mail client

Re: Trying to install GUI, flvw and fl_editor compile errors

--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. -- William M. Quarles Vice Pres, Society

Trying to install GUI, flvw and fl_editor compile errors

' 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, Canterbury Episcopal Campus Ministry James

Re: Question (fwd)

-- 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 your access privileges properly

Re: Cannot start the server after restart.

/ (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 -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry

Re: SV: Cannot start the server after restart.

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 -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James

Re: Fw: confirm subscribe to mysql@lists.mysql.com

-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry

RE: Possible Bug in mysql 3.23.38

-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's

Re: how to install mysql replication ?

://lists.mysql.com/php/unsubscribe.php -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client

Re: my.cnf mystery

://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 -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury

Re: how to install mysql replication ?

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 -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James

Re: my.cnf mystery

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 variable that he can control in my.cnf. Running

Re: my.cnf mystery

, 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 [mysqld] port=3306 socket=/home/mysql/mysql.sock The first

[Q] I need to pass one database from the computer A to computer B, they have MySQL installed

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. _ Do You Yahoo!? Get your free @yahoo.com