phil has a blog

ogr2ogr: error while loading shared libraries: libgdal.so.1

Tue, 29 Apr 2014 15:03:48 +0100

ogr2ogr: error while loading shared libraries: libgdal.so.1: cannot open shared object file: No such file or directory

Just run
sudo ldconfig

osx - Can't install Brew formulae correctly (Permission denied in /usr/local/lib) - Super User

Tue, 08 Apr 2014 15:42:07 +0100

osx - Can't install Brew formulae correctly (Permission denied in /usr/local/lib) - Super User:

sudo chown -R `whoami` /usr/local

mysql LOAD DATA INFILE speed config tests

Tue, 25 Mar 2014 23:08:00 +0000

Desktop tests
2.8 GHz Intel Core 2 Duo
4GB 667 MHz DDR2 SDRAM
Fresh 5.6.16 MySQL Community Server install - no configs made
–

Test set:
http://datagov.ic.nhs.uk/presentation/2013_11_November/T201311PDPI+BNFT.CSV

Test 1 - LOAD DATA INFILE vs LOAD DATA LOCAL INFILE

mysql> LOAD DATA INFILE ‘T201311PDPI+BNFT.csv’ INTO TABLE pres FIELDS TERMINATED BY ’,’ ENCLOSED BY ’“’ LINES TERMINATED BY ’\n’ IGNORE 1 LINES (SHA,PCT,PRACTICE,BNF_CODE,BNF_NAME,ITEMS,NIC,ACT_COST,QUANTITY,PERIOD,@dummy);
Query OK, 10053266 rows affected (2 min 49.10 sec)

mysql> LOAD DATA LOCAL INFILE ’~/Desktop/T201311PDPI+BNFT.csv’ INTO TABLE pres FIELDS TERMINATED BY ’,’ ENCLOSED BY ’”’ LINES TERMINATED BY ’\n’ IGNORE 1 LINES (SHA,PCT,PRACTICE,BNF_CODE,BNF_NAME,ITEMS,NIC,ACT_COST,QUANTITY,PERIOD,@dummy);
Query OK, 10053266 rows affected (3 min 35.55 sec)

conclusion: LOAD DATA INFILE significantly faster.

Test 2 - compact vs compressed with LOAD DATA INFILE
head -n 1000001 T201311PDPI+BNFT.CSV > 1m.csv
my.cnf
innodb_file_format=Barracuda
innodb_file_per_table=1

Query OK, 1000000 rows affected (14.67 sec)
=
125.7 MiB compact

Query OK, 1000000 rows affected (23.37 sec)
=
53.8 MiB compressed, key_block_size = 8

Query OK, 1000000 rows affected (52.45 sec)
=
47 MiB compressed, key_block_size = 4

conclusion: 8K compression saves a lot of space and only takes slightly longer to import
ALTER TABLE pres ROW_FORMAT=COMPRESSED, KEY_BLOCK_SIZE=8;

Test 3 - Messing with recommended config settings with LOAD DATA INFILE

No config changes from default
mysql> LOAD DATA INFILE 'T201311PDPI+BNFT.csv’ INTO TABLE pres FIELDS TERMINATED BY ’,’ ENCLOSED BY ’“’ LINES TERMINATED BY ’\n’ IGNORE 1 LINES (SHA,PCT,PRACTICE,BNF_CODE,BNF_NAME,ITEMS,NIC,ACT_COST,QUANTITY,PERIOD,@dummy);
Query OK, 10053266 rows affected (2 min 49.10 sec)

Each tested independently.

SET FOREIGN_KEY_CHECKS=0;
Query OK, 10053266 rows affected (2 min 44.19 sec)

SET UNIQUE_CHECKS=0;
Query OK, 10053266 rows affected (2 min 45.89 sec)

innodb_autoinc_lock_mode = 2 // my.cnf
Query OK, 10053266 rows affected (2 min 49.38 sec)

SET SESSION tx_isolation='READ-UNCOMMITTED’
Query OK, 10053266 rows affected (2 min 47.76 sec)

both
SET FOREIGN_KEY_CHECKS=0;
SET UNIQUE_CHECKS=0;
Query OK, 10053266 rows affected (2 min 50.38 sec) WTF

SET SQL_LOG_BIN=1; // testing on as other tests ran with default off
Query OK, 10053266 rows affected (4 min 26.61 sec)

conclusion: very minimal gain from altering them on 10m rows other than the obvious log_bin should be off, testing needed with larger sets 500m+ and powerful servers.

–
CREATE TABLE IF NOT EXISTS `pres` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`SHA` varchar(3) DEFAULT NULL,
`PCT` varchar(3) DEFAULT NULL,
`PRACTICE` varchar(6) DEFAULT NULL,
`BNF_CODE` varchar(15) DEFAULT NULL,
`BNF_NAME` varchar(40) DEFAULT NULL,
`ITEMS` int(7) DEFAULT NULL,
`NIC` decimal(10,2) DEFAULT NULL,
`ACT_COST` decimal(10,2) DEFAULT NULL,
`QUANTITY` int(7) DEFAULT NULL,
`PERIOD` varchar(24) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

shell - How to display current path in command prompt in linux's sh (not bash)? - Super User

Tue, 04 Mar 2014 15:43:38 +0000

shell - How to display current path in command prompt in linux's sh (not bash)? - Super User:

sh-4.2$ export PS1=“\[\e]0;\u@\h: \w\a\]${debian_chroot:+($debian_chroot)}\u@\h:\w\$”

shell - How to display current path in command prompt in linux's sh (not bash)? - Super User

Tue, 04 Mar 2014 15:43:12 +0000

shell - How to display current path in command prompt in linux's sh (not bash)? - Super User:

http://superuser.com/questions/601181/how-to-display-current-path-in-command-prompt-in-linuxs-sh-not-bash

Fiddle

Wed, 26 Feb 2014 22:38:16 +0000

Fiddle

http://www.muleradio.net/thebigwebshow/

Wed, 26 Feb 2014 22:25:51 +0000

http://www.muleradio.net/thebigwebshow/

Changing File Permissions « WordPress Codex

Wed, 26 Feb 2014 21:46:00 +0000

Changing File Permissions « WordPress Codex

php imap ubuntu - not working solution

Fri, 14 Feb 2014 11:54:48 +0000

ln -s /etc/php5/conf.d/imap.ini /etc/php5/mods-available/imap.ini
php5enmod imap
service apache2 restart

Source
http://askubuntu.com/questions/362082/php-is-not-working-well-on-ubuntu-13-10-and-mcrypt-is-missing-in-phpmyadmin

Bootswatch: Journal

Tue, 11 Feb 2014 20:52:25 +0000

Bootswatch: Journal

Schedule Tasks on Linux Using Crontab | kvz.io

Fri, 07 Feb 2014 14:24:25 +0000

Schedule Tasks on Linux Using Crontab | kvz.io:

Kevin van Zonneveld on writing apps and their ecosystems.

mysql reads rows from a text file into a table at a very high speed

Tue, 04 Feb 2014 14:57:44 +0000

LOAD DATA INFILE ‘file.csv’ INTO TABLE xxxx FIELDS TERMINATED BY ’,’ ENCLOSED BY ’“’ LINES TERMINATED BY ’\n’ IGNORE 1 LINES (col1,col2,col3);

Fixing no sound through headphones on 27" iMac with Ubuntu

Tue, 04 Feb 2014 14:56:28 +0000

sudo gedit /etc/modprobe.d/alsa-base.conf

add
options snd-hda-intel model=imac27_122

ubuntu mighty mouse scroll speed

Mon, 16 Dec 2013 11:00:48 +0000

sudo rmmod hid_magicmouse
sudo modprobe hid_magicmouse scroll-speed=55 scroll-acceleration=5

Lion like scrolling on Ubuntu – Inverse scrolling on Linux | Andy Barratt - Professional Geek

Mon, 16 Dec 2013 11:00:20 +0000

Lion like scrolling on Ubuntu – Inverse scrolling on Linux | Andy Barratt - Professional Geek:

[caption id=attachment_606 align=alignright width=175 caption=Lion, the latest operating sytem for mac from Apple.][/caption] Any one who has

bluetooth - Apple Magic Mouse and ubuntu

Tue, 10 Dec 2013 13:14:39 +0000

bluetooth - Apple Magic Mouse and ubuntu:

sudo apt-get install blueman

sudo reboot

gnome3 snippets

Fri, 06 Dec 2013 11:27:00 +0000

sudo apt-get install gnome-shell ubuntu-gnome-desktop
sudo apt-get install gnome-tweak-tool

http://itsfoss.com/things-to-do-after-installing-ubuntu-13-10/

Create a Windows 8 USB Installer on 10.9 Using BootCamp (Also Windows 7)

Mon, 25 Nov 2013 19:42:53 +0000

Create a Windows 8 USB Installer on 10.9 Using BootCamp (Also Windows 7):

In terminal, run the following command without the quotes: “sudo codesign -fs - /Applications/Utilities/Boot\ Camp\ Assistant.app” I did not mention it in th…

[ubuntu] How to fix the "/var/log/jockey.log" wifi driver problem

Mon, 25 Nov 2013 09:55:01 +0000

[ubuntu] How to fix the "/var/log/jockey.log" wifi driver problem:

install

broadcom-sta-common
broadcom-sta-source
bcmwl-kernel-source

and reboot

rename files in directory to lowercase linux

Thu, 21 Nov 2013 10:04:37 +0000

rename ‘y/A-Z/a-z/’ *