-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Fredrik Carlsson wrote:
>>
>>>
>>>
>>> I would be interested in a ktruss of this mysqldump to see what it's
>>> doing.  Have you tried dumping to stdout and just redirecting?
>>>
>>
>> Sorry- Do this first:
>> Can you also try with options --quick?  The --skip-opt is causing
>> mysqldump to attempt dumping to memory first and then to disk (I
>> assume this minimizes the time tables are locked).
>>
>> If you want dumping to memory and it's failing around 2GB, then maybe
>> you have a 32bit issue?
>>
>>
> 
> Its the same problem if we only use --quick (-q) and not --skip-opt
> 
> ktruss -d -o ktruss.out sh backup_mysql-test.sh
> mysqldump: Error 5: Out of memory (Needed 14727464 bytes) when dumping
> table `table` at row: 2644266
> 
> I have attached a dump of the ktruss from my last run.
> 
> // Fredrik
> 
Fredrik Carlsson wrote:
>>
>>>
>>>
>>> I would be interested in a ktruss of this mysqldump to see what it's
>>> doing.  Have you tried dumping to stdout and just redirecting?
>>>
>>
>> Sorry- Do this first:
>> Can you also try with options --quick?  The --skip-opt is causing
>> mysqldump to attempt dumping to memory first and then to disk (I
>> assume this minimizes the time tables are locked).
>>
>> If you want dumping to memory and it's failing around 2GB, then maybe
>> you have a 32bit issue?
>>
>>
> 
> Its the same problem if we only use --quick (-q) and not --skip-opt
> 
> ktruss -d -o ktruss.out sh backup_mysql-test.sh
> mysqldump: Error 5: Out of memory (Needed 14727464 bytes) when dumping
> table `table` at row: 2644266
> 
> I have attached a dump of the ktruss from my last run.
> 
> // Fredrik
> 

 	
> 	/usr/pkg/bin/mysqldump -h localhost -B database --quick -u backuper -pXXX > /storage/vol1/backup\
> 	/mysql/all-sql.sql.new 
	
I think that you should post here ktruss output from this command and not from
script.

Regards
- ---------------------------------------------------------------
Adam Hamsik
ICQ 249727910
jabber haad@jabber.org
- ---------------------------------------------------------------
There are 10 kinds of people in the world. Those who understand
binary numbers, and those who don't.
				
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (NetBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGPaAH9Wt2FT7y228RAiezAJ9uTbUg5fzXMdsWwyPhy/2//c0TTwCfZByQ
f7AAbpUqMNrFvWY6E7fi/Do=
=7KVW
-----END PGP SIGNATURE-----