![]() OS WAIT ARRAY INFO: reservation count 13486 Srv_master_thread log flush and writes: 27447 Srv_master_thread loops: 26859 srv_active, 0 srv_shutdown, 588 srv_idle Per second averages calculated from the last 50 seconds ![]() ![]() Trx read view will not see trx with id >= 13339315174, sees = 13339315174, sees show engine innodb status \G MySQL thread id 28, OS thread handle 0x1a68, query id 37763097 localhost 127.0.0 In my logs, it looks like I get LOCK WAIT TIMEOUTS, The problem looks like it is in MySQL, in a SHOW ENGINE INNODB STATUS\G this is usually what we see: -TRANSACTION 13339315173, ACTIVE 1339 secġ7 lock struct(s), heap size 3112, 28 row lock(s), undo log entries 236 1-2 times a day the application hangs and restarting the server gets things back running. I have a Rails application running on mysql 5.6.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |