Hello Ivan, I update Ubuntu 11.04 to the newest release and added a swap file.
Reading the literature, there should have been a swap file from the beginning. I have no empirically numbers, but it seems to help performance. I ran the entire conversion and upload process, and everything is working great. Notes: 1. Newest Ubuntu 11.04: http://uec-images.ubuntu.com/releases/11.04/release/ 2. Kernal update: I could not update the Ubuntu 11.04 kernal. I don't know if this is an Ubuntu/Amazon issue, or just don't know what I'm doing. I don't think it is a big deal, the OS is 2-6-38-11 instead of 2-6-39-0 3. Add Swap file that is twice (2x) the memory. https://help.ubuntu.com/community/DisklessUbuntuHowto#Adding_a_swap_file sudo apt-get install dphys-swapfile sudo losetup /dev/loop0 /var/swap sudo swapon /dev/loop0 Thanks for all the help! Malcolm -----Original Message----- From: Ivan Shcheklein [mailto:[email protected]] Sent: Wednesday, January 11, 2012 1:14 PM To: Malcolm Davis Cc: [email protected] Subject: Re: [Sedna-discussion] SEDNA diagnostics Malcolm, Would it make sense to dynamically adjust the buffers during updates? It can be very inconvenient if you run them often. Moreover, this won't solve the main problem (at least I think that this is the main reason) - memory consumption. It's quite possible to run several queries which require all available memory. Probably, you should try to create swap file: https://forums.aws.amazon.com/thread.jspa?threadID=53053 Does the command line -bufs-num override the -bufs-num value set in the dbname configuration file? Yes. BTW, what's the 'top' output when bug happens? Just to understand exact memory consumption by se_trn processes. Ivan ------------------------------------------------------------------------------ RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2 _______________________________________________ Sedna-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sedna-discussion
