List:General Discussion« Previous MessageNext Message »
From:曹凯 Date:June 2 2010 10:13am
Subject:RE: large table issue
View as plain text  
hi huys,

here's the explain of a query on this table

EXPLAIN SELECT COUNT(game_log_id) AS sum2 FROM game_log AS g, player AS p WHERE
g.player_id = p.player_id AND  g.game_id=p.game_id=27 AND p.type=1 AND g.event_id = 32
    -> ;
+----+-------------+-------+--------+--------------------+----------+---------+----------------------------+--------+-------------+
| id | select_type | table | type   | possible_keys      | key      | key_len | ref       
                | rows   | Extra       |
+----+-------------+-------+--------+--------------------+----------+---------+----------------------------+--------+-------------+
|  1 | SIMPLE      | g     | ref    | event_id,player_id | event_id | 4       | const     
                | 237894 |             |
|  1 | SIMPLE      | p     | eq_ref | PRIMARY            | PRIMARY  | 4       |
trigger_replay.g.player_id |      1 | Using where |
+----+-------------+-------+--------+--------------------+----------+---------+----------------------------+--------+-------------+
2 rows in set (0.00 sec)

and,  index on 'game_id', 'event_id', 'player_id'

CK
 		 	   		  
_________________________________________________________________
想知道明天天气如何?必应告诉你!
http://cn.bing.com/search?q=%E5%A4%A9%E6%B0%94%E9%A2%84%E6%8A%A5&form=MICHJ2
Thread
large table issue曹凯2 Jun
  • Re: large table issueAnanda Kumar2 Jun
    • RE: large table issue曹凯2 Jun
      • RE: large table issueJerry Schwartz2 Jun
  • Re: large table issuezhang sand2 Jun
  • Re: large table issueKrishna Chandra Prajapati2 Jun