int apm_driver_mysql_mshutdown(SHUTDOWN_FUNC_ARGS)
{
if (APM_G(mysql_event_db) != NULL) {
mysql_destroy(TSRMLS_C);
}
return SUCCESS;
}
/*%
* Properly cleans up a list of database instances.
* This function is only used when the module is compiled for
* multithreaded operation.
*/
static void
mysql_destroy_dblist(db_list_t *dblist) {
dbinstance_t *ndbi = NULL;
dbinstance_t *dbi = NULL;
ndbi = DLZ_LIST_HEAD(*dblist);
while (ndbi != NULL) {
dbi = ndbi;
ndbi = DLZ_LIST_NEXT(dbi, link);
mysql_destroy(dbi);
}
/* release memory for the list structure */
free(dblist);
}
/*%
* Destroy the module.
*/
void
dlz_destroy(void *dbdata) {
mysql_instance_t *db = (mysql_instance_t *)dbdata;
#if PTHREADS
/* cleanup the list of DBI's */
if (db->db != NULL)
mysql_destroy_dblist((db_list_t *)(db->db));
#else /* PTHREADS */
mysql_destroy(db);
#endif /* PTHREADS */
if (db->dbname != NULL)
free(db->dbname);
if (db->host != NULL)
free(db->host);
if (db->user != NULL)
free(db->user);
if (db->pass != NULL)
free(db->pass);
if (db->socket != NULL)
free(db->socket);
}
/* Returns the MYSQL instance (singleton) */
MYSQL * mysql_get_instance(TSRMLS_D) {
my_bool reconnect = 1;
if (APM_G(mysql_event_db) == NULL) {
APM_DEBUG("[MySQL driver] mysql_event_db is null (mysql handler)... \n");
mysql_library_init(0, NULL, NULL);
APM_G(mysql_event_db) = malloc(sizeof(MYSQL));
mysql_init(APM_G(mysql_event_db));
mysql_options(APM_G(mysql_event_db), MYSQL_OPT_RECONNECT, &reconnect);
APM_DEBUG("[MySQL driver] Connecting to server...");
if (mysql_real_connect(APM_G(mysql_event_db), APM_G(mysql_db_host), APM_G(mysql_db_user), APM_G(mysql_db_pass), APM_G(mysql_db_name), APM_G(mysql_db_port), NULL, 0) == NULL) {
APM_DEBUG("FAILED! Message: %s\n", mysql_error(APM_G(mysql_event_db)));
mysql_destroy(TSRMLS_C);
return NULL;
}
APM_DEBUG("OK\n");
mysql_set_character_set(APM_G(mysql_event_db), "utf8");
mysql_query(
APM_G(mysql_event_db),
"\
CREATE TABLE IF NOT EXISTS request (\
id INTEGER UNSIGNED PRIMARY KEY auto_increment,\
application VARCHAR(255) NOT NULL,\
ts TIMESTAMP NOT NULL,\
script TEXT NOT NULL,\
uri TEXT NOT NULL,\
host TEXT NOT NULL,\
ip INTEGER UNSIGNED NOT NULL,\
cookies TEXT NOT NULL,\
post_vars TEXT NOT NULL,\
referer TEXT NOT NULL,\
method TEXT NOT NULL,\
status TEXT NOT NULL\
)"
);
mysql_query(
APM_G(mysql_event_db),
"\
CREATE TABLE IF NOT EXISTS event (\
id INTEGER UNSIGNED PRIMARY KEY auto_increment,\
request_id INTEGER UNSIGNED,\
ts TIMESTAMP NOT NULL,\
type SMALLINT UNSIGNED NOT NULL,\
file TEXT NOT NULL,\
line MEDIUMINT UNSIGNED NOT NULL,\
message TEXT NOT NULL,\
backtrace BLOB NOT NULL,\
KEY request (request_id)\
)"
);
mysql_query(
APM_G(mysql_event_db),
"\
CREATE TABLE IF NOT EXISTS stats (\
id INTEGER UNSIGNED PRIMARY KEY auto_increment,\
request_id INTEGER UNSIGNED,\
duration FLOAT UNSIGNED NOT NULL,\
user_cpu FLOAT UNSIGNED NOT NULL,\
sys_cpu FLOAT UNSIGNED NOT NULL,\
mem_peak_usage INTEGER UNSIGNED NOT NULL,\
KEY request (request_id)\
)"
);
}
return APM_G(mysql_event_db);
}
