RE: Why won't mysql use the index? WAS: strange table speed issue

004 11:16 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Why won't mysql use the index? WAS: strange table speed issue Here is what the manual says about the table scan threshold: (http://dev.mysql.com/doc/mysql/en/Where_optimisations.html) Each table index is q

RE: Why won't mysql use the index? WAS: strange table speed issue

y, June 25, 2004 10:56 AM To: [EMAIL PROTECTED] Subject: Why won't mysql use the index? WAS: strange table speed issue This is crazy. If someone can help me out, I'll pay them! A table: +--+-+-

RE: Why won't mysql use the index? WAS: strange table speed issue

al Message- From: MerchantSense [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:56 AM To: [EMAIL PROTECTED] Subject: Why won't mysql use the index? WAS: strange table speed issue This is crazy. If someone can help me out, I'll pay them! A table: +--+

Why won't mysql use the index? WAS: strange table speed issue

l Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 11:41 PM To: Marc Slemko Cc: MerchantSense; [EMAIL PROTECTED] Subject: Re: strange table speed issue I'm not certain, but I don't think a multi-column index will help here. The manual is uncle

RE: strange table speed issue

lto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 11:41 PM To: Marc Slemko Cc: MerchantSense; [EMAIL PROTECTED] Subject: Re: strange table speed issue I'm not certain, but I don't think a multi-column index will help here. The manual is unclear on how a multi-column index is used

Re: strange table speed issue

I'm not certain, but I don't think a multi-column index will help here. The manual is unclear on how a multi-column index is used when you are comparing the first key part to a range rather than to a constant, but I get the impression it doesn't use the second key part in that case. For you, t

RE: strange table speed issue

Yep, that's exactly what I did -Original Message- From: Sergio Salvi [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 10:55 PM To: [EMAIL PROTECTED] Subject: RE: strange table speed issue On Thu, 24 Jun 2004, MerchantSense wrote: > Yes, but I now have multi-column

RE: strange table speed issue

: Thursday, June 24, 2004 10:37 PM > To: Sergio Salvi > Cc: MerchantSense; [EMAIL PROTECTED] > Subject: Re: strange table speed issue > > > Sergio Salvi wrote: > > Hi! > > > > Can you send the output of the following command? > > > > show index from

Re: strange table speed issue

On Fri, 25 Jun 2004, Michael Stassen wrote: > > Sergio Salvi wrote: > > Hi! > > > > Can you send the output of the following command? > > > > show index from ip2org; > > > > It seems you don't have an index on both fields (even though it says you > > have multi-field index)... > > MUL doesn'

RE: strange table speed issue

ergio Salvi Cc: MerchantSense; [EMAIL PROTECTED] Subject: Re: strange table speed issue Sergio Salvi wrote: > Hi! > > Can you send the output of the following command? > > show index from ip2org; > > It seems you don't have an index on both fields (even though it says you &

Re: strange table speed issue

Sergio Salvi wrote: Hi! Can you send the output of the following command? show index from ip2org; It seems you don't have an index on both fields (even though it says you have multi-field index)... MUL doesn't mean part of a multi-field index. From the manual

RE: strange table speed issue

I added the multicolumn, and still have the same problem : mysql> explain SELECT org from ip2org where ip_start<=1094799892 and ip_end>=1094799892; ++--+---+--+-+--+-+- ---+ | table | type | possible_keys | key | key_len | ref | rows|

RE: strange table speed issue

On Thu, 24 Jun 2004, MerchantSense wrote: > Seems ok to me... > > It seems to be checking all the rows in the explain for some reason too... > > mysql> show index from ip2org; > +++--+--+-+---+- > +--++

RE: strange table speed issue

lto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 8:00 PM To: MerchantSense Cc: [EMAIL PROTECTED] Subject: Re: strange table speed issue Hi! Can you send the output of the following command? show index from ip2org; It seems you don't have an index on both fields (even though it says you ha

Re: strange table speed issue

Hi! Can you send the output of the following command? show index from ip2org; It seems you don't have an index on both fields (even though it says you have multi-field index)... []s, Sergio Salvi. On Thu, 24 Jun 2004, MerchantSense wrote: > Hi - I need some help :) > > I set up a simple my

strange table speed issue

Hi - I need some help :) I set up a simple mysql table: mysql> describe ip2org; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | ip_start | bigint(20) | | MU