/* Copyright (c) 2000, 2002, 2005-2007 MySQL AB, 2008 Sun Microsystems, Inc. Use is subject to license terms. 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 Free Software Foundation; version 2 of the License. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */ /* * sql_manager.cc * This thread manages various maintenance tasks. * * o Flushing the tables every flush_time seconds. * o Berkeley DB: removing unneeded log files. */ #include "mysql_priv.h" static bool volatile manager_thread_in_use; static bool abort_manager; pthread_t manager_thread; pthread_mutex_t LOCK_manager; pthread_cond_t COND_manager; struct handler_cb { struct handler_cb *next; void (*action)(void); }; static struct handler_cb * volatile cb_list; bool mysql_manager_submit(void (*action)()) { bool result= FALSE; DBUG_ASSERT(manager_thread_in_use); struct handler_cb * volatile *cb; pthread_mutex_lock(&LOCK_manager); cb= &cb_list; while (*cb && (*cb)->action != action) cb= &(*cb)->next; if (!*cb) { *cb= (struct handler_cb *)my_malloc(sizeof(struct handler_cb), MYF(MY_WME)); if (!*cb) result= TRUE; else { (*cb)->next= NULL; (*cb)->action= action; } } pthread_mutex_unlock(&LOCK_manager); return result; } pthread_handler_t handle_manager(void *arg __attribute__((unused))) { int error = 0; struct timespec abstime; bool reset_flush_time = TRUE; struct handler_cb *cb= NULL; my_thread_init(); DBUG_ENTER("handle_manager"); pthread_detach_this_thread(); manager_thread = pthread_self(); (void) pthread_cond_init(&COND_manager,NULL); (void) pthread_mutex_init(&LOCK_manager,NULL); manager_thread_in_use = 1; for (;;) { pthread_mutex_lock(&LOCK_manager); /* XXX: This will need to be made more general to handle different * polling needs. */ if (flush_time) { if (reset_flush_time) { set_timespec(abstime, flush_time); reset_flush_time = FALSE; } while ((!error || error == EINTR) && !abort_manager) error= pthread_cond_timedwait(&COND_manager, &LOCK_manager, &abstime); } else { while ((!error || error == EINTR) && !abort_manager) error= pthread_cond_wait(&COND_manager, &LOCK_manager); } if (cb == NULL) { cb= cb_list; cb_list= NULL; } pthread_mutex_unlock(&LOCK_manager); if (abort_manager) break; if (error == ETIMEDOUT || error == ETIME) { flush_tables(); error = 0; reset_flush_time = TRUE; } while (cb) { struct handler_cb *next= cb->next; cb->action(); my_free((uchar*)cb, MYF(0)); cb= next; } } manager_thread_in_use = 0; (void) pthread_mutex_destroy(&LOCK_manager); (void) pthread_cond_destroy(&COND_manager); DBUG_LEAVE; // Can't use DBUG_RETURN after my_thread_end my_thread_end(); return (NULL); } /* Start handle manager thread */ void start_handle_manager() { DBUG_ENTER("start_handle_manager"); abort_manager = false; if (flush_time && flush_time != ~(ulong) 0L) { pthread_t hThread; if (pthread_create(&hThread,&connection_attrib,handle_manager,0)) sql_print_warning("Can't create handle_manager thread"); } DBUG_VOID_RETURN; } /* Initiate shutdown of handle manager thread */ void stop_handle_manager() { DBUG_ENTER("stop_handle_manager"); abort_manager = true; if (manager_thread_in_use) { pthread_mutex_lock(&LOCK_manager); DBUG_PRINT("quit", ("initiate shutdown of handle manager thread: 0x%lx", (ulong)manager_thread)); pthread_cond_signal(&COND_manager); pthread_mutex_unlock(&LOCK_manager); } DBUG_VOID_RETURN; }