Re: Do SELECT statements create some kind of row/table lock?

[Aftab Khan]

Please provide output of the following:

EXPLAIN SELECT count(digg_id) 
FROM kaneva.channel_diggs cd 
INNER JOIN kaneva.communities_game cg ON cg.community_id = cd.channel_id 
INNER JOIN __make_population_cache mpc ON mpc.game_id = cg.game_id 
WHERE 
cd.created_date >= DATE_SUB(DATE(NOW()),INTERVAL 7 DAY) ;

show create table kaneva.communities_game\G
show create table __make_population_cache\G



Edited 2 time(s). Last edit at 12/03/2012 11:02AM by Aftab Khan.