what's mean of the messgaes in innodb status;

[Justin Xu]

Hello, what does the below messages in "show engine innodb status;"
are there some problems in this Mysql version 5.5 ?
thanks


------------
TRANSACTIONS
------------
Trx id counter B8F147B9
Purge done for trx's n:o < B8F125BE undo n:o < 0
History list length 5429
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION B8F146A4, not started
MySQL thread id 2874156, OS thread handle 0x10f0, query id 2487515055 192.168.1.111 webadcc
---TRANSACTION B8F1250D, not started
MySQL thread id 2874150, OS thread handle 0x10ff, query id 2487509285 192.168.1.111 webadcc
---TRANSACTION B8F094C9, not started
MySQL thread id 2874100, OS thread handle 0x10dd, query id 2487481983 192.168.1.69 webapp33
---TRANSACTION B8EE7088, not started
MySQL thread id 2873921, OS thread handle 0x10f2, query id 2487377720 192.168.1.111 webadcc
---TRANSACTION 0, not started
MySQL thread id 2873819, OS thread handle 0x10fd, query id 2487515341 192.168.29.200 root
show engine innodb status
---TRANSACTION B8ECE935, not started
MySQL thread id 2873799, OS thread handle 0x1099, query id 2487303854 192.168.1.111 webadcc
---TRANSACTION B8EC15AF, not started
MySQL thread id 2873728, OS thread handle 0x110e, query id 2487410984 192.168.1.69 webapp33
---TRANSACTION 0, not started
MySQL thread id 2873727, OS thread handle 0x10e7, query id 2487263338 192.168.1.69 webapp33
---TRANSACTION B8EF650C, not started
MySQL thread id 2873275, OS thread handle 0x1070, query id 2487424222 192.168.1.69 webapp33
---TRANSACTION B8F094FA, not started
MySQL thread id 2872554, OS thread handle 0x10fe, query id 2487482034 192.168.1.69 webapp33
---TRANSACTION B8EF8328, not started
MySQL thread id 2872552, OS thread handle 0x10e9, query id 2487429439 192.168.1.69 webapp33
---TRANSACTION B8EF6156, not started
MySQL thread id 2872550, OS thread handle 0xcce, query id 2487423308 192.168.1.69 webapp33
---TRANSACTION B8F094D1, not started
MySQL thread id 2872444, OS thread handle 0x1056, query id 2487481992 192.168.1.69 webapp33
---TRANSACTION B8F11C42, not started
MySQL thread id 2872177, OS thread handle 0x10f9, query id 2487423325 192.168.1.69 webapp33
---TRANSACTION B8F13F50, not started
MySQL thread id 2871834, OS thread handle 0x10fc, query id 2487513746 192.168.1.69 webapp33
---TRANSACTION B8EF615B, not started
MySQL thread id 2871802, OS thread handle 0x10ea, query id 2487423314 192.168.1.69 webapp33
---TRANSACTION B8F12F4F, not started
MySQL thread id 2871798, OS thread handle 0x107e, query id 2487511519 192.168.1.69 webapp33
---TRANSACTION B8F094EC, not started
MySQL thread id 2871796, OS thread handle 0x10f4, query id 2487482020 192.168.1.69 webapp33
---TRANSACTION B8F094CF, not started
MySQL thread id 2871400, OS thread handle 0x1090, query id 2487481990 192.168.1.69 webapp33
---TRANSACTION B8F112C1, not started
MySQL thread id 2871184, OS thread handle 0x107b, query id 2487505299 192.168.1.69 webapp33
---TRANSACTION B8F094BF, not started
MySQL thread id 2871147, OS thread handle 0x10b7, query id 2487481965 192.168.1.69 webapp33
---TRANSACTION B8F12C0E, not started
MySQL thread id 2864926, OS thread handle 0x1055, query id 2487510702 192.168.1.69 webapp33
---TRANSACTION B8F12E05, not started
MySQL thread id 2830648, OS thread handle 0x1101, query id 2487511253 192.168.1.69 webapp33
---TRANSACTION B8F14749, not started
MySQL thread id 2770265, OS thread handle 0x10d9, query id 2487515226 192.168.1.69 webapp33
---TRANSACTION B8F14740, not started
MySQL thread id 2770262, OS thread handle 0x10ce, query id 2487515222 192.168.1.69 webapp33
---TRANSACTION B8F14747, not started
MySQL thread id 2770269, OS thread handle 0x10c5, query id 2487515224 192.168.1.69 webapp33
---TRANSACTION B8F1473C, not started
MySQL thread id 2770266, OS thread handle 0x10f8, query id 2487515213 192.168.1.69 webapp33
---TRANSACTION B8F14753, not started
MySQL thread id 2770257, OS thread handle 0x10e0, query id 2487515239 192.168.1.69 webapp33
---TRANSACTION B8F1474A, not started
MySQL thread id 2770260, OS thread handle 0x101b, query id 2487515227 192.168.1.69 webapp33
---TRANSACTION B8F14748, not started
MySQL thread id 2770270, OS thread handle 0x10ec, query id 2487515225 192.168.1.69 webapp33
---TRANSACTION B8F14741, not started
MySQL thread id 2770267, OS thread handle 0x106f, query id 2487515213 192.168.1.69 webapp33
---TRANSACTION B8F1473D, not started
MySQL thread id 2770263, OS thread handle 0x10da, query id 2487515216 192.168.1.69 webapp33
---TRANSACTION B8F1474D, not started
MySQL thread id 2770258, OS thread handle 0x108f, query id 2487515233 192.168.1.69 webapp33
---TRANSACTION B8F14746, not started
MySQL thread id 2770264, OS thread handle 0x10ed, query id 2487515220 192.168.1.69 webapp33
---TRANSACTION B8F14745, not started
MySQL thread id 2770259, OS thread handle 0x1047, query id 2487515217 192.168.1.69 webapp33
---TRANSACTION B8F1473B, not started
MySQL thread id 2770268, OS thread handle 0x10b4, query id 2487515219 192.168.1.69 webapp33
---TRANSACTION B8F1473F, not started
MySQL thread id 2770261, OS thread handle 0x1097, query id 2487515223 192.168.1.69 webapp33
---TRANSACTION B8F1475A, not started
MySQL thread id 2770256, OS thread handle 0x10c9, query id 2487515246 192.168.1.69 webapp33
---TRANSACTION B8F1475B, not started
MySQL thread id 2770255, OS thread handle 0x110b, query id 2487515247 192.168.1.69 webapp33
---TRANSACTION B8F12E04, not started
MySQL thread id 2346936, OS thread handle 0xbea, query id 2487511254 192.168.1.69 webapp33
---TRANSACTION B8F12E08, not started
MySQL thread id 2346937, OS thread handle 0x10cb, query id 2487511256 192.168.1.69 webapp33
---TRANSACTION B8F14634, not started
MySQL thread id 2346935, OS thread handle 0x10c6, query id 2487514943 192.168.1.69 webapp33
---TRANSACTION B8F147B2, not started
MySQL thread id 2346934, OS thread handle 0x109a, query id 2487515335 192.168.1.69 webapp33
---TRANSACTION B8F147B7, not started
MySQL thread id 2346927, OS thread handle 0x10e6, query id 2487515339 192.168.1.69 webapp33
---TRANSACTION B8F147B1, not started
MySQL thread id 2346928, OS thread handle 0x10e4, query id 2487515330 192.168.1.69 webapp33
---TRANSACTION B8F147AD, not started
MySQL thread id 2346925, OS thread handle 0x105d, query id 2487515331 192.168.1.69 webapp33
---TRANSACTION B8F147B4, not started
MySQL thread id 2346933, OS thread handle 0x1088, query id 2487515336 192.168.1.69 webapp33
---TRANSACTION B8F147B3, not started
MySQL thread id 2346930, OS thread handle 0x10e5, query id 2487515333 192.168.1.69 webapp33
---TRANSACTION B8F147B5, not started
MySQL thread id 2346932, OS thread handle 0x1053, query id 2487515336 192.168.1.69 webapp33
---TRANSACTION B8F147B6, not started
MySQL thread id 2346926, OS thread handle 0x10dc, query id 2487515338 192.168.1.69 webapp33
---TRANSACTION B8F147B0, not started
MySQL thread id 2346931, OS thread handle 0x10a3, query id 2487515334 192.168.1.69 webapp33
---TRANSACTION B8F147AE, not started
MySQL thread id 2346929, OS thread handle 0xa4d, query id 2487515332 192.168.1.69 webapp33
---TRANSACTION B8F147B8, not started
MySQL thread id 2346924, OS thread handle 0x10bc, query id 2487515340 192.168.1.69 webapp33
---TRANSACTION B8F14790, not started
MySQL thread id 2346637, OS thread handle 0xa60, query id 2487515300 192.168.1.69 webapp33
---TRANSACTION B8F14789, not started
MySQL thread id 2346636, OS thread handle 0xb2f, query id 2487515286 192.168.1.69 webapp33
---TRANSACTION B8F1478F, not started
MySQL thread id 2346638, OS thread handle 0xc3a, query id 2487515299 192.168.1.69 webapp33
---TRANSACTION B8F14783, not started
MySQL thread id 2346640, OS thread handle 0xc04, query id 2487515287 192.168.1.69 webapp33
---TRANSACTION B8F14782, not started
MySQL thread id 2346643, OS thread handle 0xa62, query id 2487515292 192.168.1.69 webapp33
---TRANSACTION B8F1478A, not started
MySQL thread id 2346631, OS thread handle 0xc28, query id 2487515295 192.168.1.69 webapp33
---TRANSACTION B8F14787, not started
MySQL thread id 2346635, OS thread handle 0x10d0, query id 2487515283 192.168.1.69 webapp33
---TRANSACTION B8F14788, not started
MySQL thread id 2346641, OS thread handle 0xb6c, query id 2487515290 192.168.1.69 webapp33
---TRANSACTION B8F14784, not started
MySQL thread id 2346644, OS thread handle 0xc22, query id 2487515293 192.168.1.69 webapp33
---TRANSACTION B8F14795, not started
MySQL thread id 2346634, OS thread handle 0x10a0, query id 2487515305 192.168.1.69 webapp33
---TRANSACTION B8F14780, not started
MySQL thread id 2346639, OS thread handle 0xa5a, query id 2487515289 192.168.1.69 webapp33
---TRANSACTION B8F1477E, not started
MySQL thread id 2346633, OS thread handle 0xa83, query id 2487515285 192.168.1.69 webapp33
---TRANSACTION B8F14781, not started
MySQL thread id 2346642, OS thread handle 0x9f9, query id 2487515291 192.168.1.69 webapp33
---TRANSACTION B8F14797, not started
MySQL thread id 2346632, OS thread handle 0x102d, query id 2487515307 192.168.1.69 webapp33
---TRANSACTION B8F14796, not started
MySQL thread id 2346630, OS thread handle 0x10a5, query id 2487515306 192.168.1.69 webapp33
---TRANSACTION B8F14798, not started
MySQL thread id 2346629, OS thread handle 0x10ef, query id 2487515308 192.168.1.69 webapp33
---TRANSACTION B8F1479C, not started
MySQL thread id 2346328, OS thread handle 0x108d, query id 2487515319 192.168.1.69 webapp33
---TRANSACTION B8F147AB, not started
MySQL thread id 2346318, OS thread handle 0x10ee, query id 2487515327 192.168.1.69 webapp33
---TRANSACTION B8F147A1, not started
MySQL thread id 2346325, OS thread handle 0x10e2, query id 2487515318 192.168.1.69 webapp33
---TRANSACTION B8F147A7, not started
MySQL thread id 2346319, OS thread handle 0x102a, query id 2487515310 192.168.1.69 webapp33
---TRANSACTION B8F1479D, not started
MySQL thread id 2346329, OS thread handle 0x10c0, query id 2487515321 192.168.1.69 webapp33
---TRANSACTION B8F147A4, not started
MySQL thread id 2346322, OS thread handle 0x10e8, query id 2487515316 192.168.1.69 webapp33
---TRANSACTION B8F1479A, not started
MySQL thread id 2346331, OS thread handle 0xa61, query id 2487515323 192.168.1.69 webapp33
---TRANSACTION B8F1479F, not started
MySQL thread id 2346324, OS thread handle 0x10c3, query id 2487515314 192.168.1.69 webapp33
---TRANSACTION B8F147A8, not started
MySQL thread id 2346326, OS thread handle 0x10df, query id 2487515317 192.168.1.69 webapp33
---TRANSACTION B8F14799, not started
MySQL thread id 2346327, OS thread handle 0xa71, query id 2487515319 192.168.1.69 webapp33
---TRANSACTION B8F147A2, not started
MySQL thread id 2346320, OS thread handle 0x10de, query id 2487515313 192.168.1.69 webapp33
---TRANSACTION B8F147A6, not started
MySQL thread id 2346330, OS thread handle 0x100f, query id 2487515322 192.168.1.69 webapp33
---TRANSACTION B8F147A0, not started
MySQL thread id 2346332, OS thread handle 0x10e1, query id 2487515324 192.168.1.69 webapp33
---TRANSACTION B8F147A3, not started
MySQL thread id 2346323, OS thread handle 0x10b1, query id 2487515314 192.168.1.69 webapp33
---TRANSACTION B8F147A5, not started
MySQL thread id 2346321, OS thread handle 0x1044, query id 2487515312 192.168.1.69 webapp33
---TRANSACTION B8F147AA, not started
MySQL thread id 2346317, OS thread handle 0x10e3, query id 2487515326 192.168.1.69 webapp33
---TRANSACTION B8F14763, not started
MySQL thread id 2345639, OS thread handle 0xa70, query id 2487515263 192.168.1.69 webapp33
---TRANSACTION B8F1476E, not started
MySQL thread id 2345637, OS thread handle 0x1040, query id 2487515266 192.168.1.69 webapp33
---TRANSACTION B8F1476C, not started
MySQL thread id 2345638, OS thread handle 0x1066, query id 2487515264 192.168.1.69 webapp33

......
.....



Edited 1 time(s). Last edit at 01/09/2013 01:40AM by Justin Xu.