Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
r67 committed - Handle new timestamp format (fixes issue 51)
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  1 message - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
inno...@googlecode.com  
View profile  
 More options Feb 25, 8:37 pm
From: inno...@googlecode.com
Date: Sun, 26 Feb 2012 01:37:05 +0000
Local: Sat, Feb 25 2012 8:37 pm
Subject: [innotop] r67 committed - Handle new timestamp format (fixes issue 51)
Revision: 67
Author:   baron.schwa...@gmail.com
Date:     Sat Feb 25 17:35:59 2012
Log:      Handle new timestamp format (fixes issue 51)
http://code.google.com/p/innotop/source/detail?r=67

Added:
  /trunk/t/innodb-status-003
  /trunk/t/innodb-status-004
  /trunk/t/innodb-status-005
Modified:
  /trunk/innotop

=======================================
--- /dev/null
+++ /trunk/t/innodb-status-003  Sat Feb 25 17:35:59 2012
@@ -0,0 +1,269 @@
+Type Name Status InnoDB
+=====================================
+111010 9:56:19 INNODB MONITOR OUTPUT
+=====================================
+Per second averages calculated from the last 46 seconds
+-----------------
+BACKGROUND THREAD
+-----------------
+srv_master_thread loops: 384353 1_second, 384352 sleeps, 38427 10_second,  
87 background, 65 flush
+srv_master_thread log flush and writes: 437110
+----------
+SEMAPHORES
+----------
+OS WAIT ARRAY INFO: reservation count 1757986, signal count 2154155
+Mutex spin waits 10064599, rounds 171797460, OS waits 835032
+RW-shared spins 1011518, rounds 22210753, OS waits 376443
+RW-excl spins 349482, rounds 17619220, OS waits 306941
+Spin rounds per wait: 17.07 mutex, 21.96 RW-shared, 50.42 RW-excl
+------------
+TRANSACTIONS
+------------
+Trx id counter 1F69D1888
+Purge done for trx's n:o < 1F69D12D8 undo n:o < 0
+History list length 2402
+LIST OF TRANSACTIONS FOR EACH SESSION:
+---TRANSACTION 0, not started
+MySQL thread id 711853, OS thread handle 0x4e95f940, query id 105609582  
localhost admin
+SHOW ENGINE INNODB STATUS
+---TRANSACTION 1F69D1887, not started
+MySQL thread id 3, OS thread handle 0x40680940, query id 105609581 Slave  
has read all relay log; waiting for the slave I/O thread to update it
+--------
+FILE I/O
+--------
+I/O thread 0 state: waiting for completed aio requests (insert buffer  
thread)
+I/O thread 1 state: waiting for completed aio requests (log thread)
+I/O thread 2 state: waiting for completed aio requests (read thread)
+I/O thread 3 state: waiting for completed aio requests (read thread)
+I/O thread 4 state: waiting for completed aio requests (read thread)
+I/O thread 5 state: waiting for completed aio requests (read thread)
+I/O thread 6 state: waiting for completed aio requests (read thread)
+I/O thread 7 state: waiting for completed aio requests (read thread)
+I/O thread 8 state: waiting for completed aio requests (read thread)
+I/O thread 9 state: waiting for completed aio requests (read thread)
+I/O thread 10 state: waiting for completed aio requests (write thread)
+I/O thread 11 state: waiting for completed aio requests (write thread)
+I/O thread 12 state: waiting for completed aio requests (write thread)
+I/O thread 13 state: waiting for completed aio requests (write thread)
+I/O thread 14 state: waiting for completed aio requests (write thread)
+I/O thread 15 state: waiting for completed aio requests (write thread)
+I/O thread 16 state: waiting for completed aio requests (write thread)
+I/O thread 17 state: waiting for completed aio requests (write thread)
+Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0,  
0, 0, 0, 0, 0, 0, 0] ,
+ ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
+Pending flushes (fsync) log: 0; buffer pool: 0
+26577594 OS file reads, 223579711 OS file writes, 14445339 OS fsyncs
+92.56 reads/s, 8192 avg bytes/read, 470.23 writes/s, 34.11 fsyncs/s
+-------------------------------------
+INSERT BUFFER AND ADAPTIVE HASH INDEX
+-------------------------------------
+Ibuf: size 1, free list len 239892, seg size 239894, 14939364 merges
+merged operations:
+ insert 15239524, delete mark 68559, delete 578
+discarded operations:
+ insert 0, delete mark 0, delete 0
+Hash table size 42499511, node heap has 2770 buffer(s)
+4591.57 hash searches/s, 2233.78 non-hash searches/s
+---
+LOG
+---
+Log sequence number 14488682912398
+Log flushed up to 14488681979708
+Last checkpoint at 14488628831318
+0 pending log writes, 0 pending chkp writes
+52129562 log i/o's done, 158.61 log i/o's/second
+----------------------
+BUFFER POOL AND MEMORY
+----------------------
+Total memory allocated 21978152960; in additional pool allocated 0
+Dictionary memory allocated 629197
+Buffer pool size 1310715
+Free buffers 2
+Database pages 2172781
+Old database pages 1086188
+Modified db pages 37825
+Pending reads 0

+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 25666511, not young 13656785
+87.89 youngs/s, 46.69 non-youngs/s
+Pages read 26577530, created 1212937, written 165977879
+92.56 reads/s, 3.80 creates/s, 296.95 writes/s
+Buffer pool hit rate 997 / 1000, young-making rate 3 / 1000 not 2 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 2172781, unzip_LRU len: 217284
+I/O sum[196720]:cur[10], unzip sum[129380]:cur[280]
+----------------------
+INDIVIDUAL BUFFER POOL INFO
+----------------------
+---BUFFER POOL 0
+Buffer pool size 131072
+Free buffers 1
+Database pages 216709
+Old database pages 108334
+Modified db pages 4044
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2616368, not young 1375080
+8.91 youngs/s, 4.46 non-youngs/s
+Pages read 2694671, created 122120, written 16823308
+9.46 reads/s, 0.48 creates/s, 29.74 writes/s
+Buffer pool hit rate 994 / 1000, young-making rate 5 / 1000 not 2 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 216709, unzip_LRU len: 21670
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 1
+Buffer pool size 131071
+Free buffers 0
+Database pages 217760
+Old database pages 108860
+Modified db pages 3952
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2543386, not young 1359308
+8.07 youngs/s, 4.65 non-youngs/s
+Pages read 2635344, created 118790, written 16490525
+9.20 reads/s, 1.30 creates/s, 29.65 writes/s
+Buffer pool hit rate 998 / 1000, young-making rate 2 / 1000 not 1 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 217760, unzip_LRU len: 21777
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 2
+Buffer pool size 131072
+Free buffers 0
+Database pages 216589
+Old database pages 108275
+Modified db pages 3917
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2548667, not young 1377767
+9.35 youngs/s, 4.37 non-youngs/s
+Pages read 2654956, created 124183, written 16720160
+9.00 reads/s, 0.54 creates/s, 29.61 writes/s
+Buffer pool hit rate 992 / 1000, young-making rate 8 / 1000 not 3 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 216589, unzip_LRU len: 21660
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 3
+Buffer pool size 131071
+Free buffers 0
+Database pages 217840
+Old database pages 108900
+Modified db pages 3637
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2564137, not young 1406406
+9.74 youngs/s, 5.11 non-youngs/s
+Pages read 2648976, created 118566, written 16286966
+9.48 reads/s, 0.09 creates/s, 29.70 writes/s
+Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 217840, unzip_LRU len: 21785
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 4
+Buffer pool size 131072
+Free buffers 0
+Database pages 216837
+Old database pages 108398
+Modified db pages 3255
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2581059, not young 1371478
+8.85 youngs/s, 4.83 non-youngs/s
+Pages read 2674161, created 121745, written 16991661
+9.50 reads/s, 0.11 creates/s, 29.70 writes/s
+Buffer pool hit rate 992 / 1000, young-making rate 8 / 1000 not 4 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 216837, unzip_LRU len: 21684
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 5
+Buffer pool size 131071
+Free buffers 0
+Database pages 217830
+Old database pages 108895
+Modified db pages 3890
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2479065, not young 1320844
+8.24 youngs/s, 4.39 non-youngs/s
+Pages read 2611513, created 120326, written 16305231
+8.54 reads/s, 0.50 creates/s, 29.65 writes/s
+Buffer pool hit rate 991 / 1000, young-making rate 9 / 1000 not 5 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 217830, unzip_LRU len: 21784
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 6
+Buffer pool size 131072
+Free buffers 1
+Database pages 216749
+Old database pages 108354
+Modified db pages 3825
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2653763, not young 1385736
+8.65 youngs/s, 4.61 non-youngs/s
+Pages read 2712296, created 122124, written 16771177
+9.37 reads/s, 0.43 creates/s, 29.70 writes/s
+Buffer pool hit rate 994 / 1000, young-making rate 5 / 1000 not 3 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 216749, unzip_LRU len: 21674
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 7
+Buffer pool size 131071
+Free buffers 0
+Database pages 217891
+Old database pages 108925
+Modified db pages 3463
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2525387, not young 1325427
+8.43 youngs/s, 4.50 non-youngs/s
+Pages read 2627162, created 123347, written 16236437
+9.70 reads/s, 0.26 creates/s, 29.74 writes/s
+Buffer pool hit rate 987 / 1000, young-making rate 11 / 1000 not 6 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 217891, unzip_LRU len: 21791
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 8
+Buffer pool size 131072
+Free buffers 0
+Database pages 216769
+Old database pages 108364
+Modified db pages 4080
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2607735, not young 1380831
+9.17 youngs/s, 5.04 non-youngs/s
+Pages read 2699519, created 121948, written 16981677
+9.11 reads/s, 0.00 creates/s, 29.65 writes/s
+Buffer pool hit rate 992 / 1000, young-making rate 8 / 1000 not 4 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 216769, unzip_LRU len: 21678
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+---BUFFER POOL 9
+Buffer pool size 131071
+Free buffers 0
+Database pages 217807
+Old database pages 108883
+Modified db pages 3762
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 2546944, not young 1353908
+8.48 youngs/s, 4.74 non-youngs/s
+Pages read 2618932, created 119788, written 16370737
+9.22 reads/s, 0.09 creates/s, 29.83 writes/s
+Buffer pool hit rate 990 / 1000, young-making rate 9 / 1000 not 5 / 1000
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 217807, unzip_LRU len: 21781
+I/O sum[19672]:cur[1], unzip sum[12938]:cur[28]
+--------------
+ROW OPERATIONS
+--------------
+0 queries inside InnoDB, 0 queries in queue
+1 read views open inside InnoDB
+Main thread process no. 13224, id 1285777728, state: sleeping
+Number of rows inserted 56419253, updated 89734067, deleted 4113, read  
1369226134
+182.82 inserts/s, 324.15 updates/s, 0.00 deletes/s, 5380.27 reads/s
+----------------------------
+END OF INNODB MONITOR OUTPUT
+============================
+
=======================================
--- /dev/null
+++ /trunk/t/innodb-status-004  Sat Feb 25 17:35:59 2012
@@ -0,0 +1,133 @@
+*************************** 1. row ***************************
+  Type: InnoDB
+  Name:
+Status:
+=====================================
+120118 13:23:16 INNODB MONITOR OUTPUT
+=====================================
+Per second averages calculated from the last 39 seconds
+-----------------
+BACKGROUND THREAD
+-----------------
+srv_master_thread loops: 115984 1_second, 115983 sleeps, 11253 10_second,  
7921 background, 7921 flush
+srv_master_thread log flush and writes: 118163
+----------
+SEMAPHORES
+----------
+OS WAIT ARRAY INFO: reservation count 24103, signal count 25061
+Mutex spin waits 50177, rounds 436385, OS waits 4143
+RW-shared spins 17481, rounds 505350, OS waits 16775
+RW-excl spins 259, rounds 93826, OS waits 3039
+Spin rounds per wait: 8.70 mutex, 28.91 RW-shared, 362.26 RW-excl
+------------------------
+LATEST DETECTED DEADLOCK
+------------------------
+111226 14:48:08
+*** (1) TRANSACTION:
+TRANSACTION 6FE138, ACTIVE 0 sec inserting
+mysql tables in use 1, locked 1
+LOCK WAIT 4 lock struct(s), heap size 1248, 3 row lock(s)
+MySQL thread id 424565, OS thread handle 0x40e13940, query id 446715  
<anonymized>
+INSERT INTO cache_menu <anonymized>
+*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
+RECORD LOCKS space id 7169 page no 14 n bits 80 index "PRIMARY" of  
table "<anonymized>"."cache_menu" trx id 6FE138 lock_mode X insert  
intention waiting
+Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info  
bits 0
+ 0: len 8; hex 73757072656d756d; asc supremum;;
+
+*** (2) TRANSACTION:
+TRANSACTION 6FE12E, ACTIVE 0 sec inserting
+mysql tables in use 1, locked 1
+4 lock struct(s), heap size 1248, 3 row lock(s)
+MySQL thread id 424568, OS thread handle 0x40e57940, query id 446716  
<anonymized>
+INSERT INTO cache_menu <anonymized>
+*** (2) HOLDS THE LOCK(S):
+RECORD LOCKS space id 7169 page no 14 n bits 80 index "PRIMARY" of  
table "<anonymized>"."cache_menu" trx id 6FE12E lock_mode X
+Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info  
bits 0
+ 0: len 8; hex 73757072656d756d; asc supremum;;
+
+*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
+RECORD LOCKS space id 7169 page no 14 n bits 80 index "PRIMARY" of  
table "<anonymized>"."cache_menu" trx id 6FE12E lock_mode X insert  
intention waiting
+Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info  
bits 0
+ 0: len 8; hex 73757072656d756d; asc supremum;;
+
+*** WE ROLL BACK TRANSACTION (2)
+------------
+TRANSACTIONS
+------------
+Trx id counter 9BB413
+Purge done for trx's n:o < 9BB412 undo n:o < 0
+History list length 1001
+LIST OF TRANSACTIONS FOR EACH SESSION:
+---TRANSACTION 0, not started
+MySQL thread id 2724342, OS thread handle 0x4996d940, query id 131346550  
localhost root
+SHOW ENGINE INNODB STATUS
+---TRANSACTION 0, not started
+MySQL thread id 2724315, OS thread handle 0x40e13940, query id 131346524  
localhost root
+--------
+FILE I/O
+--------
+I/O thread 0 state: waiting for i/o request (insert buffer thread)
+I/O thread 1 state: waiting for i/o request (log thread)
+I/O thread 2 state: waiting for i/o request (read thread)
+I/O thread 3 state: waiting for i/o request (read thread)
+I/O thread 4 state: waiting for i/o request (read thread)
+I/O thread 5 state: waiting for i/o request (read thread)
+I/O thread 6 state: waiting for i/o request (write thread)
+I/O thread 7 state: waiting for i/o request (write thread)
+I/O thread 8 state: waiting for i/o request (write thread)
+I/O thread 9 state: waiting for i/o request (write thread)
+Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
+ ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
+Pending flushes (fsync) log: 0; buffer pool: 0
+21645 OS file reads, 3808477 OS file writes, 2998804 OS fsyncs
+0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
+-------------------------------------
+INSERT BUFFER AND ADAPTIVE HASH INDEX
+-------------------------------------
+Ibuf: size 1, free list len 18, seg size 20, 477 merges
+merged operations:
+ insert 97, delete mark 8225, delete 913
+discarded operations:
+ insert 0, delete mark 0, delete 0
+Hash table size 796937, node heap has 1764 buffer(s)
+0.00 hash searches/s, 0.00 non-hash searches/s
+---
+LOG
+---
+Log sequence number 10105955776
+Log flushed up to   10105955776
+Last checkpoint at  10105955776
+0 pending log writes, 0 pending chkp writes
+2702576 log i/o's done, 0.00 log i/o's/second
+----------------------
+BUFFER POOL AND MEMORY
+----------------------
+Total memory allocated 412090368; in additional pool allocated 0
+Dictionary memory allocated 11180352
+Buffer pool size   24575
+Free buffers       8
+Database pages     22803
+Old database pages 8397
+Modified db pages  0
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 49712, not young 0
+0.00 youngs/s, 0.00 non-youngs/s
+Pages read 21483, created 97048, written 2192576
+0.00 reads/s, 0.00 creates/s, 0.00 writes/s
+No buffer pool page gets since the last printout
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 22803, unzip_LRU len: 0
+I/O sum[0]:cur[0], unzip sum[0]:cur[0]
+--------------
+ROW OPERATIONS
+--------------
+0 queries inside InnoDB, 0 queries in queue
+1 read views open inside InnoDB
+Main thread process no. 4958, id 1201822016, state: waiting for server  
activity
+Number of rows inserted 2719476, updated 1504406, deleted 877686, read  
170171101
+0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
+----------------------------
+END OF INNODB MONITOR OUTPUT
+============================
+
=======================================
--- /dev/null
+++ /trunk/t/innodb-status-005  Sat Feb 25 17:35:59 2012
@@ -0,0 +1,118 @@
+*************************** 1. row ***************************
+  Type: InnoDB
+  Name:
+Status:
+=====================================
+120125  0:58:17 INNODB MONITOR OUTPUT
+=====================================
+Per second averages calculated from the last 10 seconds
+-----------------
+BACKGROUND THREAD
+-----------------
+srv_master_thread loops: 68 1_second, 68 sleeps, 6 10_second, 8  
background, 8 flush
+srv_master_thread log flush and writes: 68
+----------
+SEMAPHORES
+----------
+OS WAIT ARRAY INFO: reservation count 5, signal count 4
+Mutex spin waits 2, rounds 60, OS waits 2
+RW-shared spins 3, rounds 90, OS waits 3
+RW-excl spins 0, rounds 0, OS waits 0
+Spin rounds per wait: 30.00 mutex, 30.00 RW-shared, 0.00 RW-excl
+--------
+FILE I/O
+--------
+I/O thread 0 state: waiting for i/o request (insert buffer thread)
+I/O thread 1 state: waiting for i/o request (log thread)
+I/O thread 2 state: waiting for i/o request (read thread)
+I/O thread 3 state: waiting for i/o request (read thread)
+I/O thread 4 state: waiting for i/o request (read thread)
+I/O thread 5 state: waiting for i/o request (read thread)
+I/O thread 6 state: waiting for i/o request (write thread)
+I/O thread 7 state: waiting for i/o request (write thread)
+I/O thread 8 state: waiting for i/o request (write thread)
+I/O thread 9 state: waiting for i/o request (write thread)
+Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
+ ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
+Pending flushes (fsync) log: 0; buffer pool: 0
+159 OS file reads, 12 OS file writes, 8 OS fsyncs
+0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
+-------------------------------------
+INSERT BUFFER AND ADAPTIVE HASH INDEX
+-------------------------------------
+Ibuf: size 1, free list len 0, seg size 2, 0 merges
+merged operations:
+ insert 0, delete mark 0, delete 0
+discarded operations:
+ insert 0, delete mark 0, delete 0
+Hash table size 5291753, node heap has 1 buffer(s)
+0.00 hash searches/s, 0.00 non-hash searches/s
+---
+LOG
+---
+Log sequence number 1603188
+Log flushed up to   1603188
+Last checkpoint at  1603188
+Max checkpoint age    162363434
+Checkpoint age target 157289577
+Modified age          0
+Checkpoint age        0
+0 pending log writes, 0 pending chkp writes
+12 log i/o's done, 0.00 log i/o's/second
+----------------------
+BUFFER POOL AND MEMORY
+----------------------
+Total memory allocated 1356857344; in additional pool allocated 0
+Internal hash tables (constant factor + variable factor)
+    Adaptive hash index 21187556       (21167012 + 20544)
+    Page hash           661876 (buffer pool 0 only)
+    Dictionary cache    5316101        (5292824 + 23277)
+    File system         42020  (41336 + 684)
+    Lock system         1654404        (1654084 + 320)
+    Recovery system     0      (0 + 0)
+Dictionary memory allocated 23277
+Buffer pool size        81599
+Buffer pool size, bytes 1336918016
+Free buffers            81451
+Database pages          147
+Old database pages      0
+Modified db pages       0
+Pending reads 0
+Pending writes: LRU 0, flush list 0, single page 0

+Pages made young 0, not young 0
+0.00 youngs/s, 0.00 non-youngs/s
+Pages read 147, created 0, written 4
+0.00 reads/s, 0.00 creates/s, 0.00 writes/s
+No buffer pool page gets since the last printout
+Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead  
0.00/s
+LRU len: 147, unzip_LRU len: 0
+I/O sum[0]:cur[0], unzip sum[0]:cur[0]
+--------------
+ROW OPERATIONS
+--------------
+0 queries inside InnoDB, 0 queries in queue
+1 read views open inside InnoDB
+---OLDEST VIEW---
+Normal read view
+Read view low limit trx n:o 500
+Read view up limit trx id 500
+Read view low limit trx id 500
+Read view individually stored trx ids:
+-----------------
+Main thread process no. 27684, id 1498786704, state: waiting for server  
activity
+Number of rows inserted 1, updated 0, deleted 0, read 0
+0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
+------------
+TRANSACTIONS
+------------
+Trx id counter 506
+Purge done for trx's n:o < 0 undo n:o < 0
+History list length 0
+LIST OF TRANSACTIONS FOR EACH SESSION:
+---TRANSACTION 0, not started
+MySQL thread id 43579, OS thread handle 0x5b83eb90, query id 145519  
localhost root
+show engine innodb status
+----------------------------
+END OF INNODB MONITOR OUTPUT
+============================
+
=======================================
--- /trunk/innotop      Sat Feb 25 17:19:30 2012
+++ /trunk/innotop      Sat Feb 25 17:35:59 2012
@@ -369,7 +369,7 @@
  my $w  = qr/(\w+)/;                    # Words
  my $fl = qr/([\w\.\/]+) line $d/;      # Filename and line number
  my $h  = qr/((?:0x)?[0-9a-f]*)/;       # Hex
-my $s  = qr/(\d{6} .\d:\d\d:\d\d)/;    # InnoDB timestamp
+my $s  = qr/(\d{6} .?\d:\d\d:\d\d)/;   # InnoDB timestamp

  # If you update this variable, also update the SYNOPSIS in the pod.
  my %innodb_section_headers = (
@@ -506,10 +506,15 @@
              $innodb_sections{$section}->[1] ||= $innodb_data{'got_all'};
           }

-         $innodb_data{'sections'}->{ $header }
-            ->{'fulltext'} = $innodb_sections{$section}->[0];
-         $innodb_data{'sections'}->{ $header }
-            ->{'complete'} = $innodb_sections{$section}->[1];
+         if ( $header && $section ) {
+            $innodb_data{'sections'}->{ $header }
+               ->{'fulltext'} = $innodb_sections{$section}->[0];
+            $innodb_data{'sections'}->{ $header }
+               ->{'complete'} = $innodb_sections{$section}->[1];
+         }
+         else {
+            _debug( $debug, "header = " . ($header || 'undef') . ",  
section = " . ($section || 'undef')) if $debug;
+         }
        }
     };
     if ( $EVAL_ERROR ) {


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »