Use MySQL? You need Maatkit

databases Maatkit is a pretty useful set of utilities for MySQL. From their site:

You can use Maatkit to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much, much more.


This entry was:

MySQL JDBC Load Balancing with MySQL Cluster

databases Here's a neat tip posted by Henrik Ingo from the MySQL Telecom Team

It's not really properly documented in the manual part, but I found in the changelogs, and confirmed on IRC that to do load-balancing across the SQL nodes in MySQL Cluster, you would use a different JDBC connection


This entry was:

Top 10 Reserved SQL Keywords

databases You may know that I created a SQL Reserved Keywords Checker a few years ago. I was just noticing today that a lot of people are searching for the same keywords. Here's a list of the top 10 keywords people searched for using the tool in the past year:.


This entry was:

INFORMATION_SCHEMA Support in MySQL, PostgreSQL

databases I've known about the INFORMATION_SCHEMA views (or system tables) in SQL Server for a while, but I just leared recently that they are actually part of the SQL-92 standard and supported on other database platforms.


This entry was:

Amazon S3 Storage Engine for MySQL

databases I got an email today from O'Reilly today about the MySQL Conference (coming up at the end in April), it looks like a pretty good conference, but one of the sessions caught my eye. It was called A Storage Engine for Amazon S3.


This entry was:

Calculating Distance in Miles from Latitude and Longitude

databases The amount of data out there via API's is increadible these days. For instance you can take an address, and get the latitude and longitude using Google's GeoCoding API.

I am using this API along with some others to build a pretty some interesting stuff (more on that when its public).


This entry was:

Backwards LIKE Statements

databases Sometimes you need to think backwards.

Here was the problem. I needed to match up some IP address ranges to the company that owns them.


This entry was:

MySQL Optimization Hints

databases Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.


This entry was:

Sphinx - Open Source SQL Full Text Search Engine

databases I came across Sphinx today via the MySQL Performance Blog (which has some good entries you might want to check out). It is an Open Source Full Text SQL Search Engine.


This entry was:

Trick or Treat - Web 2.0 Goodies for ColdFusion

coldfusion I am happy to announce the latest creation from foundeo: fusionKit.

fusionKit is a CD full of some handy ColdFusion components and UDF's. It is a similar concept to the DRK's that Macromedia used to sell, but is it's 100% ColdFusion.


This entry was:

MySQL Command Line Help

databases I tend to use MySQL from the interactive command line shell quite a bit (SSH to your db server and type the command mysql to start). I noticed today that there is a pretty extensive built in help system in this command.


This entry was:

Google Video: MySQL Performance Tuning Best Practices

databases Jay Pipes is a co-author of the recently published Pro MySQL recently spoke at Google on MySQL Performance Tuning Best Practices

You can check out a video of the presentation on Google Video



There is also a good video from Google called The Paradox of Choice:


This entry was:

Updated SQL Reserved Words Checker

databases I just updated my SQL reserved words checker to include a few new words from MySQL 5 that it wasn't picking up.

I use the tool when I'm designing a database table, or column. It can tell you if a value is a reserved word in MySQL, PostgreSQL, Oracle, or SQL Server.


This entry was:

Forta's MySQL Crash Course

books databases Ben Forta sent me a copy of his latest book: MySQL Crash Course a book based on his: Teach yourself SQL in 10 minutes book.

MySQL Crash Course is a concise guide (it's actually about the size of a novel, but 300 pages) to MySQL. I am a big fan of short and to the point books.


This entry was:

MySQL FULLTEXT Indexing and Searching

databases MySQL has supported FULLTEXT indexes since version 3.23.23. VARCHAR and TEXT Columns that have been indexed with FULLTEXT can be used with special SQL statements that perform the full text search in MySQL.

To get started you need to define the FULLTEXT index on some columns.


This entry was:

SQL to Select a random row from a database table

databases There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.


This entry was:

Cheat Sheet Roundup - Over 30 Cheatsheets for developers

apple coldfusion databases java linux web Lets face it, unless you have a photographic memory, no developer can remember all the different functions, options, tags, etc. that exist. Documentation can be cumbersome at times, thats why I like cheat sheets.


This entry was:

LIMIT and OFFSET SQL Pagination

databases Both MySQL and PostgreSQL support a really cool feature called OFFSET that is usually used with a LIMIT clause.

The LIMIT clause is used to limit the number of results returned in a SQL statement.


This entry was:

MySQL DELAY_KEY_WRITE Option

databases Another performance option in MySQL is the DELAY_KEY_WRITE option. According to the MySQL documentation the option makes index updates faster because they are not flushed to disk until the table is closed.


This entry was:

Insert Delayed with MySQL

databases I just discovered that MySQL has some handy optimization hints, and commands that you can pass in your SQL statements. Since there is a lot to cover with each tip, I will be posting them in separate blog entries. I have already written about the MySQL Query Cache optimization hints.


This entry was:

The MySQL Query Cache

databases I have been reading about MySQL's Query Caching features in the High Performance MySQL book, and on the web. I have also been playing around with it on my own. I have concluded that it is a pretty cool feature! You will need MySQL 4.0.1 or higher to play...


This entry was:

Performance of database tag schemas

databases Philipp Keller has done some performance test on 4 different database schemas for storing tagged items. Although his article refers to tagging bookmarks, you can tag pretty much anything.


This entry was:

Multiple Inserts with MySQL

databases Andy Jarrett posted this technique for insterting multiple rows (bulk insert) in one SQL statement a few months ago.


This entry was:

Multiple Statements with MySQL and JDBC

databases Cameron Childress pointed out the allowMultiQueries setting in the MySQL JDBC driver on the CFGURU list. It is set to false by default to protect you from SQL Injection attacks.


This entry was:

Prepared Statements in PHP and MySQL

databases I'm working on a web security presentation, and I was curious to know if PHP supported prepared statements. It looks like as of PHP 5 they do support it with the new mysqli object (mysqli replaces the mysql class with support for mysql 4.


This entry was:

High Performance MySQL

books databases I just received my copy of High Performance MySQL by Jeremy D. Zawodny (from Yahoo) and Derek J. Balling.


This entry was:

SQL Reserved Key Words Checker Tool

databases I just whipped together a tool for checking for reserved sql words. The tool checks against SQL Server 2000, MySQL 5.0, PostgreSQL 8.0, Oracle 10g, ODBC, and SQL Server Future Keywords list.


This entry was:

Triggers in MySQL 5

databases Peter Gulutzan shows a sneak peak of Trigger support in MySQL 5 alpha in his article MySQL Triggers Tryout on O'Reilly OnLamp.


This entry was:

MySQL Popular among ColdFusion Developers

databases After 163 votes, I've decided it's time to retire my poll: "What Database server do you use?


This entry was:

Returning TOP N Records

databases Returning only the first N records in a SQL query differs quite a bit between database platforms.


This entry was:

foundeo


did you hack my cf?