InnoDB: Warning: a long semaphore wait: --Thread 139737025918720 has waited at ../../../storage/innobase/buf/buf0buf.c line 1181 for 4906.00 seconds the semaphore: Mutex at 0x7f175dbfdcb8 created file ../../../storage/innobase/buf/buf0buf.c line 600, lock var 0 waiters flag 0 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 181107 19:22:29 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 11 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 17535445, signal count 17383270 --Thread 139736956786432 has waited at ../../../storage/innobase/include/btr0btr.ic line 28 for 11.00 seconds the semaphore: S-lock on RW-latch at 0x7f1715e68470 created in file ../../../storage/innobase/buf/buf0buf.c line 550 a writer (thread id 139736956786432) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file ../../../storage/innobase/btr/btr0pcur.c line 249 Last time write locked in file ../../../storage/innobase/buf/buf0buf.c line 1823 Mutex spin waits 0, rounds 131168198, OS waits 1842101 RW-shared spins 32601543, OS waits 15333516; RW-excl spins 119646, OS waits 40381 ------------ TRANSACTIONS ------------ Trx id counter 0 1479377924 Purge done for trx's n:o < 0 1479375655 undo n:o < 0 0 History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1479377921, not started, process no 31289, OS thread id 139736933889792 MySQL thread id 1548304, query id 61866220 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377920, not started, process no 31289, OS thread id 139736933623552 MySQL thread id 1548305, query id 61866222 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377917, not started, process no 31289, OS thread id 139736932558592 MySQL thread id 1548313, query id 61866234 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377916, not started, process no 31289, OS thread id 139736932292352 MySQL thread id 1548314, query id 61866236 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377915, not started, process no 31289, OS thread id 139736930961152 MySQL thread id 1548323, query id 61866249 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377914, not started, process no 31289, OS thread id 139736930694912 MySQL thread id 1548324, query id 61867352 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377910, not started, process no 31289, OS thread id 139736929896192 MySQL thread id 1548330, query id 61867351 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377908, not started, process no 31289, OS thread id 139736927233792 MySQL thread id 1548344, query id 61866386 10.0.4.110 root closing tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 0, not started, process no 31289, OS thread id 139736926967552 MySQL thread id 1548345, query id 61866369 10.0.4.110 root Opening tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377907, not started, process no 31289, OS thread id 139736926701312 MySQL thread id 1548348, query id 61866289 10.0.4.110 root closing tables select * from system_monitor_alarmvalues order by id desc limit 1 ---TRANSACTION 0 1479377906, not started, process no 31289, OS thread id 139736926435072 MySQL thread id 1548350, query id 61867350 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377904, not started, process no 31289, OS thread id 139736925902592 MySQL thread id 1548352, query id 61866299 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377902, not started, process no 31289, OS thread id 139736925370112 MySQL thread id 1548354, query id 61866691 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377898, not started, process no 31289, OS thread id 139736924571392 MySQL thread id 1548359, query id 61866650 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377897, not started, process no 31289, OS thread id 139736924305152 MySQL thread id 1548363, query id 61866318 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377901, not started, process no 31289, OS thread id 139736924038912 MySQL thread id 1548364, query id 61867348 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377894, not started, process no 31289, OS thread id 139736923506432 MySQL thread id 1548368, query id 61866718 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377892, not started, process no 31289, OS thread id 139736922707712 MySQL thread id 1548372, query id 61866331 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377891, not started, process no 31289, OS thread id 139736922441472 MySQL thread id 1548373, query id 61866333 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377890, not started, process no 31289, OS thread id 139736921908992 MySQL thread id 1548375, query id 61866598 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377889, not started, process no 31289, OS thread id 139736921642752 MySQL thread id 1548379, query id 61867346 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377888, not started, process no 31289, OS thread id 139736921110272 MySQL thread id 1548381, query id 61866344 10.0.4.110 root closing tables select * from logsystem_info where (hoststatus = 'backup' or hoststatus = 'backup ') and datetime >= '2018-11-07 17:51:35' and datetime < '2018-11-07 18:21:35' order by datetime desc limit 1 ---TRANSACTION 0 1479377886, not started, process no 31289, OS thread id 139736920844032 MySQL thread id 1548382, query id 61866383 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377885, not started, process no 31289, OS thread id 139736920045312 MySQL thread id 1548387, query id 61866423 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377887, not started, process no 31289, OS thread id 139736919779072 MySQL thread id 1548389, query id 61867345 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377883, not started, process no 31289, OS thread id 139736919512832 MySQL thread id 1548390, query id 61866357 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377880, not started, process no 31289, OS thread id 139736918714112 MySQL thread id 1548396, query id 61866455 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377881, not started, process no 31289, OS thread id 139736918447872 MySQL thread id 1548397, query id 61867344 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377878, not started, process no 31289, OS thread id 139736917649152 MySQL thread id 1548400, query id 61866463 10.0.4.110 root closing tables select a.id, b.group_id, uh.company_id from auth_user a left join auth_user_groups b on a.id = b.user_id left join usrmgr_userhelp uh on a.id = uh.user_id where a.username = '"admin"' ---TRANSACTION 0 1479377877, not started, process no 31289, OS thread id 139736917382912 MySQL thread id 1548404, query id 61867342 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377876, not started, process no 31289, OS thread id 139736917116672 MySQL thread id 1548405, query id 61866377 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 0, not started, process no 31289, OS thread id 139736916051712 MySQL thread id 1548411, query id 61866599 10.0.4.110 root Opening tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377872, not started, process no 31289, OS thread id 139736915252992 MySQL thread id 1548415, query id 61867341 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377871, not started, process no 31289, OS thread id 139736914986752 MySQL thread id 1548418, query id 61866395 10.0.4.110 root closing tables select * from logsystem_info where (hoststatus = 'master ' or hoststatus = 'master' or hoststatus = '' or hoststatus is null ) and datetime >= '2018-11-07 17:57:35' and datetime < '2018-11-07 18:27:35' order by datetime desc limit 1 ---TRANSACTION 0 1479377869, not started, process no 31289, OS thread id 139736914188032 MySQL thread id 1548422, query id 61866402 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377868, not started, process no 31289, OS thread id 139736913389312 MySQL thread id 1548429, query id 61867340 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377867, not started, process no 31289, OS thread id 139736913123072 MySQL thread id 1548430, query id 61866416 10.0.4.110 root closing tables select * from logsystem_info where (hoststatus = 'backup' or hoststatus = 'backup ') and datetime >= '2018-11-07 17:57:35' and datetime < '2018-11-07 18:27:35' order by datetime desc limit 1 ---TRANSACTION 0 0, not started, process no 31289, OS thread id 139736912590592 MySQL thread id 1548432, query id 61866520 10.0.4.110 root Opening tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377865, not started, process no 31289, OS thread id 139736911525632 MySQL thread id 1548439, query id 61866497 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377863, not started, process no 31289, OS thread id 139736910726912 MySQL thread id 1548442, query id 61867337 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377834, not started, process no 31289, OS thread id 139736899811072 MySQL thread id 1548508, query id 61866539 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377831, not started, process no 31289, OS thread id 139736898746112 MySQL thread id 1548515, query id 61866547 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377833, not started, process no 31289, OS thread id 139736898479872 MySQL thread id 1548516, query id 61867308 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377826, not started, process no 31289, OS thread id 139736895551232 MySQL thread id 1548533, query id 61866574 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377822, not started, process no 31289, OS thread id 139736887830272 MySQL thread id 1548580, query id 61867295 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377802, not started, process no 31289, OS thread id 139736879310592 MySQL thread id 1548632, query id 61866732 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377799, not started, process no 31289, OS thread id 139736876648192 MySQL thread id 1548648, query id 61867276 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377797, not started, process no 31289, OS thread id 139736876115712 MySQL thread id 1548650, query id 61866871 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377798, not started, process no 31289, OS thread id 139736874784512 MySQL thread id 1548658, query id 61867275 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377795, not started, process no 31289, OS thread id 139736873985792 MySQL thread id 1548664, query id 61866775 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377794, not started, process no 31289, OS thread id 139736872388352 MySQL thread id 1548675, query id 61867273 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377788, not started, process no 31289, OS thread id 139736870790912 MySQL thread id 1548685, query id 61866898 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377787, not started, process no 31289, OS thread id 139736870524672 MySQL thread id 1548686, query id 61866853 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 0, not started, process no 31289, OS thread id 139736870258432 MySQL thread id 1548687, query id 61866814 10.0.4.110 root Opening tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 1479377786, not started, process no 31289, OS thread id 139736869725952 MySQL thread id 1548691, query id 61867267 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377785, not started, process no 31289, OS thread id 139736869459712 MySQL thread id 1548692, query id 61867268 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8016 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377776, not started, process no 31289, OS thread id 139736868128512 MySQL thread id 1548700, query id 61866872 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377770, not started, process no 31289, OS thread id 139736828520192 MySQL thread id 1548905, query id 61867258 10.0.4.110 root ---TRANSACTION 0 1479377768, not started, process no 31289, OS thread id 139736835176192 MySQL thread id 1548862, query id 61867255 10.0.4.110 root ---TRANSACTION 0 1479377767, not started, process no 31289, OS thread id 139736835442432 MySQL thread id 1548861, query id 61867254 10.0.4.110 root ---TRANSACTION 0 1479377765, not started, process no 31289, OS thread id 139736835708672 MySQL thread id 1548859, query id 61867252 10.0.4.110 root ---TRANSACTION 0 1479377762, not started, process no 31289, OS thread id 139736846092032 MySQL thread id 1548795, query id 61867152 10.0.4.110 root ---TRANSACTION 0 1479377758, not started, process no 31289, OS thread id 139736857540352 MySQL thread id 1548726, query id 61867248 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377753, not started, process no 31289, OS thread id 139736855410432 MySQL thread id 1548737, query id 61867243 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8030 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377743, not started, process no 31289, OS thread id 139736854611712 MySQL thread id 1548744, query id 61866894 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377738, not started, process no 31289, OS thread id 139736852215552 MySQL thread id 1548757, query id 61866953 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377727, not started, process no 31289, OS thread id 139736850351872 MySQL thread id 1548769, query id 61866995 10.0.4.110 root closing tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 1479377726, not started, process no 31289, OS thread id 139736849819392 MySQL thread id 1548772, query id 61867221 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377722, not started, process no 31289, OS thread id 139736832513792 MySQL thread id 1548877, query id 61867141 10.0.4.110 root ---TRANSACTION 0 1479377720, not started, process no 31289, OS thread id 139736842897152 MySQL thread id 1548815, query id 61867217 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377703, not started, process no 31289, OS thread id 139736842098432 MySQL thread id 1548821, query id 61867094 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377700, not started, process no 31289, OS thread id 139736841033472 MySQL thread id 1548825, query id 61867197 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377698, not started, process no 31289, OS thread id 139736838371072 MySQL thread id 1548843, query id 61867036 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377675, not started, process no 31289, OS thread id 139736951727872 MySQL thread id 1548198, query id 61866169 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377674, not started, process no 31289, OS thread id 139736951195392 MySQL thread id 1548200, query id 61867187 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377672, not started, process no 31289, OS thread id 139736950929152 MySQL thread id 1548201, query id 61867186 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377667, not started, process no 31289, OS thread id 139736949864192 MySQL thread id 1548208, query id 61866072 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377666, not started, process no 31289, OS thread id 139736949597952 MySQL thread id 1548209, query id 61866074 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377662, not started, process no 31289, OS thread id 139736948532992 MySQL thread id 1548215, query id 61866133 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377661, not started, process no 31289, OS thread id 139736948266752 MySQL thread id 1548217, query id 61866190 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377660, not started, process no 31289, OS thread id 139736948000512 MySQL thread id 1548218, query id 61866088 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377659, not started, process no 31289, OS thread id 139736947734272 MySQL thread id 1548219, query id 61866090 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377658, not started, process no 31289, OS thread id 139736947468032 MySQL thread id 1548223, query id 61866093 10.0.4.110 root closing tables select * from system_monitor_alarmvalues order by id desc limit 1 ---TRANSACTION 0 1479377657, not started, process no 31289, OS thread id 139736947201792 MySQL thread id 1548224, query id 61866232 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377656, not started, process no 31289, OS thread id 139736946935552 MySQL thread id 1548225, query id 61866325 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377654, not started, process no 31289, OS thread id 139736945870592 MySQL thread id 1548232, query id 61866108 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377653, not started, process no 31289, OS thread id 139736945604352 MySQL thread id 1548234, query id 61867185 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377650, not started, process no 31289, OS thread id 139736945338112 MySQL thread id 1548236, query id 61866121 10.0.4.110 root closing tables select * from logsystem_info where (hoststatus = 'master ' or hoststatus = 'master' or hoststatus = '' or hoststatus is null ) and datetime >= '2018-11-07 17:38:34' and datetime < '2018-11-07 18:08:34' order by datetime desc limit 1 ---TRANSACTION 0 1479377649, not started, process no 31289, OS thread id 139736945071872 MySQL thread id 1548237, query id 61866346 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377648, not started, process no 31289, OS thread id 139736944805632 MySQL thread id 1548238, query id 61866209 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377647, not started, process no 31289, OS thread id 139736944539392 MySQL thread id 1548239, query id 61866737 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 0, not started, process no 31289, OS thread id 139736944273152 MySQL thread id 1548240, query id 61866216 10.0.4.110 root Opening tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377645, not started, process no 31289, OS thread id 139736943740672 MySQL thread id 1548245, query id 61867183 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377643, not started, process no 31289, OS thread id 139736943474432 MySQL thread id 1548246, query id 61867182 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377641, not started, process no 31289, OS thread id 139736942409472 MySQL thread id 1548253, query id 61866138 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377639, not started, process no 31289, OS thread id 139736941610752 MySQL thread id 1548256, query id 61866143 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377637, not started, process no 31289, OS thread id 139736940812032 MySQL thread id 1548266, query id 61867180 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377635, not started, process no 31289, OS thread id 139736940545792 MySQL thread id 1548267, query id 61866381 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377631, not started, process no 31289, OS thread id 139736939214592 MySQL thread id 1548273, query id 61866175 10.0.4.110 root closing tables select id, platform_id, types, name from tradeplatform_broker ---TRANSACTION 0 1479377630, not started, process no 31289, OS thread id 139736938948352 MySQL thread id 1548274, query id 61866348 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377629, not started, process no 31289, OS thread id 139736938149632 MySQL thread id 1548279, query id 61867179 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377628, not started, process no 31289, OS thread id 139736937883392 MySQL thread id 1548281, query id 61866349 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377627, not started, process no 31289, OS thread id 139736937350912 MySQL thread id 1548285, query id 61866194 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377626, not started, process no 31289, OS thread id 139736937084672 MySQL thread id 1548286, query id 61866196 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377625, not started, process no 31289, OS thread id 139736936818432 MySQL thread id 1548287, query id 61866198 10.0.4.110 root closing tables select * from system_monitor_alarmvalues order by id desc limit 1 ---TRANSACTION 0 1479377623, not started, process no 31289, OS thread id 139736936019712 MySQL thread id 1548293, query id 61866204 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377621, not started, process no 31289, OS thread id 139736935220992 MySQL thread id 1548297, query id 61866278 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 0, not started, process no 31289, OS thread id 139736910460672 MySQL thread id 1548443, query id 61866442 localhost root Opening tables LOCK TABLES `accountFinance` READ /*!32311 LOCAL */,`account_account` READ /*!32311 LOCAL */,`account_account_remote` READ /*!32311 LOCAL */,`account_account_servers` READ /*!32311 LOCAL */,`account_adjust_deal_record` READ /*!32311 LOCAL */,`account_adjust_order_record` READ /*!32311 LOCAL */,`account_adjust_position_record` READ /*!32311 LOCAL */,`account_algotypeinfo` READ /*!32311 LOCAL */,`account_assetsindex` READ /*!32311 LOCAL */,`account_assetsindexcondition` READ /*!32311 LOCAL */,`account_bankfinancialnet` READ /*!32311 LOCAL */,`account_black_white` READ /*!32311 LOCAL */,`account_ ---TRANSACTION 0 1479377861, not started, process no 31289, OS thread id 139736910194432 MySQL thread id 1548444, query id 61867336 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377859, not started, process no 31289, OS thread id 139736909129472 MySQL thread id 1548453, query id 61867335 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377857, not started, process no 31289, OS thread id 139736908863232 MySQL thread id 1548454, query id 61867333 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377858, not started, process no 31289, OS thread id 139736907798272 MySQL thread id 1548463, query id 61867334 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=6000 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377848, not started, process no 31289, OS thread id 139736907532032 MySQL thread id 1548464, query id 61867324 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377845, not started, process no 31289, OS thread id 139736906200832 MySQL thread id 1548472, query id 61867321 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377605, not started, process no 31289, OS thread id 139736905934592 MySQL thread id 1548473, query id 61867320 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377599, not started, process no 31289, OS thread id 139736904337152 MySQL thread id 1548482, query id 61866553 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377598, not started, process no 31289, OS thread id 139736904070912 MySQL thread id 1548483, query id 61867313 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377597, not started, process no 31289, OS thread id 139736903804672 MySQL thread id 1548484, query id 61867312 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377844, not started, process no 31289, OS thread id 139736903005952 MySQL thread id 1548490, query id 61867319 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=4200 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377836, not started, process no 31289, OS thread id 139736902739712 MySQL thread id 1548491, query id 61867309 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377589, not started, process no 31289, OS thread id 139736901142272 MySQL thread id 1548500, query id 61866527 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377588, not started, process no 31289, OS thread id 139736900876032 MySQL thread id 1548501, query id 61867176 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377587, not started, process no 31289, OS thread id 139736900609792 MySQL thread id 1548503, query id 61866568 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377835, not started, process no 31289, OS thread id 139736900343552 MySQL thread id 1548504, query id 61866578 10.0.4.110 root closing tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 1479377586, not started, process no 31289, OS thread id 139736900077312 MySQL thread id 1548507, query id 61867175 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377829, not started, process no 31289, OS thread id 139736897148672 MySQL thread id 1548524, query id 61867306 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377578, not started, process no 31289, OS thread id 139736895817472 MySQL thread id 1548532, query id 61866572 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377574, not started, process no 31289, OS thread id 139736894220032 MySQL thread id 1548543, query id 61867300 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377828, not started, process no 31289, OS thread id 139736893953792 MySQL thread id 1548544, query id 61867305 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8016 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377824, not started, process no 31289, OS thread id 139736892622592 MySQL thread id 1548552, query id 61867299 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=4040 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377569, not started, process no 31289, OS thread id 139736892356352 MySQL thread id 1548553, query id 61867296 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377566, not started, process no 31289, OS thread id 139736892090112 MySQL thread id 1548554, query id 61866608 10.0.4.110 root closing tables select * from logsystem_info where (hoststatus = 'backup' or hoststatus = 'backup ') and datetime >= '2018-11-07 18:10:35' and datetime < '2018-11-07 18:40:35' order by datetime desc limit 1 ---TRANSACTION 0 1479377563, not started, process no 31289, OS thread id 139736891291392 MySQL thread id 1548560, query id 61866756 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377562, not started, process no 31289, OS thread id 139736891025152 MySQL thread id 1548561, query id 61866617 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377561, not started, process no 31289, OS thread id 139736890758912 MySQL thread id 1548563, query id 61866620 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377560, not started, process no 31289, OS thread id 139736890492672 MySQL thread id 1548566, query id 61866623 10.0.4.110 root closing tables select id, platform_id, types, name from tradeplatform_broker ---TRANSACTION 0 1479377559, not started, process no 31289, OS thread id 139736890226432 MySQL thread id 1548568, query id 61867171 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377557, not started, process no 31289, OS thread id 139736889960192 MySQL thread id 1548569, query id 61866628 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377556, not started, process no 31289, OS thread id 139736889693952 MySQL thread id 1548570, query id 61866699 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 0, not started, process no 31289, OS thread id 139736888895232 MySQL thread id 1548573, query id 61866941 10.0.4.110 root Opening tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 1479377553, not started, process no 31289, OS thread id 139736888096512 MySQL thread id 1548579, query id 61866643 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377820, not started, process no 31289, OS thread id 139736886765312 MySQL thread id 1548587, query id 61867170 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377549, not started, process no 31289, OS thread id 139736886499072 MySQL thread id 1548588, query id 61867169 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377542, not started, process no 31289, OS thread id 139736885434112 MySQL thread id 1548595, query id 61867167 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377539, not started, process no 31289, OS thread id 139736885167872 MySQL thread id 1548596, query id 61867294 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377537, not started, process no 31289, OS thread id 139736884369152 MySQL thread id 1548601, query id 61866968 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377819, not started, process no 31289, OS thread id 139736883836672 MySQL thread id 1548604, query id 61867292 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8000 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377818, not started, process no 31289, OS thread id 139736883570432 MySQL thread id 1548605, query id 61867293 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8016 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377810, not started, process no 31289, OS thread id 139736882239232 MySQL thread id 1548613, query id 61867285 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8016 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377808, not started, process no 31289, OS thread id 139736881972992 MySQL thread id 1548614, query id 61867282 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377527, not started, process no 31289, OS thread id 139736881706752 MySQL thread id 1548615, query id 61866823 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377807, not started, process no 31289, OS thread id 139736880908032 MySQL thread id 1548621, query id 61867280 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=4040 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377803, not started, process no 31289, OS thread id 139736879576832 MySQL thread id 1548631, query id 61867277 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377518, not started, process no 31289, OS thread id 139736877979392 MySQL thread id 1548640, query id 61867160 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377801, not started, process no 31289, OS thread id 139736877713152 MySQL thread id 1548641, query id 61867159 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377515, not started, process no 31289, OS thread id 139736877446912 MySQL thread id 1548643, query id 61866869 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377511, not started, process no 31289, OS thread id 139736875050752 MySQL thread id 1548657, query id 61867274 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377509, not started, process no 31289, OS thread id 139736873719552 MySQL thread id 1548667, query id 61867158 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377506, not started, process no 31289, OS thread id 139736872654592 MySQL thread id 1548674, query id 61866786 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377790, not started, process no 31289, OS thread id 139736871323392 MySQL thread id 1548682, query id 61867270 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377791, not started, process no 31289, OS thread id 139736871057152 MySQL thread id 1548683, query id 61867271 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377499, not started, process no 31289, OS thread id 139736868660992 MySQL thread id 1548698, query id 61867154 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377777, not started, process no 31289, OS thread id 139736868394752 MySQL thread id 1548699, query id 61867153 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377495, not started, process no 31289, OS thread id 139736867329792 MySQL thread id 1548704, query id 61867123 10.0.4.110 root ---TRANSACTION 0 1479377775, not started, process no 31289, OS thread id 139736866797312 MySQL thread id 1548708, query id 61867261 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8000 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377774, not started, process no 31289, OS thread id 139736866264832 MySQL thread id 1548710, query id 61867262 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=6090 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377759, not started, process no 31289, OS thread id 139736858605312 MySQL thread id 1548719, query id 61867249 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377489, not started, process no 31289, OS thread id 139736857274112 MySQL thread id 1548727, query id 61867247 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377484, not started, process no 31289, OS thread id 139736855942912 MySQL thread id 1548734, query id 61866934 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377483, not started, process no 31289, OS thread id 139736855676672 MySQL thread id 1548736, query id 61867241 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377745, not started, process no 31289, OS thread id 139736854345472 MySQL thread id 1548745, query id 61867236 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8000 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377741, not started, process no 31289, OS thread id 139736854079232 MySQL thread id 1548747, query id 61867234 10.0.4.110 root closing tables select * from tradeplatform_idcline where platform_id = 10064 and broker_id = '000' and idc_type = 0 ---TRANSACTION 0 1479377757, not started, process no 31289, OS thread id 139736853280512 MySQL thread id 1548752, query id 61867246 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=4040 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377739, not started, process no 31289, OS thread id 139736852748032 MySQL thread id 1548755, query id 61867232 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377467, not started, process no 31289, OS thread id 139736851416832 MySQL thread id 1548763, query id 61866924 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377466, not started, process no 31289, OS thread id 139736850618112 MySQL thread id 1548766, query id 61866994 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377725, not started, process no 31289, OS thread id 139736849553152 MySQL thread id 1548773, query id 61867220 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377461, not started, process no 31289, OS thread id 139736848754432 MySQL thread id 1548779, query id 61867140 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377460, not started, process no 31289, OS thread id 139736846890752 MySQL thread id 1548789, query id 61867218 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377459, not started, process no 31289, OS thread id 139736846624512 MySQL thread id 1548790, query id 61867139 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377737, not started, process no 31289, OS thread id 139736845559552 MySQL thread id 1548797, query id 61867229 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8000 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377479, not started, process no 31289, OS thread id 139736845293312 MySQL thread id 1548798, query id 61867148 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8000 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377454, not started, process no 31289, OS thread id 139736844760832 MySQL thread id 1548800, query id 61867137 10.0.4.110 root ---TRANSACTION 0 1479377736, not started, process no 31289, OS thread id 139736844494592 MySQL thread id 1548806, query id 61867230 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8000 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377735, not started, process no 31289, OS thread id 139736844228352 MySQL thread id 1548807, query id 61867228 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8000 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377732, not started, process no 31289, OS thread id 139736842630912 MySQL thread id 1548816, query id 61867227 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8030 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377447, not started, process no 31289, OS thread id 139736842364672 MySQL thread id 1548820, query id 61867014 10.0.4.110 root closing tables select * from logsystem_info where (hoststatus = 'master ' or hoststatus = 'master' or hoststatus = '' or hoststatus is null ) and datetime >= '2018-11-07 18:43:05' and datetime < '2018-11-07 19:13:05' order by datetime desc limit 1 ---TRANSACTION 0 1479377705, not started, process no 31289, OS thread id 139736841565952 MySQL thread id 1548823, query id 61867100 10.0.4.110 root closing tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 1479377719, not started, process no 31289, OS thread id 139736841299712 MySQL thread id 1548824, query id 61867219 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377445, not started, process no 31289, OS thread id 139736840767232 MySQL thread id 1548828, query id 61867058 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377444, not started, process no 31289, OS thread id 139736840500992 MySQL thread id 1548832, query id 61867215 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377443, not started, process no 31289, OS thread id 139736840234752 MySQL thread id 1548833, query id 61867213 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377441, not started, process no 31289, OS thread id 139736838903552 MySQL thread id 1548839, query id 61867073 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377718, not started, process no 31289, OS thread id 139736838637312 MySQL thread id 1548842, query id 61867214 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377439, not started, process no 31289, OS thread id 139736838104832 MySQL thread id 1548845, query id 61867076 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377438, not started, process no 31289, OS thread id 139736837306112 MySQL thread id 1548850, query id 61867210 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377437, not started, process no 31289, OS thread id 139736837039872 MySQL thread id 1548851, query id 61867047 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377435, not started, process no 31289, OS thread id 139736836507392 MySQL thread id 1548853, query id 61867097 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377434, not started, process no 31289, OS thread id 139736836241152 MySQL thread id 1548857, query id 61867054 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377716, not started, process no 31289, OS thread id 139736835974912 MySQL thread id 1548858, query id 61867209 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377714, not started, process no 31289, OS thread id 139736834643712 MySQL thread id 1548866, query id 61867206 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377715, not started, process no 31289, OS thread id 139736834377472 MySQL thread id 1548867, query id 61867212 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=4040 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377713, not started, process no 31289, OS thread id 139736833312512 MySQL thread id 1548874, query id 61867208 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=4040 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377428, not started, process no 31289, OS thread id 139736833046272 MySQL thread id 1548875, query id 61867081 10.0.4.110 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377702, not started, process no 31289, OS thread id 139736831715072 MySQL thread id 1548883, query id 61867195 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377701, not started, process no 31289, OS thread id 139736831448832 MySQL thread id 1548884, query id 61867194 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377695, not started, process no 31289, OS thread id 139736830117632 MySQL thread id 1548894, query id 61867189 10.0.4.110 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377699, not started, process no 31289, OS thread id 139736829851392 MySQL thread id 1548895, query id 61867196 10.0.4.111 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=8050 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377709, not started, process no 31289, OS thread id 139736829585152 MySQL thread id 1548896, query id 61867205 10.0.4.110 root ---TRANSACTION 0 1479377422, not started, process no 31289, OS thread id 139736955188992 MySQL thread id 1548168, query id 61865913 10.0.30.28 root ---TRANSACTION 0 1479377697, not started, process no 31289, OS thread id 139736829052672 MySQL thread id 1548902, query id 61867191 10.0.4.111 root closing tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377420, not started, process no 31289, OS thread id 139736957052672 MySQL thread id 1548180, query id 61865983 10.0.4.111 root closing tables select types, platform_id, id from tradeplatform_broker order by create_time ---TRANSACTION 0 1479377419, not started, process no 31289, OS thread id 139736828786432 MySQL thread id 1548903, query id 61867192 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377417, not started, process no 31289, OS thread id 139736952526592 MySQL thread id 1548181, query id 61867190 10.0.4.110 root Opening tables SELECT id, platform_id, broker_id FROM account_account WHERE platform_id=20001 and broker_id=9080 ORDER BY platform_id, broker_id ---TRANSACTION 0 1479377416, not started, process no 31289, OS thread id 139736952260352 MySQL thread id 1548196, query id 61866054 10.0.4.110 root closing tables select * from logsystem_info where (hoststatus = 'backup' or hoststatus = 'backup ') and datetime >= '2018-11-07 17:32:04' and datetime < '2018-11-07 18:02:04' order by datetime desc limit 1 ---TRANSACTION 0 1479377357, not started, process no 31289, OS thread id 139736961844992 MySQL thread id 1548152, query id 61865783 10.0.4.110 root closing tables select * from logsystem_info where (hoststatus = 'master ' or hoststatus = 'master' or hoststatus = '' or hoststatus is null ) and datetime >= '2018-11-07 17:32:04' and datetime < '2018-11-07 18:02:04' order by datetime desc limit 1 ---TRANSACTION 0 1479370360, not started, process no 31289, OS thread id 139736952792832 MySQL thread id 1527126, query id 61866307 10.0.4.110 root Opening tables select id , 0 from product_product order by id ---TRANSACTION 0 1479377677, not started, process no 31289, OS thread id 139736958650112 MySQL thread id 1527127, query id 61866097 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 1 and update_time= CURDATE() ---TRANSACTION 0 1479377322, not started, process no 31289, OS thread id 139736959715072 MySQL thread id 1527121, query id 61866287 10.0.4.110 root closing tables SELECT product_id as id, SUM(right_value) as sum FROM product_otherright GROUP BY product_id ---TRANSACTION 0 1479377683, not started, process no 31289, OS thread id 139736954390272 MySQL thread id 1527114, query id 61866080 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479374859, not started, process no 31289, OS thread id 139736953591552 MySQL thread id 1527120, query id 61866118 10.0.4.110 root Opening tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377682, not started, process no 31289, OS thread id 139736958383872 MySQL thread id 1527115, query id 61866286 10.0.4.110 root closing tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377679, not started, process no 31289, OS thread id 139736963442432 MySQL thread id 1527123, query id 61866192 10.0.4.110 root closing tables select * from idata_ctotaldealinfos where type = 2 and update_time= CURDATE() ---TRANSACTION 0 1479377685, not started, process no 31289, OS thread id 139736965838592 MySQL thread id 1527109, query id 61866524 10.0.4.110 root closing tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 1479377314, not started, process no 31289, OS thread id 139736965572352 MySQL thread id 1527019, query id 61865563 10.0.4.110 root closing tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 1479373023, not started, process no 31289, OS thread id 139736953325312 MySQL thread id 1527016, query id 61866055 10.0.4.110 root Opening tables select p.id as m_nPlatformId, p.name as m_strPlatformName, b.id as m_strBrokerID, b.name as m_strBrokerName, b.types as m_eBrokerType, b.verification_code as m_strClientVerify, b.trade_json from tradeplatform_broker b left join tradeplatform_platform p on b.platform_id = p.id ---TRANSACTION 0 1479377272, not started, process no 31289, OS thread id 139736958916352 MySQL thread id 1527013, query id 61866149 10.0.4.110 root closing tables SELECT product_id as id, SUM(right_value) as sum FROM product_otherright GROUP BY product_id ---TRANSACTION 0 1479376108, not started, process no 31289, OS thread id 139736953059072 MySQL thread id 1527000, query id 61866258 10.0.4.110 root Opening tables select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id ---TRANSACTION 0 1479359422, not started, process no 31289, OS thread id 139736960247552 MySQL thread id 1526700, query id 61866128 10.0.4.110 root Opening tables INSERT INTO logmgr_log(build_time, action, ip_str, outcome, reason, builder_name, agent, mac_str, version) VALUES('2018-11-07 18:09:20', 5, '61.140.25.106:12529', 'True', '', 'abmlijk3', 2, '44-8A-5B-BD-36-63', '3.0.1.11202') ---TRANSACTION 0 1479377414, not started, process no 31289, OS thread id 139736957851392 MySQL thread id 1526622, query id 61865836 10.0.4.110 root closing tables SELECT id, username FROM ttmgrportal.auth_user ---TRANSACTION 0 1479377415, not started, process no 31289, OS thread id 139736962377472 MySQL thread id 1526619, query id 61865835 10.0.4.110 root closing tables SELECT id, username FROM ttmgrportal.auth_user ---TRANSACTION 0 1479377905, ACTIVE 2 sec, process no 31289, OS thread id 139736926168832 MySQL thread id 1548351, query id 61867349 10.0.4.110 root Opening tables select address, port, username, password from system_monitor_smtpsetting order by id desc limit 1 Trx read view will not see trx with id >= 0 1479377906, sees < 0 1479374482 ---TRANSACTION 0 1479377692, ACTIVE 5 sec, process no 31289, OS thread id 139736962909952 committing MySQL thread id 1527017, query id 61866066 10.0.4.110 root Sending data select au.id, au.is_active, au.is_superuser, au.password, au.last_login, au.username, au.date_joined, au.email, au.last_name, ag.name, uh.mobile, uh.telephone, uh.department_id, dd.name as department_name, uh.is_otp_verify, uh.is_ctp, uh.update_pwd_user_id, us.interface_orders_num, us.interface_orders_num_socket, aug.group_id, uh.company_id, uh.is_company_superuser, uh.modify_time, cc.companyName from auth_user au left join auth_user_groups aug on au.id = aug.user_id left join auth_group ag on aug.group_id = ag.id Trx read view will not see trx with id >= 0 1479377693, sees < 0 1479374482 ---TRANSACTION 0 1479377665, ACTIVE 7 sec, process no 31289, OS thread id 139736949331712 MySQL thread id 1548210, query id 61866077 10.0.4.110 root closing tables select id from department_department Trx read view will not see trx with id >= 0 1479377666, sees < 0 1479374482 ---TRANSACTION 0 1479377640, ACTIVE 7 sec, process no 31289, OS thread id 139736941876992 MySQL thread id 1548255, query id 61867181 10.0.4.110 root Opening tables select address, port, username, password from system_monitor_smtpsetting order by id desc limit 1 Trx read view will not see trx with id >= 0 1479377641, sees < 0 1479374482 ---TRANSACTION 0 1479377613, ACTIVE 8 sec, process no 31289, OS thread id 139736908064512 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 1548459, query id 61866467 10.0.4.110 root closing tables insert into logsystem_log(datetime, level, content) values('2018-11-07 18:31:12', 1, 'host:GDZQ-XT-HXZY is backup, [ XtTraderService ] should be stopped, kill it now') ---TRANSACTION 0 1479377218, ACTIVE 4918 sec, process no 31289, OS thread id 139736953857792 MySQL thread id 1547872, query id 61865346 10.0.4.110 root Trx read view will not see trx with id >= 0 1479377219, sees < 0 1479374482 ---TRANSACTION 0 1479374482, ACTIVE 4949 sec, process no 31289, OS thread id 139736956786432 fetching rows, thread declared inside InnoDB 486 mysql tables in use 1, locked 0 MySQL thread id 1547866, query id 61865293 10.0.4.110 root Sending data select m_strInsertTime from idata_corderdetail where m_trade_date='20181107' and m_nBrokerType=3 and m_prikey_tag like '3\_\_\_\_%\_\_\_\_20181107' Trx read view will not see trx with id >= 0 1479374484, sees < 0 1479374465 -------- 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: complete io for buf page (read thread) ev set I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 59, 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 28110978 OS file reads, 3155744 OS file writes, 645045 OS fsyncs 3.42 reads/s, 87114 avg bytes/read, 0.42 writes/s, 0.08 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 5, seg size 7, 554520 inserts, 554515 merged recs, 200884 merges Hash table size 2212699, node heap has 83 buffer(s) 3021.09 hash searches/s, 1414.51 non-hash searches/s --- LOG --- Log sequence number 97 3935032711 Log flushed up to 97 3935032711 Last checkpoint at 97 3935021322 0 pending log writes, 0 pending chkp writes 1191258 log i/o's done, 0.42 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1284832314; in additional pool allocated 1046272 Dictionary memory allocated 914720 Buffer pool size 65536 Free buffers 1 Database pages 65452 Modified db pages 17 Pending reads 110 Pending writes: LRU 0, flush list 0, single page 0 Pages read 115679354, created 452004, written 3252417 10.35 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 4 queries inside InnoDB, 0 queries in queue 6 read views open inside InnoDB Main thread process no. 31289, id 139736975562496, state: sleeping Number of rows inserted 28557627, updated 1853836, deleted 27320218, read 3983894361 0.27 inserts/s, 0.00 updates/s, 0.00 deletes/s, 14207.98 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 181107 19:22:48 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 19 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 17535706, signal count 17383463 --Thread 139736956786432 has waited at ../../../storage/innobase/include/btr0btr.ic line 28 for 10.00 seconds the semaphore: S-lock on RW-latch at 0x7f17170ed070 created in file ../../../storage/innobase/buf/buf0buf.c line 550 a writer (thread id 139736956786432) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file ../../../storage/innobase/include/btr0btr.ic line 28 Last time write locked in file ../../../storage/innobase/buf/buf0buf.c line 1823 --Thread 139736920577792 has waited at ../../../storage/innobase/include/btr0btr.ic line 28 for 10.00 seconds the semaphore: S-lock onInnoDB: ###### Diagnostic info printed to the standard error stream RW-latch at 0x7f1715be9410 created in file ../../../storage/innobase/buf/buf0buf.c line 550 number of readers 0, waiters flag 0 Last time read locked in file ../../../storage/innobase/btr/btr0pcur.c line 249 Last time write locked in file ../../../storage/innobase/buf/buf0buf.c line 1823 --Thread 139736953857792 has waited at ../../../storage/innobase/btr/btr0cur.c line 3785 for 8.00 seconds the semaphore: S-lock on RW-latch at 0x7f17164634f0 created in file ../../../storage/innobase/buf/buf0buf.c line 550 a writer (thread id 139736953857792) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file ../../../storage/innobase/btr/btr0pcur.c line 249 Last time write locked in file ../../../storage/innobase/buf/buf0buf.c line 1823 --Thread 139736910460672 has waited at ../../../storage/innobase/include/btr0btr.ic line 28 for 1.00 seconds the semaphore: X-lock on RW-latch at 0x7f1716cba170 created in file ../../../storage/innobase/buf/buf0buf.c line 550 a writer (thread id 139736910460672) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file ../../../storage/innobase/btr/btr0pcur.c line 249 Last time write locked in file ../../../storage/innobase/buf/buf0buf.c line 1823 Mutex spin waits 0, rounds 131287802, OS waits 1842259 RW-shared spins 32601614, OS waits 15333534; RW-excl spins 119698, OS waits 40384 ------------ TRANSACTIONS ------------ Trx id counter 0 1479380745 Purge done for trx's n:o < 0 1479375655 undo n:o < 0 0 History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1479379533, not started, process no 31289, OS thread id 139736910194432 MySQL thread id 1548906, query id 61868874 10.0.4.110 root ---TRANSACTION 0 1479379537, not started, process no 31289, OS thread id 139736834111232 MySQL thread id 1548869, query id 61869021 10.0.4.110 root ---TRANSACTION 0 1479379466, not started, process no 31289, OS thread id 139736867063552 MySQL thread id 1548705, query id 61869015 10.0.4.110 root ---TRANSACTION 0 1479380083, not started, process no 31289, OS thread id 139736830650112 MySQL thread id 1548888, query id 61869699 10.0.4.110 root ---TRANSACTION 0 1479380662, not started, process no 31289, OS thread id 139736830916352 MySQL thread id 1548887, query id 61870384 10.0.4.110 root ---TRANSACTION 0 1479378652, not started, process no 31289, OS thread id 139736831182592 MySQL thread id 1548885, query id 61868084 10.0.4.110 root ---TRANSACTION 0 1479380089, not started, process no 31289, OS thread id 139736843429632 MySQL thread id 1548812, query id 61869708 10.0.4.110 root ---TRANSACTION 0 1479378471, not started, process no 31289, OS thread id 139736839436032 MySQL thread id 1548836, query id 61867893 10.0.4.110 root ---TRANSACTION 0 1479378465, not started, process no 31289, OS thread id 139736839702272 MySQL thread id 1548835, query id 61867788 10.0.4.110 root ---TRANSACTION 0 1479378354, not started, process no 31289, OS thread id 139736839968512 MySQL thread id 1548834, query id 61867784 10.0.4.110 root ---TRANSACTION 0 1479379970, not started, process no 31289, OS thread id 139736833578752 MySQL thread id 1548873, query id 61869568 10.0.4.110 root ---TRANSACTION 0 1479379963, not started, process no 31289, OS thread id 139736848221952 MySQL thread id 1548781, query id 61869562 10.0.4.110 root ---TRANSACTION 0 1479379950, not started, process no 31289, OS thread id 139736830383872 MySQL thread id 1548891, query id 61869482 10.0.4.110 root ---TRANSACTION 0 1479380742, not started, process no 31289, OS thread id 139736856475392 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 1548732, query id 61870483 10.0.4.110 root Sending data select address, port from tradeplatform_serverline where idcLine_id = 36 ---TRANSACTION 0 1479380553, not started, process no 31289, OS thread id 139736837572352 MySQL thread id 1548847, query id 61870232 10.0.4.110 root ---TRANSACTION 0 1479378070, not started, process no 31289, OS thread id 139736929363712 MySQL thread id 1548333, query id 61866268 10.0.30.28 root ---TRANSACTION 0 1479377960, not started, process no 31289, OS thread id 139736832247552 MySQL thread id 1548878, query id 61867404 10.0.4.110 root ---TRANSACTION 0 1479379539, not started, process no 31289, OS thread id 139736837838592 MySQL thread id 1548846, query id 61869081 10.0.4.110 root ---TRANSACTION 0 1479380104, not started, process no 31289, OS thread id 139736869992192 MySQL thread id 1548688, query id 61869721 10.0.4.110 root ---TRANSACTION 0 1479380081, not started, process no 31289, OS thread id 139736880109312 MySQL thread id 1548626, query id 61869688 10.0.4.110 root ---TRANSACTION 0 1479379461, not started, process no 31289, OS thread id 139736845027072 MySQL thread id 1548799, query id 61868938 10.0.4.110 root ---TRANSACTION 0 1479379975, not started, process no 31289, OS thread id 139736828520192 MySQL thread id 1548905, query id 61869576 10.0.4.110 root ---TRANSACTION 0 1479379392, not started, process no 31289, OS thread id 139736835176192 MySQL thread id 1548862, query id 61868930 10.0.4.110 root ---TRANSACTION 0 1479379382, not started, process no 31289, OS thread id 139736835442432 MySQL thread id 1548861, query id 61868921 10.0.4.110 root ---TRANSACTION 0 1479380160, not started, process no 31289, OS thread id 139736835708672 MySQL thread id 1548859, query id 61869766 10.0.4.110 root ---TRANSACTION 0 1479377762, not started, process no 31289, OS thread id 139736846092032 MySQL thread id 1548795, query id 61868562 10.0.4.110 root ---TRANSACTION 0 1479380361, not started, process no 31289, OS thread id 139736832513792 MySQL thread id 1548877, query id 61870016 10.0.4.110 root ---TRANSACTION 0 1479380623, not started, process no 31289, OS thread id 139736910460672 mysql tables in use 119, locked 119 MySQL thread id 1548443, query id 61870409 localhost root show table status like 'account\_account\_servers' ---TRANSACTION 0 1479377495, not started, process no 31289, OS thread id 139736867329792 MySQL thread id 1548704, query id 61868564 10.0.4.110 root ---TRANSACTION 0 1479379069, not started, process no 31289, OS thread id 139736854079232 MySQL thread id 1548747, query id 61868560 10.0.4.110 root ---TRANSACTION 0 1479379374, not started, process no 31289, OS thread id 139736844760832 MySQL thread id 1548800, query id 61868841 10.0.4.110 root ---TRANSACTION 0 1479377709, not started, process no 31289, OS thread id 139736829585152 MySQL thread id 1548896, query id 61867205 10.0.4.110 root ---TRANSACTION 0 1479377422, not started, process no 31289, OS thread id 139736955188992 MySQL thread id 1548168, query id 61865913 10.0.30.28 root ---TRANSACTION 0 1479380487, not started, process no 31289, OS thread id 139736960247552 MySQL thread id 1526700, query id 61870082 10.0.4.110 root ---TRANSACTION 0 1479380739, not started, process no 31289, OS thread id 139736957851392 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 1526622, query id 61870485 10.0.4.110 root Sending data SELECT id, username FROM ttmgrportal.auth_user ---TRANSACTION 0 1479380734, not started, process no 31289, OS thread id 139736962377472 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 0 MySQL thread id 1526619, query id 61870486 10.0.4.110 root Sending data SELECT id, username FROM ttmgrportal.auth_user ---TRANSACTION 0 1479380744, ACTIVE 0 sec, process no 31289, OS thread id 139736833844992 committing MySQL thread id 1548872, query id 61870484 10.0.4.110 root Sending data select aa.name as name , types from account_account as aa ,product_accounts as pa where aa.id = pa.account_id and pa.product_id = 670 Trx read view will not see trx with id >= 0 1479380745, sees < 0 1479374482 ---TRANSACTION 0 1479380565, ACTIVE 2 sec, process no 31289, OS thread id 139736944273152 MySQL thread id 1548907, query id 61870253 10.0.4.110 root Table lock insert into idata_cstatement(m_dEBalance,m_dMortgage,m_dOccupyMargin,m_dIOGold,m_dPositionProfit,m_dCloseProfit,m_dBBalance,m_dCommission,m_strDate,m_priKey_tag,m_dRisk,m_dClientBalance,m_dAvailCap) values(55433498.4599,0.0,54777494.21,0.0,616588.10991,0.0,54816910.35,1982.87,'20170117','2____10064____000____49____20163777____',0.988165923708,55433498.4599,40499.07) on duplicate key update m_dEBalance = 55433498.4599,m_dMortgage = 0.0,m_dOccupyMargin = 54777494.21,m_dIOGold = 0.0,m_dPositionProfit = 616588.10991,m_dCloseProfit = 0.0,m_dBBalance = 54816910.35,m_dCommission = 1982.87,m_strDate = Trx read view will not see trx with id >= 0 1479380566, sees < 0 1479374482 ---TRANSACTION 0 1479378406, ACTIVE 16 sec, process no 31289, OS thread id 139736920577792 fetching rows, thread declared inside InnoDB 366 mysql tables in use 1, locked 0 MySQL thread id 1548385, query id 61866393 10.0.4.110 root Sorting result select * from logsystem_log where datetime >= '2018-11-07 00:00:00' and datetime <= '2018-11-07 23:59:59' ORDER BY datetime DESC LIMIT 3000 Trx read view will not see trx with id >= 0 1479378407, sees < 0 1479374482 ---TRANSACTION 0 1479377218, ACTIVE 4937 sec, process no 31289, OS thread id 139736953857792 MySQL thread id 1547872, query id 61868940 10.0.4.110 root Trx read view will not see trx with id >= 0 1479377219, sees < 0 1479374482 ---TRANSACTION 0 1479374482, ACTIVE 4968 sec, process no 31289, OS thread id 139736956786432, thread declared inside InnoDB 419 mysql tables in use 1, locked 0 MySQL thread id 1547866, query id 61865293 10.0.4.110 root Sending data select m_strInsertTime from idata_corderdetail where m_trade_date='20181107' and m_nBrokerType=3 and m_prikey_tag like '3\_\_\_\_%\_\_\_\_20181107' Trx read view will not see trx with id >= 0 1479374484, sees < 0 1479374465 -------- 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: complete io for buf page (read thread) ev set I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 63, 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 28111228 OS file reads, 3155752 OS file writes, 645047 OS fsyncs 13.16 reads/s, 61997 avg bytes/read, 0.42 writes/s, 0.11 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 5, seg size 7, 554526 inserts, 554515 merged recs, 200884 merges Hash table size 2212699, node heap has 84 buffer(s) 9896.74 hash searches/s, 800.17 non-hash searches/s --- LOG --- Log sequence number 97 3935034064 Log flushed up to 97 3935034054 Last checkpoint at 97 3935021322 0 pending log writes, 0 pending chkp writes 1191266 log i/o's done, 0.42 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1281579962; in additional pool allocated 1001216 Dictionary memory allocated 914720 Buffer pool size 65536 Free buffers 0 Database pages 65452 Modified db pages 18 Pending reads 126 Pending writes: LRU 0, flush list 0, single page 0 Pages read 115680274, created 452004, written 3252417 83.63 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 997 / 1000 -------------- ROW OPERATIONS -------------- 3 queries inside InnoDB, 0 queries in queue 7 read views open inside InnoDB Main thread process no. 31289, id 139736975562496, state: sleeping Number of rows inserted 28557629, updated 1853836, deleted 27320218, read 3984046575 0.11 inserts/s, 0.00 updates/s, 0.00 deletes/s, 8018.21 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================