Morning Discussion

by Xav de Matos, Jan 03, 2011 5:00am PST

2010 is over. Time to start clearing space on our shelves for the swarm of new titles hitting in 2011. In the first three months alone we're going to be bombarded with quality titles. Then a steady stream of other anticipated games are going to trickle out. In November we have Uncharted 3 landing and my personal "OMGOMGOMG" game of 2011, The Elder Scrolls V: Skyrim, arrives. Then Gears of War 3 and, well, all those games that have yet to be revealed.

This generation makes me happy to be a gamer. You know who else is happy? Credit card companies and loan sharks; the only two options I use when making mass video game purchases. What I'm saying is, I make bad decisions.

Read all the News

« Previous Story
Battlefield: Bad Company 2's Operation Hastings Map Unlocked Across PC, Xbox 360 and PS3

Next Story »
Weekend Discussion

See All Comments | 259 Threads | 5,620 Comments

#3847

Refresh Thread

By: MisterPhoton x Show Full Post

Reply

MySQL Professionals

I need some way to profile a query that's taking an inordinately long time to run. I've already done an EXPLAIN and it comes back as I expect - its not using a key on one of three tables in a join, and of course that means its stepping through 25k records to find a match. Funny thing is, I'm joining on the primary key, so I don't know WTF is preventing it from joining faster.

Here's the query:
https://gist.github.com/763987

NOTICE: I didn't write this stupid query.

Jan 03, 2011 1:23pm PST

toggle
MySQL Professionals I need some way to profile a query that's taking an inordinately long time to run.... : MisterPhoton
Thread Truncated. Click to see all 13 replies.
- toggle
  IIRC you can tell it to explicitly use indexes. look into that. : manero
  - toggle
    also, wtf? lol: (Plan_Item.reminderSendDate is not null) AND (Plan_Item.reminderSentDate is : manero
    - toggle
      oh, senT date vs senD date. : manero
      
      don't worry. I did a double take as well. : sKetchflow
  - I tried that, and it still gave me the same crap for the explain. I commented on the gist, above, and add... : MisterPhoton
- Help me, Shack, you're my only hope! I'm still working on trying to find a way to get this query to ru... : MisterPhoton
- toggle
  MY SQL PROFESSIONALS : mrvandelay
  - COME ON VANDELAY, MAKE IT HAPPEN : MisterPhoton
- toggle
  Don't do date_sub on reminderSendDate. As far as I know, MySQL isn't smart enough to change that into a d... : CrazyPants
  - toggle
    that's what I'm doing now - I've changed it to only do date_add on the right side of the <, and I'm movin... : MisterPhoton
    - #5569
      
      Refresh Thread
      
      By: sKetchflow x Show Full Post
      
      Reply
      
      I dunno. That's where I'd expect the slowdown...
      
      try not doing the inner join with a using... :D seriously I dunno
      
      Jan 03, 2011 5:12pm PST
      
      I dunno. That's where I'd expect the slowdown... try not doing the inner join with a using... :D serio : sKetchflow
- I'm guessing that the wpi table is largish and that none of the predicates in your where clause are the h... : randomjgj

red	r{...}r	italics	/[...]/
green	g{...}g	bold	b[...]b
blue	b{...}b	quote	q[...]q
yellow	y{...}y	sample	s[...]s
limegreen	l[...]l	underline	_[...]_
orange	n[...]n	strike	-[...]-
multisync	p[...]p	spoiler	o[...]o
olive	e[...]e	code	/{{...}}/