===================================== 070712 15:09:11 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 36 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 575312, signal count 297796 --Thread 2980 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 for 0.00 seconds the semaphore: X-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 1064 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 489 for 0.00 seconds the semaphore: X-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 2916 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 1383 for 0.00 seconds the semaphore: X-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 932 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 for 0.00 seconds the semaphore: S-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 1704 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\row\row0sel.c line 3326 for 0.00 seconds the semaphore: S-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 2404 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\row\row0sel.c line 3326 for 0.00 seconds the semaphore: S-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 1540 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2184 for 0.00 seconds the semaphore: X-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 920 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\row\row0sel.c line 3326 for 0.00 seconds the semaphore: S-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 760 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\row\row0sel.c line 3326 for 0.00 seconds the semaphore: S-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 2572 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\row\row0sel.c line 3326 for 0.00 seconds the semaphore: S-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 --Thread 2772 has waited at Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 1127 for 0.00 seconds the semaphore: S-lock on RW-latch at 00000000034B30E8 created in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 139 a writer (thread id 1064) has reserved it in mode wait exclusive number of readers 0, waiters flag 1 Last time read locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0sea.c line 746 Last time write locked in file Y:\MySQLx64\mysql-5.0.41\innobase\btr\btr0cur.c line 2322 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 660058, OS waits 339152; RW-excl spins 1218855, OS waits 236122 ------------------------ LATEST DETECTED DEADLOCK ------------------------ 070712 15:07:24 *** (1) TRANSACTION: TRANSACTION 0 270705, ACTIVE 7 sec, OS thread id 2196 setting auto-inc lock mysql tables in use 3, locked 3 LOCK WAIT 40 lock struct(s), heap size 6752, undo log entries 6084 MySQL thread id 8649, query id 986974 fms.adc.analit.net 195.98.69.135 system insert into farm.Core0 (FirmCode, FullCode, CodeFirmCr, SynonymCode, SynonymFirmCrCode, Period, Junk, Await, BaseCost, MinBoundCost, VitallyImportant, RequestRatio, RegistryCost, MaxBoundCost, OrderCost, MinOrderCount, Code, CodeCr, Unit, Volume, Quantity, Note, Doc, Currency) values (1926, 8448, 2229, 1404103, 213750, '', '', '', 285.50, null, 0, null, null, null, null, null, '2608', '', '', '0', '21', '', '', '???.') , (1926, 63047, 1105, 2508550, 217753, '', '', '', 28.30, null, 0, null, null, null, null, null, '83686', '', '', '200', '201', '', '', '???.') , (1926, 40801, 1105, 2492660, 217753, '', '', '', 13.80, null, 0, null, null, null, null, null, '83545', '', '', '850', '1472', '', '', '???.') , (1926, 5, 2409, 2138884, 217713, '', '', '', 43.90, null, 0, null, null, null, null, null, '20290', '', '', '50', '7', '', '', '???.') , (1926, 14, 1147, 2797182, 207674, '', '', '', 67.75, null, 0, null, null, null, null, null, '14525', '', '', '280,440', '426', '', '', '???.') , (1926, 23, 2409, 1322740, 217713, '', '', '', 56.55, null, 0, null, null, null, null, null, '15999', '', '', '50', '11', '', '', '???.') , (1926, 21899, 457, 2092924, 151468, '', '', '', 68.50, null, 0, null, null, null, null, null, '77078', '', '', '144', '73', '', '', '???.') , (1926, 21898, 457, 2096578, 151468, '', '', '', 33.00, null, 0, null, null, null, null, null, '77077', '', '', '288', '28', '', '', '???.') , (1926, 21899, 457, 2077200, 151468, '', '', '', 68.80, null, 0, null, null, null, null, null, '77419', '', '', '144', '20', '', '', '???.') , (1926, 21899, 457, 2082904, 151468, '', '', '', 68.80, null, 0, null, null, null, null, null, '77420', '', '', '144', '5', '', '', '???.') , (1926, 39830, 457, 2083006, 151468, '', '', '', 79.70, null, 0, null, null, null, null, null, '77418', '', '', '144', '11', '', '', '???.') , (1926, 23879, 457, 2076708, 151468, '', '', '', 59.35, null, 0, null, null, null, null, null, '77128', '', '', '24', '18', '', '', '???.') , (1926, 23880, 457, 2102232, 151468, '', '', '', 59.35, null, 0, null, null, null, null, null, '77804', '', '', '24', '8', '', '', '???.') , (1926, 23867, 457, 2076709, 151468, '', '', '', 59.35, null, 0, null, null, null, null, null, '77129', '', '', '24', '5', '', '', '???.') , (1926, 23868, 457, 2087390, 151468, '', '', '', 56.20, null, 0, null, null, null, null, null, '77125', '', '', '12', '8', '', '', '???.') , (1926, 41511, 457, 2116675, 151468, '', '', '', 54.75, null, 0, null, null, null, null, null, '78252', '', '', '12', '2', '', '', '???.') , (1926, 23871, 457, 2883043, 151468, '', '', '', 65.65, null, 0, null, null, null, null, null, '80241', '', '', '12', '12', '', '', '???.') , (1926, 54452, 457, 2883044, 151468, '', '', '', 85.40, null, 0, null, null, null, null, null, '78253', '', '', '10', '7', '', '', '???.') , (1926, 23869, 457, 2107286, 151468, '', '', '', 55.60, null, 0, null, null, null, null, null, '77124', '', '', '12', '4', '', '', '???.') , (1926, 44820, *** (1) WAITING FOR THIS LOCK TO BE GRANTED: TABLE LOCK table `farm/core0` trx id 0 270705 lock mode AUTO-INC waiting *** (2) TRANSACTION: TRANSACTION 0 270570, ACTIVE 17 sec, OS thread id 2216 starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 3 397 lock struct(s), heap size 125712, undo log entries 6820 MySQL thread id 8621, query id 992033 fms.adc.analit.net 195.98.69.135 system Updating update distinctsynonymfirmcrtmp set date=curdate() where synonymcode=NEW.synonymfirmcrcode *** (2) HOLDS THE LOCK(S): TABLE LOCK table `farm/core0` trx id 0 270570 lock mode AUTO-INC *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 27702 n bits 2384 index `PRIMARY` of table `farm/distinctsynonymfirmcrtmp` trx id 0 270570 lock_mode X locks rec but not gap waiting Record lock, heap no 25 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 000342f6; asc B?;; 1: len 6; hex 000000002865; asc (e;; 2: len 7; hex 0000002d2aea49; asc -*?I;; 3: len 4; hex 469536c0; asc F?6?;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 0 271505 Purge done for trx's n:o < 0 271240 undo n:o < 0 733 History list length 23 Total number of lock structs in row lock hash table 353 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 2948 waiting in InnoDB queue mysql tables in use 5, locked 0 MySQL thread id 9055, query id 1082491 offdc.adc.analit.net 192.168.0.1 system Sending data SELECT oh.RowId FROM orders.ordershead oh, usersettings.pricesdata pd, usersettings.retclientsset rcs, usersettings.clientsdata cd WHERE oh.processed = 0 AND if(SubmitOrders = 1, Submited, 1) AND Deleted = 0 AND oh.pricecode = pd.pricecode AND rcs.clientcode = oh.clientcode AND cd.firmcode = pd.firmcode AND cd.oldcode = 1 AND EXISTS( SELECT * FROM OrderSendRules.order_send_rules osc WHERE osc.FirmCode = cd.FirmCode ) ---TRANSACTION 0 271479, not started, OS thread id 1252 MySQL thread id 9045, query id 1082322 195.98.69.139 system ---TRANSACTION 0 271465, not started, OS thread id 1744 MySQL thread id 9044, query id 1082196 195.98.69.139 system ---TRANSACTION 0 271382, not started, OS thread id 2216 MySQL thread id 9017, query id 1081508 195.98.69.139 system ---TRANSACTION 0 271361, not started, OS thread id 824 MySQL thread id 9011, query id 1082494 195.98.69.139 system ---TRANSACTION 0 271338, not started, OS thread id 1452 MySQL thread id 9004, query id 1081239 195.98.69.139 system ---TRANSACTION 0 271329, not started, OS thread id 136 MySQL thread id 9002, query id 1081169 195.98.69.139 system ---TRANSACTION 0 271044, not started, OS thread id 1784 MySQL thread id 8876, query id 1057883 195.98.69.139 system ---TRANSACTION 0 270977, not started, OS thread id 2940 MySQL thread id 8850, query id 1056349 195.98.69.139 system ---TRANSACTION 0 269965, not started, OS thread id 1424 MySQL thread id 8540, query id 1082234 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 269938, not started, OS thread id 1288 MySQL thread id 8538, query id 1075807 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 270018, not started, OS thread id 240 MySQL thread id 8542, query id 1081707 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 271191, not started, OS thread id 380 MySQL thread id 8536, query id 1082286 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 270019, not started, OS thread id 2492 MySQL thread id 8543, query id 1081707 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 271393, not started, OS thread id 2872 MySQL thread id 8545, query id 1081651 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 271367, not started, OS thread id 1012 MySQL thread id 8547, query id 1081466 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 271437, not started, OS thread id 2516 MySQL thread id 8539, query id 1082253 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 271426, not started, OS thread id 2508 MySQL thread id 8537, query id 1082286 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 271418, not started, OS thread id 2496 MySQL thread id 8541, query id 1082234 fms.adc.analit.net 195.98.69.135 system ---TRANSACTION 0 271475, not started, OS thread id 2520 MySQL thread id 8339, query id 1082458 195.98.69.139 WebRetail ---TRANSACTION 0 271199, not started, OS thread id 3028 MySQL thread id 146, query id 1074694 by.adc.analit.net 192.168.0.11 system ---TRANSACTION 0 264271, not started, OS thread id 2504 MySQL thread id 6572, query id 913595 195.98.69.139 adm ---TRANSACTION 0 259339, not started, OS thread id 248 MySQL thread id 6533, query id 888006 195.98.69.139 adm ---TRANSACTION 0 266364, not started, OS thread id 2240 MySQL thread id 5525, query id 922528 opt1.adc.analit.net 192.168.0.231 system ---TRANSACTION 0 271497, not started, OS thread id 1964 MySQL thread id 4788, query id 1082444 opt1.adc.analit.net 192.168.0.231 system ---TRANSACTION 0 248353, not started, OS thread id 388 MySQL thread id 4517, query id 863422 opt1.adc.analit.net 192.168.0.231 system ---TRANSACTION 0 263293, not started, OS thread id 692 MySQL thread id 4211, query id 907692 opt1.adc.analit.net 192.168.0.231 system ---TRANSACTION 0 0, not started, OS thread id 2864 MySQL thread id 4067, query id 1082497 emkwork.adc.analit.net 192.168.0.3 system SHOW INNODB STATUS ---TRANSACTION 0 266390, not started, OS thread id 2212 MySQL thread id 3617, query id 922759 192.168.0.233 system ---TRANSACTION 0 269580, not started, OS thread id 964 MySQL thread id 3405, query id 940075 opt2.adc.analit.net 192.168.0.251 system ---TRANSACTION 0 267263, not started, OS thread id 196 MySQL thread id 2857, query id 930240 opt2.adc.analit.net 192.168.0.251 system ---TRANSACTION 0 265635, not started, OS thread id 1268 MySQL thread id 2737, query id 919431 opt2.adc.analit.net 192.168.0.251 system ---TRANSACTION 0 271444, not started, OS thread id 2076 MySQL thread id 2492, query id 1081996 opt2.adc.analit.net 192.168.0.251 system ---TRANSACTION 0 269166, not started, OS thread id 2388 MySQL thread id 1758, query id 938970 192.168.0.233 system ---TRANSACTION 0 271504, ACTIVE 0 sec, OS thread id 2776 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 9053, query id 1082461 195.98.69.139 system Sending data select ifnull(Max(IncludeClientCode=1410 or ClientCode=1410), 0) as A from osuseraccessright left join includeregulation on PrimaryClientCode=ClientCode and IncludeType=0 where osusername='chloborovsk' Trx read view will not see trx with id >= 0 271505, sees < 0 271314 ---TRANSACTION 0 271503, ACTIVE 0 sec, OS thread id 920 starting index read, thread declared inside InnoDB 500 mysql tables in use 2, locked 0 MySQL thread id 7386, query id 1082480 195.98.69.139 adm Sending data SELECT persons0_.ContactGroupId as ContactG3___1_, persons0_.Id as Id1_, persons0_.Id as Id6_0_, persons0_.Name as Name8_0_, persons0_.ContactGroupId as ContactG3_8_0_ FROM contacts.Persons persons0_ inner join contacts.contact_owners persons0_1_ on persons0_.Id=persons0_1_.Id WHERE persons0_.ContactGroupId=20180 Trx read view will not see trx with id >= 0 271504, sees < 0 271314 ---TRANSACTION 0 271498, ACTIVE 0 sec, OS thread id 760 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 9048, query id 1082464 195.98.69.139 system statistics select UniqueCopyID from ret_update_info where clientcode=2313 Trx read view will not see trx with id >= 0 271499, sees < 0 271314 ---TRANSACTION 0 271489, ACTIVE 1 sec, OS thread id 2528 waiting in InnoDB queue mysql tables in use 11, locked 0 MySQL thread id 2534, query id 1082393 emkwork.adc.analit.net 192.168.0.3 system Sending data SELECT 0 As LAppCode, LogTime AS LLogTime, null As LShortName, null As LRegion, null As LFirmSegment, null as LPriceName, 0 As LPriceCode, if(Form is null, 0, Form) As LForm, if(Unform is null, 0, Unform) As LUnform, if(Zero is null, 0, Zero) As LZero, if(Forb is null, 0, Forb) As LForb, Addition As LAddition, ResultID As LResultID, logtime as lt FROM logs.formlogs as logs WHERE logs.PriceCode = 0 and logs.LogTime > '2007-07-12 15:08:34' UNION SELECT 0 As LAppCode, LogTime AS LLogTime, ClientsData.ShortName As LShortName, regi Trx read view will not see trx with id >= 0 271490, sees < 0 271314 ---TRANSACTION 0 271488, ACTIVE 1 sec, OS thread id 2572 starting index read, thread declared inside InnoDB 500 mysql tables in use 9, locked 0 MySQL thread id 9047, query id 1082388 offdc.adc.analit.net 192.168.0.1 system statistics SELECT ol.Code, ol.CodeCr, if(st.Synonym is null, concat(name,' ',form), st.synonym) as FullName, if(si.SynonymFirmcrCode is null, ifNull(firmCr, '-'), si.synonym) as CrName, ol.FullCode, ol.CodeFirmCr, ol.Quantity, ol.Cost, ol.Junk, ol.Await, c.period, ol.Cost as basecost FROM (orders.ordershead as oh, orders.orderslist as ol, farm.Catalog as t, usersettings.intersection i, usersettings.retclientsset rcs) LEFT JOIN farm.synonym as st ON st.SynonymCode = ol.SynonymCode LEFT JOIN farm Trx read view will not see trx with id >= 0 271490, sees < 0 271314 ---TRANSACTION 0 271478, ACTIVE 3 sec, OS thread id 1704 starting index read, thread declared inside InnoDB 13 mysql tables in use 11, locked 0 MySQL thread id 9036, query id 1082282 offdc.adc.analit.net 192.168.0.1 system Copying to tmp table SELECT ol.OrderId, ol.Code, ol.CodeCr, if(st.Synonym is null, concat(name,' ',form), st.synonym) as s1, if(si.SynonymFirmcrCode is null, ifNull(firmCr, '-'), si.synonym) as s2, ol.Quantity, ol.Cost, round(ol.Cost*ol.Quantity,2) as SumPos, ol.Junk, ol.Await, c.period, if(c.basecost is Null, 0, c.basecost) as basecost FROM (ordershead as oh, orderslist as ol, farm.Catalog as t, usersettings.intersection i, usersettings.retclientsset rcs, usersettings.clientsdata cd, usersettings.pricesdata pd) LEFT JOIN farm.synonym as st ON st.SynonymCode = ol.SynonymCode LEFT JOIN farm.synonymFirmCr as si ON Trx read view will not see trx with id >= 0 271479, sees < 0 271314 ---TRANSACTION 0 271383, ACTIVE 24 sec, OS thread id 1064 fetching rows, thread declared inside InnoDB 329 mysql tables in use 3, locked 3 4 lock struct(s), heap size 3024, undo log entries 336 MySQL thread id 8996, query id 1081515 fms.adc.analit.net 195.98.69.135 system updating delete from farm.Core0 where FirmCode=2279 ---TRANSACTION 0 271358, ACTIVE 31 sec, OS thread id 3024 starting index read mysql tables in use 2, locked 2 LOCK WAIT 61 lock struct(s), heap size 14320 MySQL thread id 9008, query id 1082240 195.98.69.139 system Sending data INSERT INTO Core SELECT Prices.PriceCode, Prices.regioncode, core0.fullcode, if(if(round(corecosts.cost*Prices.UpCost,2)MaxBoundCost, MaxBoundCost, if(round(corecosts.cost*Prices.UpCost,2)= 0 271359, sees < 0 271311 ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 253629 n bits 2240 index `FirmCode_IDX` of table `farm/core0` trx id 0 271358 lock mode S waiting Record lock, heap no 215 PHYSICAL RECORD: n_fields 2; compact format; info bits 32 0: len 4; hex 000008d6; asc ?;; 1: len 8; hex 000000001437a9b1; asc 7??;; ------------------ ---TRANSACTION 0 271327, ACTIVE 34 sec, OS thread id 2772 fetching rows, thread declared inside InnoDB 238 mysql tables in use 2, locked 2 257 lock struct(s), heap size 60176 MySQL thread id 9003, query id 1081217 195.98.69.139 AOL Sending data INSERT INTO Core SELECT Prices.PriceCode, Prices.regioncode, core0.fullcode, if(if(round(corecosts.cost*Prices.UpCost,2)MaxBoundCost, MaxBoundCost, if(round(corecosts.cost*Prices.UpCost,2)= 0 271328, sees < 0 271311 ---TRANSACTION 0 271326, ACTIVE 34 sec, OS thread id 1540 updating or deleting, thread declared inside InnoDB 16 mysql tables in use 3, locked 3 6 lock struct(s), heap size 3024, undo log entries 493 MySQL thread id 8905, query id 1081155 fms.adc.analit.net 195.98.69.135 system updating delete from farm.Core0 where FirmCode=2262 ---TRANSACTION 0 271320, ACTIVE 37 sec, OS thread id 2404 starting index read, thread declared inside InnoDB 142 mysql tables in use 13, locked 0 MySQL thread id 8998, query id 1081112 195.98.69.139 amp Copying to tmp table select distinct catalog.FullCode PrepCode, catalog.Name, catalog.Form from (intersection, clientsdata, pricesdata, pricesregionaldata, retclientsset, clientsdata as AClientsData, farm.catalog) left join farm.formrules on formrules.firmcode=pricesdata.pricecode left join farm.core0 c on c.firmcode = if(pricesdata.costtype = 0, intersection.priceCode, intersection.costCode) and catalog.fullcode=c.fullcode and to_days(now())-to_days(datecurprice)= 0 271321, sees < 0 271311 ---TRANSACTION 0 271318, ACTIVE 37 sec, OS thread id 932 updating or deleting, thread declared inside InnoDB 424 mysql tables in use 3, locked 3 20 lock struct(s), heap size 6752, undo log entries 2794 MySQL thread id 8896, query id 1081100 fms.adc.analit.net 195.98.69.135 system updating delete from farm.Core0 where FirmCode=22 ---TRANSACTION 0 271314, ACTIVE 37 sec, OS thread id 2980 updating or deleting, thread declared inside InnoDB 247 mysql tables in use 3, locked 3 29 lock struct(s), heap size 6752, undo log entries 5137 MySQL thread id 8871, query id 1081088 fms.adc.analit.net 195.98.69.135 system updating delete from farm.Core0 where FirmCode=2179 -------- 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 (write thread) I/O thread 6 state: wait Windows aio (write thread) I/O thread 7 state: wait Windows aio (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 100660 OS file reads, 55121 OS file writes, 4876 OS fsyncs 0.19 reads/s, 65536 avg bytes/read, 0.86 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 7, seg size 9, 23292 inserts, 23271 merged recs, 12374 merges Hash table size 42499631, used cells 17316853, node heap has 8162 buffer(s) 4038.36 hash searches/s, 3997.92 non-hash searches/s --- LOG --- Log sequence number 6 1855477146 Log flushed up to 6 1851924117 Last checkpoint at 6 1392021270 0 pending log writes, 0 pending chkp writes 10994 log i/o's done, 0.84 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 22760171914; in additional pool allocated 17483008 Buffer pool size 327680 Free buffers 202097 Database pages 117423 Modified db pages 12885 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 100650, created 16773, written 44132 0.19 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 10 queries inside InnoDB, 1 queries in queue 8 read views open inside InnoDB Main thread id 2916, state: purging Number of rows inserted 3090405, updated 20731, deleted 1702542, read 240241108 0.97 inserts/s, 0.28 updates/s, 120.72 deletes/s, 23989.22 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================