Re: Query Optimization

2011-09-01 Thread Jochem van Dieten
On Aug 30, 2011 6:46 PM, "Brandon Phelps" wrote: > SELECT >sc.open_dt, >sc.close_dt, >sc.protocol, >INET_NTOA( sc.src_address ) AS src_address, >sc.src_port, >INET_NTOA( sc.dst_address ) AS dst_address, >sc.dst_port, >sc.sent, >

Re: Query Optimization

2011-09-01 Thread Brandon Phelps
On 09/01/2011 04:59 AM, Jochem van Dieten wrote: > > SELECT > >sc.open_dt, > >sc.close_dt, > >sc.protocol, > >INET_NTOA( sc.src_address ) AS src_address, > >sc.src_port, > >INET_NTOA( sc.dst_address ) AS dst_address, > >sc.dst_port, > >

RE: locked non-existent row

2011-09-01 Thread Jerry Schwartz
>-Original Message- >From: Peter Brawley [mailto:peter.braw...@earthlink.net] >Sent: Wednesday, August 31, 2011 10:40 AM >To: r...@grib.nl; mysql@lists.mysql.com >Subject: Re: locked non-existent row > >On 8/31/2011 4:50 AM, Rik Wasmus wrote: >>> While a transaction in one thread tries to u

Re: locked non-existent row

2011-09-01 Thread Rik Wasmus
> >-Original Message- > >From: Peter Brawley [mailto:peter.braw...@earthlink.net] > >Sent: Wednesday, August 31, 2011 10:40 AM > >To: r...@grib.nl; mysql@lists.mysql.com > >Subject: Re: locked non-existent row > > > >On 8/31/2011 4:50 AM, Rik Wasmus wrote: > >>> While a transaction in one t

Re: locked non-existent row

2011-09-01 Thread Peter Brawley
On 9/1/2011 9:46 AM, Rik Wasmus wrote: -Original Message- From: Peter Brawley [mailto:peter.braw...@earthlink.net] Sent: Wednesday, August 31, 2011 10:40 AM To: r...@grib.nl; mysql@lists.mysql.com Subject: Re: locked non-existent row On 8/31/2011 4:50 AM, Rik Wasmus wrote: While a trans

Re: Query Optimization

2011-09-01 Thread Shawn Green (MySQL)
On 9/1/2011 09:42, Brandon Phelps wrote: On 09/01/2011 04:59 AM, Jochem van Dieten wrote: > > ... > > WHERE > > (open_dt >= '2011-08-30 00:00:00' OR close_dt >= '2011-08-30 00:00:00') > > AND (open_dt <= '2011-08-30 12:36:53' OR close_dt <= '2011-08-30 12:36:53') > In that case your logic

Re: Query Optimization

2011-09-01 Thread Brandon Phelps
On 09/01/2011 12:47 PM, Shawn Green (MySQL) wrote: On 9/1/2011 09:42, Brandon Phelps wrote: On 09/01/2011 04:59 AM, Jochem van Dieten wrote: > > ... > > WHERE > > (open_dt >= '2011-08-30 00:00:00' OR close_dt >= '2011-08-30 00:00:00') > > AND (open_dt <= '2011-08-30 12:36:53' OR close_dt <= '20

RE: locked non-existent row

2011-09-01 Thread Jerry Schwartz
>> The ability to lock non-existent records is critical. > >I concur, although this is just a transaction consisting of 1 statement :). >-- [JS] As the Three Musketeers used to say, "One for all and all for one!" Peter, I couldn't even //understand// that paragraph about key gaps. The document wr