THIS MODULE IS OBSOLETE. USE THE PYTHON ONE - IT SUPPORTS MULTIPLE JOBS AND IT IS MORE EFFICIENT
The plugin will monitor one or more mysql servers
It will produce the following charts:
Bandwidth in kbps * in * out
Queries in queries/sec * queries * questions * slow queries
Operations in operations/sec * opened tables * flush * commit * delete * prepare * read first * read key * read next * read prev * read random * read random next * rollback * save point * update * write
Table Locks in locks/sec * immediate * waited
Select Issues in issues/sec * full join * full range join * range * range check * scan
Sort Issues in issues/sec * merge passes * range * scan
You can configure many database servers, like this:
You can provide, per server, the following:
- a name, anything you like, but keep it short
- the mysql command to connect to the server
- the mysql command line options to be used for connecting to the server
Here is an example for 2 servers:
mysql_opts[server1]="-h server1.example.com" mysql_opts[server2]="-h server2.example.com --connect_timeout 2"
The above will use the
mysql command found in the system path.
You can also provide a custom mysql command per server, like this:
The above sets the mysql command only for server2. server1 will use the system default.
If no configuration is given, the plugin will attempt to connect to mysql server at localhost.