+---++-+--+-+---+-+--++--++-+
| Table | Non_unique | Key_name| Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type |
Comment |
+-
the dataset,
then MySQL has it right in this case.
- Original Message -
From: Brent Baisley <[EMAIL PROTECTED]>
To: bowen <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Monday, October 9, 2006 10:52:47 AM GMT-0500 US/Eastern
Subject: Re: How to speed up query of indexed colu
of transferring the results.
- Original Message -
From: "bowen" <[EMAIL PROTECTED]>
To:
Sent: Monday, October 09, 2006 8:54 AM
Subject: How to speed up query of indexed column with 5M rows?
How to speed up query of indexed column with 5M rows?
I have a table with more than
: Monday, October 9, 2006 9:18:01 AM GMT-0500 US/Eastern
Subject: Re: How to speed up query of indexed column with 5M rows?
Dan Buettner wrote:
> bowen -
>
> Right now, it appears your performance hinges on I/O to the disk drive.
>
> The reason you are seeing fast performance when query
.
>
> Dan
>
> On 10/9/06, bowen <[EMAIL PROTECTED]> wrote:
>> How to speed up query of indexed column with 5M rows?
>>
>> I have a table with more than 5M rows. (400M .MYD 430M .MYI).
>>
>> It took 27 seconds to do a common select...where... in the ind
consistent.
I'd recommend doing both if possible.
Dan
On 10/9/06, bowen <[EMAIL PROTECTED]> wrote:
How to speed up query of indexed column with 5M rows?
I have a table with more than 5M rows. (400M .MYD 430M .MYI).
It took 27 seconds to do a common select...where... in the index col
How to speed up query of indexed column with 5M rows?
I have a table with more than 5M rows. (400M .MYD 430M .MYI).
It took 27 seconds to do a common select...where... in the index column.
I can not bear the long run.
Vmstat show that system was bounded by IO busy.(Always more than 13000
bi/s