locking mysql problems
mysql skip-locking is on by default. but i dont' want it on. i'm having problems b/c my pages are being served up by apache which reference my mysql tables. i need to have them locked up...therefore "skip-locking" needs to be off....
see:
#mysqladmin -u root -p variables
<prompt for password>
so pages being servered won't be trying to accessed during mysql maintainace (table fix to be exact). we've also had some problems with the mysql queue backing up whenever we just simply cut off mysql when trying to check and fix the table. queue gets filled up too fast and explodes...hard to get mysql running again. i'm hoping getting this table locking works..but it will only work if i can se that "skip-locking" to off. does anyone know how to edit the variables (skip-locking to be exact) in mysql?
|