Skip navigation links

MySQL Forums :: InnoDB :: what's mean of the messgaes in innodb status;


Advanced Search

what's mean of the messgaes in innodb status;
Posted by: Justin Xu ()
Date: January 07, 2013 09:14PM

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.

Options: ReplyQuote


Subject Views Written By Posted
what's mean of the messgaes in innodb status; 951 Justin Xu 01/07/2013 09:14PM
Re: what's mean of the messaes in innodb status; 525 aftab khan 01/08/2013 07:06AM
Re: what's mean of the messaes in innodb status; 413 Justin Xu 01/08/2013 11:29PM
Re: what's mean of the messgaes in innodb status; 309 Velja Radenkovic 02/13/2013 10:23AM
Re: what's mean of the messgaes in innodb status; 374 Rick James 02/13/2013 08:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.