Brad Fitzpatrick (bradfitz) wrote in lj_dev,
Brad Fitzpatrick
bradfitz
lj_dev

System lock ?

Sometimes when I'm looking at "show processlist" in MySQL I see that certain threads are in the "System lock" state.

I assume this means the db is using flock on the files? I can't find documentation about this state.

However, I'm not running mysqld with --enable-locking! I'm using --skip-locking, which "show status" confirms:

skip_locking ON

So are we losing performance because of this? Or is MySQL should going doing something like:

set_state("System Lock");
// we are here?
if (! skip_locking) {
flock(....);
}
set_state("Sending data...");

This disturbs me.
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 15 comments