e kind of thing.
Hope this helps!
Mike
-Original Message-
From: ighen [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 5:34 PM
To: Michael Shuler
Subject: Re: Getting a particular row from GROUP BY
- Original Message -
From: "Michael Shuler" <[EMAIL PROTE
om MySQL's website. Perhaps I would try compiling from source?
Mike
-Original Message-
From: Michael Shuler [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 4:41 PM
To: [EMAIL PROTECTED]
Subject: Very Slow GROUP BY Query
I have been trying to understand why this query is
What would be the rules for deciding if id 3 should be fr or de?
Michael Shuler, C.E.O.
BitWise Systems, Inc.
1301 W. Pioneer Parkway
Peoria, IL 61615
Office: (217) 585-0357
Cell: (309) 657-6365
Fax: (309) 213-3500
E-Mail: [EMAIL PROTECTED]
Customer
var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[isamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[myisamchk]
set-variable = key_buffer=256M
set-variable= sort_bu
opTime) AND (Realm =
'testrealm.com')
Is this a bug and is there a way to force MySQL to use an index that you
know is a better choice?
Thanks again,
Michael Shuler
-----Original Message-
From: Michael Shuler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 3:44 PM
To:
, November 11, 2003 4:02 PM
To: Michael Shuler
Cc: [EMAIL PROTECTED]
Subject: Re: Dirt Slow Query On Datetime Range
The first thing I noticed is that you are using varchar instead of
char, why? Unless you have a variable length field like text or blob,
you can and should use char.
As far as I know, you
const
73394 Using where
Perhapse my InnoDB file needs to be "optimized" if such a thing exists. I
don't know why this takes so long but I can definitly use some help.
Thanks!
Michael Shuler
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
