Skip to content

Instantly share code, notes, and snippets.

@chrishomer

chrishomer/gist:3758910

Created September 20, 2012 23:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chrishomer/3758910 to your computer and use it in GitHub Desktop.
Save chrishomer/3758910 to your computer and use it in GitHub Desktop.
Download ZIP
SHOW ENGINE INNODB STATUS
Raw
gistfile1.txt
| InnoDB | |
=====================================
120920 22:53:10 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 49 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 46401 1_second, 45420 sleeps, 4635 10_second, 70 background, 70 flush
srv_master_thread log flush and writes: 48122
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 932347, signal count 36368075
Mutex spin waits 109610481, rounds 78572935, OS waits 90152
RW-shared spins 10236124, rounds 30108124, OS waits 397019
RW-excl spins 4741349, rounds 49830141, OS waits 399532
Spin rounds per wait: 0.72 mutex, 2.94 RW-shared, 10.51 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 3B1A15EAC
Purge done for trx's n:o < 3B1A14EB4 undo n:o < 0
History list length 1836
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started, process no 19564, OS thread id 1288399168
MySQL thread id 8561, query id 14744931 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1099692352
MySQL thread id 8551, query id 14718181 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1098750272
MySQL thread id 8550, query id 14741311 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1242872128
MySQL thread id 8549, query id 14741020 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1244469568
MySQL thread id 8548, query id 14718744 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1101023552
MySQL thread id 8547, query id 14709082 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1258314048
MySQL thread id 8546, query id 14709099 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1267099968
MySQL thread id 8544, query id 14719050 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1282275648
MySQL thread id 8542, query id 14721068 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1270561088
MySQL thread id 8541, query id 14751682 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A140E4, not started, process no 19564, OS thread id 1247131968
MySQL thread id 8535, query id 14745022 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A13A03, not started, process no 19564, OS thread id 1281210688
MySQL thread id 8530, query id 14745107 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A13FEE, not started, process no 19564, OS thread id 1244735808
MySQL thread id 8534, query id 14744640 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A10AE4, not started, process no 19564, OS thread id 1280145728
MySQL thread id 8531, query id 14727894 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A13B10, not started, process no 19564, OS thread id 1279347008
MySQL thread id 8532, query id 14743293 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1247930688
MySQL thread id 8527, query id 14731290 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1100224832
MySQL thread id 8526, query id 14729072 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1261242688
MySQL thread id 8525, query id 14717984 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1255917888
MySQL thread id 8524, query id 14713589 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1249261888
MySQL thread id 8523, query id 14739636 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1287067968
MySQL thread id 8522, query id 14709730 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1276152128
MySQL thread id 8521, query id 14718347 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1243670848
MySQL thread id 8520, query id 14719053 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1104107840
MySQL thread id 8519, query id 14712435 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1098217792
MySQL thread id 8518, query id 14693891 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1275353408
MySQL thread id 8517, query id 14713885 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1242605888
MySQL thread id 8516, query id 14751003 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1259645248
MySQL thread id 8514, query id 14702764 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1250593088
MySQL thread id 8513, query id 14748517 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1250859328
MySQL thread id 8512, query id 14610415 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1102813504
MySQL thread id 8511, query id 14722255 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1255119168
MySQL thread id 8508, query id 14743129 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1100757312
MySQL thread id 8507, query id 14743093 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1272691008
MySQL thread id 8506, query id 14742664 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1099282752
MySQL thread id 8504, query id 14612458 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1253787968
MySQL thread id 8503, query id 14703027 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1291860288
MySQL thread id 8502, query id 14750827 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1257515328
MySQL thread id 8501, query id 14741202 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1280678208
MySQL thread id 8500, query id 14748349 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1259379008
MySQL thread id 8499, query id 14740145 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1283074368
MySQL thread id 8498, query id 14739624 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1101289792
MySQL thread id 8497, query id 14739486 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1262573888
MySQL thread id 8496, query id 14736614 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1267898688
MySQL thread id 8495, query id 14734716 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1265768768
MySQL thread id 8494, query id 14752617 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1276418368
MySQL thread id 8493, query id 14695503 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1097951552
MySQL thread id 8492, query id 14713884 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1259112768
MySQL thread id 8491, query id 14742670 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1252723008
MySQL thread id 8490, query id 14713600 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1245800768
MySQL thread id 8489, query id 14713587 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1288931648
MySQL thread id 8488, query id 14719052 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1250326848
MySQL thread id 8487, query id 14713431 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1266833728
MySQL thread id 8486, query id 14713435 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1260710208
MySQL thread id 8485, query id 14713149 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1252989248
MySQL thread id 8484, query id 14719056 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1269496128
MySQL thread id 8483, query id 14750163 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1243138368
MySQL thread id 8482, query id 14750062 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1253521728
MySQL thread id 8481, query id 14712977 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1262041408
MySQL thread id 8480, query id 14712905 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1268164928
MySQL thread id 8479, query id 14712665 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1247398208
MySQL thread id 8478, query id 14712573 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1285204288
MySQL thread id 8477, query id 14740447 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1288132928
MySQL thread id 8476, query id 14712289 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1268431168
MySQL thread id 8475, query id 14719012 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1278282048
MySQL thread id 8474, query id 14718941 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1246599488
MySQL thread id 8473, query id 14594961 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1248995648
MySQL thread id 8472, query id 14710456 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1290795328
MySQL thread id 8471, query id 14739653 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1280944448
MySQL thread id 8470, query id 14747789 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1264970048
MySQL thread id 8469, query id 14693651 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1279879488
MySQL thread id 8467, query id 14718613 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1277483328
MySQL thread id 8466, query id 14727398 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1243937088
MySQL thread id 8465, query id 14718580 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1260177728
MySQL thread id 8464, query id 14747595 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1274554688
MySQL thread id 8463, query id 14739416 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1289996608
MySQL thread id 8462, query id 14747415 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1245268288
MySQL thread id 8461, query id 14693484 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1096087872
MySQL thread id 8460, query id 14709725 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1103841600
MySQL thread id 8459, query id 14709721 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1250060608
MySQL thread id 8458, query id 14692480 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1245002048
MySQL thread id 8457, query id 14746123 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A1410A, not started, process no 19564, OS thread id 1241274688
MySQL thread id 8456, query id 14744998 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A13A2B, not started, process no 19564, OS thread id 1286535488
MySQL thread id 8454, query id 14743016 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0FDCF, not started, process no 19564, OS thread id 1292659008
MySQL thread id 8453, query id 14724392 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A111B2, not started, process no 19564, OS thread id 1258580288
MySQL thread id 8451, query id 14729730 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A13A1D, not started, process no 19564, OS thread id 1292925248
MySQL thread id 8450, query id 14745016 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0EDD7, not started, process no 19564, OS thread id 1101556032
MySQL thread id 8447, query id 14719934 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A141B6, not started, process no 19564, OS thread id 1102088512
MySQL thread id 8449, query id 14745230 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0F255, not started, process no 19564, OS thread id 1279613248
MySQL thread id 8443, query id 14721299 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A14138, not started, process no 19564, OS thread id 1249528128
MySQL thread id 8442, query id 14745182 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0F279, not started, process no 19564, OS thread id 1275885888
MySQL thread id 8441, query id 14721356 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A13DCB, not started, process no 19564, OS thread id 1273755968
MySQL thread id 8440, query id 14744044 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A141AD, not started, process no 19564, OS thread id 1241540928
MySQL thread id 8439, query id 14745216 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0FED4, not started, process no 19564, OS thread id 1264703808
MySQL thread id 8438, query id 14724655 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A141C5, not started, process no 19564, OS thread id 1271093568
MySQL thread id 8437, query id 14745260 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0EDAF, not started, process no 19564, OS thread id 1268963648
MySQL thread id 8436, query id 14719929 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0F036, not started, process no 19564, OS thread id 1284938048
MySQL thread id 8435, query id 14720654 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0EDC6, not started, process no 19564, OS thread id 1244203328
MySQL thread id 8433, query id 14719960 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0EA08, not started, process no 19564, OS thread id 1245534528
MySQL thread id 8431, query id 14719914 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A13AE6, not started, process no 19564, OS thread id 1104374080
MySQL thread id 8418, query id 14743248 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A14149, not started, process no 19564, OS thread id 1095821632
MySQL thread id 8427, query id 14745158 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0F2EC, not started, process no 19564, OS thread id 1095555392
MySQL thread id 8416, query id 14721505 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A14198, not started, process no 19564, OS thread id 1242339648
MySQL thread id 8409, query id 14745185 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A1420C, not started, process no 19564, OS thread id 1263638848
MySQL thread id 8413, query id 14745387 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A15EAB, not started, process no 19564, OS thread id 1265236288
MySQL thread id 8411, query id 14754478 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A14234, not started, process no 19564, OS thread id 1272957248
MySQL thread id 8414, query id 14745418 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A1419C, not started, process no 19564, OS thread id 1282009408
MySQL thread id 8429, query id 14745189 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0EDB8, not started, process no 19564, OS thread id 1272158528
MySQL thread id 8419, query id 14719878 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A139CF, not started, process no 19564, OS thread id 1267632448
MySQL thread id 8425, query id 14742872 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A140F9, not started, process no 19564, OS thread id 1286003008
MySQL thread id 8428, query id 14745146 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0F449, not started, process no 19564, OS thread id 1261775168
MySQL thread id 8417, query id 14729810 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A14174, not started, process no 19564, OS thread id 1256450368
MySQL thread id 8424, query id 14745138 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A145FD, not started, process no 19564, OS thread id 1264437568
MySQL thread id 8407, query id 14746833 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0F26B, not started, process no 19564, OS thread id 1283873088
MySQL thread id 8408, query id 14721344 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0F043, not started, process no 19564, OS thread id 1099016512
MySQL thread id 8406, query id 14729794 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A141DB, not started, process no 19564, OS thread id 1103345984
MySQL thread id 8405, query id 14745286 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B19F1EB0, not started, process no 19564, OS thread id 1287866688
MySQL thread id 8404, query id 14718348 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A141BC, not started, process no 19564, OS thread id 1097152832
MySQL thread id 8403, query id 14745277 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A14196, not started, process no 19564, OS thread id 1279080768
MySQL thread id 8400, query id 14745207 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1288665408
MySQL thread id 8402, query id 14746083 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A1575A, not started, process no 19564, OS thread id 1248196928 flushing log
MySQL thread id 8401, query id 14752405 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 0, not started, process no 19564, OS thread id 1291594048
MySQL thread id 8398, query id 14745866 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A09760, not started, process no 19564, OS thread id 1287600448
MySQL thread id 8397, query id 14737634 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A11195, not started, process no 19564, OS thread id 1274022208
MySQL thread id 8396, query id 14729688 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A13FBA, not started, process no 19564, OS thread id 1274820928
MySQL thread id 8395, query id 14744546 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0F1EB, not started, process no 19564, OS thread id 1276684608
MySQL thread id 8390, query id 14721169 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A10C18, not started, process no 19564, OS thread id 1252190528
MySQL thread id 8393, query id 14728220 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1101822272
MySQL thread id 8392, query id 14745258 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1096620352
MySQL thread id 8389, query id 14709416 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0F7EB, not started, process no 19564, OS thread id 1290529088
MySQL thread id 8388, query id 14722846 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0F801, not started, process no 19564, OS thread id 1265502528
MySQL thread id 8387, query id 14722869 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A13FED, not started, process no 19564, OS thread id 1100491072
MySQL thread id 8386, query id 14744637 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A10947, not started, process no 19564, OS thread id 1266035008
MySQL thread id 8384, query id 14727384 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A139DB, not started, process no 19564, OS thread id 1257781568
MySQL thread id 8383, query id 14745303 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A13A7C, not started, process no 19564, OS thread id 1277749568
MySQL thread id 8382, query id 14745064 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0F252, not started, process no 19564, OS thread id 1254054208
MySQL thread id 8380, query id 14721295 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0F2A7, not started, process no 19564, OS thread id 1264171328
MySQL thread id 8379, query id 14721441 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0F318, not started, process no 19564, OS thread id 1266567488
MySQL thread id 8378, query id 14721563 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1251658048
MySQL thread id 8377, query id 14708486 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1277217088
MySQL thread id 8376, query id 14736525 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A10CA1, not started, process no 19564, OS thread id 1243404608
MySQL thread id 8373, query id 14728368 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A14455, not started, process no 19564, OS thread id 1254852928
MySQL thread id 8372, query id 14746305 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A156E4, not started, process no 19564, OS thread id 1260443968
MySQL thread id 8371, query id 14752273 ip-10-60-194-125.ec2.internal 10.60.194.125 admin Copying to group table
SELECT categories.name as cat_name, count(distinct items.id) as category_count FROM `items` INNER JOIN `categories` ON `categories`.`id` = `items`.`category_id` WHERE `items`.`state` IN ('listed', 'reserved', 'purchased', 'packed', 'sent', 'received') AND (items.category_id IS NOT NULL) GROUP BY categories.name ORDER BY category_count desc LIMIT 10
---TRANSACTION 3B1A14126, not started, process no 19564, OS thread id 1292392768
MySQL thread id 8370, query id 14745019 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A156EE, not started, process no 19564, OS thread id 1284671808 flushing log
MySQL thread id 8366, query id 14752292 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A0ECA5, not started, process no 19564, OS thread id 1271892288
MySQL thread id 8365, query id 14719935 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A0EFDB, not started, process no 19564, OS thread id 1270827328
MySQL thread id 8362, query id 14720576 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A13B2E, not started, process no 19564, OS thread id 1291061568
MySQL thread id 8361, query id 14745315 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0EFDD, not started, process no 19564, OS thread id 1102547264
MySQL thread id 8360, query id 14720558 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1283606848
MySQL thread id 8356, query id 14725687 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1284139328
MySQL thread id 8353, query id 14716146 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1282808128
MySQL thread id 8351, query id 14707750 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1103079744
MySQL thread id 8349, query id 14709063 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1255385408
MySQL thread id 8348, query id 14581524 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B19E2463, not started, process no 19564, OS thread id 1249794368
MySQL thread id 8347, query id 14737059 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1097419072
MySQL thread id 8345, query id 14744911 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B19F122B, not started, process no 19564, OS thread id 1257249088
MySQL thread id 8340, query id 14735401 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1256982848
MySQL thread id 8339, query id 14695737 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1267366208
MySQL thread id 8315, query id 14715329 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1097685312
MySQL thread id 8314, query id 14706227 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A10CA2, not started, process no 19564, OS thread id 1268697408
MySQL thread id 8297, query id 14728371 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A14015, not started, process no 19564, OS thread id 1289464128
MySQL thread id 8305, query id 14744691 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A14142, not started, process no 19564, OS thread id 1256716608
MySQL thread id 8271, query id 14745133 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A13B70, not started, process no 19564, OS thread id 1263106368
MySQL thread id 8261, query id 14743423 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A13B3F, not started, process no 19564, OS thread id 1273223488
MySQL thread id 8258, query id 14745153 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A141C9, not started, process no 19564, OS thread id 1285470528
MySQL thread id 8233, query id 14745256 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
---TRANSACTION 3B1A0F001, not started, process no 19564, OS thread id 1095022912
MySQL thread id 8231, query id 14720626 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
---TRANSACTION 3B1A1397A, not started, process no 19564, OS thread id 1246067008
MySQL thread id 7870, query id 14742771 ip-10-218-41-183.ec2.internal 10.218.41.183 admin
---TRANSACTION 3B180FBC5, not started, process no 19564, OS thread id 1269762368
MySQL thread id 6547, query id 11735145 ip-10-218-41-183.ec2.internal 10.218.41.183 admin
---TRANSACTION 3B163FB65, not started, process no 19564, OS thread id 1270028608
MySQL thread id 5871, query id 14754479 ip-10-244-238-10.ec2.internal 10.244.238.10 admin
SHOW ENGINE INNODB STATUS
---TRANSACTION 3B160A3EB, not started, process no 19564, OS thread id 1286269248
MySQL thread id 5988, query id 9003248 ip-10-218-41-183.ec2.internal 10.218.41.183 admin
---TRANSACTION 0, not started, process no 19564, OS thread id 1271626048
MySQL thread id 4344, query id 14746150 ip-10-218-41-183.ec2.internal 10.218.41.183 admin
---TRANSACTION 3B19CAB65, not started, process no 19564, OS thread id 1254320448
MySQL thread id 4345, query id 14326809 ip-10-218-41-183.ec2.internal 10.218.41.183 admin
---TRANSACTION 3B1A0A1CD, not started, process no 19564, OS thread id 1254586688
MySQL thread id 3944, query id 14695849 ip-10-218-41-183.ec2.internal 10.218.41.183 admin
---TRANSACTION 3B0F53A22, not started, process no 19564, OS thread id 1094756672
MySQL thread id 1, query id 14719027 localhost 127.0.0.1 rdsadmin
---TRANSACTION 3B1A15E9C, ACTIVE (PREPARED) 1 sec, process no 19564, OS thread id 1248729408 preparing
2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 2
MySQL thread id 8529, query id 14754453 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15E99, ACTIVE (PREPARED) 1 sec, process no 19564, OS thread id 1251924288 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8410, query id 14754447 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15D53, ACTIVE (PREPARED) 2 sec, process no 19564, OS thread id 1260976448 preparing
2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 2
MySQL thread id 8292, query id 14754112 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15D37, ACTIVE (PREPARED) 3 sec, process no 19564, OS thread id 1247664448 preparing
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 7809, query id 14754080 ip-10-244-238-10.ec2.internal 10.244.238.10 admin
COMMIT
Trx read view will not see trx with id >= 3B1A15D38, sees < 3B1A15658
---TRANSACTION 3B1A15BC2, ACTIVE (PREPARED) 5 sec, process no 19564, OS thread id 1281476928 preparing
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 8367, query id 14753690 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A15BBF, ACTIVE (PREPARED) 5 sec, process no 19564, OS thread id 1258047808 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8445, query id 14753683 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15BAB, ACTIVE (PREPARED) 6 sec, process no 19564, OS thread id 1098484032 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8391, query id 14753661 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15BA9, ACTIVE (PREPARED) 6 sec, process no 19564, OS thread id 1289730368 preparing
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 8359, query id 14753657 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A15BA8, ACTIVE (PREPARED) 6 sec, process no 19564, OS thread id 1280411968 preparing
2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 2
MySQL thread id 8358, query id 14753654 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A15B9F, ACTIVE (PREPARED) 7 sec, process no 19564, OS thread id 1266301248 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8421, query id 14753643 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15996, ACTIVE (PREPARED) 8 sec, process no 19564, OS thread id 1278015808 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8434, query id 14753119 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A1597A, ACTIVE (PREPARED) 8 sec, process no 19564, OS thread id 1251391808 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8430, query id 14753091 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A1595C, ACTIVE 8 sec, process no 19564, OS thread id 1099958592 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s)
MySQL thread id 8262, query id 14753058 ip-10-78-85-116.ec2.internal 10.78.85.116 admin Updating
UPDATE `users` SET `login_count` = 5305836, `last_login_at` = '2012-09-20 22:52:54', `current_login_at` = '2012-09-20 22:53:02', `updated_at` = '2012-09-20 22:53:02' WHERE `users`.`id` = 1
------- TRX HAS BEEN WAITING 8 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1690 page no 19 n bits 96 index `PRIMARY` of table `thredup_v2_production`.`users` trx id 3B1A1595C lock_mode X locks rec but not gap waiting
Record lock, heap no 27 PHYSICAL RECORD: n_fields 34; compact format; info bits 0
0: len 4; hex 80000001; asc ;;
1: len 6; hex 0003b1a158cd; asc X ;;
2: len 7; hex 170000801010fe; asc ;;
3: len 20; hex 6b6e69747769747340746872656475702e636f6d; asc knitwits@thredup.com;;
4: len 30; hex 373262646439376562653663303834666334353436623334623963656163; asc 72bdd97ebe6c084fc4546b34b9ceac; (total 128 bytes);
5: len 20; hex 3042577368726d48586d62314654456638393457; asc 0BWshrmHXmb1FTEf894W;;
6: len 30; hex 666130343235323462613639353362363663633364333763656362356235; asc fa042524ba6953b66cc3d37cecb5b5; (total 128 bytes);
7: len 20; hex 6c6f2d4c7348514474392d76526a6c4466686f76; asc lo-LsHQDt9-vRjlDfhov;;
8: len 20; hex 55426c5467364356323649336c594e6a76356467; asc UBlTg6CV26I3lYNjv5dg;;
9: len 4; hex 8050f5ec; asc P ;;
10: len 4; hex 80000000; asc ;;
11: len 8; hex 8000124cc44d7615; asc L Mv ;;
12: len 8; hex 8000124cc44d75e6; asc L Mu ;;
13: len 13; hex 3130372e32312e38332e323438; asc 107.21.83.248;;
14: len 13; hex 3130372e32312e38332e323438; asc 107.21.83.248;;
15: len 7; hex 74687265645550; asc thredUP;;
16: len 8; hex 6b6e697477697473; asc knitwits;;
17: SQL NULL;
18: len 6; hex 616374697665; asc active;;
19: len 7; hex 636f6d70616e79; asc company;;
20: len 4; hex 80000002; asc ;;
21: len 4; hex 80000008; asc ;;
22: len 4; hex 900040c3; asc @ ;;
23: len 4; hex 80048007; asc ;;
24: len 1; hex 81; asc ;;
25: len 8; hex 80001247f853619b; asc G Sa ;;
26: len 8; hex 8000124cc44d7615; asc L Mv ;;
27: SQL NULL;
28: SQL NULL;
29: SQL NULL;
30: len 8; hex 8000124cb7e5246a; asc L $j;;
31: len 3; hex 8fb8eb; asc ;;
32: len 1; hex 80; asc ;;
33: len 4; hex 80000001; asc ;;
------------------
---TRANSACTION 3B1A1594A, ACTIVE 8 sec, process no 19564, OS thread id 1276950848
MySQL thread id 7807, query id 14753041 ip-10-244-238-10.ec2.internal 10.244.238.10 admin
Trx read view will not see trx with id >= 3B1A1594B, sees < 3B1A15658
---TRANSACTION 3B1A158EA, ACTIVE (PREPARED) 9 sec, process no 19564, OS thread id 1242073408 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8446, query id 14752935 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A158E9, ACTIVE (PREPARED) 9 sec, process no 19564, OS thread id 1252456768 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8420, query id 14752932 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A158E7, ACTIVE (PREPARED) 9 sec, process no 19564, OS thread id 1253255488 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8363, query id 14752926 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A158E3, ACTIVE (PREPARED) 9 sec, process no 19564, OS thread id 1096886592 preparing
3 lock struct(s), heap size 376, 1 row lock(s), undo log entries 2
MySQL thread id 8415, query id 14752922 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
Trx read view will not see trx with id >= 3B1A158E4, sees < 3B1A15658
---TRANSACTION 3B1A158DC, ACTIVE (PREPARED) 9 sec, process no 19564, OS thread id 1258846528 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8422, query id 14752902 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A158D2, ACTIVE (PREPARED) 9 sec, process no 19564, OS thread id 1273489728 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8295, query id 14752886 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A158CD, ACTIVE (PREPARED) 10 sec, process no 19564, OS thread id 1262307648 preparing
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 8385, query id 14752877 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A158C9, ACTIVE 10 sec, process no 19564, OS thread id 1278814528
MySQL thread id 7810, query id 14752867 ip-10-244-238-10.ec2.internal 10.244.238.10 admin
Trx read view will not see trx with id >= 3B1A158CA, sees < 3B1A15658
---TRANSACTION 3B1A15884, ACTIVE (PREPARED) 10 sec, process no 19564, OS thread id 1248463168 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8448, query id 14752780 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15882, ACTIVE (PREPARED) 10 sec, process no 19564, OS thread id 1292126528 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8412, query id 14752774 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A15844, ACTIVE (PREPARED) 11 sec, process no 19564, OS thread id 1278548288 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8423, query id 14752702 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15841, ACTIVE (PREPARED) 11 sec, process no 19564, OS thread id 1263372608 preparing
2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 2
MySQL thread id 8381, query id 14752697 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A157BD, ACTIVE (PREPARED) 12 sec, process no 19564, OS thread id 1251125568 preparing
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 8537, query id 14752553 ip-10-218-41-183.ec2.internal 10.218.41.183 admin
COMMIT
---TRANSACTION 3B1A157BA, ACTIVE (PREPARED) 12 sec, process no 19564, OS thread id 1287334208 preparing
2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 2
MySQL thread id 8444, query id 14752547 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A157B7, ACTIVE (PREPARED) 13 sec, process no 19564, OS thread id 1274288448 preparing
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 8368, query id 14752541 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
Trx read view will not see trx with id >= 3B1A157B8, sees < 3B1A15658
---TRANSACTION 3B1A157A8, ACTIVE (PREPARED) 13 sec, process no 19564, OS thread id 1261508928 preparing
2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 2
MySQL thread id 8375, query id 14752506 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A157A5, ACTIVE (PREPARED) 13 sec, process no 19564, OS thread id 1272424768 preparing
2 lock struct(s), heap size 376, 0 row lock(s), undo log entries 2
MySQL thread id 8293, query id 14752498 ip-10-60-194-125.ec2.internal 10.60.194.125 admin
COMMIT
---TRANSACTION 3B1A157A1, ACTIVE (PREPARED) 13 sec, process no 19564, OS thread id 1255651648 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8452, query id 14752491 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15797, ACTIVE (PREPARED) 14 sec, process no 19564, OS thread id 1263905088 preparing
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 8374, query id 14752473 ip-10-78-85-116.ec2.internal 10.78.85.116 admin
COMMIT
---TRANSACTION 3B1A15658, ACTIVE 16 sec, process no 19564, OS thread id 1246865728
MySQL thread id 7808, query id 14752103 ip-10-244-238-10.ec2.internal 10.244.238.10 admin
Trx read view will not see trx with id >= 3B1A15659, sees < 3B1A14EA7
--------
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: 1; buffer pool: 1
865972 OS file reads, 2574320 OS file writes, 2014956 OS fsyncs
3.65 reads/s, 19404 avg bytes/read, 17.71 writes/s, 15.22 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 756, free list len 24802, seg size 25559, 117204 merges
merged operations:
insert 76155, delete mark 295289, delete 196079
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 108635339, node heap has 62300 buffer(s)
94935.45 hash searches/s, 3343.20 non-hash searches/s
---
LOG
---
Log sequence number 365092530803
Log flushed up to 365092504322
Last checkpoint at 364923597373
1 pending log writes, 0 pending chkp writes
1889722 log i/o's done, 13.75 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 56179507200; in additional pool allocated 0
Dictionary memory allocated 2453736
Buffer pool size 3350399
Free buffers 2366216
Database pages 921883
Old database pages 340324
Modified db pages 112011
Pending reads 0
Pending writes: LRU 0, flush list 1, single page 0
Pages made young 12173, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 897982, created 23901, written 1951700
4.33 reads/s, 0.10 creates/s, 7.98 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
LRU len: 921883, unzip_LRU len: 0
I/O sum[0]:cur[4], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
7 read views open inside InnoDB
Main thread process no. 19564, id 1209272640, state: flushing buffer pool pages
Number of rows inserted 586331, updated 387067, deleted 4614562, read 32472205832
6.80 inserts/s, 3.65 updates/s, 0.14 deletes/s, 642880.15 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment