Hi Tharindu,
Above deadlock occurred when we remove topic subscription.
DELETE FROM UM_HYBRID_ROLE WHERE UM_ROLE_NAME =
'Q_tmp_192_168_1_21_41372_1' AND UM_TENANT_ID=-1234
We are getting another deadlock when we adding topic subscription also.
INSERT INTO UM_HYBRID_USER_ROLE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID,
UM_DOMAIN_ID) VALUES ('admin',(SELECT UM_ID FROM UM_HYBRID_ROLE WHERE
UM_ROLE_NAME='Q_tmp_192_168_1_21_58252_1' AND UM_TENANT_ID=-1234), -1234,
(SELECT UM_DOMAIN_ID FROM UM_DOMAIN WHERE UM_TENANT_ID=-1234 AND
UM_DOMAIN_NAME='PRIMARY'))
Please find the attached text file which contains output of SHOW ENGINE
INNODB STATUS;
Cheers!
On Fri, Aug 14, 2015 at 3:40 PM, Indika Sampath <indi...@wso2.com> wrote:
> Hi Tharindu,
>
> Please find the attach text file which contains output of above command.
>
> Cheers!
>
> On Fri, Aug 14, 2015 at 1:03 PM, Tharindu Edirisinghe <tharin...@wso2.com>
> wrote:
>
>> Hi Ramith,
>>
>> It seems this is not the exact same issue reported in [1]. For
>> investigating further can you connect to mysql database from terminal/mysql
>> client and run the following command and share the output with us. We
>> should be able to see the database level errors caused from the output of
>> this command [2].
>>
>> *SHOW ENGINE INNODB STATUS;*
>>
>> [1] https://wso2.org/jira/browse/CARBON-15265
>> [2] https://dev.mysql.com/doc/refman/5.5/en/show-engine.html
>>
>> Thanks,
>> TharinduE
>>
>> On Fri, Aug 14, 2015 at 12:44 PM, Ramith Jayasinghe <ram...@wso2.com>
>> wrote:
>>
>>> $subject. Could we have a look?
>>>
>>> --
>>> Ramith Jayasinghe
>>> Technical Lead
>>> WSO2 Inc., http://wso2.com
>>> lean.enterprise.middleware
>>>
>>> E: ram...@wso2.com
>>> P: +94 777542851
>>>
>>>
>>
>>
>> --
>>
>> Tharindu Edirisinghe
>> Software Engineer | WSO2 Inc
>> Identity Server Team
>> Blog : tharindue.blogspot.com
>> mobile : +94 775 181586
>>
>>
>>
>> _______________________________________________
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
>
> --
> Indika Sampath
> Senior Software Engineer
> WSO2 Inc.
> http://wso2.com
>
> Phone: +94 716 424 744
> Blog: http://indikasampath.blogspot.com/
>
>
--
Indika Sampath
Senior Software Engineer
WSO2 Inc.
http://wso2.com
Phone: +94 716 424 744
Blog: http://indikasampath.blogspot.com/
=====================================
150814 15:45:59 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 1 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1669 1_second, 1669 sleeps, 156 10_second, 238
background, 238 flush
srv_master_thread log flush and writes: 2757
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1095210, signal count 634234
Mutex spin waits 6843782, rounds 34981966, OS waits 893336
RW-shared spins 594791, rounds 10468841, OS waits 156859
RW-excl spins 214480, rounds 2478214, OS waits 35428
Spin rounds per wait: 5.11 mutex, 17.60 RW-shared, 11.55 RW-excl
------------------------
LATEST DETECTED DEADLOCK
------------------------
150814 15:45:27
*** (1) TRANSACTION:
TRANSACTION 1FC44D6, ACTIVE 0 sec fetching rows
mysql tables in use 3, locked 3
LOCK WAIT 4 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1
MySQL thread id 285, OS thread handle 0x1664, query id 19128689 192.168.1.22
root Sending data
INSERT INTO UM_HYBRID_USER_ROLE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID,
UM_DOMAIN_ID) VALUES ('admin',(SELECT UM_ID FROM UM_HYBRID_ROLE WHERE
UM_ROLE_NAME='Q_tmp_192_168_1_21_58252_1' AND UM_TENANT_ID=-1234), -1234,
(SELECT UM_DOMAIN_ID FROM UM_DOMAIN WHERE UM_TENANT_ID=-1234 AND
UM_DOMAIN_NAME='PRIMARY'))
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 113 page no 3 n bits 168 index `PRIMARY` of table
`carbondb`.`um_hybrid_role` trx id 1FC44D6 lock mode S locks rec but not gap
waiting
Record lock, heap no 94 PHYSICAL RECORD: n_fields 5; compact format; info bits 0
0: len 4; hex 80000107; asc ;;
1: len 4; hex 7ffffb2e; asc .;;
2: len 6; hex 000001fc44d4; asc D ;;
3: len 7; hex de0005c0030110; asc ;;
4: len 26; hex 515f746d705f3139325f3136385f315f32315f34313532385f31; asc
Q_tmp_192_168_1_21_41528_1;;
*** (2) TRANSACTION:
TRANSACTION 1FC44D4, ACTIVE 0 sec fetching rows, thread declared inside InnoDB
407
mysql tables in use 3, locked 3
4 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1
MySQL thread id 260, OS thread handle 0x168c, query id 19128690 192.168.1.20
root Sending data
INSERT INTO UM_HYBRID_USER_ROLE (UM_USER_NAME, UM_ROLE_ID, UM_TENANT_ID,
UM_DOMAIN_ID) VALUES ('admin',(SELECT UM_ID FROM UM_HYBRID_ROLE WHERE
UM_ROLE_NAME='Q_tmp_192_168_1_21_41528_1' AND UM_TENANT_ID=-1234), -1234,
(SELECT UM_DOMAIN_ID FROM UM_DOMAIN WHERE UM_TENANT_ID=-1234 AND
UM_DOMAIN_NAME='PRIMARY'))
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 113 page no 3 n bits 168 index `PRIMARY` of table
`carbondb`.`um_hybrid_role` trx id 1FC44D4 lock_mode X locks rec but not gap
Record lock, heap no 94 PHYSICAL RECORD: n_fields 5; compact format; info bits 0
0: len 4; hex 80000107; asc ;;
1: len 4; hex 7ffffb2e; asc .;;
2: len 6; hex 000001fc44d4; asc D ;;
3: len 7; hex de0005c0030110; asc ;;
4: len 26; hex 515f746d705f3139325f3136385f315f32315f34313532385f31; asc
Q_tmp_192_168_1_21_41528_1;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 113 page no 3 n bits 168 index `PRIMARY` of table
`carbondb`.`um_hybrid_role` trx id 1FC44D4 lock mode S locks rec but not gap
waiting
Record lock, heap no 95 PHYSICAL RECORD: n_fields 5; compact format; info bits 0
0: len 4; hex 80000108; asc ;;
1: len 4; hex 7ffffb2e; asc .;;
2: len 6; hex 000001fc44d6; asc D ;;
3: len 7; hex e0000023820110; asc # ;;
4: len 26; hex 515f746d705f3139325f3136385f315f32315f35383235325f31; asc
Q_tmp_192_168_1_21_58252_1;;
*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 1FC475F
Purge done for trx's n:o < 1FC3F95 undo n:o < 0
History list length 1030
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 1FC3D9E, not started
MySQL thread id 294, OS thread handle 0x11e8, query id 19118563 192.168.1.22
root
---TRANSACTION 1FC3D8F, not started
MySQL thread id 292, OS thread handle 0x161c, query id 19118531 192.168.1.22
root
---TRANSACTION 1FC3D8D, not started
MySQL thread id 293, OS thread handle 0x7e0, query id 19118515 192.168.1.22 root
---TRANSACTION 1FC3D81, not started
MySQL thread id 291, OS thread handle 0x1584, query id 19118499 192.168.1.22
root
---TRANSACTION 1FC3D63, not started
MySQL thread id 290, OS thread handle 0x950, query id 19118446 192.168.1.20 root
---TRANSACTION 1FC475D, not started
MySQL thread id 285, OS thread handle 0x1664, query id 19137472 192.168.1.22
root
---TRANSACTION 1FC4059, not started
MySQL thread id 284, OS thread handle 0x17ec, query id 19121679 192.168.1.22
root
---TRANSACTION 1FC3D4A, not started
MySQL thread id 283, OS thread handle 0x9b8, query id 19118434 192.168.1.22 root
---TRANSACTION 1FC3D47, not started
MySQL thread id 289, OS thread handle 0x1188, query id 19118413 192.168.1.20
root
---TRANSACTION 1FC46A4, not started
MySQL thread id 288, OS thread handle 0x928, query id 19131739 192.168.1.20 root
---TRANSACTION 1FC3D45, not started
MySQL thread id 287, OS thread handle 0xba4, query id 19118362 192.168.1.20 root
---TRANSACTION 1FC3D44, not started
MySQL thread id 286, OS thread handle 0xbb8, query id 19118346 192.168.1.20 root
---TRANSACTION 1FC3DB4, not started
MySQL thread id 279, OS thread handle 0x1758, query id 19118579 192.168.1.20
root
---TRANSACTION 1FC4050, not started
MySQL thread id 281, OS thread handle 0x1190, query id 19121653 192.168.1.22
root
---TRANSACTION 1FC3D33, not started
MySQL thread id 280, OS thread handle 0x16a0, query id 19118304 192.168.1.22
root
---TRANSACTION 1FC3D29, not started
MySQL thread id 282, OS thread handle 0xd18, query id 19118273 192.168.1.20 root
---TRANSACTION 1FC3D93, not started
MySQL thread id 278, OS thread handle 0x33c, query id 19118547 192.168.1.22 root
---TRANSACTION 1FC3D04, not started
MySQL thread id 272, OS thread handle 0x15b0, query id 19118144 192.168.1.20
root
---TRANSACTION 1FC3D00, not started
MySQL thread id 265, OS thread handle 0x10fc, query id 19118110 192.168.1.20
root
---TRANSACTION 1FC3D76, not started
MySQL thread id 275, OS thread handle 0x1284, query id 19118483 192.168.1.22
root
---TRANSACTION 1FC3D6B, not started
MySQL thread id 277, OS thread handle 0xb3c, query id 19118466 192.168.1.22 root
---TRANSACTION 1FC3CF9, not started
MySQL thread id 276, OS thread handle 0x1678, query id 19117967 192.168.1.20
root
---TRANSACTION 1FC474B, not started
MySQL thread id 266, OS thread handle 0x14b8, query id 19133168 192.168.1.22
root
---TRANSACTION 1FC4020, not started
MySQL thread id 270, OS thread handle 0xcfc, query id 19121495 192.168.1.20 root
---TRANSACTION 1FC3D0B, not started
MySQL thread id 271, OS thread handle 0x150c, query id 19118468 192.168.1.20
root
---TRANSACTION 1FC475B, not started
MySQL thread id 273, OS thread handle 0x1094, query id 19133387 192.168.1.22
root
---TRANSACTION 1FC3D39, not started
MySQL thread id 274, OS thread handle 0x12c, query id 19118328 192.168.1.20 root
---TRANSACTION 1FC404F, not started
MySQL thread id 269, OS thread handle 0x3a0, query id 19121651 192.168.1.22 root
---TRANSACTION 1FC4021, not started
MySQL thread id 267, OS thread handle 0xb84, query id 19121493 192.168.1.20 root
---TRANSACTION 1FC474C, not started
MySQL thread id 268, OS thread handle 0x1770, query id 19133176 192.168.1.22
root
---TRANSACTION 1FC4698, not started
MySQL thread id 264, OS thread handle 0x17c0, query id 19131641 192.168.1.20
root
---TRANSACTION 1FC4057, not started
MySQL thread id 263, OS thread handle 0x1060, query id 19121678 192.168.1.22
root
---TRANSACTION 1FC475E, not started
MySQL thread id 262, OS thread handle 0x13e0, query id 19140004 192.168.1.20
root
---TRANSACTION 1FC3D8A, not started
MySQL thread id 261, OS thread handle 0xcec, query id 19118222 192.168.1.20 root
---TRANSACTION 1FC4696, not started
MySQL thread id 260, OS thread handle 0x168c, query id 19131642 192.168.1.20
root
---TRANSACTION 1FC3D9D, not started
MySQL thread id 259, OS thread handle 0x13ec, query id 19118608 192.168.1.20
root
---TRANSACTION 1FC3D89, not started
MySQL thread id 258, OS thread handle 0x9f4, query id 19118610 192.168.1.20 root
---TRANSACTION 1FC3D69, not started
MySQL thread id 255, OS thread handle 0x17e4, query id 19118598 192.168.1.22
root
---TRANSACTION 1FC3D2A, not started
MySQL thread id 256, OS thread handle 0x1574, query id 19118599 192.168.1.22
root
---TRANSACTION 1FC3D4C, not started
MySQL thread id 254, OS thread handle 0x570, query id 19118594 192.168.1.22 root
---TRANSACTION 1FC3D73, not started
MySQL thread id 252, OS thread handle 0x17f0, query id 19118601 192.168.1.22
root
---TRANSACTION 1FC3D99, not started
MySQL thread id 257, OS thread handle 0x170c, query id 19118607 192.168.1.22
root
---TRANSACTION 1FC3DA6, not started
MySQL thread id 253, OS thread handle 0xb78, query id 19118618 192.168.1.22 root
---TRANSACTION 1FC401E, not started
MySQL thread id 249, OS thread handle 0x750, query id 19121485 192.168.1.20 root
---TRANSACTION 1FC3D28, not started
MySQL thread id 250, OS thread handle 0x1578, query id 19118609 192.168.1.20
root
---TRANSACTION 1FC4028, not started
MySQL thread id 251, OS thread handle 0xc14, query id 19121510 192.168.1.20 root
---TRANSACTION 1FC475C, not started
MySQL thread id 248, OS thread handle 0x15b4, query id 19164241 192.168.1.22
root
---TRANSACTION 1FC3D7E, not started
MySQL thread id 247, OS thread handle 0x15e4, query id 19118605 192.168.1.22
root
---TRANSACTION 1FC3D5D, not started
MySQL thread id 246, OS thread handle 0x14d4, query id 19118592 192.168.1.22
root
---TRANSACTION 0, not started
MySQL thread id 244, OS thread handle 0x12f0, query id 19166478 192.168.1.52
root checking query cache for query
/* ApplicationName=DBeaver Enterprise 3.4.2 - Main */ SHOW ENGINE INNODB STATUS
---TRANSACTION 1FC3D85, not started
MySQL thread id 240, OS thread handle 0x4c0, query id 19118604 192.168.1.20 root
---TRANSACTION 1FC3D7C, not started
MySQL thread id 239, OS thread handle 0x8b4, query id 19118606 192.168.1.20 root
---TRANSACTION 1FC3D02, not started
MySQL thread id 238, OS thread handle 0xe90, query id 19118115 192.168.1.20 root
---TRANSACTION 1FC3D22, not started
MySQL thread id 221, OS thread handle 0x5c8, query id 19118580 192.168.1.20 root
---TRANSACTION 1FC3D64, not started
MySQL thread id 200, OS thread handle 0x16e0, query id 19118603 192.168.1.20
root
---TRANSACTION 1FC46A9, not started
MySQL thread id 193, OS thread handle 0x1790, query id 19166435 192.168.1.20
root
---TRANSACTION 1FC464A, not started
MySQL thread id 192, OS thread handle 0x13a4, query id 19166477 192.168.1.20
root
---TRANSACTION 1FC2A42, not started
MySQL thread id 177, OS thread handle 0x172c, query id 19114236 192.168.1.20
root
---TRANSACTION 1FC234F, not started
MySQL thread id 176, OS thread handle 0x145c, query id 19043388 192.168.1.20
root
--------
FILE I/O
--------
I/O thread 0 state: wait Windows aio (insert buffer thread)
I/O thread 1 state: wait Windows aio (log thread)
I/O thread 2 state: wait Windows aio (read thread)
I/O thread 3 state: wait Windows aio (read thread)
I/O thread 4 state: wait Windows aio (read thread)
I/O thread 5 state: wait Windows aio (read thread)
I/O thread 6 state: wait Windows aio (read thread)
I/O thread 7 state: wait Windows aio (read thread)
I/O thread 8 state: wait Windows aio (read thread)
I/O thread 9 state: wait Windows aio (read thread)
I/O thread 10 state: wait Windows aio (read thread)
I/O thread 11 state: wait Windows aio (read thread)
I/O thread 12 state: wait Windows aio (read thread)
I/O thread 13 state: wait Windows aio (read thread)
I/O thread 14 state: wait Windows aio (read thread)
I/O thread 15 state: wait Windows aio (read thread)
I/O thread 16 state: wait Windows aio (read thread)
I/O thread 17 state: wait Windows aio (read thread)
I/O thread 18 state: wait Windows aio (read thread)
I/O thread 19 state: wait Windows aio (read thread)
I/O thread 20 state: wait Windows aio (read thread)
I/O thread 21 state: wait Windows aio (read thread)
I/O thread 22 state: wait Windows aio (read thread)
I/O thread 23 state: wait Windows aio (read thread)
I/O thread 24 state: wait Windows aio (read thread)
I/O thread 25 state: wait Windows aio (read thread)
I/O thread 26 state: wait Windows aio (read thread)
I/O thread 27 state: wait Windows aio (read thread)
I/O thread 28 state: wait Windows aio (read thread)
I/O thread 29 state: wait Windows aio (read thread)
I/O thread 30 state: wait Windows aio (read thread)
I/O thread 31 state: wait Windows aio (read thread)
I/O thread 32 state: wait Windows aio (read thread)
I/O thread 33 state: wait Windows aio (read thread)
I/O thread 34 state: wait Windows aio (read thread)
I/O thread 35 state: wait Windows aio (read thread)
I/O thread 36 state: wait Windows aio (read thread)
I/O thread 37 state: wait Windows aio (read thread)
I/O thread 38 state: wait Windows aio (read thread)
I/O thread 39 state: wait Windows aio (read thread)
I/O thread 40 state: wait Windows aio (read thread)
I/O thread 41 state: wait Windows aio (read thread)
I/O thread 42 state: wait Windows aio (read thread)
I/O thread 43 state: wait Windows aio (read thread)
I/O thread 44 state: wait Windows aio (read thread)
I/O thread 45 state: wait Windows aio (read thread)
I/O thread 46 state: wait Windows aio (read thread)
I/O thread 47 state: wait Windows aio (read thread)
I/O thread 48 state: wait Windows aio (read thread)
I/O thread 49 state: wait Windows aio (read thread)
I/O thread 50 state: wait Windows aio (read thread)
I/O thread 51 state: wait Windows aio (read thread)
I/O thread 52 state: wait Windows aio (read thread)
I/O thread 53 state: wait Windows aio (read thread)
I/O thread 54 state: wait Windows aio (read thread)
I/O thread 55 state: wait Windows aio (read thread)
I/O thread 56 state: wait Windows aio (read thread)
I/O thread 57 state: wait Windows aio (read thread)
I/O thread 58 state: wait Windows aio (read thread)
I/O thread 59 state: wait Windows aio (read thread)
I/O thread 60 state: wait Windows aio (read thread)
I/O thread 61 state: wait Windows aio (read thread)
I/O thread 62 state: wait Windows aio (read thread)
I/O thread 63 state: wait Windows aio (read thread)
I/O thread 64 state: wait Windows aio (read thread)
I/O thread 65 state: wait Windows aio (read thread)
I/O thread 66 state: wait Windows aio (write thread)
I/O thread 67 state: wait Windows aio (write thread)
I/O thread 68 state: wait Windows aio (write thread)
I/O thread 69 state: wait Windows aio (write thread)
I/O thread 70 state: wait Windows aio (write thread)
I/O thread 71 state: wait Windows aio (write thread)
I/O thread 72 state: wait Windows aio (write thread)
I/O thread 73 state: wait Windows aio (write thread)
I/O thread 74 state: wait Windows aio (write thread)
I/O thread 75 state: wait Windows aio (write thread)
I/O thread 76 state: wait Windows aio (write thread)
I/O thread 77 state: wait Windows aio (write thread)
I/O thread 78 state: wait Windows aio (write thread)
I/O thread 79 state: wait Windows aio (write thread)
I/O thread 80 state: wait Windows aio (write thread)
I/O thread 81 state: wait Windows aio (write thread)
I/O thread 82 state: wait Windows aio (write thread)
I/O thread 83 state: wait Windows aio (write thread)
I/O thread 84 state: wait Windows aio (write thread)
I/O thread 85 state: wait Windows aio (write thread)
I/O thread 86 state: wait Windows aio (write thread)
I/O thread 87 state: wait Windows aio (write thread)
I/O thread 88 state: wait Windows aio (write thread)
I/O thread 89 state: wait Windows aio (write thread)
I/O thread 90 state: wait Windows aio (write thread)
I/O thread 91 state: wait Windows aio (write thread)
I/O thread 92 state: wait Windows aio (write thread)
I/O thread 93 state: wait Windows aio (write thread)
I/O thread 94 state: wait Windows aio (write thread)
I/O thread 95 state: wait Windows aio (write thread)
I/O thread 96 state: wait Windows aio (write thread)
I/O thread 97 state: wait Windows aio (write thread)
I/O thread 98 state: wait Windows aio (write thread)
I/O thread 99 state: wait Windows aio (write thread)
I/O thread 100 state: wait Windows aio (write thread)
I/O thread 101 state: wait Windows aio (write thread)
I/O thread 102 state: wait Windows aio (write thread)
I/O thread 103 state: wait Windows aio (write thread)
I/O thread 104 state: wait Windows aio (write thread)
I/O thread 105 state: wait Windows aio (write thread)
I/O thread 106 state: wait Windows aio (write thread)
I/O thread 107 state: wait Windows aio (write thread)
I/O thread 108 state: wait Windows aio (write thread)
I/O thread 109 state: wait Windows aio (write thread)
I/O thread 110 state: wait Windows aio (write thread)
I/O thread 111 state: wait Windows aio (write thread)
I/O thread 112 state: wait Windows aio (write thread)
I/O thread 113 state: wait Windows aio (write thread)
I/O thread 114 state: wait Windows aio (write thread)
I/O thread 115 state: wait Windows aio (write thread)
I/O thread 116 state: wait Windows aio (write thread)
I/O thread 117 state: wait Windows aio (write thread)
I/O thread 118 state: wait Windows aio (write thread)
I/O thread 119 state: wait Windows aio (write thread)
I/O thread 120 state: wait Windows aio (write thread)
I/O thread 121 state: wait Windows aio (write thread)
I/O thread 122 state: wait Windows aio (write thread)
I/O thread 123 state: wait Windows aio (write thread)
I/O thread 124 state: wait Windows aio (write thread)
I/O thread 125 state: wait Windows aio (write thread)
I/O thread 126 state: wait Windows aio (write thread)
I/O thread 127 state: wait Windows aio (write thread)
I/O thread 128 state: wait Windows aio (write thread)
I/O thread 129 state: wait Windows aio (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0
[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 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
1074 OS file reads, 2463060 OS file writes, 555439 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 2894, seg size 2896, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 25499819, node heap has 12 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 293636295710
Log flushed up to 293636295710
Last checkpoint at 293636295710
0 pending log writes, 0 pending chkp writes
247978 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 13186891776; in additional pool allocated 0
Dictionary memory allocated 376899
Buffer pool size 786432
Free buffers 755872
Database pages 30548
Old database pages 11194
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 475, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1027, created 29521, written 1976859
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: 30548, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 196608
Free buffers 180702
Database pages 15901
Old database pages 5849
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 128, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 852, created 15049, written 599608
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: 15901, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 196608
Free buffers 191874
Database pages 4732
Old database pages 1726
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 64, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 22, created 4710, written 439040
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: 4732, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 196608
Free buffers 191683
Database pages 4923
Old database pages 1797
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 34, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 45, created 4878, written 454949
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: 4923, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 196608
Free buffers 191613
Database pages 4992
Old database pages 1822
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 249, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 108, created 4884, written 483262
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: 4992, 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 id 2316, state: waiting for server activity
Number of rows inserted 8021657, updated 297, deleted 8001463, read 13720756
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
