Ejemplo n.º 1
0
static int mysql_read (user_data_t *ud)
{
	mysql_database_t *db;
	MYSQL     *con;
	MYSQL_RES *res;
	MYSQL_ROW  row;
	char      *query;

	derive_t qcache_hits          = 0;
	derive_t qcache_inserts       = 0;
	derive_t qcache_not_cached    = 0;
	derive_t qcache_lowmem_prunes = 0;
	gauge_t qcache_queries_in_cache = NAN;

	gauge_t threads_running   = NAN;
	gauge_t threads_connected = NAN;
	gauge_t threads_cached    = NAN;
	derive_t threads_created = 0;

	unsigned long long traffic_incoming = 0ULL;
	unsigned long long traffic_outgoing = 0ULL;

	if ((ud == NULL) || (ud->data == NULL))
	{
		ERROR ("mysql plugin: mysql_database_read: Invalid user data.");
		return (-1);
	}

	db = (mysql_database_t *) ud->data;

	/* An error message will have been printed in this case */
	if ((con = getconnection (db)) == NULL)
		return (-1);

	query = "SHOW STATUS";
	if (mysql_get_server_version (con) >= 50002)
		query = "SHOW GLOBAL STATUS";

	res = exec_query (con, query);
	if (res == NULL)
		return (-1);

	while ((row = mysql_fetch_row (res)))
	{
		char *key;
		unsigned long long val;

		key = row[0];
		val = atoll (row[1]);

		if (strncmp (key, "Com_", 
			          strlen ("Com_")) == 0)
		{
			if (val == 0ULL)
				continue;

			/* Ignore `prepared statements' */
			if (strncmp (key, "Com_stmt_", strlen ("Com_stmt_")) != 0)
				counter_submit ("mysql_commands", 
						key + strlen ("Com_"), 
						val, db);
		}
		else if (strncmp (key, "Handler_", 
				        strlen ("Handler_")) == 0)
		{
			if (val == 0ULL)
				continue;

			counter_submit ("mysql_handler", 
					key + strlen ("Handler_"), 
					val, db);
		}
		else if (strncmp (key, "Qcache_",
       				        strlen ("Qcache_")) == 0)
		{
			if (strcmp (key, "Qcache_hits") == 0)
				qcache_hits = (derive_t) val;
			else if (strcmp (key, "Qcache_inserts") == 0)
				qcache_inserts = (derive_t) val;
			else if (strcmp (key, "Qcache_not_cached") == 0)
				qcache_not_cached = (derive_t) val;
			else if (strcmp (key, "Qcache_lowmem_prunes") == 0)
				qcache_lowmem_prunes = (derive_t) val;
			else if (strcmp (key, "Qcache_queries_in_cache") == 0)
				qcache_queries_in_cache = (gauge_t) val;
		}
		else if (strncmp (key, "Bytes_", 
				        strlen ("Bytes_")) == 0)
		{
			if (strcmp (key, "Bytes_received") == 0)
				traffic_incoming += val;
			else if (strcmp (key, "Bytes_sent") == 0)
				traffic_outgoing += val;
		}
		else if (strncmp (key, "Threads_", 
       				        strlen ("Threads_")) == 0)
		{
			if (strcmp (key, "Threads_running") == 0)
				threads_running = (gauge_t) val;
			else if (strcmp (key, "Threads_connected") == 0)
				threads_connected = (gauge_t) val;
			else if (strcmp (key, "Threads_cached") == 0)
				threads_cached = (gauge_t) val;
			else if (strcmp (key, "Threads_created") == 0)
				threads_created = (derive_t) val;
		}
		else if (strncmp (key, "Table_locks_",
					strlen ("Table_locks_")) == 0)
		{
			counter_submit ("mysql_locks",
					key + strlen ("Table_locks_"),
					val, db);
		}
	}
	mysql_free_result (res); res = NULL;

	if ((qcache_hits != 0)
			|| (qcache_inserts != 0)
			|| (qcache_not_cached != 0)
			|| (qcache_lowmem_prunes != 0))
	{
		derive_submit ("cache_result", "qcache-hits",
				qcache_hits, db);
		derive_submit ("cache_result", "qcache-inserts",
				qcache_inserts, db);
		derive_submit ("cache_result", "qcache-not_cached",
				qcache_not_cached, db);
		derive_submit ("cache_result", "qcache-prunes",
				qcache_lowmem_prunes, db);

		gauge_submit ("cache_size", "qcache",
				qcache_queries_in_cache, db);
	}

	if (threads_created != 0)
	{
		gauge_submit ("threads", "running",
				threads_running, db);
		gauge_submit ("threads", "connected",
				threads_connected, db);
		gauge_submit ("threads", "cached",
				threads_cached, db);

		derive_submit ("total_threads", "created",
				threads_created, db);
	}

	traffic_submit  (traffic_incoming, traffic_outgoing, db);

	if (db->master_stats)
		mysql_read_master_stats (db, con);

	if ((db->slave_stats) || (db->slave_notif))
		mysql_read_slave_stats (db, con);

	return (0);
} /* int mysql_read */
Ejemplo n.º 2
0
static int vserver_read (void)
{
#if NAME_MAX < 1024
# define DIRENT_BUFFER_SIZE (sizeof (struct dirent) + 1024 + 1)
#else
# define DIRENT_BUFFER_SIZE (sizeof (struct dirent) + NAME_MAX + 1)
#endif

	DIR 			*proc;
	struct dirent 	*dent; /* 42 */
	char dirent_buffer[DIRENT_BUFFER_SIZE];

	errno = 0;
	proc = opendir (PROCDIR);
	if (proc == NULL)
	{
		char errbuf[1024];
		ERROR ("vserver plugin: fopen (%s): %s", PROCDIR, 
				sstrerror (errno, errbuf, sizeof (errbuf)));
		return (-1);
	}

	while (42)
	{
		int len;
		char file[BUFSIZE];

		FILE *fh;
		char buffer[BUFSIZE];

		struct stat statbuf;
		char *cols[4];

		int status;

		status = readdir_r (proc, (struct dirent *) dirent_buffer, &dent);
		if (status != 0)
		{
			char errbuf[4096];
			ERROR ("vserver plugin: readdir_r failed: %s",
					sstrerror (errno, errbuf, sizeof (errbuf)));
			closedir (proc);
			return (-1);
		}
		else if (dent == NULL)
		{
			/* end of directory */
			break;
		}

		if (dent->d_name[0] == '.')
			continue;

		len = ssnprintf (file, sizeof (file), PROCDIR "/%s", dent->d_name);
		if ((len < 0) || (len >= BUFSIZE))
			continue;
		
		status = stat (file, &statbuf);
		if (status != 0)
		{
			char errbuf[4096];
			WARNING ("vserver plugin: stat (%s) failed: %s",
					file, sstrerror (errno, errbuf, sizeof (errbuf)));
			continue;
		}
		
		if (!S_ISDIR (statbuf.st_mode))
			continue;

		/* socket message accounting */
		len = ssnprintf (file, sizeof (file),
				PROCDIR "/%s/cacct", dent->d_name);
		if ((len < 0) || ((size_t) len >= sizeof (file)))
			continue;

		if (NULL == (fh = fopen (file, "r")))
		{
			char errbuf[1024];
			ERROR ("Cannot open '%s': %s", file,
					sstrerror (errno, errbuf, sizeof (errbuf)));
		}

		while ((fh != NULL) && (NULL != fgets (buffer, BUFSIZE, fh)))
		{
			derive_t rx;
			derive_t tx;
			char *type_instance;

			if (strsplit (buffer, cols, 4) < 4)
				continue;

			if (0 == strcmp (cols[0], "UNIX:"))
				type_instance = "unix";
			else if (0 == strcmp (cols[0], "INET:"))
				type_instance = "inet";
			else if (0 == strcmp (cols[0], "INET6:"))
				type_instance = "inet6";
			else if (0 == strcmp (cols[0], "OTHER:"))
				type_instance = "other";
			else if (0 == strcmp (cols[0], "UNSPEC:"))
				type_instance = "unspec";
			else
				continue;

			rx = vserver_get_sock_bytes (cols[1]);
			tx = vserver_get_sock_bytes (cols[2]);
			/* cols[3] == errors */

			traffic_submit (dent->d_name, type_instance, rx, tx);
		} /* while (fgets) */

		if (fh != NULL)
		{
			fclose (fh);
			fh = NULL;
		}

		/* thread information and load */
		len = ssnprintf (file, sizeof (file),
				PROCDIR "/%s/cvirt", dent->d_name);
		if ((len < 0) || ((size_t) len >= sizeof (file)))
			continue;

		if (NULL == (fh = fopen (file, "r")))
		{
			char errbuf[1024];
			ERROR ("Cannot open '%s': %s", file,
					sstrerror (errno, errbuf, sizeof (errbuf)));
		}

		while ((fh != NULL) && (NULL != fgets (buffer, BUFSIZE, fh)))
		{
			int n = strsplit (buffer, cols, 4);

			if (2 == n)
			{
				char   *type_instance;
				gauge_t value;

				if (0 == strcmp (cols[0], "nr_threads:"))
					type_instance = "total";
				else if (0 == strcmp (cols[0], "nr_running:"))
					type_instance = "running";
				else if (0 == strcmp (cols[0], "nr_unintr:"))
					type_instance = "uninterruptable";
				else if (0 == strcmp (cols[0], "nr_onhold:"))
					type_instance = "onhold";
				else
					continue;

				value = atof (cols[1]);
				submit_gauge (dent->d_name, "vs_threads", type_instance, value);
			}
			else if (4 == n) {
				if (0 == strcmp (cols[0], "loadavg:"))
				{
					gauge_t snum = atof (cols[1]);
					gauge_t mnum = atof (cols[2]);
					gauge_t lnum = atof (cols[3]);
					load_submit (dent->d_name, snum, mnum, lnum);
				}
			}
		} /* while (fgets) */

		if (fh != NULL)
		{
			fclose (fh);
			fh = NULL;
		}

		/* processes and memory usage */
		len = ssnprintf (file, sizeof (file),
				PROCDIR "/%s/limit", dent->d_name);
		if ((len < 0) || ((size_t) len >= sizeof (file)))
			continue;

		if (NULL == (fh = fopen (file, "r")))
		{
			char errbuf[1024];
			ERROR ("Cannot open '%s': %s", file,
					sstrerror (errno, errbuf, sizeof (errbuf)));
		}

		while ((fh != NULL) && (NULL != fgets (buffer, BUFSIZE, fh)))
		{
			char *type = "vs_memory";
			char *type_instance;
			gauge_t value;

			if (strsplit (buffer, cols, 2) < 2)
				continue;

			if (0 == strcmp (cols[0], "PROC:"))
			{
				type = "vs_processes";
				type_instance = "";
				value = atof (cols[1]);
			}
			else
			{
				if (0 == strcmp (cols[0], "VM:"))
					type_instance = "vm";
				else if (0 == strcmp (cols[0], "VML:"))
					type_instance = "vml";
				else if (0 == strcmp (cols[0], "RSS:"))
					type_instance = "rss";
				else if (0 == strcmp (cols[0], "ANON:"))
					type_instance = "anon";
				else
					continue;

				value = atof (cols[1]) * pagesize;
			}

			submit_gauge (dent->d_name, type, type_instance, value);
		} /* while (fgets) */

		if (fh != NULL)
		{
			fclose (fh);
			fh = NULL;
		}
	} /* while (readdir) */

	closedir (proc);

	return (0);
} /* int vserver_read */
Ejemplo n.º 3
0
Archivo: mysql.c Proyecto: brd/collectd
static int mysql_read (user_data_t *ud)
{
    mysql_database_t *db;
    MYSQL      *con;
    MYSQL_RES  *res;
    MYSQL_ROW   row;
    const char *query;

    derive_t qcache_hits          = 0;
    derive_t qcache_inserts       = 0;
    derive_t qcache_not_cached    = 0;
    derive_t qcache_lowmem_prunes = 0;
    gauge_t qcache_queries_in_cache = NAN;

    gauge_t threads_running   = NAN;
    gauge_t threads_connected = NAN;
    gauge_t threads_cached    = NAN;
    derive_t threads_created = 0;

    unsigned long long traffic_incoming = 0ULL;
    unsigned long long traffic_outgoing = 0ULL;
    unsigned long mysql_version = 0ULL;

    if ((ud == NULL) || (ud->data == NULL))
    {
        ERROR ("mysql plugin: mysql_database_read: Invalid user data.");
        return (-1);
    }

    db = (mysql_database_t *) ud->data;

    /* An error message will have been printed in this case */
    if ((con = getconnection (db)) == NULL)
        return (-1);

    mysql_version = mysql_get_server_version(con);

    query = "SHOW STATUS";
    if (mysql_version >= 50002)
        query = "SHOW GLOBAL STATUS";

    res = exec_query (con, query);
    if (res == NULL)
        return (-1);

    while ((row = mysql_fetch_row (res)))
    {
        char *key;
        unsigned long long val;

        key = row[0];
        val = atoll (row[1]);

        if (strncmp (key, "Com_",
                     strlen ("Com_")) == 0)
        {
            if (val == 0ULL)
                continue;

            /* Ignore `prepared statements' */
            if (strncmp (key, "Com_stmt_", strlen ("Com_stmt_")) != 0)
                counter_submit ("mysql_commands",
                                key + strlen ("Com_"),
                                val, db);
        }
        else if (strncmp (key, "Handler_",
                          strlen ("Handler_")) == 0)
        {
            if (val == 0ULL)
                continue;

            counter_submit ("mysql_handler",
                            key + strlen ("Handler_"),
                            val, db);
        }
        else if (strncmp (key, "Qcache_",
                          strlen ("Qcache_")) == 0)
        {
            if (strcmp (key, "Qcache_hits") == 0)
                qcache_hits = (derive_t) val;
            else if (strcmp (key, "Qcache_inserts") == 0)
                qcache_inserts = (derive_t) val;
            else if (strcmp (key, "Qcache_not_cached") == 0)
                qcache_not_cached = (derive_t) val;
            else if (strcmp (key, "Qcache_lowmem_prunes") == 0)
                qcache_lowmem_prunes = (derive_t) val;
            else if (strcmp (key, "Qcache_queries_in_cache") == 0)
                qcache_queries_in_cache = (gauge_t) val;
        }
        else if (strncmp (key, "Bytes_",
                          strlen ("Bytes_")) == 0)
        {
            if (strcmp (key, "Bytes_received") == 0)
                traffic_incoming += val;
            else if (strcmp (key, "Bytes_sent") == 0)
                traffic_outgoing += val;
        }
        else if (strncmp (key, "Threads_",
                          strlen ("Threads_")) == 0)
        {
            if (strcmp (key, "Threads_running") == 0)
                threads_running = (gauge_t) val;
            else if (strcmp (key, "Threads_connected") == 0)
                threads_connected = (gauge_t) val;
            else if (strcmp (key, "Threads_cached") == 0)
                threads_cached = (gauge_t) val;
            else if (strcmp (key, "Threads_created") == 0)
                threads_created = (derive_t) val;
        }
        else if (strncmp (key, "Table_locks_",
                          strlen ("Table_locks_")) == 0)
        {
            counter_submit ("mysql_locks",
                            key + strlen ("Table_locks_"),
                            val, db);
        }
        else if (db->innodb_stats && strncmp (key, "Innodb_", strlen ("Innodb_")) == 0)
        {
            /* buffer pool */
            if (strcmp (key, "Innodb_buffer_pool_pages_data") == 0)
                gauge_submit ("mysql_bpool_pages", "data", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_pages_dirty") == 0)
                gauge_submit ("mysql_bpool_pages", "dirty", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_pages_flushed") == 0)
                counter_submit ("mysql_bpool_counters", "pages_flushed", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_pages_free") == 0)
                gauge_submit ("mysql_bpool_pages", "free", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_pages_misc") == 0)
                gauge_submit ("mysql_bpool_pages", "misc", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_pages_total") == 0)
                gauge_submit ("mysql_bpool_pages", "total", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_read_ahead_rnd") == 0)
                counter_submit ("mysql_bpool_counters", "read_ahead_rnd", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_read_ahead") == 0)
                counter_submit ("mysql_bpool_counters", "read_ahead", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_read_ahead_evicted") == 0)
                counter_submit ("mysql_bpool_counters", "read_ahead_evicted", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_read_requests") == 0)
                counter_submit ("mysql_bpool_counters", "read_requests", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_reads") == 0)
                counter_submit ("mysql_bpool_counters", "reads", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_write_requests") == 0)
                counter_submit ("mysql_bpool_counters", "write_requests", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_bytes_data") == 0)
                gauge_submit ("mysql_bpool_bytes", "data", val, db);
            else if (strcmp (key, "Innodb_buffer_pool_bytes_dirty") == 0)
                gauge_submit ("mysql_bpool_bytes", "dirty", val, db);

            /* data */
            if (strcmp (key, "Innodb_data_fsyncs") == 0)
                counter_submit ("mysql_innodb_data", "fsyncs", val, db);
            else if (strcmp (key, "Innodb_data_read") == 0)
                counter_submit ("mysql_innodb_data", "read", val, db);
            else if (strcmp (key, "Innodb_data_reads") == 0)
                counter_submit ("mysql_innodb_data", "reads", val, db);
            else if (strcmp (key, "Innodb_data_writes") == 0)
                counter_submit ("mysql_innodb_data", "writes", val, db);
            else if (strcmp (key, "Innodb_data_written") == 0)
                counter_submit ("mysql_innodb_data", "written", val, db);

            /* double write */
            else if (strcmp (key, "Innodb_dblwr_writes") == 0)
                counter_submit ("mysql_innodb_dblwr", "writes", val, db);
            else if (strcmp (key, "Innodb_dblwr_pages_written") == 0)
                counter_submit ("mysql_innodb_dblwr", "written", val, db);

            /* log */
            else if (strcmp (key, "Innodb_log_waits") == 0)
                counter_submit ("mysql_innodb_log", "waits", val, db);
            else if (strcmp (key, "Innodb_log_write_requests") == 0)
                counter_submit ("mysql_innodb_log", "write_requests", val, db);
            else if (strcmp (key, "Innodb_log_writes") == 0)
                counter_submit ("mysql_innodb_log", "writes", val, db);
            else if (strcmp (key, "Innodb_os_log_fsyncs") == 0)
                counter_submit ("mysql_innodb_log", "fsyncs", val, db);
            else if (strcmp (key, "Innodb_os_log_written") == 0)
                counter_submit ("mysql_innodb_log", "written", val, db);

            /* pages */
            else if (strcmp (key, "Innodb_pages_created") == 0)
                counter_submit ("mysql_innodb_pages", "created", val, db);
            else if (strcmp (key, "Innodb_pages_read") == 0)
                counter_submit ("mysql_innodb_pages", "read", val, db);
            else if (strcmp (key, "Innodb_pages_written") == 0)
                counter_submit ("mysql_innodb_pages", "written", val, db);

            /* row lock */
            else if (strcmp (key, "Innodb_row_lock_time") == 0)
                counter_submit ("mysql_innodb_row_lock", "time", val, db);
            else if (strcmp (key, "Innodb_row_lock_waits") == 0)
                counter_submit ("mysql_innodb_row_lock", "waits", val, db);

            /* rows */
            else if (strcmp (key, "Innodb_rows_deleted") == 0)
                counter_submit ("mysql_innodb_rows", "deleted", val, db);
            else if (strcmp (key, "Innodb_rows_inserted") == 0)
                counter_submit ("mysql_innodb_rows", "inserted", val, db);
            else if (strcmp (key, "Innodb_rows_read") == 0)
                counter_submit ("mysql_innodb_rows", "read", val, db);
            else if (strcmp (key, "Innodb_rows_updated") == 0)
                counter_submit ("mysql_innodb_rows", "updated", val, db);
        }
        else if (strncmp (key, "Select_", strlen ("Select_")) == 0)
        {
            counter_submit ("mysql_select", key + strlen ("Select_"),
                            val, db);
        }
        else if (strncmp (key, "Sort_", strlen ("Sort_")) == 0)
        {
            if (strcmp (key, "Sort_merge_passes") == 0)
                counter_submit ("mysql_sort_merge_passes", NULL, val, db);
            else if (strcmp (key, "Sort_rows") == 0)
                counter_submit ("mysql_sort_rows", NULL, val, db);
            else if (strcmp (key, "Sort_range") == 0)
                counter_submit ("mysql_sort", "range", val, db);
            else if (strcmp (key, "Sort_scan") == 0)
                counter_submit ("mysql_sort", "scan", val, db);

        }
        else if (strncmp (key, "Slow_queries", strlen ("Slow_queries")) == 0)
        {
            counter_submit ("mysql_slow_queries", NULL , val, db);
        }
    }
    mysql_free_result (res);
    res = NULL;

    if ((qcache_hits != 0)
            || (qcache_inserts != 0)
            || (qcache_not_cached != 0)
            || (qcache_lowmem_prunes != 0))
    {
        derive_submit ("cache_result", "qcache-hits",
                       qcache_hits, db);
        derive_submit ("cache_result", "qcache-inserts",
                       qcache_inserts, db);
        derive_submit ("cache_result", "qcache-not_cached",
                       qcache_not_cached, db);
        derive_submit ("cache_result", "qcache-prunes",
                       qcache_lowmem_prunes, db);

        gauge_submit ("cache_size", "qcache",
                      qcache_queries_in_cache, db);
    }

    if (threads_created != 0)
    {
        gauge_submit ("threads", "running",
                      threads_running, db);
        gauge_submit ("threads", "connected",
                      threads_connected, db);
        gauge_submit ("threads", "cached",
                      threads_cached, db);

        derive_submit ("total_threads", "created",
                       threads_created, db);
    }

    traffic_submit  (traffic_incoming, traffic_outgoing, db);

    if (mysql_version >= 50600 && db->innodb_stats)
        mysql_read_innodb_stats (db, con);

    if (db->master_stats)
        mysql_read_master_stats (db, con);

    if ((db->slave_stats) || (db->slave_notif))
        mysql_read_slave_stats (db, con);

    if (db->wsrep_stats)
        mysql_read_wsrep_stats (db, con);

    return (0);
} /* int mysql_read */
Ejemplo n.º 4
0
static int mysql_read (user_data_t *ud)
{
	mysql_database_t *db;
	MYSQL     *con;
	MYSQL_RES *res;
	MYSQL_ROW  row;
	char      *query;
	int        field_num;

	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;

	int threads_running   = -1;
	int threads_connected = -1;
	int threads_cached    = -1;
	unsigned long long threads_created = 0ULL;

	unsigned long long traffic_incoming = 0ULL;
	unsigned long long traffic_outgoing = 0ULL;

	if ((ud == NULL) || (ud->data == NULL))
	{
		ERROR ("mysql plugin: mysql_database_read: Invalid user data.");
		return (-1);
	}

	db = (mysql_database_t *) ud->data;

	/* An error message will have been printed in this case */
	if ((con = getconnection (db)) == NULL)
		return (-1);

	query = "SHOW STATUS";
	if (mysql_get_server_version (con) >= 50002)
		query = "SHOW GLOBAL STATUS";

	res = exec_query (con, query);
	if (res == NULL)
		return (-1);

	field_num = mysql_num_fields (res);
	while ((row = mysql_fetch_row (res)))
	{
		char *key;
		unsigned long long val;

		key = row[0];
		val = atoll (row[1]);

		if (strncmp (key, "Com_", 4) == 0)
		{
			if (val == 0ULL)
				continue;

			/* Ignore `prepared statements' */
			if (strncmp (key, "Com_stmt_", 9) != 0)
				counter_submit ("mysql_commands", key + 4, val, db);
		}
		else if (strncmp (key, "Handler_", 8) == 0)
		{
			if (val == 0ULL)
				continue;

			counter_submit ("mysql_handler", key + 8, val, db);
		}
		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 (strcmp (key, "Bytes_received") == 0)
				traffic_incoming += val;
			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;

	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, db);

	if (threads_created != 0ULL)
		threads_submit (threads_running, threads_connected,
				threads_cached, threads_created, db);

	traffic_submit  (traffic_incoming, traffic_outgoing, db);

	if (db->master_stats)
		mysql_read_master_stats (db, con);

	if ((db->slave_stats) || (db->slave_notif))
		mysql_read_slave_stats (db, con);

	return (0);
} /* int mysql_read */