Mindblown: a blog about philosophy.

  • YouTube video uploader

    YouTube with that many videos uploaded and yet they have a pretty bad interface for upload (comparing to flickr). The newer Multi-Uploader needs to install into your computer and yet still provide a broken web interface (TRANSIENT_ERROR) and would not upload but keep trying (keep cycling through the process), I tried it in different browsers…

  • X10 Toys

    Some notes when I try to play with a bunch of X10 devices, XX20A (XC22A camera) is B/W, advertised to see 3x more than XCam2 color cameras but subjectively I don’t think it’s that good, also, it does not see as wide as the XC19A (Wide-Eye, which now turns out to be pretty good). Another…

  • US zipcode database in SQL format

    Don’t remember where I got this file, but might be useful for some: us.zipcodes.sql

  • Debugging PowerDNS

    Run “service pdns monitor” and it will show the live running stats, very useful for debugging geobackend. Sample Output [root@s203 fold]# service pdns monitor Dec 17 18:59:29 [GeoBackend] This is the geobackend (Aug 30 2007, 15:24:28 – $Revision: 1.1 $) reporting Dec 17 18:59:29 This is a standalone pdns Dec 17 18:59:29 UDP server bound…

  • Wholesale domain registration prices increased

    It’s been over a month to report but the wholesale prices of domain name for major extensions (.COM, .NET, .ORG, .INFO, .BIZ) increased by about 50 cents/year. For the majority of people with several names, it would not make a different, for those with hundreds or thousands, it’s a more significant impact. The trend for…

  • MySQL – Join changes starting 5.0.12

    If a SQL suddenly die after an upgrade, check your query and the changes to the JOIN, especially this could cause “Unknown column ‘X.XX’ in ‘on clause’ “. The reason being before 5.0.12, the comma operator and JOIN both had the same precedence, so the join expression t1, t2 JOIN t3 was interpreted as ((t1,…

  • Yahoo Search Marketing $100 Promo Coupon

    For new self-service accounts with minimum $30 deposit (meaning you get $130 for $30). Coupon: US2245 Link: http://searchmarketing.yahoo.com/arp/choose.php?o=US2245

  • Load balancing FastCGI

    Run this command on a worker spawn-fcgi -p 8081 -a 192.168.2.100 -f /usr/bin/php-cgi -u lighttpd -g lighttpd -C 5 -P /var/run/spawn-fcgi-8081.pid Don’t forget to open up the right port (8081 in the example) and monitor the processes (say restart when it dies) Reference http://www.cyberciti.biz/tips/lighttpd-mod_proxy-to-run-php-fastcgi-app-server.html Bind to a socket spawn-fcgi -s /tmp/php-fastcgi-ext.sock -f /usr/bin/php-cgi -u lighttpd…

  • MySQL slaves catch up with master

    Even if running “show slave status” will show there is no delay but it could still receiving data from the master. Check it by running “show processlist” on the master. If the status is “Writing to net”, it’s still sending data to that slave. If it’s “Has sent all binlog to slave; waiting for binlog…

  • MySQL upgrade breaks replication

    Upgrade from 4.1.x and 5.0.22 to 5.0.42 and going forward (5.0.46, 5.0.48) in CentOS breaks replication. The error log now placed as /var/run/mysqld/mysqld.err instead of into the default datadir and the name is mysqld.err instead of .err, is it a MySQL bug? mysql> start slave; ERROR 1201 (HY000): Could not initialize master info structure; more…

Got any book recommendations?