Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

FreeBSD 11.0 - man page for pthread_spin_destroy (freebsd section 3)

PTHREAD_SPIN_INIT(3)					   BSD Library Functions Manual 				      PTHREAD_SPIN_INIT(3)

pthread_spin_init, pthread_spin_destroy -- initialize or destroy a spin lock
POSIX Threads Library (libpthread, -lpthread)
#include <pthread.h> int pthread_spin_init(pthread_spinlock_t *lock, int pshared); int pthread_spin_destroy(pthread_spinlock_t *lock);
The pthread_spin_init() function will initialize lock to an unlocked state and allocate any resources necessary to begin using it. If pshared is set to PTHREAD_PROCESS_SHARED, any thread, whether belonging to the process in which the spinlock was created or not, that has access to the memory area where lock resides, can use lock. If it is set to PTHREAD_PROCESS_PRIVATE, it can only be used by threads within the same process. The pthread_spin_destroy() function will destroy lock and release any resources that may have been allocated on its behalf.
If successful, both pthread_spin_init() and pthread_spin_destroy() will return zero. Otherwise, an error number will be returned to indicate the error. Neither of these functions will return EINTR.
The pthread_spin_init() and pthread_spin_destroy() functions will fail if: [EBUSY] An attempt to initialize or destroy lock while it is in use. [EINVAL] The value specified by lock is invalid. The pthread_spin_init() function will fail if: [EAGAIN] Insufficient resources, other than memory, to initialize lock. [ENOMEM] Insufficient memory to initialize lock.
pthread_spin_lock(3), pthread_spin_unlock(3)
The pthread_spin_init() and pthread_spin_destroy() functions first appeared in N:M Threading Library (libkse, -lkse) in FreeBSD 5.2, and in 1:1 Threading Library (libthr, -lthr) in FreeBSD 5.3.
The implementation of pthread_spin_init() does not fully conform to IEEE Std 1003.2 (``POSIX.2'') because the pshared argument is ignored in 1:1 Threading Library (libthr, -lthr), and in N:M Threading Library (libkse, -lkse) if any value other than PTHREAD_PROCESSES_PRIVATE is specified, it returns EINVAL.
January 22, 2004 BSD

Featured Tech Videos