Archives
-
Recent Comments
Category Archives: 4QuickLookUp
MongoDB distinct count
List of disctinct values for a FIELD in COLLECTION: db.COLLECTION.distinct(“FIELDNAME”, {}) Count of the same: db.COLLECTION.distinct(“FIELDNAME”, {}).count
Posted in 4QuickLookUp
Leave a comment
How to move MySQL storage to RamFS or TmpFS partition
Whether moving all MySQL storage to a tmpfs helps with speeding it up or not is questionable but I needed to do for some testing purposes, so this is a short overview of how I did that hopefully will be … Continue reading
Posted in 4QuickLookUp, Just messing..., Linux/UNIX
Tagged mysql, performance, ramfs, tmpfs
2 Comments
Apache 2 and HTTP Authentication with PAM
There are 2 ways(at least that I know of) to get Apache 2 to use PAM for http auth: Old mod_auth_pam, which I believe is not developed anymore and also posses some security risks Newer mod_authnz_external and pwauth This little … Continue reading
How to play a .ogv file
Lately I’ve been putting together a lot of videos and all of them in OGV format(for obvious reasons ). Sharing those with my ‘Windows’ friends often raises the same question – “How do I play those ogv files?” Here is … Continue reading
Posted in 4QuickLookUp
Leave a comment
Installing Mercurial 1.5, 1.6 or 1.7 on Ubuntu Lucid Lynx 10.04
Lycid Lynx’ repository by default set to install Mercurial 1.4.x, which is great, but as of today that’s already 3 major releases behind To get yourself on the latest and greatest version of Mercurial there are 2 options: build from … Continue reading
Advanced Web Ranking on Ubuntu: Fixing “SQLite Could Not Be Found” Issue
“SQLite Could Not Be Found Issue” that you see when running AWR on 64bit Linux(in my case Ubuntu 10.04 ) is caused by the fact that AWR relies on 32bit JRE(you can read about this on AWR’s forum). Problem could … Continue reading
Posted in 4QuickLookUp, Linux/UNIX
3 Comments
MySQL5 TINYINT, SMALLINT, MEDUIMINT, INT, BIGINT boundaries
From MySQL Documentation, boundaries of the numerical types are as follows: Type Min Value Max Value Bytes TINYINT -128 127 1 TINYINT UNSIGNED 0 255 1 SMALLINT -32,768 32,767 2 SMALLINT UNSIGNED 0 65,535 2 MEDIUMINT -8,388,608 8,388,607 3 MEDIUMINT … Continue reading
Find and Replace Across Multiple Files
Need to replace broken links across 1000 html files? If you’re using linux/unix/macosx it’s just fire up the terminal and use this: find -iname “*.htm” -exec sed -i ‘s/search/replace/’ {} \; search – is regex(or a string in the simplest … Continue reading