I'm trying to look into an intermittent issue where an INSERT statement into a busy but relatively small InnoDB table (around 6k rows) with relatively small data (no blobs) sometimes takes 8-10 seconds. When I replicate it on an identical test table (on the same server) it doesn't ever stall. As far as I know there's no way to use EXPLAIN on an INSERT so how can I determine where it's spending the time?
Login or Sign Up
- Log in with Facebook