The more data u fetch the more time the query takes,.
Can u please check the explain plan for the entire month and lets us know.
If the number of rows processed by db is more than 10% of the total rows,
than optimizer considers doing a FULL TABLE scan better than a index scan
On 6/27/08, Darryl
Hi..
I've got an issue with doing a Load data file" cmd..
my test text tbl has a column named "company name" i'm trying to figure out
how to use the load data file cmd, to be able to extract the "company name"
col...
when i do:
load data file '/foo/test.csv' into table abc.test (company name)";
Hi mysql,
Add me as a friend on Last.fm so we can share our music taste :)
Check out what I'm listening to:
http://www.last.fm/user/agquarx/?invitedby=agquarx&tp=ff_tp_b
I also sent you a personal note:
"Wspaniała zabawa i możliwość rozszerzenia horyzontów muzycznych // Lots of fun
Dear MySQL users,
MySQL 6.0.5-alpha, a new version of the MySQL database system including
the Falcon transactional storage engine, has been released. The main
page for MySQL 6.0 release is at:
http://www.mysql.com/mysql60/
If you are new to the Falcon storage engine and need more informat
Peter,
I really appreciate all the help. Unfortunately, the query you came up
with still returns two rows for catalog_number = 520.
I modified your query slightly to this to qualify a specific catalog_number:
SELECT c.course_id,s.course_offer_number,s.subject
FROM course c
JOIN course_subject
In the last episode (Jun 27), mos said:
> I'm creating a MyISAM table using a Select statement as in:
>
> create table t2 select if(col1>col2,1.2,4.1) NewCol from t1
>
> (Ok, the computations are a lot more complicated than that).
>
> For some reason the column type of NewCol is Decimal and not
>What I want is ONLY the 'ME' row (if a row exists with a subject of
'ME').
>If an 'ME' subject row does not exist, then I want the other one.
Ill be offline for awhile so I'll assume answers not available, ie allow
='ME' dupes and <>'ME' dupes if they exist. A one-query answer is to
union
Hi,
I'm having difficulty with ordering on a calculated field, the order
is just not doing what I expect. I'll post the query here, it is a
distance calculation based on lat and lng so it quite complex
SELECT * , (
ACOS( LEAST( 1, COS( 0.898348891269513 ) * COS( -
0.00293599286770486
Hi Ananda,
The problem is the one date is stored as a unix time stamp, and the other as
a -XX-XX XX:XX:XX format :/. Can MySQL just match it without converting?
I have dropped the 2nd conversions on the WHERE part of the query as I can
format that before executing to look correct.
It's takin
Also since mysql give date in Y-M-D you might want to remove the
"from_unixtime" and "date_format" formating functions
On 6/27/08, Darryl Steyn <[EMAIL PROTECTED]> wrote:
>
> Hi Jörg,
>
> I have applied the changes you have suggested and still no joy :(
>
> I will carry on playing around with it t
Hi Jörg,
I have applied the changes you have suggested and still no joy :(
I will carry on playing around with it to see if there is no way else for me
to simplify it (maybe selecting only every 30mins or so).
Thanks for the help,
Darryl
On Fri, Jun 27, 2008 at 5:28 PM, Joerg Bruehe <[EMAIL PRO
Tina
>What I want is ONLY the 'ME' row (if a row exists with a subject of
'ME').
>If an 'ME' subject row does not exist, then I want the other one.
I see. Then to complete spec, what behaviour is desired when there are
two rows with 'ME', or two rows with (course_offer_number = 1 AND
subj
Hi Darryl, all,
Darryl Steyn wrote:
Hi Ananda,
The query is for reporting purposes and I would like to include a date range
for the user to report on. That part of the query has to be there for it to
work nicely.
Regards,
Darryl
On Fri, Jun 27, 2008 at 4:25 PM, Ananda Kumar <[EMAIL PROTECTED
At 10:07 AM 6/27/2008, you wrote:
Hi Ananda,
The query is for reporting purposes and I would like to include a date range
for the user to report on. That part of the query has to be there for it to
work nicely.
Regards,
Darryl
Darryl,
Your Where Clause uses a date expression on the colum
I'm creating a MyISAM table using a Select statement as in:
create table t2 select if(col1>col2,1.2,4.1) NewCol from t1
(Ok, the computations are a lot more complicated than that).
For some reason the column type of NewCol is Decimal and not Double. How do
I force the expression column to be d
Hi Ananda,
The query is for reporting purposes and I would like to include a date range
for the user to report on. That part of the query has to be there for it to
work nicely.
Regards,
Darryl
On Fri, Jun 27, 2008 at 4:25 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi Darryl,
> Indexing looks
Hi Darryl,
Indexing looks fine, but what are ur trying to achive using this conditions
"cache.server.tstamp > 0) AND
((date_format(cache.server.tstamp,'%Y-%m-%d') BETWEEN "2008-05-31" AND
"2008-06-10" ))"
On 6/27/08, Darryl Steyn <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> From the traffic.traffic
Hi,
>From the traffic.trafficin table;
UNIQUE KEY `namekey` (`name`,`time`),
KEY `nameindex` (`name`),
KEY `dateindex` (`date`),
KEY `timeindex` (`time`)
>From the cache.server table;
PRIMARY KEY (`tstamp`)
Thanks,
Darryl
On Fri, Jun 27, 2008 at 2:31 PM, Ananda Kumar <[EMAIL PROTECTED]>
Peter,
Yes, I know there are two rows in the course_subject table with a
catalog_number of 520. One has a subject of 'ME' and the other has a
subject of 'MSE'.
What I want is ONLY the 'ME' row (if a row exists with a subject of
'ME').If an 'ME' subject row does not exist, then I want the
what are the columns in namekey index
On 6/27/08, Darryl Steyn <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am running a query that I feel shouldn't be taking as long as it does to
> execute. The query is as follows;
>
> SELECT traffic.trafficin.bytes_in as bytes_in,
> round(cache.server.serverallkbyt
Hi,
I am running a query that I feel shouldn't be taking as long as it does to
execute. The query is as follows;
SELECT traffic.trafficin.bytes_in as bytes_in,
round(cache.server.serverallkbytes_in) as serverallkbytes_in,
cache.server.tstamp as tstamp FROM traffic.trafficin LEFT JOIN cache.server
Hi,
Thanks for your suggestion.
It looks like had a minor effect. I see sometimes 4 or 5 queries running.
But it is not much different in general.
Regards,
Guillermo
From:
jocelyn fournier <[EMAIL PROTECTED]>
To:
[EMAIL PROTECTED]
Cc:
mysql@lists.mysql.com
Date:
27.06.2008 12:41
Subject:
Hi,
Could try your script with the key_buffer set to 0 ?
Regards,
Jocelyn Fournier
[EMAIL PROTECTED] a écrit :
Hello,
Thanks for you help. You can see the results in the .err file below. I've
run it twice while the algorithm was running, but my knowledge in MySQL is
still too poor to ident
Hello,
Thanks for you help. You can see the results in the .err file below. I've
run it twice while the algorithm was running, but my knowledge in MySQL is
still too poor to identify any problem here. Beside these locks that I do
not know what they are.
This is the third release of the algori
24 matches
Mail list logo
