Thank you to those of you who replied. Interesting experience.
I was uploading a data dump into MySql. My "Konsole" did not show any
activity for about an hour and a half. Then I get the message "Write
failed: Broken pipe".
This morning I erased the database I had uploaded last night because
there was no way to tell if the import was complete.
The import was about 600MB.
Last night I had added "ServerAliveInterval 5" to my sshd config.
This morning when I did the upload it took about 3 minutes. It looks
like all the data is there. That means my shell must have been hung for
well over an hour.
Thanks again for all the ideas and feedback!!
Keith
On 2014-11-04 10:40, der.hans wrote:
> Am 04. Nov, 2014 schwätzte Keith Smith so:
>
> moin moin Keith,
>
>> Last night I shelled into a web server I am working on and issue the
>> command to upload data into MySql from the command line. The process
>> took about an hour and a half.
>>
>> Then I received the message "Write failed: Broken pipe". In
>> researching, apparently sshd timed out.
>>
>> I'm guessing the process completed... But how would I know?
>
> Check MySQL to see if all of the data loaded.
>
> The ssh connection was killed, so you don't know how the shell did.
>
> If you need to run long commands on remote systems, use screen or tmux
> on
> the remote system. That will keep the shell running even if the network
> connection is killed. It also allows you to reconnect to the shell.
>
> screen -S mysession # Start a screen session named mysession
> screen -x mysession # reconnect to the screen session named mysession
>
> <ctrl>-a d # disconnect from an active screen session
>
> If you already run screen locally you can either run screen within
> screen
> or you can start a new xterm, then connect out.
>
> I also recommend the ServerAliveInterval, but I set it to 5 minutes. I
> used that for all ssh connections.
>
> ServerAliveInterval 300
>
> ciao,
>
> der.hans
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
--
Keith Smith
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss 
(text/plain)