Useful for looking at the raw data.
mysqldump --extended-insert=FALSE
Be aware that multiple inserts will be slower than one big insert.
Useful for looking at the raw data.
mysqldump --extended-insert=FALSE
Be aware that multiple inserts will be slower than one big insert.
As root:
/etc/init.d/syslog stop
echo 1 > /proc/sys/vm/block_dump
dmesg | egrep "READ|WRITE|dirtied" | egrep -o '([a-zA-Z]*)' | sort | uniq -c | sort -rn | head
Sample output
I hereby claim:
To claim this, I am signing this object:
In the MongoDB configuration file add the following line:
smallfiles=true
The safety shut off MongoDB and remove the journal files.
Full procedure:
Example is the coin Zimstake and this commit:
mapCheckpoints:
+ ( 16996,uint256("0x408084c7299169168ab371ff0e049c6bba09d03636c1618b924444260cc32edd"))
$ codesign -dvvv Bitcoin-Qt.app
Executable=/Applications/Bitcoin-Qt.app/Contents/MacOS/Bitcoin-Qt
Identifier=org.bitcoinfoundation.Bitcoin-Qt
Format=bundle with Mach-O thin (x86_64)
CodeDirectory v=20100 size=153121 flags=0x0(none) hashes=7649+3 location=embedded
Hash type=sha1 size=20
CDHash=68b2974f209336f9b90a2435768a0ebac4d3b945
Signature size=8544
Authority=Developer ID Application: BITCOIN FOUNDATION, INC., THE
sudo dd if=/dev/zero of=/mnt/myswapfile bs=1M count=1024
ls -l /mnt/myswapfile
sudo chmod 600 /mnt/myswapfile
sudo mkswap /mnt/myswapfile
sudo swapon /mnt/myswapfile
sudo vi /etc/fstab
Verifying myself: My Bitcoin username is +jyap. https://onename.io/jyap |
Swap should take place on the Instance Storage (ephemeral) disk and not an EBS device. Swapping will cause a lot of IO and will increase cost on EBS. EBS is also slower than the Instance Store and the Instance Store comes free with the EC2 Instance.
It will usually be mounted to /mnt but if not run
sudo mount /dev/xvda2 /mnt
To then create a swap file on this device do the following for a 4GB swapfile