Re: improve performance of this sql

explain select * from (select A.LEAF_CATEG_ID, A.CLUSTER_ID, A.SIGNATURE, A.IS_NULL, A.HEIGHT, A.NO_LISTINGS, A.NO_SUCC_LISTINGS, A.TOTAL_QTY,A.SOLD_QTY, A.ASP, A.NO_BIDS, A.MIN_PRICE, A.MAX_PRICE, A.MIN_ITEM_ID, A.MAX_ITEM_ID from C_DATA A, R_DATA B, ER_MAP C where B.KEYWORDS IN ('CAMERA') and B.

Downloading MySQL from Bazaar is so slow

I am behind a firewall. So I set http_proxy environment. Then I used "bzr branch http://bazaar.launchpad.net/~mysql/mysql-server/mysql-6.0 mysql-6.0" to download mysql 6.0 source code. However it has not been finished yet for three days!!! So slow. I am wondering if it is bazaar problem or my pro

Quit in MySQL logs

We are running MySQL 5.0.45 on a Linux machine. I have enabled the general query log and I notice that for some of the connections, the last command is Quit but for some of the connections, the Quit command does not appear. What do I have to do to ensure that the Quit command gets printed in t