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 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
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:
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:
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 AND
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
the
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
(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'
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
country.detail_tid=content.tid AND
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
10 matches
Mail list logo
