Hi,
Is there any way for a particular user to lock and unlock a mutex on a MySQL database, using MySQL functions?
For example, it might be that the administrator wishes to perform some lengthy and complex set of individual queries on the database, during which time it would be undesirable to allow other users to access the database, however it would be desirable to be able to silently queue other users' database queries while the administrator is working.
I know I can do this quite easily with a C wrapper using pthread_mutex_lock(pthread_mutex_t *) / pthread_mutex_unlock(pthread_mutex_t *) defined in pthread.h, but is there a built-in MySQL method of doing this?
Mike.
Is there any way for a particular user to lock and unlock a mutex on a MySQL database, using MySQL functions?
For example, it might be that the administrator wishes to perform some lengthy and complex set of individual queries on the database, during which time it would be undesirable to allow other users to access the database, however it would be desirable to be able to silently queue other users' database queries while the administrator is working.
I know I can do this quite easily with a C wrapper using pthread_mutex_lock(pthread_mutex_t *) / pthread_mutex_unlock(pthread_mutex_t *) defined in pthread.h, but is there a built-in MySQL method of doing this?
Mike.
Comment