How to Optimize distinct with index

Hi, I have a sql : Select distinct user_id from user where key1=value and key2=value2 and key3=value2; I add index on (key1,key2,key3,user_id), this sql use temporary table howevery I have thousands of queries per second. How to optimize it? Anthoer question: Select * fr

mysql5.4 bugs about mysqladmin??

Hi,I'm using mysql5.4-beta now.when I use flow command ,it does not works,is mysql5.4 bug? The command mysqladmin -p -r --sleep=1 --count=100 extended-status It run only one time. Thanks! -邮件原件- 发件人: mos [mailto:mo...@fastmail.fm] 发送时间: 2009年5月18日 2:14 收件人: mysql@lists.mysql.com 主题