===================================== 2018-04-25 15:33:24 7f6236bff700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 836225 srv_active, 0 srv_shutdown, 832212 srv_idle srv_master_thread log flush and writes: 1668437 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 708761 --Thread 140059391584000 has waited at trx0rseg.ic line 46 for 274.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x7f62b99c6aa0 '&block->lock' a writer (thread id 140059391584000) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file buf0flu.cc line 1078 Last time write locked in file /mnt/workspace/percona-server-5.6-binaries-release/label_exp/centos6-64/percona-server-5.6.36-82.0/storage/innobase/include/trx0rseg.ic line 46 OS WAIT ARRAY INFO: signal count 709495 Mutex spin waits 29554381, rounds 51811565, OS waits 325030 RW-shared spins 557905, rounds 13109338, OS waits 355688 RW-excl spins 129593, rounds 1616089, OS waits 15507 Spin rounds per wait: 1.75 mutex, 23.50 RW-shared, 12.47 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 15254045741 Purge done for trx's n:o < 15254044071 undo n:o < 0 state: running but idle History list length 2497 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 15254028730, not started MySQL thread id 12178805, OS thread handle 0x7f621edaa700, query id 108505828 10.10.136.39 xes_homework ---TRANSACTION 15254008895, not started MySQL thread id 12173215, OS thread handle 0x7f621e896700, query id 108468925 10.10.136.39 xes_homework ---TRANSACTION 15253998065, not started MySQL thread id 12162071, OS thread handle 0x7f621e58a700, query id 108449261 10.10.136.39 xes_homework ---TRANSACTION 15253960370, not started MySQL thread id 12159506, OS thread handle 0x7f621e68e700, query id 108379350 10.10.136.39 xes_homework ---TRANSACTION 15254022065, not started MySQL thread id 12141566, OS thread handle 0x7f61b69d7700, query id 108492918 10.10.136.39 xes_homework ---TRANSACTION 15253982664, not started MySQL thread id 12141537, OS thread handle 0x7f621e4c7700, query id 108419002 10.10.136.39 xes_homework ---TRANSACTION 15254026341, not started MySQL thread id 12136482, OS thread handle 0x7f621ee2c700, query id 108501217 10.10.136.39 xes_homework ---TRANSACTION 15254017102, not started MySQL thread id 12135774, OS thread handle 0x7f621e792700, query id 108483092 10.10.136.39 xes_homework ---TRANSACTION 15253989703, not started MySQL thread id 12133198, OS thread handle 0x7f621e549700, query id 108433561 10.10.136.39 xes_homework ---TRANSACTION 15253980772, not started MySQL thread id 12132588, OS thread handle 0x7f61b6adb700, query id 108415902 10.10.136.39 xes_homework ---TRANSACTION 15254013186, not started MySQL thread id 12131968, OS thread handle 0x7f61b6c20700, query id 108475863 10.10.136.39 xes_homework ---TRANSACTION 15253997630, not started MySQL thread id 12131953, OS thread handle 0x7f61b62fc700, query id 108448665 10.10.136.39 xes_homework ---TRANSACTION 15254042055, not started MySQL thread id 12129810, OS thread handle 0x7f61b7071700, query id 108530813 10.10.136.39 xes_homework ---TRANSACTION 15254005708, not started MySQL thread id 12129077, OS thread handle 0x7f61b6586700, query id 108462888 10.10.136.39 xes_homework ---TRANSACTION 15254038336, not started MySQL thread id 12128087, OS thread handle 0x7f621e58a700, query id 108523680 10.10.136.39 xes_homework ---TRANSACTION 15254012660, not started MySQL thread id 12127800, OS thread handle 0x7f61b60b3700, query id 108474848 10.10.136.39 xes_homework ---TRANSACTION 15254022860, not started MySQL thread id 12127795, OS thread handle 0x7f61b5ca3700, query id 108495320 10.10.136.39 xes_homework ---TRANSACTION 15254043099, not started MySQL thread id 12127063, OS thread handle 0x7f621e896700, query id 108532416 10.10.136.39 xes_homework ---TRANSACTION 15254022857, not started MySQL thread id 12126294, OS thread handle 0x7f621e792700, query id 108495319 10.10.136.39 xes_homework ---TRANSACTION 15254025079, not started MySQL thread id 12125798, OS thread handle 0x7f621e486700, query id 108499251 10.10.136.39 xes_homework ---TRANSACTION 15254021571, not started MySQL thread id 12125106, OS thread handle 0x7f621ee2c700, query id 108492082 10.10.136.39 xes_homework ---TRANSACTION 15254024563, not started MySQL thread id 12124421, OS thread handle 0x7f61b6586700, query id 108498250 10.10.136.39 xes_homework ---TRANSACTION 15254041362, not started MySQL thread id 12121947, OS thread handle 0x7f61b6f2c700, query id 108529505 10.10.136.39 xes_homework ---TRANSACTION 15254032704, not started MySQL thread id 12121302, OS thread handle 0x7f61b72fb700, query id 108513756 10.10.136.39 xes_homework ---TRANSACTION 15253985456, not started MySQL thread id 12121248, OS thread handle 0x7f61b6135700, query id 108424884 10.10.136.39 xes_homework ---TRANSACTION 15254042113, not started MySQL thread id 12120740, OS thread handle 0x7f61b5ff0700, query id 108530940 10.10.136.39 xes_homework ---TRANSACTION 15254030100, not started MySQL thread id 12120463, OS thread handle 0x7f621e896700, query id 108508188 10.10.136.39 xes_homework ---TRANSACTION 15254042277, not started MySQL thread id 12119856, OS thread handle 0x7f61b6135700, query id 108531204 10.10.136.39 xes_homework ---TRANSACTION 15254034539, not started MySQL thread id 12119248, OS thread handle 0x7f61b6c20700, query id 108516639 10.10.136.39 xes_homework ---TRANSACTION 15254032560, not started MySQL thread id 12116603, OS thread handle 0x7f61b6b9e700, query id 108513483 10.10.136.39 xes_homework ---TRANSACTION 15254037463, not started MySQL thread id 12115162, OS thread handle 0x7f621e855700, query id 108522268 10.10.136.39 xes_homework ---TRANSACTION 15254042044, not started MySQL thread id 12115055, OS thread handle 0x7f621e58a700, query id 108530796 10.10.136.39 xes_homework ---TRANSACTION 15254038138, not started MySQL thread id 12114783, OS thread handle 0x7f621eba2700, query id 108523287 10.10.136.39 xes_homework ---TRANSACTION 15254045141, not started MySQL thread id 12112923, OS thread handle 0x7f621e5cb700, query id 108535682 10.10.136.39 xes_homework ---TRANSACTION 15254022544, not started MySQL thread id 12112804, OS thread handle 0x7f61b5997700, query id 108494861 10.10.136.39 xes_homework ---TRANSACTION 15254029945, not started MySQL thread id 12112710, OS thread handle 0x7f61b72fb700, query id 108507899 10.10.136.39 xes_homework ---TRANSACTION 15254028864, not started MySQL thread id 12111820, OS thread handle 0x7f61b5997700, query id 108506006 10.10.136.39 xes_homework ---TRANSACTION 15254021611, not started MySQL thread id 12111709, OS thread handle 0x7f61b64c3700, query id 108492153 10.10.136.39 xes_homework ---TRANSACTION 15254037625, not started MySQL thread id 12111002, OS thread handle 0x7f61b61f8700, query id 108522486 10.10.136.39 xes_homework ---TRANSACTION 15254033002, not started MySQL thread id 12110544, OS thread handle 0x7f61b6135700, query id 108514278 10.10.136.39 xes_homework ---TRANSACTION 15254038341, not started MySQL thread id 12109649, OS thread handle 0x7f61b71f7700, query id 108523689 10.10.136.39 xes_homework ---TRANSACTION 15254028710, not started MySQL thread id 12108822, OS thread handle 0x7f61b72fb700, query id 108505803 10.10.136.39 xes_homework ---TRANSACTION 15254014937, not started MySQL thread id 12108748, OS thread handle 0x7f61b5997700, query id 108479654 10.10.136.39 xes_homework ---TRANSACTION 15254038546, not started MySQL thread id 12108131, OS thread handle 0x7f61b6b9e700, query id 108524008 10.10.136.39 xes_homework ---TRANSACTION 15253979873, not started MySQL thread id 12107414, OS thread handle 0x7f61b69d7700, query id 108414426 10.10.136.39 xes_homework ---TRANSACTION 15254040913, not started MySQL thread id 12106703, OS thread handle 0x7f621e58a700, query id 108527697 10.10.136.39 xes_homework ---TRANSACTION 15254037276, not started MySQL thread id 12106692, OS thread handle 0x7f61b6adb700, query id 108521943 10.10.136.39 xes_homework ---TRANSACTION 15254042133, not started MySQL thread id 12105831, OS thread handle 0x7f621eba2700, query id 108530970 10.10.136.39 xes_homework ---TRANSACTION 15254041029, not started MySQL thread id 12105433, OS thread handle 0x7f621e3c3700, query id 108528947 10.10.136.39 xes_homework ---TRANSACTION 15254029384, not started MySQL thread id 12104204, OS thread handle 0x7f61b5ff0700, query id 108506806 10.10.136.39 xes_homework ---TRANSACTION 15254041560, not started MySQL thread id 12102198, OS thread handle 0x7f621e792700, query id 108529927 10.10.136.39 xes_homework ---TRANSACTION 15253973278, not started MySQL thread id 12101355, OS thread handle 0x7f621e5cb700, query id 108402763 10.10.136.39 xes_homework ---TRANSACTION 15253964157, not started MySQL thread id 12100804, OS thread handle 0x7f61b568b700, query id 108386192 10.10.136.39 xes_homework ---TRANSACTION 15253992324, not started MySQL thread id 12100373, OS thread handle 0x7f61b6586700, query id 108438945 10.10.136.39 xes_homework ---TRANSACTION 15254041505, not started MySQL thread id 12100206, OS thread handle 0x7f621e792700, query id 108529811 10.10.136.39 xes_homework ---TRANSACTION 15254022864, not started MySQL thread id 12099189, OS thread handle 0x7f621ea9e700, query id 108495328 10.10.136.39 xes_homework ---TRANSACTION 15254039625, not started MySQL thread id 12098706, OS thread handle 0x7f61b7071700, query id 108525686 10.10.136.39 xes_homework ---TRANSACTION 15254014364, not started MySQL thread id 12098658, OS thread handle 0x7f621ee2c700, query id 108478783 10.10.136.39 xes_homework ---TRANSACTION 15254034921, not started MySQL thread id 12098182, OS thread handle 0x7f621e549700, query id 108517292 10.10.136.39 xes_homework ---TRANSACTION 15254025044, not started MySQL thread id 12097899, OS thread handle 0x7f621e5cb700, query id 108499175 10.10.136.39 xes_homework ---TRANSACTION 15254043387, not started MySQL thread id 12097807, OS thread handle 0x7f621e896700, query id 108532856 10.10.136.39 xes_homework ---TRANSACTION 15254036114, not started MySQL thread id 12097773, OS thread handle 0x7f621ea9e700, query id 108520174 10.10.136.39 xes_homework ---TRANSACTION 15254041531, not started MySQL thread id 12096324, OS thread handle 0x7f61b6adb700, query id 108529865 10.10.136.39 xes_homework ---TRANSACTION 15254031309, not started MySQL thread id 12094145, OS thread handle 0x7f61b71f7700, query id 108510285 10.10.136.39 xes_homework ---TRANSACTION 15254036217, not started MySQL thread id 12092158, OS thread handle 0x7f621e549700, query id 108520355 10.10.136.39 xes_homework ---TRANSACTION 15253991676, not started MySQL thread id 12092051, OS thread handle 0x7f61b6b9e700, query id 108437863 10.10.136.39 xes_homework ---TRANSACTION 15254034601, not started MySQL thread id 12088694, OS thread handle 0x7f621e486700, query id 108516728 10.10.136.39 xes_homework ---TRANSACTION 15254035024, not started MySQL thread id 12084267, OS thread handle 0x7f621e5cb700, query id 108517426 10.10.136.39 xes_homework ---TRANSACTION 15254042122, not started MySQL thread id 12081273, OS thread handle 0x7f61b5956700, query id 108530960 10.10.136.39 xes_homework ---TRANSACTION 15254044050, not started MySQL thread id 12075696, OS thread handle 0x7f61b60b3700, query id 108533928 10.10.136.39 xes_homework ---TRANSACTION 15254043718, not started MySQL thread id 12067905, OS thread handle 0x7f61b5956700, query id 108533410 10.10.136.39 xes_homework ---TRANSACTION 15254043294, not started MySQL thread id 12066849, OS thread handle 0x7f61b5956700, query id 108532691 10.10.136.39 xes_homework ---TRANSACTION 15254042551, not started MySQL thread id 12066604, OS thread handle 0x7f61b5997700, query id 108531572 10.10.136.39 xes_homework ---TRANSACTION 15254043605, not started MySQL thread id 12066127, OS thread handle 0x7f621e896700, query id 108533197 10.10.136.39 xes_homework ---TRANSACTION 15254043524, not started MySQL thread id 12066084, OS thread handle 0x7f61b6adb700, query id 108533080 10.10.136.39 xes_homework ---TRANSACTION 15254021935, not started MySQL thread id 12062510, OS thread handle 0x7f61b69d7700, query id 108492725 10.10.136.39 xes_homework ---TRANSACTION 15254024928, not started MySQL thread id 12062271, OS thread handle 0x7f621eba2700, query id 108498979 10.10.136.39 xes_homework ---TRANSACTION 15254037002, not started MySQL thread id 12061952, OS thread handle 0x7f61b674d700, query id 108521459 10.10.136.39 xes_homework ---TRANSACTION 15254044069, not started MySQL thread id 12060473, OS thread handle 0x7f61b71f7700, query id 108533952 10.10.136.39 xes_homework ---TRANSACTION 15254044041, not started MySQL thread id 12060393, OS thread handle 0x7f61b5956700, query id 108533884 10.10.136.39 xes_homework ---TRANSACTION 15254029830, not started MySQL thread id 12059962, OS thread handle 0x7f621e855700, query id 108507634 10.10.136.39 xes_homework ---TRANSACTION 15254042140, not started MySQL thread id 12059906, OS thread handle 0x7f61b61f8700, query id 108530981 10.10.136.39 xes_homework ---TRANSACTION 15254043441, not started MySQL thread id 12059228, OS thread handle 0x7f61b5ff0700, query id 108532931 10.10.136.39 xes_homework ---TRANSACTION 15254028733, not started MySQL thread id 12059068, OS thread handle 0x7f61b5997700, query id 108505832 10.10.136.39 xes_homework ---TRANSACTION 15254040259, not started MySQL thread id 12058736, OS thread handle 0x7f61b674d700, query id 108526674 10.10.136.39 xes_homework ---TRANSACTION 15254030428, not started MySQL thread id 12058710, OS thread handle 0x7f61b72fb700, query id 108508713 10.10.136.39 xes_homework ---TRANSACTION 15254030089, not started MySQL thread id 12058597, OS thread handle 0x7f621e6cf700, query id 108508165 10.10.136.39 xes_homework ---TRANSACTION 15253963367, not started MySQL thread id 12058383, OS thread handle 0x7f621eba2700, query id 108385050 10.10.136.39 xes_homework ---TRANSACTION 15254041489, not started MySQL thread id 12058286, OS thread handle 0x7f621e486700, query id 108529777 10.10.136.39 xes_homework ---TRANSACTION 15254043134, not started MySQL thread id 12057798, OS thread handle 0x7f621e792700, query id 108532504 10.10.136.39 xes_homework ---TRANSACTION 15254014981, not started MySQL thread id 12057694, OS thread handle 0x7f621e549700, query id 108479719 10.10.136.39 xes_homework ---TRANSACTION 15254041536, not started MySQL thread id 12056807, OS thread handle 0x7f621e58a700, query id 108529878 10.10.136.39 xes_homework ---TRANSACTION 15254035563, not started MySQL thread id 12056481, OS thread handle 0x7f61b5956700, query id 108518316 10.10.136.39 xes_homework ---TRANSACTION 15254030204, not started MySQL thread id 12051760, OS thread handle 0x7f61b6c20700, query id 108508349 10.10.136.39 xes_homework ---TRANSACTION 15254013173, not started MySQL thread id 12049633, OS thread handle 0x7f61b62fc700, query id 108475844 10.10.136.39 xes_homework ---TRANSACTION 15254013010, not started MySQL thread id 12046825, OS thread handle 0x7f61b62fc700, query id 108475493 10.10.136.39 xes_homework ---TRANSACTION 15254042952, not started MySQL thread id 12045892, OS thread handle 0x7f61b5997700, query id 108532099 10.10.136.39 xes_homework ---TRANSACTION 15254042164, not started MySQL thread id 12045766, OS thread handle 0x7f621e549700, query id 108531012 10.10.136.39 xes_homework ---TRANSACTION 15254037410, not started MySQL thread id 12045682, OS thread handle 0x7f621e855700, query id 108522170 10.10.136.39 xes_homework ---TRANSACTION 15254009505, not started MySQL thread id 12045679, OS thread handle 0x7f621eb61700, query id 108469818 10.10.136.39 xes_homework ---TRANSACTION 15253961249, not started MySQL thread id 12045490, OS thread handle 0x7f621e855700, query id 108380859 10.10.136.39 xes_homework ---TRANSACTION 15253957425, not started MySQL thread id 12044966, OS thread handle 0x7f61b69d7700, query id 108370931 10.10.136.39 xes_homework ---TRANSACTION 15254030248, not started MySQL thread id 12044024, OS thread handle 0x7f61b6996700, query id 108508445 10.10.136.39 xes_homework ---TRANSACTION 15254021994, not started MySQL thread id 12040729, OS thread handle 0x7f621e3c3700, query id 108492849 10.10.136.39 xes_homework ---TRANSACTION 15254028070, not started MySQL thread id 12040273, OS thread handle 0x7f621e3c3700, query id 108504812 10.10.136.39 xes_homework ---TRANSACTION 15254035057, not started MySQL thread id 12039900, OS thread handle 0x7f61b6adb700, query id 108517486 10.10.136.39 xes_homework ---TRANSACTION 15254045740, ACTIVE (PREPARED) 0 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183767, OS thread handle 0x7f61b6da6700, query id 108537982 10.10.6.23 xes_logs query end INSERT INTO error_logs (`e_param`,`e_str`,`e_no`,`e_file`,`e_line`,`create_time`) VALUES ('偊sessId?38d53633158ce2eefdb895612cdac0489sb9yfyyqqiveId?6569', 'exception \'PDOException\' with message \'exception \'PDOException\' with message \'SQLSTATE[HY000] [2003] Can\'t connect to MySQL server on \'logs-mdb\' (4)\' in /home/www/api.xueersi.com/dbengine/pdodbs.class.php:59\nStack trace:\n#0 /home/www/api.xueersi.com/dbengine/pdodbs.class.php(59): PDO->__construct(\'mysql:host=logs...\', \'xes_logs\', \'wi8uoJei\', Array)\n#1 /home/www/api.xueersi.com/dbengine/pdodbs.class.php(41): pdodbs->__ ---TRANSACTION 15254045739, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 12183766, OS thread handle 0x7f621ece7700, query id 108537980 10.10.9.53 xes_homework updating UPDATE `xes_homework_correct_relations` set `view_time` = '2018-04-25 15:33:24' WHERE `id` = '15526295' ------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3604 page no 82643 n bits 248 index `PRIMARY` of table `homework`.`xes_homework_correct_relations` trx id 15254045739 lock_mode X locks rec but not gap waiting ------------------ ---TRANSACTION 15254045737, ACTIVE (PREPARED) 0 sec 2 lock struct(s), heap size 360, 2 row lock(s), undo log entries 2 MySQL thread id 12183765, OS thread handle 0x7f621e8d7700, query id 108537976 10.10.9.57 xes_homework init COMMIT ---TRANSACTION 15254045735, ACTIVE (PREPARED) 6 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12057838, OS thread handle 0x7f61b678e700, query id 108537956 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/app/quiz/2018/04/25/6467327_1524641597678_quizimg_43296_13868_1.jpg', '2018-04-25 15:33:18') ---TRANSACTION 15254045713, ACTIVE (PREPARED) 14 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183725, OS thread handle 0x7f61b7279700, query id 108537908 10.10.6.236 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('偊sessId?908c772cd1751ad69ca5ad3ccdff76994qxy99yyqiveId?7688', '8', 'Undefined index: stuId', '/home/www/api.xueersi.com/controller/lecturelivecache.class.php', '1306', 'lecturelivecache', 'visitPlayBack', 'view', 'playBackVideoNew', '2018-04-25 15:33:10') ---TRANSACTION 15254045682, ACTIVE 23 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 12183706, OS thread handle 0x7f621e959700, query id 108537850 localhost root update replace into test.pulse(id,now_time) values(1,now()) ------- TRX HAS BEEN WAITING 23 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3626 page no 3 n bits 72 index `PRIMARY` of table `test`.`pulse` trx id 15254045682 lock_mode X locks rec but not gap waiting ------------------ ---TRANSACTION 15254045669, ACTIVE (PREPARED) 34 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183690, OS thread handle 0x7f61b6441700, query id 108537813 10.10.6.23 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('偊sessId?908c772cd1751ad69ca5ad3ccdff76994qxy99yyqiveId?7688', '8', 'Undefined index: stuId', '/home/www/api.xueersi.com/controller/lecturelivecache.class.php', '1306', 'lecturelivecache', 'visitPlayBack', 'view', 'playBackVideoNew', '2018-04-25 15:32:50') ---TRANSACTION 15254045661, ACTIVE (PREPARED) 53 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183655, OS thread handle 0x7f621eb61700, query id 108537760 10.10.6.23 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('偊sessId?27eef0ad18d28e077fa5c9534bd62b749bfmyfq90iveId?1657', '8', 'Undefined index: stuId', '/home/www/api.xueersi.com/controller/lecturelivecache.class.php', '1306', 'lecturelivecache', 'visitPlayBack', 'view', 'expVideoView', '2018-04-25 15:32:31') ---TRANSACTION 15254045634, ACTIVE (PREPARED) 75 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183607, OS thread handle 0x7f621e896700, query id 108537640 10.10.6.23 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('偊sessId?38d53633158ce2eefdb895612cdac0489sb9yfyyqqiveId?6569', '8', 'Undefined index: stuId', '/home/www/api.xueersi.com/controller/lecturelivecache.class.php', '1306', 'lecturelivecache', 'visitPlayBack', 'view', 'playBackVideoNew', '2018-04-25 15:32:09') ---TRANSACTION 15254045633, ACTIVE (PREPARED) 85 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12127888, OS thread handle 0x7f61b668a700, query id 108537603 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/app/quiz/2018/04/25/6245032_1524641518692_quizimg_42108_12813_1.jpg', '2018-04-25 15:31:59') ---TRANSACTION 15254045604, ACTIVE (PREPARED) 91 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12066911, OS thread handle 0x7f61b6de7700, query id 108537557 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641513590843226957.jpeg', '2018-04-25 15:31:53') ---TRANSACTION 15254045458, ACTIVE (PREPARED) 115 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12066810, OS thread handle 0x7f61b6400700, query id 108537349 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641489176638409523.jpeg', '2018-04-25 15:31:29') ---TRANSACTION 15254045457, ACTIVE (PREPARED) 117 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12066800, OS thread handle 0x7f621efb2700, query id 108537342 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641487520561854374.jpeg', '2018-04-25 15:31:27') ---TRANSACTION 15254045452, ACTIVE (PREPARED) 137 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12047920, OS thread handle 0x7f61b6fef700, query id 108537302 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641466748644551686.jpeg', '2018-04-25 15:31:06') ---TRANSACTION 15254045444, ACTIVE (PREPARED) 146 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 11668284, OS thread handle 0x7f61b5d25700, query id 108537268 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641458589768867979.jpeg', '2018-04-25 15:30:58') ---TRANSACTION 15254045415, ACTIVE (PREPARED) 150 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12066711, OS thread handle 0x7f61b6e69700, query id 108537232 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641454301474546494.jpeg', '2018-04-25 15:30:54') ---TRANSACTION 15254045414, ACTIVE (PREPARED) 151 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 11679715, OS thread handle 0x7f61b5ce4700, query id 108537229 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641453762191841032.jpeg', '2018-04-25 15:30:53') ---TRANSACTION 15254045413, ACTIVE (PREPARED) 153 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12066584, OS thread handle 0x7f621e60c700, query id 108537219 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641451978977004955.jpeg', '2018-04-25 15:30:51') ---TRANSACTION 15254045412, ACTIVE (PREPARED) 154 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12065718, OS thread handle 0x7f61b6239700, query id 108537216 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641450914628388527.jpeg', '2018-04-25 15:30:50') ---TRANSACTION 15254045411, ACTIVE (PREPARED) 158 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12065667, OS thread handle 0x7f621e814700, query id 108537211 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641446796789226551.jpeg', '2018-04-25 15:30:46') ---TRANSACTION 15254045410, ACTIVE (PREPARED) 163 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12079882, OS thread handle 0x7f61b6bdf700, query id 108537192 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641441704469538618.jpeg', '2018-04-25 15:30:41') ---TRANSACTION 15254045381, ACTIVE (PREPARED) 167 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183455, OS thread handle 0x7f621e58a700, query id 108537152 10.10.6.236 xes_logs query end INSERT INTO error_logs (`e_param`,`e_str`,`e_no`,`e_file`,`e_line`,`create_time`) VALUES ('偊sessId?860b1c19143a11178236f7ca1177add6myqqb0yfb0iveId?2129', 'exception \'PDOException\' with message \'exception \'PDOException\' with message \'SQLSTATE[HY000] [2003] Can\'t connect to MySQL server on \'logs-mdb\' (4)\' in /home/www/api.xueersi.com/dbengine/pdodbs.class.php:59\nStack trace:\n#0 /home/www/api.xueersi.com/dbengine/pdodbs.class.php(59): PDO->__construct(\'mysql:host=logs...\', \'xes_logs\', \'wi8uoJei\', Array)\n#1 /home/www/api.xueersi.com/dbengine/pdodbs.class.php(41): pdodbs->__ ---TRANSACTION 15254045352, ACTIVE (PREPARED) 173 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12106400, OS thread handle 0x7f61b6996700, query id 108537095 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_corrects` (`correct_time`,`commit_id`,`correct_comment`) VALUES('2018-04-25 15:30:31', '15539640', '鎷嶇収涓€鏍凤紝閲嶆柊鎻愪氦鍝?) ---TRANSACTION 15254045351, ACTIVE (PREPARED) 177 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12067338, OS thread handle 0x7f61b7071700, query id 108537080 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641427460458632613.jpeg', '2018-04-25 15:30:27') ---TRANSACTION 15254045350, ACTIVE (PREPARED) 180 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12108436, OS thread handle 0x7f621e99a700, query id 108537074 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_corrects` (`correct_time`,`commit_id`,`correct_comment`) VALUES('2018-04-25 15:30:24', '15522565', '鐓х墖灏哄涓嶇锛岃閲嶆柊鎷嶇収锛屾媿鐓ф椂鎶婁綔涓氬唴瀹规斁鍒版彁绀烘鍐?) ---TRANSACTION 15254045349, ACTIVE (PREPARED) 183 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12076467, OS thread handle 0x7f61b62bb700, query id 108537057 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641420959573983246.jpeg', '2018-04-25 15:30:21') ---TRANSACTION 15254045347, ACTIVE (PREPARED) 193 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12064818, OS thread handle 0x7f621ee2c700, query id 108537027 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641410968936319396.jpeg', '2018-04-25 15:30:11') ---TRANSACTION 15254045341, ACTIVE 199 sec MySQL thread id 12183403, OS thread handle 0x7f61b5c21700, query id 108537926 10.10.8.191 xes_dataanalysis ---TRANSACTION 15254045340, ACTIVE (PREPARED) 201 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12077405, OS thread handle 0x7f61b73be700, query id 108536270 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641403223236064042.jpeg', '2018-04-25 15:30:03') ---TRANSACTION 15254045310, ACTIVE (PREPARED) 204 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183390, OS thread handle 0x7f61b5c62700, query id 108535897 10.10.135.240 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('?, '2', '[msgpack] (php_msgpack_unserialize) Extra bytes', '/home/www/api.xueersi.com/controller/shelllivecoursegold.class.php', '144', 'shelllivecoursegold', 'run', '', '', '2018-04-25 15:30:00') ---TRANSACTION 15254045289, ACTIVE (PREPARED) 204 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183388, OS thread handle 0x7f61b737d700, query id 108535874 10.10.135.240 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('?, '8', 'Undefined index: group_id', '/home/www/api.xueersi.com/controller/shelllivecoursetest.class.php', '255', 'shelllivecoursetest', 'run', '', '', '2018-04-25 15:30:00') ---TRANSACTION 15254045226, ACTIVE (PREPARED) 209 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12076441, OS thread handle 0x7f61b62fc700, query id 108535787 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641394329864633230.jpeg', '2018-04-25 15:29:55') ---TRANSACTION 15254045197, ACTIVE (PREPARED) 211 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12071334, OS thread handle 0x7f61b72fb700, query id 108535752 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641393404556153627.jpeg', '2018-04-25 15:29:53') ---TRANSACTION 15254045142, ACTIVE (PREPARED) 214 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12083091, OS thread handle 0x7f621e5cb700, query id 108535686 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641390233324632686.jpeg', '2018-04-25 15:29:50') ---TRANSACTION 15254045061, ACTIVE (PREPARED) 218 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12084945, OS thread handle 0x7f61b6d24700, query id 108535589 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641385327276871249.jpeg', '2018-04-25 15:29:46') ---TRANSACTION 15254045060, ACTIVE (PREPARED) 218 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12083967, OS thread handle 0x7f61b627a700, query id 108535588 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641385126910789382.jpeg', '2018-04-25 15:29:46') ---TRANSACTION 15254045059, ACTIVE (PREPARED) 222 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12088036, OS thread handle 0x7f61b568b700, query id 108535577 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_corrects` (`correct_time`,`commit_id`,`correct_comment`) VALUES('2018-04-25 15:29:42', '15527845', '鎷嶇瓟棰樺崱鍝?) ---TRANSACTION 15254045053, ACTIVE (PREPARED) 226 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12067263, OS thread handle 0x7f621eeae700, query id 108535566 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641378255330883935.jpeg', '2018-04-25 15:29:38') ---TRANSACTION 15254045050, ACTIVE (PREPARED) 229 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12077248, OS thread handle 0x7f61b6c20700, query id 108535558 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641374141080217431.jpeg', '2018-04-25 15:29:35') ---TRANSACTION 15254045049, ACTIVE (PREPARED) 230 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12068160, OS thread handle 0x7f61b6e28700, query id 108535556 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641374330996817347.jpeg', '2018-04-25 15:29:34') ---TRANSACTION 15254045048, ACTIVE (PREPARED) 231 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12074805, OS thread handle 0x7f61b6031700, query id 108535551 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641373899593238161.jpeg', '2018-04-25 15:29:33') ---TRANSACTION 15254045047, ACTIVE (PREPARED) 231 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12047569, OS thread handle 0x7f621e3c3700, query id 108535548 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/app/quiz/2018/04/25/6153572_1524641372575_quizimg_45355_13216_5.jpg', '2018-04-25 15:29:33') ---TRANSACTION 15254044970, ACTIVE (PREPARED) 233 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183336, OS thread handle 0x7f61b670c700, query id 108535444 10.10.6.237 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('偊sessId?7cde21589e8afdafe1704153fb738a28009xm44m0fiveId?2110', '8', 'Undefined index: stuId', '/home/www/api.xueersi.com/controller/lecturelivecache.class.php', '1306', 'lecturelivecache', 'visitPlayBack', 'view', 'expVideoView', '2018-04-25 15:29:31') ---TRANSACTION 15254044927, ACTIVE (PREPARED) 235 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183323, OS thread handle 0x7f61b5b5e700, query id 108535378 10.10.6.23 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('偊sessId?860b1c19143a11178236f7ca1177add6myqqb0yfb0iveId?2129', '8', 'Undefined index: stuId', '/home/www/api.xueersi.com/controller/lecturelivecache.class.php', '1306', 'lecturelivecache', 'visitPlayBack', 'view', 'playBackVideoNew', '2018-04-25 15:29:29') ---TRANSACTION 15254044926, ACTIVE (PREPARED) 235 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12074786, OS thread handle 0x7f621ef71700, query id 108535376 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641369827733787391.jpg', '2018-04-25 15:29:29') ---TRANSACTION 15254044897, ACTIVE (PREPARED) 235 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12067217, OS thread handle 0x7f61b6810700, query id 108535335 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641369710871385224.jpeg', '2018-04-25 15:29:29') ---TRANSACTION 15254044861, ACTIVE (PREPARED) 236 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 12049385, OS thread handle 0x7f61b578f700, query id 108535284 10.10.136.39 xes_homework query end UPDATE `xes_homework_objectives` SET `is_wrong` = '0', `m_time` = '2018-04-25 15:29:28', `status` = 3 WHERE `commit_id` = 15523293 AND `test_id` = '9' ---TRANSACTION 15254044778, ACTIVE (PREPARED) 238 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12183297, OS thread handle 0x7f61b66cb700, query id 108535171 10.10.6.23 xes_logs query end INSERT INTO error_logs (`e_param`,`e_no`,`e_str`,`e_file`,`e_line`,`controller`,`method`,`cake_controller`,`cake_method`,`create_time`) VALUES ('偊sessId?5c3e1427cefcf8253d2bae5baf354111mbbxyff0mfiveId?3636', '8', 'Undefined index: stuId', '/home/www/api.xueersi.com/controller/lecturelivecache.class.php', '1306', 'lecturelivecache', 'visitPlayBack', 'view', 'playBackVideoNew', '2018-04-25 15:29:26') ---TRANSACTION 15254044694, ACTIVE (PREPARED) 239 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12069677, OS thread handle 0x7f61b6586700, query id 108535051 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641364232112438662.jpeg', '2018-04-25 15:29:25') ---TRANSACTION 15254044630, ACTIVE (PREPARED) 241 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 10 MySQL thread id 12061665, OS thread handle 0x7f621e4c7700, query id 108534963 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_objectives` (`commit_id`,`class_id`,`work_id`,`stu_id`,`test_id`,`stest_id`,`test_type`,`stu_answer`,`first_is_wrong`,`is_wrong`,`answer_time`,`m_time`,`test_score`,`status`) VALUES('15541219', '43761', '13622', '5864148', '1', '1057796', '2', 'B', '0', '0', '2018-04-25 15:29:23', '', '10', '0'),('15541219', '43761', '13622', '5864148', '2', '1057795', '2', 'C', '0', '0', '2018-04-25 15:29:23', '', '10', '0'),('15541219', '43761', '13622', '5864148', '3', '1057794', '2', 'B', '0', '0', '2018-04-25 15:29:23', '', '10', '0'),('15541219', '43761', '13622', '5864148', '4' ---TRANSACTION 15254044545, ACTIVE (PREPARED) 242 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12073461, OS thread handle 0x7f621ef30700, query id 108534845 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641361609980325538.jpeg', '2018-04-25 15:29:22') ---TRANSACTION 15254044509, ACTIVE (PREPARED) 244 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12066334, OS thread handle 0x7f61b7238700, query id 108534787 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641360704254647330.jpeg', '2018-04-25 15:29:20') ---TRANSACTION 15254044353, ACTIVE (PREPARED) 248 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12078011, OS thread handle 0x7f61b5a19700, query id 108534566 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641356598868801984.jpeg', '2018-04-25 15:29:16') ---TRANSACTION 15254044289, ACTIVE (PREPARED) 249 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12045345, OS thread handle 0x7f61b5956700, query id 108534464 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/app/quiz/2018/04/25/5662360_1524641355153_1524641308345.jpg', '2018-04-25 15:29:15') ---TRANSACTION 15254044288, ACTIVE (PREPARED) 249 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12071203, OS thread handle 0x7f61b5ca3700, query id 108534463 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641355184891192353.jpeg', '2018-04-25 15:29:15') ---TRANSACTION 15254044287, ACTIVE (PREPARED) 252 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12068090, OS thread handle 0x7f61b61f8700, query id 108534437 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641352398398087514.jpeg', '2018-04-25 15:29:12') ---TRANSACTION 15254044286, ACTIVE (PREPARED) 252 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 10 MySQL thread id 12060116, OS thread handle 0x7f61b5ff0700, query id 108534434 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_objectives` (`commit_id`,`class_id`,`work_id`,`stu_id`,`test_id`,`stest_id`,`test_type`,`stu_answer`,`first_is_wrong`,`is_wrong`,`answer_time`,`m_time`,`test_score`,`status`) VALUES('15541217', '37470', '12167', '1031741', '1', '1411998', '4', '100', '0', '0', '2018-04-25 15:29:12', '', '10', '0'),('15541217', '37470', '12167', '1031741', '2', '1411997', '4', '100', '0', '0', '2018-04-25 15:29:12', '', '10', '0'),('15541217', '37470', '12167', '1031741', '3', '1411996', '4', '97', '0', '0', '2018-04-25 15:29:12', '', '10', '0'),('15541217', '37470', '12167', '1031741' ---TRANSACTION 15254044285, ACTIVE (PREPARED) 254 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12076251, OS thread handle 0x7f61b6f2c700, query id 108534420 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641350892112081932.jpeg', '2018-04-25 15:29:10') ---TRANSACTION 15254044256, ACTIVE (PREPARED) 255 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12071142, OS thread handle 0x7f621e792700, query id 108534369 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641348660622151452.jpeg', '2018-04-25 15:29:09') ---TRANSACTION 15254044255, ACTIVE (PREPARED) 256 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12068045, OS thread handle 0x7f621edaa700, query id 108534360 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641348194091474637.jpeg', '2018-04-25 15:29:08') ---TRANSACTION 15254044254, ACTIVE (PREPARED) 257 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12071099, OS thread handle 0x7f61b6b9e700, query id 108534350 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641347163589171261.jpeg', '2018-04-25 15:29:07') ---TRANSACTION 15254044252, ACTIVE (PREPARED) 260 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12068004, OS thread handle 0x7f61b60f4700, query id 108534319 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641342483628704633.jpg', '2018-04-25 15:29:04') ---TRANSACTION 15254044251, ACTIVE (PREPARED) 260 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12067102, OS thread handle 0x7f621e549700, query id 108534318 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641343964667331547.jpeg', '2018-04-25 15:29:04') ---TRANSACTION 15254044250, ACTIVE (PREPARED) 261 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12060800, OS thread handle 0x7f61b674d700, query id 108534309 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641343976399358956.jpeg', '2018-04-25 15:29:03') ---TRANSACTION 15254044223, ACTIVE (PREPARED) 262 sec 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 12183159, OS thread handle 0x7f621eba2700, query id 108534262 localhost root init commit ---TRANSACTION 15254044178, ACTIVE (PREPARED) 264 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12047249, OS thread handle 0x7f61b5eec700, query id 108534187 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://hw.xesimg.com/homework/imgs/2018/04/25/1524641339527471745475.jpeg', '2018-04-25 15:29:00') ---TRANSACTION 15254044122, ACTIVE (PREPARED) 265 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12066264, OS thread handle 0x7f61b6135700, query id 108534100 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641338215070083415.jpeg', '2018-04-25 15:28:58') ---TRANSACTION 15254044121, ACTIVE (PREPARED) 266 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12069288, OS thread handle 0x7f61b60b3700, query id 108534097 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641338712184801780.jpeg', '2018-04-25 15:28:58') ---TRANSACTION 15254044120, ACTIVE (PREPARED) 267 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12067742, OS thread handle 0x7f621eadf700, query id 108534080 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://ek.xesimg.com/homework/imgs/2018/04/25/1524641337123971146838.jpeg', '2018-04-25 15:28:57') ---TRANSACTION 15254044119, ACTIVE (PREPARED) 267 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12075161, OS thread handle 0x7f61b71f7700, query id 108534079 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641337399626081970.jpeg', '2018-04-25 15:28:57') ---TRANSACTION 15254044118, ACTIVE (PREPARED) 267 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12073812, OS thread handle 0x7f61b6adb700, query id 108534078 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641337319431188198.jpeg', '2018-04-25 15:28:57') ---TRANSACTION 15254044111, ACTIVE (PREPARED) 268 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12066196, OS thread handle 0x7f61b5997700, query id 108534057 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641336938952664321.jpeg', '2018-04-25 15:28:56') ---TRANSACTION 15254044110, ACTIVE (PREPARED) 269 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12067694, OS thread handle 0x7f61b69d7700, query id 108534047 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641334176975962065.jpeg', '2018-04-25 15:28:55') ---TRANSACTION 15254044109, ACTIVE (PREPARED) 272 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12067666, OS thread handle 0x7f621e855700, query id 108534017 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://oo.xesimg.com/homework/imgs/2018/04/25/1524641331140747369472.jpeg', '2018-04-25 15:28:52') ---TRANSACTION 15254044108, ACTIVE (PREPARED) 273 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 12060861, OS thread handle 0x7f621ea9e700, query id 108534008 10.10.136.39 xes_homework query end INSERT INTO `xes_homework_imgs` (`full_homework_url`,`up_time`) VALUES('http://mr.xesimg.com/homework/imgs/2018/04/25/1524641331458263001678.jpeg', '2018-04-25 15:28:51') ---TRANSACTION 15254044080, ACTIVE (PREPARED) 274 sec committing mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 12066734, OS thread handle 0x7f621e486700, query id 108533965 10.10.136.39 xes_homework query end UPDATE `xes_homework_commits` SET `status` = '4',`correct_time` = '2018-04-25 15:28:50' WHERE `id` = '15526434' -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 4 [0, 0, 0, 4, 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 4721946 OS file reads, 57574391 OS file writes, 4622561 OS fsyncs 0.25 reads/s, 16384 avg bytes/read, 0.40 writes/s, 0.20 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 8073, seg size 8075, 95273 merges merged operations: insert 59331, delete mark 69948, delete 2903 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 11.70 non-hash searches/s --- LOG --- Log sequence number 2101750377457 Log flushed up to 2101750377457 Pages flushed up to 2101750224579 Last checkpoint at 2101750224579 Max checkpoint age 325436314 Checkpoint age target 315266430 Modified age 152878 Checkpoint age 152878 0 pending log writes, 0 pending chkp writes 32406669 log i/o's done, 0.40 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 44711280640; in additional pool allocated 0 Total memory allocated by read views 2848 Internal hash tables (constant factor + variable factor) Adaptive hash index 679996496 (679992296 + 4200) Page hash 10625704 (buffer pool 0 only) Dictionary cache 172416521 (169999504 + 2417017) File system 989512 (812272 + 177240) Lock system 106316112 (106249768 + 66344) Recovery system 0 (0 + 0) Dictionary memory allocated 2417017 Buffer pool size 2621436 Buffer pool size, bytes 42949607424 Free buffers 4096 Database pages 2617340 Old database pages 966084 Modified db pages 321 Pending reads 0 Pending writes: LRU 0, flush list 4, single page 0 Pages made young 11398741, not young 129914769 0.00 youngs/s, 3.45 non-youngs/s Pages read 4721398, created 1142948, written 24369037 0.25 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 995 / 1000, young-making rate 0 / 1000 not 77 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2617340, unzip_LRU len: 0 I/O sum[24]:cur[4], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 655359 Buffer pool size, bytes 10737401856 Free buffers 1024 Database pages 654335 Old database pages 241521 Modified db pages 141 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2828652, not young 31119497 0.00 youngs/s, 1.35 non-youngs/s Pages read 1166070, created 284263, written 8725797 0.10 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 988 / 1000, young-making rate 0 / 1000 not 166 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654335, unzip_LRU len: 0 I/O sum[6]:cur[1], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 655359 Buffer pool size, bytes 10737401856 Free buffers 1024 Database pages 654335 Old database pages 241521 Modified db pages 64 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2877830, not young 32770961 0.00 youngs/s, 0.30 non-youngs/s Pages read 1190465, created 289835, written 5360376 0.05 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 70 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654335, unzip_LRU len: 0 I/O sum[6]:cur[1], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 655359 Buffer pool size, bytes 10737401856 Free buffers 1024 Database pages 654335 Old database pages 241521 Modified db pages 60 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2837907, not young 32754303 0.00 youngs/s, 0.00 non-youngs/s Pages read 1182665, created 285158, written 4904184 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654335, unzip_LRU len: 0 I/O sum[6]:cur[1], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 655359 Buffer pool size, bytes 10737401856 Free buffers 1024 Database pages 654335 Old database pages 241521 Modified db pages 56 Pending reads 0 Pending writes: LRU 0, flush list 4, single page 0 Pages made young 2854352, not young 33270008 0.00 youngs/s, 1.80 non-youngs/s Pages read 1182198, created 283692, written 5378680 0.10 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 132 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 654335, unzip_LRU len: 0 I/O sum[6]:cur[1], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 76 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 76 out of 1000 descriptors used Main thread process no. 5004, id 140059508463360, state: sleeping Number of rows inserted 53403586, updated 7003146, deleted 62678683, read 622998476304 0.15 inserts/s, 0.10 updates/s, 0.00 deletes/s, 4.10 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================