X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:to:from:subject:message-id:date:mime-version
	:content-type:content-transfer-encoding; q=dns; s=default; b=Hv8
	k++ZoSM5UxQ7yryVoSh0AdSG4ce/G3f6olyf5TdMk4Gmnk7pwjPQIBwEZHUcONYQ
	jmbiGexH0k2ElPCKSYFev1ynmdY5MrOjT9Va2rtAALIsam1fBEndncwhA6hdB3dl
	TyP4o1TBAAd3UywRBrNZB3ohli4rQhhYUhuTIa2A=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:to:from:subject:message-id:date:mime-version
	:content-type:content-transfer-encoding; s=default; bh=sx4Sjctl3
	svf6Lrae68FOQCJ3G0=; b=cxmjvnALgWch57xnuf7CuEGRaQWzskDic86EaFNv8
	M8ocfiWO9fdPpMW8DXebmH9ucTWox+hbzQZMLHnLOLSA9ruLYOn4yYNcRxjHISba
	PRk39nQKIZtfwi0C5B+QXCXcwbUPmkfgejXpwwPBgMsvh2iQ/k6ofHw3RsPM33tm
	yo=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Authentication-Results:	sourceware.org; auth=none
X-Virus-Found:	No
X-Spam-SWARE-Status:	Yes, score=5.6 required=5.0 tests=AWL,BAYES_50,FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,SPAM_SUBJECT,SPF_NEUTRAL autolearn=no version=3.3.2
X-HELO:	pbmail.coopexsoft.sk
To:	cygwin AT cygwin DOT com
From:	"V.99" <v DOT 99 AT seznam DOT cz>
Subject:	mysql - poor performance when restoring from large mysqldump backup
Message-ID:	<55907088.70901@seznam.cz>
Date:	Mon, 29 Jun 2015 00:09:12 +0200
User-Agent:	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.0.1
MIME-Version:	1.0
X-CoopexSoftPB-MailScanner-Information:	Please contact the ISP for more information
X-CoopexSoftPB-MailScanner-ID:	F11A39F69C.AFD37
X-CoopexSoftPB-MailScanner:	Found to be clean
X-CoopexSoftPB-MailScanner-From:	v DOT 99 AT seznam DOT cz

Hello.

I am trying to restore a backup of our database in order to examine the 
data state three weeks ago.
Backup is 1GB large SQL text file created by mysqldump.
After many attempts I found this:
Processing of backup file runs fluently in the beginning, several tables 
are successfully restored, including table event_log 3x10e6 row big.
Processing hangs after cca one hour of run during insert-s to table 
student_grade - this is approx 6x10e6 row big. (Exact place differs in 
every attempt.)
Mysqld process is running as before: 13%CPU, 187MB RAM, but HDD activity 
is now very low. Open connection to mysqld is not possible. I was 
waiting that mysqld will recover more than six hours, but the situation 
has not improved.
All this occurs on my workstation Intel(R) Core(TM) i7-4700MQ CPU @ 
2.40GHz, 16GB RAM, Windows 7 Professional x64, Cygwin 32-bit, mysql Ver 
14.14 Distrib 5.5.41, for CYGWIN (i686) using readline 6.3.

On the other hand I tried to restore the same backup file on linux 
machine (Pentium(R) Dual-Core  CPU E5300  @ 2.60GHz, 4GB RAM, CentOS 
release 6.6 (Final), 32-bit, mysql  Ver 14.14 Distrib 5.1.73, for 
redhat-linux-gnu (i386) using readline 5.1).
Whole database was successfully restored after cca two and half hours of 
run.

Can I tweak something in mysql or cygwin to improve restore (inserts) 
performance?
Any other suggestions, please?

-- 

.: Vlado :.


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

- Raw text -