*************************** 1. row *************************** Id: 3 User: root Host: localhost:2211 db: netflix Command: Query Time: 29497 State: Locked Info: ALTER TABLE `netflix`.`qualifying` ADD UNIQUE `idx_qualifying`(`cust_id`, `movie_id`) , ENGINE = MyISAM *************************** 2. row *************************** Id: 11 User: netflix Host: localhost:2350 db: netflix Command: Query Time: 29826 State: Copying to tmp table Info: select distinct qualifying.cust_id, customers.num_peers, customers.rating_cutoff from qualifying join customers on customers.cust_id = qualifying.cust_id where customers.num_peers > 0 and qualifying.rating = 0 order by qualifying.cust_id *************************** 3. row *************************** Id: 12 User: root Host: localhost:2353 db: NULL Command: Query Time: 0 State: NULL Info: show full processlist *************************** 4. row *************************** Id: 13 User: root Host: localhost:2354 db: mysql Command: Sleep Time: 3 State: Info: NULL