RE: table locking with forking

> -----Original Message-----
> From: Jeremy Kister [mailto:perl-mysql@jeremykister.com]
> Sent: Tuesday, September 18, 2007 11:44 PM
> To: perl@lists.mysql.com
> Subject: table locking with forking
>
> I'm having issues with locking and forking code. I've consolidated the
> problem into the below example code.

I played around with this, and came up with the attached code. The key was using InnoDB with commit() in the right place.

I don't understand the behavior of the original script; it looks like the INSERT from the child process gets queued up by MySQL, and the killing of the child doesn't affect it.

-- 
MySQL Perl Mailing List
For list archives: 
http://lists.mysql.com/perl
To unsubscribe:    
http://lists.mysql.com/perl?unsub=lists@pantek.com