Selon Rob Wultsch <[EMAIL PROTECTED]>:
> http://www.google.com/search?q=STRAIGHT_FORWARD+mysql yields buckus.
> Where is this documented?
oops, I meant 'straight_join' :/
Tristan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
On Wed, Apr 16, 2008 at 12:41 AM, <[EMAIL PROTECTED]> wrote:
> The 'STRAIGHT_FORWARD' + 'FORCE INDEX' worked, thanks a lot to all :)
http://www.google.com/search?q=STRAIGHT_FORWARD+mysql yields buckus.
Where is this documented?
--
Rob Wultsch
[EMAIL PROTECTED]
wultsch (aim)
--
MySQL General
The 'STRAIGHT_FORWARD' + 'FORCE INDEX' worked, thanks a lot to all :)
Tristan
--
Tristan Marly
06.16.84.57.43
http://www.linkedin.com/in/tristanmarly
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, Apr 15, 2008 at 9:05 AM, Wm Mussatto <[EMAIL PROTECTED]> wrote:
> Possible key refers to the keys that the server thinks might be usable.
> key refers to the one is chose. On the slow server it decided that the
> possible key would not work so it didn't use it. You might try to force
>
On Tue, April 15, 2008 02:03, [EMAIL PROTECTED] wrote:
> I'm still trying to decript the EXPLAIN result, and there is something I
> really
> don't understand:
>
> mysql> EXPLAIN SELECT STRAIGHT_JOIN media.* FROM country,content,media
> WHERE
> country.id='Germany' AND country.detail_tid=content.tid
I'm still trying to decript the EXPLAIN result, and there is something I really
don't understand:
mysql> EXPLAIN SELECT STRAIGHT_JOIN media.* FROM country,content,media WHERE
country.id='Germany' AND country.detail_tid=content.tid AND
content.id=media.content_id;
On the FAST server:
+--+---+
Tristan Marly schrieb:
First, thanks for all your suggestions and for beeing so reactive.
@Martin: the explain result was in attachment, but you will have more results
in this current mail.
@Rob: you are right, the 'show index' shows strange things, cf. below.
@Rodolphe: indeed the STRAIGHT_
(cf. in attachment my notes. I attached there to avoid unwanted carriage
returns)
--
First, thanks for all your suggestions and for beeing so reactive.
@Martin: the explain result was in attachment, but you will have more results
in this current mail.
@Rob: you are right, the 'show index' sh
2008/4/11 <[EMAIL PROTECTED]>:
> Hi,
>
> I have 2 MySql server instances. One which is 5.0.27/Debian, another
> 5.0.32/Solaris.
>
> Both instances have the same data in the database.
>
> And I'm doing a select:
> SELECT media.* FROM media,country,content WHERE country.id='Germany' AND
> coun
