Mini Searches with Answers
These are links associated with recent searches I’ve done. They’re not difficult enough to warrant to their own posts but still super useful.
DLC Taxi/Cab Phone number for transport to Westchester (HPN) Airport
Taxi: DLC Car Service (tel: (914) 946 6664) provides taxi service from the airport.
Taxi: DLC Car Service (tel: (914) 946 6664) provides taxi service from the airport.
Repairing this weird Mysql error: Table ‘./mysql/user’ is marked as crashed and should be repaired.
Repairing this weird Mysql error: Table ‘./mysql/user’ is marked as crashed and should be repaired.
Repairing this weird Mysql error: Table ‘./mysql/user’ is marked as crashed and should be repaired.
geocoder.us: a free US address geocoder
Lots of geographic tools with an API too. Get lat/long of an address, find distances, etc.
Lots of geographic tools with an API too. Get lat/long of an address, find distances, etc.
Flexigrid
Lightweight but rich data grid with resizable columns and a scrolling data to match the headers, plus an ability to connect to an xml based data source using Ajax to load the content. Supposedly it can convert existing tables too?
Lightweight but rich data grid with resizable columns and a scrolling data to match the headers, plus an ability to connect to an xml based data source using Ajax to load the content. Supposedly it can convert existing tables too?
Musings of an Anonymous Geek » Blog Archive » A Couple of MySQL Performance Tips
Useful MySQL performance tips
Useful MySQL performance tips
Add new Path variables in Ubuntu
$ sudo nano /etc/profile
Add "PATH=$PATH:/new/path\nexport PATH" to end of file and save.
Then do
$ . /etc/profile (to restart)
$ sudo nano /etc/profile
Add "PATH=$PATH:/new/path\nexport PATH" to end of file and save.
Then do
$ . /etc/profile (to restart)
MySQL :: MySQL 5.0 Reference Manual :: 12.2.7.2 Index Hint Syntax
Here’s how to suggest and/or force MySQL to use an index.
Here’s how to suggest and/or force MySQL to use an index.
How do I get my Wikipedia article to show up in the Google Earth Geographic Web layer?
You must geotag the article. The simplest way to do this is to use the {{coord}} template. This template can be used anywhere within the article text. For example, if the article for San Francisco, California contained this markup anywhere within the arti
You must geotag the article. The simplest way to do this is to use the {{coord}} template. This template can be used anywhere within the article text. For example, if the article for San Francisco, California contained this markup anywhere within the arti
HOWTO: open a file in Nautilus with gedit as root – Ubuntu Forums
Let’s you right click on a file and open it in a text editor as root in Ubuntu Hardy Heron (8.04)
Let’s you right click on a file and open it in a text editor as root in Ubuntu Hardy Heron (8.04)
Speeding up GROUP BY if you want aproximate results | MySQL Performance Blog
This guy claims grouping by crc32(<some string>) instead of just <some string> will make your query 120 times faster…
This guy claims grouping by crc32(<some string>) instead of just <some string> will make your query 120 times faster…
Places to store your kayak – The Stamford Kayaking Meetup Group (Stamford, CT) – Meetup.com
Places to store your Kayak near Stamford, CT
Places to store your Kayak near Stamford, CT
Thad’s Tech Blog: How to add disk space with LVM on Linux
$ sudo fdisk /dev/sda (new partition type 8e, w for write)
$ sudo pvcreate /dev/sda1
$ sudo vgdisplay
$ sudo vgextend PFA-CT-LPDB01 /dev/sda1
$ sudo lvextend -L +930G /dev/PFA-CT-LPDB01/root
$ sudo ext2online /dev/PFA-CT-LPDB
$ sudo fdisk /dev/sda (new partition type 8e, w for write)
$ sudo pvcreate /dev/sda1
$ sudo vgdisplay
$ sudo vgextend PFA-CT-LPDB01 /dev/sda1
$ sudo lvextend -L +930G /dev/PFA-CT-LPDB01/root
$ sudo ext2online /dev/PFA-CT-LPDB
Tags: Address, Airport, Ajax, Api, Census, Distance, Forum_I_Posted_To, Geolocation, Geotagging, Gis, Googleearth, Gps, Groupby, Javascript, Jquery, Kayak, Linux, Local, Lvm, Maps, Mysql, Optimization, Performance, Pfam, Query, Sql, Storage, Table, Taxi, Ubuntu, Visualization, Webservices, Wikipedia