X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;f=src%2Fmysql.c;h=caebdf31f3d0f3e1156398cc9768863f4b4738d5;hb=4dc48314be6a40b0d561d9dbf257c92f6197d15c;hp=bd9685b632b56a629642392ebd30855126e88407;hpb=1ee7b4bb5336b0a8a7b39867dfb738b93ed5c426;p=collectd.git diff --git a/src/mysql.c b/src/mysql.c index bd9685b6..caebdf31 100644 --- a/src/mysql.c +++ b/src/mysql.c @@ -1,6 +1,6 @@ /** * collectd - src/mysql.c - * Copyright (C) 2005 Florian octo Forster + * Copyright (C) 2006 Florian octo Forster * * This program is free software; you can redistribute it and/or modify it * under the terms of the GNU General Public License as published by the @@ -44,26 +44,55 @@ static char *user; static char *pass; static char *db = NULL; -static char init_suceeded = 0; +/* TODO + * understand `Select_*' and possibly do that stuff as well.. + */ -static char *commands_file = "mysql_commands.rrd"; -static char *traffic_file = "mysql_traffic.rrd"; +static char *commands_file = "mysql/mysql_commands-%s.rrd"; +static char *handler_file = "mysql/mysql_handler-%s.rrd"; +static char *qcache_file = "mysql/mysql_qcache.rrd"; +static char *threads_file = "mysql/mysql_threads.rrd"; +static char *traffic_file = "traffic-mysql.rrd"; static char *commands_ds_def[] = { - "DS:insert:COUNTER:25:0:U", - "DS:select:COUNTER:25:0:U", - "DS:show:COUNTER:25:0:U", - "DS:update:COUNTER:25:0:U", - "DS:other:COUNTER:25:0:U", + "DS:value:COUNTER:"COLLECTD_HEARTBEAT":0:U", NULL }; -static int commands_ds_num = 5; +static int commands_ds_num = 1; + +static char *handler_ds_def[] = +{ + "DS:value:COUNTER:"COLLECTD_HEARTBEAT":0:U", + NULL +}; +static int handler_ds_num = 1; + +static char *qcache_ds_def[] = +{ + "DS:hits:COUNTER:"COLLECTD_HEARTBEAT":0:U", + "DS:inserts:COUNTER:"COLLECTD_HEARTBEAT":0:U", + "DS:not_cached:COUNTER:"COLLECTD_HEARTBEAT":0:U", + "DS:lowmem_prunes:COUNTER:"COLLECTD_HEARTBEAT":0:U", + "DS:queries_in_cache:GAUGE:"COLLECTD_HEARTBEAT":0:U", + NULL +}; +static int qcache_ds_num = 5; + +static char *threads_ds_def[] = +{ + "DS:running:GAUGE:"COLLECTD_HEARTBEAT":0:U", + "DS:connected:GAUGE:"COLLECTD_HEARTBEAT":0:U", + "DS:cached:GAUGE:"COLLECTD_HEARTBEAT":0:U", + "DS:created:COUNTER:"COLLECTD_HEARTBEAT":0:U", + NULL +}; +static int threads_ds_num = 4; static char *traffic_ds_def[] = { - "DS:incoming:COUNTER:25:0:U", - "DS:outgoing:COUNTER:25:0:U", + "DS:incoming:COUNTER:"COLLECTD_HEARTBEAT":0:U", + "DS:outgoing:COUNTER:"COLLECTD_HEARTBEAT":0:U", NULL }; static int traffic_ds_num = 2; @@ -84,6 +113,11 @@ static MYSQL *getconnection (void) static MYSQL *con; static int state; + static int wait_for = 0; + static int wait_increase = 60; + + int step; + if (state != 0) { int err; @@ -99,6 +133,19 @@ static MYSQL *getconnection (void) } } + step = atoi (COLLECTD_STEP); + + if (wait_for > 0) + { + wait_for -= step; + return (NULL); + } + + wait_for = wait_increase; + wait_increase *= 2; + if (wait_increase > 86400) + wait_increase = 86400; + if ((con = mysql_init (con)) == NULL) { syslog (LOG_ERR, "mysql_init failed: %s", mysql_error (con)); @@ -115,6 +162,8 @@ static MYSQL *getconnection (void) else { state = 1; + wait_for = 0; + wait_increase = 60; return (con); } } /* static MYSQL *getconnection (void) */ @@ -122,16 +171,6 @@ static MYSQL *getconnection (void) static void init (void) { -#if MYSQL_HAVE_READ - if (getconnection () != NULL) - init_suceeded = 1; - else - { - syslog (LOG_ERR, "The `mysql' plugin will be disabled because `init' failed to connect to `%s'", host); - init_suceeded = 0; - } -#endif /* MYSQL_HAVE_READ */ - return; } @@ -151,26 +190,49 @@ static int config (char *key, char *value) static void commands_write (char *host, char *inst, char *val) { - rrd_update_file (host, commands_file, val, commands_ds_def, commands_ds_num); + char buf[BUFSIZE]; + + if (snprintf (buf, BUFSIZE, commands_file, inst) >= BUFSIZE) + return; + + rrd_update_file (host, buf, val, commands_ds_def, commands_ds_num); +} + +static void handler_write (char *host, char *inst, char *val) +{ + char buf[BUFSIZE]; + + if (snprintf (buf, BUFSIZE, handler_file, inst) >= BUFSIZE) + return; + + rrd_update_file (host, buf, val, handler_ds_def, handler_ds_num); +} + +static void qcache_write (char *host, char *inst, char *val) +{ + rrd_update_file (host, qcache_file, val, + qcache_ds_def, qcache_ds_num); +} + +static void threads_write (char *host, char *inst, char *val) +{ + rrd_update_file (host, threads_file, val, + threads_ds_def, threads_ds_num); } static void traffic_write (char *host, char *inst, char *val) { - rrd_update_file (host, traffic_file, val, traffic_ds_def, traffic_ds_num); + rrd_update_file (host, traffic_file, val, + traffic_ds_def, traffic_ds_num); } #if MYSQL_HAVE_READ -static void commands_submit (unsigned long long insert, - unsigned long long select, - unsigned long long show, - unsigned long long update, - unsigned long long other) +static void commands_submit (char *inst, unsigned long long value) { char buf[BUFSIZE]; int status; - status = snprintf (buf, BUFSIZE, "%u:%llu:%llu:%llu:%llu:%llu", (unsigned int) curtime, - insert, select, show, update, other); + status = snprintf (buf, BUFSIZE, "%u:%llu", (unsigned int) curtime, value); if (status < 0) { @@ -183,7 +245,77 @@ static void commands_submit (unsigned long long insert, return; } - plugin_submit ("mysql_commands", "-", buf); + plugin_submit ("mysql_commands", inst, buf); +} + +static void handler_submit (char *inst, unsigned long long value) +{ + char buf[BUFSIZE]; + int status; + + status = snprintf (buf, BUFSIZE, "%u:%llu", (unsigned int) curtime, value); + + if (status < 0) + { + syslog (LOG_ERR, "snprintf failed"); + return; + } + else if (status >= BUFSIZE) + { + syslog (LOG_WARNING, "snprintf was truncated"); + return; + } + + plugin_submit ("mysql_handler", inst, buf); +} + +static void qcache_submit (unsigned long long hits, unsigned long long inserts, + unsigned long long not_cached, unsigned long long lowmem_prunes, + int queries_in_cache) +{ + char buf[BUFSIZE]; + int status; + + status = snprintf (buf, BUFSIZE, "%u:%llu:%llu:%llu:%llu:%i", + (unsigned int) curtime, hits, inserts, not_cached, + lowmem_prunes, queries_in_cache); + + if (status < 0) + { + syslog (LOG_ERR, "snprintf failed"); + return; + } + else if (status >= BUFSIZE) + { + syslog (LOG_WARNING, "snprintf was truncated"); + return; + } + + plugin_submit ("mysql_qcache", "-", buf); +} + +static void threads_submit (int running, int connected, int cached, + unsigned long long created) +{ + char buf[BUFSIZE]; + int status; + + status = snprintf (buf, BUFSIZE, "%u:%i:%i:%i:%llu", + (unsigned int) curtime, + running, connected, cached, created); + + if (status < 0) + { + syslog (LOG_ERR, "snprintf failed"); + return; + } + else if (status >= BUFSIZE) + { + syslog (LOG_WARNING, "snprintf was truncated"); + return; + } + + plugin_submit ("mysql_threads", "-", buf); } static void traffic_submit (unsigned long long incoming, @@ -218,34 +350,41 @@ static void mysql_read (void) int query_len; int field_num; - unsigned long long cmd_insert = 0LL; - unsigned long long cmd_select = 0LL; - unsigned long long cmd_show = 0LL; - unsigned long long cmd_update = 0LL; - unsigned long long cmd_other = 0LL; + unsigned long long qcache_hits = 0ULL; + unsigned long long qcache_inserts = 0ULL; + unsigned long long qcache_not_cached = 0ULL; + unsigned long long qcache_lowmem_prunes = 0ULL; + int qcache_queries_in_cache = -1; - unsigned long long traffic_incoming = 0LL; - unsigned long long traffic_outgoing = 0LL; + int threads_running = -1; + int threads_connected = -1; + int threads_cached = -1; + unsigned long long threads_created = 0ULL; - if (init_suceeded == 0) - return; + unsigned long long traffic_incoming = 0ULL; + unsigned long long traffic_outgoing = 0ULL; /* An error message will have been printed in this case */ if ((con = getconnection ()) == NULL) return; query = "SHOW STATUS"; + if (mysql_get_server_version (con) >= 50002) + query = "SHOW GLOBAL STATUS"; + query_len = strlen (query); if (mysql_real_query (con, query, query_len)) { - syslog (LOG_ERR, "mysql_real_query failed: %s\n", mysql_error (con)); + syslog (LOG_ERR, "mysql_real_query failed: %s\n", + mysql_error (con)); return; } if ((res = mysql_store_result (con)) == NULL) { - syslog (LOG_ERR, "mysql_store_result failed: %s\n", mysql_error (con)); + syslog (LOG_ERR, "mysql_store_result failed: %s\n", + mysql_error (con)); return; } @@ -260,30 +399,65 @@ static void mysql_read (void) if (strncmp (key, "Com_", 4) == 0) { - if (strncmp (key, "Com_insert", 10) == 0) - cmd_insert += val; - else if (strncmp (key, "Com_select", 10) == 0) - cmd_select += val; - else if (strncmp (key, "Com_show", 8) == 0) - cmd_show += val; - else if (strncmp (key, "Com_update", 10) == 0) - cmd_update += val; - else if (strncmp (key, "Com_stmt_", 9) == 0) - { /* do nothing */ } - else - cmd_other += val; + if (val == 0ULL) + continue; + + /* Ignore `prepared statements' */ + if (strncmp (key, "Com_stmt_", 9) != 0) + commands_submit (key + 4, val); + } + else if (strncmp (key, "Handler_", 8) == 0) + { + if (val == 0ULL) + continue; + + handler_submit (key + 8, val); + } + else if (strncmp (key, "Qcache_", 7) == 0) + { + if (strcmp (key, "Qcache_hits") == 0) + qcache_hits = val; + else if (strcmp (key, "Qcache_inserts") == 0) + qcache_inserts = val; + else if (strcmp (key, "Qcache_not_cached") == 0) + qcache_not_cached = val; + else if (strcmp (key, "Qcache_lowmem_prunes") == 0) + qcache_lowmem_prunes = val; + else if (strcmp (key, "Qcache_queries_in_cache") == 0) + qcache_queries_in_cache = (int) val; } else if (strncmp (key, "Bytes_", 6) == 0) { - if (strncmp (key, "Bytes_received", 14) == 0) + if (strcmp (key, "Bytes_received") == 0) traffic_incoming += val; - else if (strncmp (key, "Bytes_sent", 10) == 0) + else if (strcmp (key, "Bytes_sent") == 0) traffic_outgoing += val; } + else if (strncmp (key, "Threads_", 8) == 0) + { + if (strcmp (key, "Threads_running") == 0) + threads_running = (int) val; + else if (strcmp (key, "Threads_connected") == 0) + threads_connected = (int) val; + else if (strcmp (key, "Threads_cached") == 0) + threads_cached = (int) val; + else if (strcmp (key, "Threads_created") == 0) + threads_created = val; + } } mysql_free_result (res); res = NULL; - commands_submit (cmd_insert, cmd_select, cmd_show, cmd_update, cmd_other); + if ((qcache_hits != 0ULL) + || (qcache_inserts != 0ULL) + || (qcache_not_cached != 0ULL) + || (qcache_lowmem_prunes != 0ULL)) + qcache_submit (qcache_hits, qcache_inserts, qcache_not_cached, + qcache_lowmem_prunes, qcache_queries_in_cache); + + if (threads_created != 0ULL) + threads_submit (threads_running, threads_connected, + threads_cached, threads_created); + traffic_submit (traffic_incoming, traffic_outgoing); /* mysql_close (con); */ @@ -298,7 +472,10 @@ void module_register (void) { plugin_register (MODULE_NAME, init, mysql_read, NULL); plugin_register ("mysql_commands", NULL, NULL, commands_write); - plugin_register ("mysql_traffic", NULL, NULL, traffic_write); + plugin_register ("mysql_handler", NULL, NULL, handler_write); + plugin_register ("mysql_qcache", NULL, NULL, qcache_write); + plugin_register ("mysql_threads", NULL, NULL, threads_write); + plugin_register ("mysql_traffic", NULL, NULL, traffic_write); cf_register (MODULE_NAME, config, config_keys, config_keys_num); }