hi list,
i have a very strange effect.
I have two boxes with the same DB ( same version, same tables, same my.cnf, etc)
I was trying to optimise an sql statement and used desc to see what is going on
and found to my surprise two different results.
Can this be the result of the optimizer ? (the bo
> While a transaction in one thread tries to update a non-existent InnoDB
> row with a given key value, an attempt to insert that value in another
> thread is locked out. Does anyone know where this behaviour is documented?
>
> -- connection 1
> drop table if exists t;
> create table t( lockid cha
- Original Message -
> From: "Dave Dyer"
>
> It depends on if you want the forest or the trees. A frequently
> executed query asks for just the robots. An index is an efficient way to
> select 6 of 20,000. As for why the rest are null, null is just a a
> random everything else value, l
Exactly the same data, too? Different index leaf distribution might account for
something like this, and it does look like you're retrieving different datasets.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--
MySQL General Mail
Am 31.08.2011 13:51, schrieb Johan De Meersman:
> Exactly the same data, too? Different index leaf distribution might account
> for something
>like this, and it does look like you're retrieving different datasets.
>
same data
think of it as a backup.
re,
wh
--
MySQL General Mailing List
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a transaction in one thread tries to update a non-existent InnoDB
row with a given key value, an attempt to insert that value in another
thread is locked out. Does anyone know where this behaviour is documented?
-- connection 1
drop table if exists t
On Wednesday 31 August 2011 16:39:52 Peter Brawley wrote:
> >> While a transaction in one thread tries to update a non-existent InnoDB
> >> row with a given key value, an attempt to insert that value in another
> >> thread is locked out. Does anyone know where this behaviour is
> >> documented?
> >
