Hello,
can you tell me why my this query doesn't use the index?
mysql> explain select * from iploc where 1902800418 between start_ip
and end_ip;
++-+---+--+---+--+-+--+---+-+
| id | select_type | table | type | possible_keys | k
SQL> select * from orddd;
ORDERID PRODID
-- --
2 5
1 3
1 2
2 7
1 5
SQL> select prodid,count(*) from orddd group by PRODID having count(*) > 1;
PRODID COUNT(*)
-- --
On 7/12/2012 1:49 PM, John Nichel wrote:
Hi all,
Lets say I have a table with two colums: 'orderid' and 'productid'. This
table contains line items for purchases in a store where a purchase could
be 1 or more line items (1 or more rows). A typical order may look like
this:
orderid | productid
Hi all,
Lets say I have a table with two colums: 'orderid' and 'productid'. This
table contains line items for purchases in a store where a purchase could
be 1 or more line items (1 or more rows). A typical order may look like
this:
orderid | productid
12345 | 9876
12345 | 6789
12345 | 76
On Wed, Jul 11, 2012 at 5:30 PM, Sergei Petrunia wrote:
> I can provide a refutation. Ability to make a combined index access of
>
> 1. Equality with a non-constant: t.sec_id= p.sec_id
> 2. non-equality comparison with constants, trade_time IN ('2012-07-01',
> '2012-07-02')
>
> has been discussed
Thanks for the guidance and references, Shawn.
On Wed, Jul 11, 2012 at 3:37 PM, Shawn Green wrote:
>
> Ranged scans only happen for the last portion of an index being used. OR
> queries (or those using IN) can also only be applied to the last part of an
> index search. This means that if you are
Hi,
Lately I got this messgae in my errorLog file, need more datails why the DB
was restarted!
120711 19:42:06 mysqld restarted
120711 19:42:06 [Warning] Asked for 196608 thread stack, but got 126976
120711 19:42:07 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
I
