Showing entries 1 to 3
Displaying posts with tag: beer (reset)
Magic deadlock: what locks are really set by InnoDB?

Megabytes of text had been written already on InnoDB locking and deadlocks. Still, even very simple cases of deadlocks while working with a table having only one row sometimes make people wonder what happened and why.

Today I want to check if this topic is explained well in the manual and existing blog posts and understood properly. So, it's an exercise for my dear readers and those who like to report bugs as much as I do.

Let's consider a very simple example. In session #1 with default transaction isolation level execute the following:
  `id` int(11) NOT NULL,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `c1` (`c1`)
insert into tt values(1,1); -- insert a row there
select * from tt; -- check that we have row (1,1)
begin work;
select * from tt …

[Read more]
SkySQL Solutions day on Friday April 26! Free! As in free beer! Really!

Yes, Percona Live ends on Thursday, but on friday. at the same location, there is SkySQL Solutions day. Attendance is free, and among the highlights yours truly will be speaking! Register here for this free event: Another highlight of this is that it ends with a Biergarten. Free!


FOSDEM 2013, another nice open source event in Europe!
FOSDEM is a free event that offers open source communities a place to meet, 
share ideas and collaborate.
It is renowned for being highly developer-oriented 
and brings together 5000+ geeks from all over the world.

This year again, be sure that FOSDEM will be the place to be in February!

Do you have any doubts? Really ? Dude, repeat after me :

  1. Free event
  2. During a week-end
  3. Beer
  4. 5000+ open source geeks
  5. Beer
  6. MySQL and Friends devroom
  7. NoSQL devroom
  8. No registration needed (open source man!)

Ok, that sounds good?

Well, here are the informations to attend this terrific event :

  • How to register? : Are you kidding me?
  • When : 2 & 3 February 2013 (Hurry up guys!)
  • Where : Brussels (beers!!!)
  • Website …
[Read more]
Showing entries 1 to 3