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 char(3), locki
At 12:43 AM 8/30/2011, mysql-plain-digest-h...@lists.mysql.com wrote:
>Not useful to add an index for that. I also wonder why the value is null
>(meaning: unknown, not certain) for almost all records.
It depends on if you want the forest or the trees. A frequently executed
query asks for just t
There are a few things gonig on, but mainly it is the ORs that are killing
you.
As your require OR to examine two distinct columns, both of equal relevance
to the query, MySQL: is left with no choice but to do a full table scan on
what might be (at a guess) a very larger table. No amount of inde
Hello,
I have the following query I'd like to optimize a bit:
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,
Hello guys,
after upgrading from MySQL 5.1 to 5.5 we encounter a problem that C++
exceptions thrown in an UDF are not catched at all. Even there is a
"catch (... )" at the end
or our try block which avoids exceptions to be thrown outside of the
UDF, the server crashes with:
terminate called
