Re^2: Trouble opening FIFO for speedy MySQL loading

Yes, I've read that but I'm having trouble demonstrating what it really means.

Are you saying that the open statement will complete once I begin reading from the file?

I did try running the load data infile statement while the script was hanging at open but nothing happened.

Any help would be appreciated. Thanks.

Comment on Re^2: Trouble opening FIFO for speedy MySQL loading

Replies are listed 'Best First'.
Re^3: Trouble opening FIFO for speedy MySQL loading by Illuminatus (Curate) on Nov 04, 2008 at 18:03 UTC
I would need to see exactly what you are trying in order to comment. I created the following script: `#!/usr/bin/perl -w use strict; use IO::File; my $fifo = "fifo"; sysopen(FIFO, $fifo, O_RDONLY) or die "can't read $fifo: $!"; close FIFO;` [download] I kicked off your script in background, where it hung. When I run this script, the original script (the one you previously posted) exits, indicating that the open completed.	[reply] [d/l]

Replies are listed 'Best First'.

#!/usr/bin/perl -w
use strict;
use IO::File;

my $fifo = "fifo";
sysopen(FIFO, $fifo, O_RDONLY) or die "can't read $fifo: $!";
close FIFO;
[download]