Examples of MySQL Daemon Plugin

In the previous article, A look inside a MySQL Daemon plugin, we were introduced to the MySQL Plugin API. It talked about the most simple plugin type—Daemon plugins. It starts with the basic structure of a plugin—what a plugin declaration should look like, what plugin types are, and so on. Then it described features common to all plugin types—initialization and de-initialization callbacks, status variables, and configuration system variables.

This article, by Andrew Hutchings, co-author of MySQL 5.1 Plugin Development, describes and analyzes line by line four Daemon plugin examples—from a simple plugin that prints Hello World! when loaded, to a system monitoring plugin that periodically logs the number of connections, to a system usage status plugin that displays the memory and I/O usage of the MySQL server.

We will specifically cover:

• A Hello World! Daemon plugin
• A system and status variables demo plugin
• A simple monitoring plugin
• System Status Variables plugin

A Look Inside a MySQL Daemon Plugin

In this article, by Andrew Hutchings, co-author of MySQL 5.1 Plugin Development, we will be introduced to the MySQL Plugin API. It talks about the most simple plugin type—Daemon plugins. It starts with the basic structure of a plugin—what a plugin declaration should look like, what plugin types are, and so on. Then it describes features common to all plugin types—initialization and de-initialization callbacks, status variables, and configuration system variables.

We will specifically cover:

• A look inside a Daemon plugin
• Why write a Daemon plugin
• Installing and using Daemon plugins
• The role of a version
• Defining Daemon plugins

Indexing in MySQL Admin

In this article series by Daniel Schneller and Udo Schwedt, authors of MySQL Admin Cookbook, we will cover:

• Adding indexes to tables
• Adding a fulltext index
• Creating a normalized text search column
• Removing indexes from tables
• Estimating InnoDB index space requirements
• Using prefix primary keys
• Choosing InnoDB primary key columns
• Speeding up searches for (sub)domains
• Finding duplicate indexes

Read the first part of this article series—Optimizing your MySQL Servers' performance using Indexes here.

Manage Your Money with Simple Invoices

Simple Invoices provides freelancers, non-profits, and small business a user-friendly way to bill customers and track invoices. It's an application for people who don't want the hassle of larger accounting programs, such as GNU Cash, Quicken, or Quickbooks.

This article on Simple Invoices by Michael Badger, author of Scratch 1.4 Beginner's Guide and Zenoss Core Network and System Monitoring, provides an alternative to bulky accounting programs and the haphazard system of managing individual files by providing an intuitive web-based invoicing system. Because it's open source project, you enjoy free access to your software and your invoicing data.