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_lock (freebsd section 3)

PTHREAD_SPIN_LOCK(3)					   BSD Library Functions Manual 				      PTHREAD_SPIN_LOCK(3)

pthread_spin_lock, pthread_spin_trylock, pthread_spin_unlock -- lock or unlock a spin lock
POSIX Threads Library (libpthread, -lpthread)
#include <pthread.h> int pthread_spin_lock(pthread_spinlock_t *lock); int pthread_spin_trylock(pthread_spinlock_t *lock); int pthread_spin_unlock(pthread_spinlock_t *lock);
The pthread_spin_lock() function will acquire lock if it is not currently owned by another thread. If the lock cannot be acquired immedi- ately, it will spin attempting to acquire the lock (it will not sleep) until it becomes available. The pthread_spin_trylock() function is the same as pthread_spin_lock() except that if it cannot acquire lock immediately it will return with an error. The pthread_spin_unlock() function will release lock, which must have been previously locked by a call to pthread_spin_lock() or pthread_spin_trylock().
If successful, all these functions will return zero. Otherwise, an error number will be returned to indicate the error. None of these functions will return EINTR.
The pthread_spin_lock(), pthread_spin_trylock() and pthread_spin_unlock() functions will fail if: [EINVAL] The value specified by lock is invalid or is not initialized. The pthread_spin_lock() function may fail if: [EDEADLK] The calling thread already owns the lock. The pthread_spin_trylock() function will fail if: [EBUSY] Another thread currently holds lock. The pthread_spin_unlock() function may fail if: [EPERM] The calling thread does not own lock.
pthread_spin_destroy(3), pthread_spin_init(3)
The pthread_spin_lock(), pthread_spin_trylock() and pthread_spin_unlock() 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_lock(), pthread_spin_trylock() and pthread_spin_unlock() is expected to conform to IEEE Std 1003.2 (``POSIX.2'').
January 22, 2004 BSD

Featured Tech Videos