If you paste the stack trace, I'll be able to give you an idea of what is happening.ĭeadlock in InnoDB is actually a legitimate scenario. Then you dig through the list of stack traces, and with a little bit of knowledge of the source you can figure out what is going on.Ī likely cause for a long "cleaning up" is some critical lock somewhere being hogged by another thread, and there could be a multitude of reasons for that. You can do something like this: gdb -ex "set pagination 0" -ex "thread apply all bt" \ When dealing with difficult MySQL diagnostic issues, quite often you have to resort to gdb.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |