Archive for the ‘MySQL’ Category

Retro Fitting Record Pagination with ADOdb

Wednesday, January 2nd, 2008
No Gravatar

For my first project of the New Year I had to retro-fit pagination controls to an existing ADOdb powered web application for a client of mine. Looking back at my previous post on this topic, it was relatively simple to add the required features. Hers’s how I did it. (more…)

Bookmark it del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Propeller | Yahoo


Yahoo Term Extractor

Wednesday, August 1st, 2007
No Gravatar

A recent project I was working on cause me to stumble over the Yahoo Term Extractor. Something I had previously never heard of - it is a very underrated tool.

The Term Extraction Web Service provides a list of significant words or phrases extracted from a larger content. (more…)

Bookmark it del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Propeller | Yahoo


Reset MySQL password on Ubuntu in about 1 second*

Tuesday, July 17th, 2007
No Gravatar

* It may take a little longer depending on your server and finger speeds!

dpkg-reconfigure mysql-server-5.0

Bookmark it del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Propeller | Yahoo


MySQL Tuning Server Parameters

Friday, July 13th, 2007
No Gravatar

These are some of the handy MySQL 5.0 tweaks I do to get the most out a MySQL database;
I adjust the following to suit my server, I try to give MySQL as much resource as possible.

(more…)

Bookmark it del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Propeller | Yahoo