MySQL management, tutorials, scripts, coding, programming and tips for database administrators

MySQL

Database Buying Guide: Open Source Databases 09/23

MySQL and PostgreSQL are worthy alternatives to the major commercial databases.

Oracle Expands MySQL for Windows 09/07

MySQL isn't just for the LAMP stack anymore.

Should You Move Your MySQL Database to the Cloud? 05/19

Is a cloud database service for you? Here's what to consider if you're thinking about a cloud database solution.

Beyond the LIKE Operator: Advanced Pattern Matching with MySQL 05/17

The MySQL LIKE operator is great for finding words or phrases within strings, but you'll be happy to learn that it provides a form of advanced pattern matching based on UNIX utilities.

Three Ways to Identify Non-matching Records in MySQL 05/06

There are many times as a database developer and administrator that you'll want to know what entities are being excluded from a straight table join; fortunately, MySQL gives you not one but three options.

Schooner Releases Active Cluster for MySQL 03/31
New clustering system promises fully synchronous replication for MySQL databases.

Xeround Brings MySQL to Heroku 03/17
The MySQL in the cloud vendor extends its platform for Ruby developers.

MySQL Data Fragmentation - What, When and How 03/11

Fragmentation can leave large holes in your table, blocks which must be read when scanning the table. Optimizing your table can make full table scans and range scans more efficient.

Converting between MySQL Date and Time Formats 03/09
MySQL's thorough and flexible date handling allows you to switch between internal and external date/time formats with relative ease.

MySQL InnoDB File Formats 03/02
Versions of MySQL now come equipped with the powerful and stable InnoDB plugin. We will cover file formats in this article, a very important part of the InnoDB plugin feature set.

Using MySQL's Analysis Tools to Improve Query Performance 02/18
One nice feature added to the EXPLAIN statement in MySQL 4.1 is the EXTENDED keyword which provides you with some helpful additional information on query optimization.

Five Considerations for MySQL Security and Compliance in the Cloud 02/16
Security and compliance are big worries in the cloud. We give you some strategies for coping.

Comparing MySQL Statement-Based and Row-Based Replication 02/01
There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.

Identify Slow Queries using MySQL's Analysis Tools 01/28
Using MySQL analysis tools, you can identify and optimize slow queries in order to eliminate the bottlenecks that they cause. Rob Gravelle examines the Slow Query Log and Explain command, which can both help identify slow queries.

Top 5 Considerations for MySQL Administration in the Cloud 01/19
Cloud deployments of internet sites are becoming much more prevalent every day. Let's take a look at what type of special considerations we'll need to make for hosting MySQL successfully in the cloud.