I used pmp to get the following when it happens: [URL]https://gist.github.com/ae48bf7797f78e718bca[/URL]
Note that this is after I disabled the query cache, since the first few profiles showed some contention on that.
Is it normal to see this much waiting for open_and_lock_tables? I’m not very familiar with the mysql codebase.