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 system and status variables demo plugin

Let's see a more complex example. This plugin shows how to create system and status variables. It has one global system variable and one status variable, both defined as long long. When you set the global system variable, its value is copied into the status variable.

#include <stdio.h>
#include <mysql/plugin.h>
#include <mysql_version.h>
long long system_var = 0;
long long status_var = 0;
struct st_mysql_show_var vars_status_var[] =
{
{"vars_status_var", (char *) &status_var, SHOW_LONGLONG},
{0, 0, 0}
};

We have one status variable in this plugin called vars_status_var which is bound to the status_var variable defined near the top of this source code. We are defining this variable as long long so we use ...

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