MySQL Performance: MySQL => PRIMARY key not working

Members

Help

Home

Home » Performance » MySQL » PRIMARY key not working

Show: Today's Messages :: Show Polls :: Message Navigator

PRIMARY key not working [message #3677]

Wed, 29 October 2008 12:29

jeffStrahl
Messages: 1
Registered: October 2008

Junior Member

Hello,
I have a query that is joining multiple tables. I have it optimized rather well, except for one table. I can't for the life of me figure out why that table is not using the pk as the key. It is causing the query to filesort and use a temp table, changing the query time from 0.003s to 23s, obviously too long.

Attached is a file with the database and query details.

Any assistance is greatly appreciated, for I don't know what it could be.

Attachment: mysql explain query.txt
(Size: 15.55KB, Downloaded 77 time(s))

Report message to a moderator

Previous Topic:	Database Performance Counters for Mysql 5.0.45
Next Topic:	Need to optimize mysql query

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 5 16:02:57 EDT 2009

Total time taken to generate the page: 0.02949 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.