Hello,
thanks for your fast reply. even when i use
EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10
the key isn't used. the query takes about 2s :-(
Corin
Tuesday, December 9, 2003, 10:19:16 AM, you wrote:
MT> Hi,
MT> I'm not saying I fully understand the MySQL optimizer, as
MT> I never
: 'EXPLAIN SELECT datum,id FROM actions ORDER BY datum'
the key isn't used anymore :-(.
might this be bug of mysql?
Corin
---
This is a forwarded message
From: Corin Langosch <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Tuesday, December 9, 2003, 10:11:03 AM
Hello,
i'm having a problem with mysql. when i put an index on a
datetime column, it's never used.
for example the
sql: 'EXPLAIN SELECT * FROM actions ORDER BY datum'
shows:
table type possible_keys key key_len ref rows Extra
actions ALL NULL NULL NULL NULL 75853 Using filesort
even if i
Hi!
When running a query like:
LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS
TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'
(list_id,email,f1,f2,f3)
mysql seems to forget to invalidate the query cache, because added rows are
not displayed in following
SELECT stat
Hi,
sorry, didn't look at the changelog... ;)
thanks!
corin
Monday, December 30, 2002, 9:29:12 AM, you wrote:
PD> At 9:01 +0100 12/30/02, Webmaster (Corin Langosch) wrote:
>>Hi,
>>
>>when trying to create a temporary table of type merge, mysql
>>2.23.53 fails
Hi,
when trying to create a temporary table of type merge, mysql
2.23.53 fails with an error like this:
Can't find file: '#sql24b_776_0.MRG' (errno: 2)
when not using the temporary keyword, everything works fine.
so i assume this is a missing feature (not documented that this
is forbidden/not sup
Hi,
does anybody know how to make a delayed update and is this implemented in
mysql 3.23.x ? the update should not block the client (i guess this does
low_priority) if the table is a lot in use. simply update the rows later,
just like insert delayed does.
Thanks,
Corin
-
Hi !
the table has about 12.000 rows total but the query should return
a max of about 100. mysql should split the query into two queries
and merge the results.
may be this could be done by joining the same table two times
and query each table only for one of the OR expression.
i'll try but for fut
Hi,
i have the following problem. I have a table wherey to_id
and owner_id are of type unsigned int not null and both
are normal indexes. Unluckily a query like:
--
EXPLAIN SELECT * FROM `telegramme` WHERE to_id = 3157 or owner_id = 3157
--
returns very bad results:
--
table type pos
