O'Reilly logo

MySQL 5.1 Plugin Development by Andrew Hutchings, Sergei Golubchik

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

A simple monitoring plugin

Our previous examples have demonstrated how to create a plugin and how to use status and system variables, but they did not do anything practically useful. The next plugin will record the connection statistics every five seconds into a log file so that load spikes can be recorded or monitored using an external application.

This plugin will remove any previous copy of the log file, create a new one, and then start a thread to retrieve the data and record it every five seconds. Upon removal of the plugin or shutdown, the plugin will record the shutdown time and close the file gracefully:

#include <string.h> #include <mysql/plugin.h> #include <mysql_version.h> #include <my_global.h> #include <my_sys.h> #define MONITORING_BUFFER ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required