You can see all running queries in live time with: $> mysqladmin -u dbuser -p123 -i 2 processlist The option -i determines the number of seconds between refreshes(alias –sleep=DELAY).
Arch Linux is a very clean and lightweight Linux distribution. With the following steps you can install it on a SD-Card to run it on a Raspberry Pi: Get the device name (dev-path) of the SD-Card to run the operating system (see Get a list of partitions or List, partitioning and format drives) $> sudo fdisk -l […]
In earlier Magento versions it was quite difficult to set or read store specific values on entities. In most cases you have to set the store on the whole application instance like that: <?php Mage::app(STOREID)->setStore(STOREID); … $oProduct->setStore(STOREID); … $oCollection->setStore(STOREID); Sometimes it was even necessary to add the store to entities or collections it-selves too. Now (at least […]
To append all contents of textfile1.txt to the end of textfile2.txt: $> cat textfile1.txt >> textfile2.txt or to add text directly to the end of the file, you can use: $> echo “TEST” >> testfile.txt
To copy a SD-Card to another one including all partitions yo can take the following steps: Find out the device name (f.e.: /dev/mmcblk0): see List, partitioning and format drives or see Get a list of partitions or see Get free disk space and partitions Copy the whole card to an imagefile (Backup): $> sudo dd if=/dev/mmcblk0 of=backup_pi.img bs=4M […]
Here are some nice Apache configuration entries that will increase your website performance. They can be placed in a .htaccess file: <IfModule mod_headers.c> ## # Add a Vary Accept-Encoding header for the compressed resources. If you # modify the file types above, make sure to change them here accordingly. ## Header unset ETag # Header set […]
Recently I brought this assembly kit Bluetooth led clock at Banggood: http://www.banggood.com/DIY-AT89S52-Rotation-LED-Electronic-Clock-Kit-51-SCM-Learning-Board-p-965849.html Here are some pictures showing the process: The assembly was relatively easy. Except the SMD leds, resistors, transistors and capacitors! They were a little bit harder to solder. Unfortunately the Bluetooth feature didn’t work with my actual mobile phone, that has Android 4.4 […]
A nice little tool to format your JSON objects, if you had no suitable editor ready to hand. http://jsonformatter.curiousconcept.com/