I would like to place code into the store_lock method of our custom
storage engine to turn off all locking (we manage our own locks, and
don't want MySQL to lock anything on our behalf). At the moment I have
code that looks like this:
THR_LOCK_DATA **ha_edb::store_lock(THD *thd,
enum thr_lock_type lock_type)
Is this correct? I'm not sure if this is the code I need to downgrade
all locks to "no locking".
Also, does MySQL do any internal locking on our behalf? For example,
we can process UPDATE and long SELECT queries concurrently, and we
want to make sure there is nothing in MySQL server that will force
these queries to make it into our engine one at a time.