Home - database - mysql - 200906 - Thread

How to Optimize distinct with index

by 周彦伟on 2009-06-19T02:56:16+00:00

Previous thread: [ANN] PBXT 1.0.08 RC2 Released!
Next thread: safe query prevent sites from hijacker
Threads sorted by date: mysql 200906

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 * from user where user_id in(id1,id2,id3,id4,.....) order by use_id;
I add index on user_id,but after in,order use temporary table, How to
optimize it?
Thanks!
zhouyanwei
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=Bull@pubbs.net

Conversations: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Matt Neimeyer on 2009-06-19T01:36:47+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Johnny Withers on 2009-06-19T02:31:29+00:00
How to Optimize distinct with index by 周彦伟 on 2009-06-19T02:55:37+00:00
How to Optimize distinct with index by 周彦伟 on 2009-06-19T02:56:09+00:00
How to Optimize distinct with index by 周彦伟 on 2009-06-19T02:56:16+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Dan Nelson on 2009-06-19T07:16:37+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Matt Neimeyer on 2009-06-19T14:05:58+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Brent Baisley on 2009-06-19T15:30:39+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Peter Brawley on 2009-06-20T00:16:24+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Walter Heck - OlinData.com on 2009-06-20T02:45:38+00:00
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP? by Matt Neimeyer on 2009-06-22T15:06:06+00:00

Related Threads

How to Optimize distinct with index

Conversations: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?

Related Lists